AppSubscriptions
Lists all subscriptions created for a shop on the installed application.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- AppInstallationId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM AppSubscriptions
SELECT * FROM AppSubscriptions WHERE AppInstallationId = 'Val1'
Insert
The following columns can be used to create a new record:
Name, Test, ReturnUrl, TrialDays, LineItem (references AppSubscriptionLineItems)
Delete
You can delete entries by specifying the following column:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally-unique ID. | |
| AppInstallationId | String | True |
A globally-unique ID. | |
| Name | String | True |
The name of the app subscription. | |
| Status | String | True |
The status of the app subscription. | |
| Test | Bool | True |
Specifies whether the app subscription is a test transaction. | |
| ReturnUrl | String | True |
The URL that the merchant is redirected to after approving the app subscription. | |
| TrialDays | Int | True |
The number of free trial days, starting at the subscription's creation date, by which billing is delayed. | |
| CurrentPeriodEnd | Datetime | True |
The date and time when the current app subscription period ends. Returns 'null' if the subscription isn't active. | |
| CreatedAt | Datetime | True |
The date and time when the app subscription was created. | |
| LineItemIds | String | True |
The IDs of the plans attached to the app subscription. | |
| LineItem | String | True |
LineItem |