AppSubscriptions
Lists all subscriptions created for a shop on the installed application.
Select
The component uses the Shopify API to process WHERE clause conditions built with the following column and operator. The component processes other filters client-side within the component.
- 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
Insert statements are mapped to the 'appSubscriptionCreate' GraphQL mutation.
The following columns can be used to create a new record:
Name, Test, ReturnUrl, TrialDays, LineItem
Delete
Delete statements are mapped to the 'appSubscriptionCancel' GraphQL mutation.
You can delete entries by specifying the 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
Name | Type | Description |
LineItem | String |
LineItem |