AppSubscriptionLineItemUsageRecords
Returns usage records for app subscription line items.
Table-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following column and operators. The provider processes other filters client-side within the provider.
- AppSubscriptionId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM AppSubscriptionLineItemUsageRecords WHERE AppSubscriptionId = 'Val1'
Insert
The following columns can be used to create a new record:
SubscriptionLineItemId, Description, IdempotencyKey, PriceAmount, PriceCurrencyCode
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally-unique ID. | |
| SubscriptionLineItemId | String | True |
The ID of the app subscription line item that the usage record belongs to. | |
| AppSubscriptionId | String | True |
The ID of the app subscription. | |
| Description | String | True |
The description of the app usage record. | |
| IdempotencyKey | String | True |
A unique key generated by the client to avoid duplicate charges. | |
| PriceAmount | Decimal | True |
The price of the app usage record. Decimal money amount. | |
| PriceCurrencyCode | String | True |
The currency of the app usage record price. | |
| CreatedAt | Datetime | True |
The date and time when the usage record was created. |