Skio API Reference
Empower your store with an open API that can easily integrate subscription data into your tech stack (analytics, marketing tools, etc). To use this API, go to your dashboard and click the API button on the left navigation bar. Generate an API token after setting a name and use this token in the request header "authorization" (case sensitive).
For example:
headers: {
"Content-Type": "application/graphql"
"authorization": "API <token>"
}
Please refer to Shopify's GraphQL API https://shopify.dev/docs/api/admin-graphql for understanding the Skio objects, as they are 1:1. For example an Order on Skio refers to an Order on Shopify.
Objects can be queried in two ways. One is using an ID (primary key or 'PK') to find an instance for example OrdersByPK
. The other by retrieving a list of matching objects with a filter, for example Orders
using a where
filter.
Terms of Service
API Endpoints
https://graphql.skio.com/v1/graphql
Queries
AddressByPk
Description
fetch data from the table: "Address" using primary key columns
Example
Query
query AddressByPk($id: uuid!) {
AddressByPk(id: $id) {
PaymentMethod {
...PaymentMethodFragment
}
StorefrontUser {
...StorefrontUserFragment
}
Subscriptions {
...SubscriptionFragment
}
address1
address2
city
company
country
createdAt
doorCode
firstName
id
lastName
phoneNumber
platformId
province
storefrontUserId
updatedAt
zip
}
}
Variables
{"id": uuid}
Response
{
"data": {
"AddressByPk": {
"PaymentMethod": PaymentMethod,
"StorefrontUser": StorefrontUser,
"Subscriptions": [Subscription],
"address1": "xyz789",
"address2": "xyz789",
"city": "abc123",
"company": "abc123",
"country": "xyz789",
"createdAt": timestamptz,
"doorCode": "abc123",
"firstName": "abc123",
"id": uuid,
"lastName": "abc123",
"phoneNumber": "abc123",
"platformId": "abc123",
"province": "abc123",
"storefrontUserId": uuid,
"updatedAt": timestamptz,
"zip": "abc123"
}
}
}
Addresses
Description
fetch data from the table: "Address"
Response
Returns [Address!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [Address_order_by!]
|
sort the rows by one or more columns |
where - Address_bool_exp
|
filter the rows returned |
Example
Query
query Addresses(
$limit: Int,
$offset: Int,
$order_by: [Address_order_by!],
$where: Address_bool_exp
) {
Addresses(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
PaymentMethod {
...PaymentMethodFragment
}
StorefrontUser {
...StorefrontUserFragment
}
Subscriptions {
...SubscriptionFragment
}
address1
address2
city
company
country
createdAt
doorCode
firstName
id
lastName
phoneNumber
platformId
province
storefrontUserId
updatedAt
zip
}
}
Variables
{
"limit": 123,
"offset": 123,
"order_by": [Address_order_by],
"where": Address_bool_exp
}
Response
{
"data": {
"Addresses": [
{
"PaymentMethod": PaymentMethod,
"StorefrontUser": StorefrontUser,
"Subscriptions": [Subscription],
"address1": "abc123",
"address2": "xyz789",
"city": "xyz789",
"company": "xyz789",
"country": "xyz789",
"createdAt": timestamptz,
"doorCode": "abc123",
"firstName": "xyz789",
"id": uuid,
"lastName": "xyz789",
"phoneNumber": "xyz789",
"platformId": "xyz789",
"province": "xyz789",
"storefrontUserId": uuid,
"updatedAt": timestamptz,
"zip": "abc123"
}
]
}
}
DiscountByPk
Description
fetch data from the table: "Discount" using primary key columns
Example
Query
query DiscountByPk($id: uuid!) {
DiscountByPk(id: $id) {
CancelFlowSession {
...CancelFlowSessionFragment
}
Group {
...GroupFragment
}
GroupPlan {
...GroupPlanFragment
}
OrderLineItem {
...OrderLineItemFragment
}
ShippingLine {
...ShippingLineFragment
}
Subscription {
...SubscriptionFragment
}
SubscriptionLine {
...SubscriptionLineFragment
}
cancelFlowSessionId
createdAt
fixedValue
groupId
groupPlanId
id
maxTimesUsed
orderLineItemId
percentage
platformId
redeemCode
shippingLineId
subscriptionId
subscriptionLineId
timesUsed
type
updatedAt
}
}
Variables
{"id": uuid}
Response
{
"data": {
"DiscountByPk": {
"CancelFlowSession": CancelFlowSession,
"Group": Group,
"GroupPlan": GroupPlan,
"OrderLineItem": OrderLineItem,
"ShippingLine": ShippingLine,
"Subscription": Subscription,
"SubscriptionLine": SubscriptionLine,
"cancelFlowSessionId": uuid,
"createdAt": timestamptz,
"fixedValue": numeric,
"groupId": uuid,
"groupPlanId": uuid,
"id": uuid,
"maxTimesUsed": 123,
"orderLineItemId": uuid,
"percentage": numeric,
"platformId": "xyz789",
"redeemCode": "abc123",
"shippingLineId": uuid,
"subscriptionId": uuid,
"subscriptionLineId": uuid,
"timesUsed": 123,
"type": "xyz789",
"updatedAt": timestamptz
}
}
}
OrderByPk
Description
fetch data from the table: "Order" using primary key columns
Example
Query
query OrderByPk($id: uuid!) {
OrderByPk(id: $id) {
OrderLineItems {
...OrderLineItemFragment
}
PrepaidSubscription {
...SubscriptionFragment
}
ShippingLines {
...ShippingLineFragment
}
StorefrontUser {
...StorefrontUserFragment
}
cancelledAt
createdAt
deletedAt
deliveredAt
id
note
platformId
platformNumber
storefrontUserId
updatedAt
}
}
Variables
{"id": uuid}
Response
{
"data": {
"OrderByPk": {
"OrderLineItems": [OrderLineItem],
"PrepaidSubscription": Subscription,
"ShippingLines": [ShippingLine],
"StorefrontUser": StorefrontUser,
"cancelledAt": timestamptz,
"createdAt": timestamptz,
"deletedAt": timestamptz,
"deliveredAt": timestamptz,
"id": uuid,
"note": "xyz789",
"platformId": "abc123",
"platformNumber": "xyz789",
"storefrontUserId": uuid,
"updatedAt": timestamp
}
}
}
OrderLineItems
Description
An array relationship
Response
Returns [OrderLineItem!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [OrderLineItem_order_by!]
|
sort the rows by one or more columns |
where - OrderLineItem_bool_exp
|
filter the rows returned |
Example
Query
query OrderLineItems(
$limit: Int,
$offset: Int,
$order_by: [OrderLineItem_order_by!],
$where: OrderLineItem_bool_exp
) {
OrderLineItems(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
Discounts {
...DiscountFragment
}
GroupIfInitialOrder {
...GroupFragment
}
Order {
...OrderFragment
}
ProductVariant {
...ProductVariantFragment
}
SubscriptionLine {
...SubscriptionLineFragment
}
TaxLines {
...TaxLineFragment
}
attributionGroupId
createdAt
customAttributes
groupId
id
orderId
platformId
priceWithoutDiscount
productVariantId
quantity
subscriptionLineId
updatedAt
}
}
Variables
{
"limit": 987,
"offset": 123,
"order_by": [OrderLineItem_order_by],
"where": OrderLineItem_bool_exp
}
Response
{
"data": {
"OrderLineItems": [
{
"Discounts": [Discount],
"GroupIfInitialOrder": Group,
"Order": Order,
"ProductVariant": ProductVariant,
"SubscriptionLine": SubscriptionLine,
"TaxLines": [TaxLine],
"attributionGroupId": uuid,
"createdAt": timestamptz,
"customAttributes": jsonb,
"groupId": uuid,
"id": uuid,
"orderId": uuid,
"platformId": "abc123",
"priceWithoutDiscount": numeric,
"productVariantId": uuid,
"quantity": 123,
"subscriptionLineId": uuid,
"updatedAt": timestamptz
}
]
}
}
Orders
Description
An array relationship
Response
Returns [Order!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [Order_order_by!]
|
sort the rows by one or more columns |
where - Order_bool_exp
|
filter the rows returned |
Example
Query
query Orders(
$limit: Int,
$offset: Int,
$order_by: [Order_order_by!],
$where: Order_bool_exp
) {
Orders(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
OrderLineItems {
...OrderLineItemFragment
}
PrepaidSubscription {
...SubscriptionFragment
}
ShippingLines {
...ShippingLineFragment
}
StorefrontUser {
...StorefrontUserFragment
}
cancelledAt
createdAt
deletedAt
deliveredAt
id
note
platformId
platformNumber
storefrontUserId
updatedAt
}
}
Variables
{
"limit": 123,
"offset": 987,
"order_by": [Order_order_by],
"where": Order_bool_exp
}
Response
{
"data": {
"Orders": [
{
"OrderLineItems": [OrderLineItem],
"PrepaidSubscription": Subscription,
"ShippingLines": [ShippingLine],
"StorefrontUser": StorefrontUser,
"cancelledAt": timestamptz,
"createdAt": timestamptz,
"deletedAt": timestamptz,
"deliveredAt": timestamptz,
"id": uuid,
"note": "xyz789",
"platformId": "xyz789",
"platformNumber": "abc123",
"storefrontUserId": uuid,
"updatedAt": timestamp
}
]
}
}
Policies
Description
fetch data from the table: "Policy"
Response
Returns [Policy!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [Policy_order_by!]
|
sort the rows by one or more columns |
where - Policy_bool_exp
|
filter the rows returned |
Example
Query
query Policies(
$limit: Int,
$offset: Int,
$order_by: [Policy_order_by!],
$where: Policy_bool_exp
) {
Policies(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
Anchors {
...AnchorFragment
}
SellingPlansByBillingPolicy {
...SellingPlanFragment
}
SellingPlansByDeliveryPolicy {
...SellingPlanFragment
}
SellingPlansByPrepaidDeliveryPolicy {
...SellingPlanFragment
}
SubscriptionsByBillingPolicy {
...SubscriptionFragment
}
SubscriptionsByDeliveryPolicy {
...SubscriptionFragment
}
SubscriptionsByPrepaidDeliveryPolicy {
...SubscriptionFragment
}
createdAt
id
interval
intervalCount
maxCycles
minCycles
updatedAt
}
}
Variables
{
"limit": 987,
"offset": 123,
"order_by": [Policy_order_by],
"where": Policy_bool_exp
}
Response
{
"data": {
"Policies": [
{
"Anchors": [Anchor],
"SellingPlansByBillingPolicy": [SellingPlan],
"SellingPlansByDeliveryPolicy": [SellingPlan],
"SellingPlansByPrepaidDeliveryPolicy": [
SellingPlan
],
"SubscriptionsByBillingPolicy": [Subscription],
"SubscriptionsByDeliveryPolicy": [Subscription],
"SubscriptionsByPrepaidDeliveryPolicy": [
Subscription
],
"createdAt": timestamptz,
"id": uuid,
"interval": "xyz789",
"intervalCount": 987,
"maxCycles": 987,
"minCycles": 123,
"updatedAt": timestamptz
}
]
}
}
PolicyByPk
Description
fetch data from the table: "Policy" using primary key columns
Example
Query
query PolicyByPk($id: uuid!) {
PolicyByPk(id: $id) {
Anchors {
...AnchorFragment
}
SellingPlansByBillingPolicy {
...SellingPlanFragment
}
SellingPlansByDeliveryPolicy {
...SellingPlanFragment
}
SellingPlansByPrepaidDeliveryPolicy {
...SellingPlanFragment
}
SubscriptionsByBillingPolicy {
...SubscriptionFragment
}
SubscriptionsByDeliveryPolicy {
...SubscriptionFragment
}
SubscriptionsByPrepaidDeliveryPolicy {
...SubscriptionFragment
}
createdAt
id
interval
intervalCount
maxCycles
minCycles
updatedAt
}
}
Variables
{"id": uuid}
Response
{
"data": {
"PolicyByPk": {
"Anchors": [Anchor],
"SellingPlansByBillingPolicy": [SellingPlan],
"SellingPlansByDeliveryPolicy": [SellingPlan],
"SellingPlansByPrepaidDeliveryPolicy": [
SellingPlan
],
"SubscriptionsByBillingPolicy": [Subscription],
"SubscriptionsByDeliveryPolicy": [Subscription],
"SubscriptionsByPrepaidDeliveryPolicy": [
Subscription
],
"createdAt": timestamptz,
"id": uuid,
"interval": "abc123",
"intervalCount": 123,
"maxCycles": 987,
"minCycles": 123,
"updatedAt": timestamptz
}
}
}
PricingPolicies
Description
An array relationship
Response
Returns [PricingPolicy!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [PricingPolicy_order_by!]
|
sort the rows by one or more columns |
where - PricingPolicy_bool_exp
|
filter the rows returned |
Example
Query
query PricingPolicies(
$limit: Int,
$offset: Int,
$order_by: [PricingPolicy_order_by!],
$where: PricingPolicy_bool_exp
) {
PricingPolicies(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
SellingPlan {
...SellingPlanFragment
}
createdAt
fixedPrice
id
percentageOff
sellingPlanId
sellingPlanPricingPolicyAdjustmentType
updatedAt
}
}
Variables
{
"limit": 987,
"offset": 987,
"order_by": [PricingPolicy_order_by],
"where": PricingPolicy_bool_exp
}
Response
{
"data": {
"PricingPolicies": [
{
"SellingPlan": SellingPlan,
"createdAt": timestamptz,
"fixedPrice": numeric,
"id": uuid,
"percentageOff": numeric,
"sellingPlanId": uuid,
"sellingPlanPricingPolicyAdjustmentType": "abc123",
"updatedAt": timestamptz
}
]
}
}
PricingPolicyByPk
Description
fetch data from the table: "PricingPolicy" using primary key columns
Response
Returns a PricingPolicy
Arguments
Name | Description |
---|---|
id - uuid!
|
Example
Query
query PricingPolicyByPk($id: uuid!) {
PricingPolicyByPk(id: $id) {
SellingPlan {
...SellingPlanFragment
}
createdAt
fixedPrice
id
percentageOff
sellingPlanId
sellingPlanPricingPolicyAdjustmentType
updatedAt
}
}
Variables
{"id": uuid}
Response
{
"data": {
"PricingPolicyByPk": {
"SellingPlan": SellingPlan,
"createdAt": timestamptz,
"fixedPrice": numeric,
"id": uuid,
"percentageOff": numeric,
"sellingPlanId": uuid,
"sellingPlanPricingPolicyAdjustmentType": "abc123",
"updatedAt": timestamptz
}
}
}
ProductByPk
Description
fetch data from the table: "Product" using primary key columns
Example
Query
query ProductByPk($id: uuid!) {
ProductByPk(id: $id) {
DynamicBox {
...DynamicBoxFragment
}
ProductVariants {
...ProductVariantFragment
}
Site {
...SiteFragment
}
createdAt
deletedAt
id
imageSrc
metafields
platformId
siteId
slug
smsOrder
status
title
updatedAt
}
}
Variables
{"id": uuid}
Response
{
"data": {
"ProductByPk": {
"DynamicBox": DynamicBox,
"ProductVariants": [ProductVariant],
"Site": Site,
"createdAt": timestamptz,
"deletedAt": timestamptz,
"id": uuid,
"imageSrc": "abc123",
"metafields": jsonb,
"platformId": "xyz789",
"siteId": uuid,
"slug": "xyz789",
"smsOrder": 987,
"status": "xyz789",
"title": "abc123",
"updatedAt": timestamptz
}
}
}
ProductVariantByPk
Description
fetch data from the table: "ProductVariant" using primary key columns
Response
Returns a ProductVariant
Arguments
Name | Description |
---|---|
id - uuid!
|
Example
Query
query ProductVariantByPk($id: uuid!) {
ProductVariantByPk(id: $id) {
DynamicBox_SelectableProductVariants {
...DynamicBox_SelectableProductVariantFragment
}
OrderLineItems {
...OrderLineItemFragment
}
Product {
...ProductFragment
}
SellingPlanGroupResources {
...SellingPlanGroupResourceFragment
}
SubscriptionLines {
...SubscriptionLineFragment
}
createdAt
deletedAt
id
image
platformId
price
productId
sku
title
updatedAt
}
}
Variables
{"id": uuid}
Response
{
"data": {
"ProductVariantByPk": {
"DynamicBox_SelectableProductVariants": [
DynamicBox_SelectableProductVariant
],
"OrderLineItems": [OrderLineItem],
"Product": Product,
"SellingPlanGroupResources": [
SellingPlanGroupResource
],
"SubscriptionLines": [SubscriptionLine],
"createdAt": timestamptz,
"deletedAt": timestamptz,
"id": uuid,
"image": "xyz789",
"platformId": "abc123",
"price": numeric,
"productId": uuid,
"sku": "abc123",
"title": "xyz789",
"updatedAt": timestamptz
}
}
}
ProductVariants
Description
An array relationship
Response
Returns [ProductVariant!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [ProductVariant_order_by!]
|
sort the rows by one or more columns |
where - ProductVariant_bool_exp
|
filter the rows returned |
Example
Query
query ProductVariants(
$limit: Int,
$offset: Int,
$order_by: [ProductVariant_order_by!],
$where: ProductVariant_bool_exp
) {
ProductVariants(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
DynamicBox_SelectableProductVariants {
...DynamicBox_SelectableProductVariantFragment
}
OrderLineItems {
...OrderLineItemFragment
}
Product {
...ProductFragment
}
SellingPlanGroupResources {
...SellingPlanGroupResourceFragment
}
SubscriptionLines {
...SubscriptionLineFragment
}
createdAt
deletedAt
id
image
platformId
price
productId
sku
title
updatedAt
}
}
Variables
{
"limit": 987,
"offset": 987,
"order_by": [ProductVariant_order_by],
"where": ProductVariant_bool_exp
}
Response
{
"data": {
"ProductVariants": [
{
"DynamicBox_SelectableProductVariants": [
DynamicBox_SelectableProductVariant
],
"OrderLineItems": [OrderLineItem],
"Product": Product,
"SellingPlanGroupResources": [
SellingPlanGroupResource
],
"SubscriptionLines": [SubscriptionLine],
"createdAt": timestamptz,
"deletedAt": timestamptz,
"id": uuid,
"image": "xyz789",
"platformId": "abc123",
"price": numeric,
"productId": uuid,
"sku": "abc123",
"title": "xyz789",
"updatedAt": timestamptz
}
]
}
}
Products
Description
An array relationship
Response
Returns [Product!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [Product_order_by!]
|
sort the rows by one or more columns |
where - Product_bool_exp
|
filter the rows returned |
Example
Query
query Products(
$limit: Int,
$offset: Int,
$order_by: [Product_order_by!],
$where: Product_bool_exp
) {
Products(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
DynamicBox {
...DynamicBoxFragment
}
ProductVariants {
...ProductVariantFragment
}
Site {
...SiteFragment
}
createdAt
deletedAt
id
imageSrc
metafields
platformId
siteId
slug
smsOrder
status
title
updatedAt
}
}
Variables
{
"limit": 987,
"offset": 123,
"order_by": [Product_order_by],
"where": Product_bool_exp
}
Response
{
"data": {
"Products": [
{
"DynamicBox": DynamicBox,
"ProductVariants": [ProductVariant],
"Site": Site,
"createdAt": timestamptz,
"deletedAt": timestamptz,
"id": uuid,
"imageSrc": "abc123",
"metafields": jsonb,
"platformId": "xyz789",
"siteId": uuid,
"slug": "abc123",
"smsOrder": 123,
"status": "abc123",
"title": "xyz789",
"updatedAt": timestamptz
}
]
}
}
SubscriptionByPk
Description
fetch data from the table: "Subscription" using primary key columns
Response
Returns a Subscription
Arguments
Name | Description |
---|---|
id - uuid!
|
Example
Query
query SubscriptionByPk($id: uuid!) {
SubscriptionByPk(id: $id) {
AuditLogs {
...AuditLogFragment
}
BillingPolicy {
...PolicyFragment
}
CancelFlowSessions {
...CancelFlowSessionFragment
}
DeliveryPolicy {
...PolicyFragment
}
Discounts {
...DiscountFragment
}
FulfillmentOrders {
...OrderFragment
}
NotificationLogs {
...NotificationLogFragment
}
PaymentMethod {
...PaymentMethodFragment
}
PrepaidDeliveryPolicy {
...PolicyFragment
}
PrepaidSubscriptionLines {
...SubscriptionLineFragment
}
ShippingAddress {
...AddressFragment
}
Site {
...SiteFragment
}
StorefrontUser {
...StorefrontUserFragment
}
SubscriptionLines {
...SubscriptionLineFragment
}
billingPolicyId
cancelledAt
createdAt
currencyCode
customAttributes
cyclesCompleted
deliveryPolicyId
deliveryPrice
deliveryPriceOverride
id
lastBillingAttemptAt
metadata
nextBillingDate
platformId
prepaidDeliveryPolicyId
prepaidProductPricesPerDelivery
shippingAddressId
siteId
status
statusContext
storefrontUserId
updatedAt
}
}
Variables
{"id": uuid}
Response
{
"data": {
"SubscriptionByPk": {
"AuditLogs": [AuditLog],
"BillingPolicy": Policy,
"CancelFlowSessions": [CancelFlowSession],
"DeliveryPolicy": Policy,
"Discounts": [Discount],
"FulfillmentOrders": [Order],
"NotificationLogs": [NotificationLog],
"PaymentMethod": PaymentMethod,
"PrepaidDeliveryPolicy": Policy,
"PrepaidSubscriptionLines": [SubscriptionLine],
"ShippingAddress": Address,
"Site": Site,
"StorefrontUser": StorefrontUser,
"SubscriptionLines": [SubscriptionLine],
"billingPolicyId": uuid,
"cancelledAt": timestamptz,
"createdAt": timestamptz,
"currencyCode": "abc123",
"customAttributes": jsonb,
"cyclesCompleted": 123,
"deliveryPolicyId": uuid,
"deliveryPrice": numeric,
"deliveryPriceOverride": 123,
"id": uuid,
"lastBillingAttemptAt": timestamptz,
"metadata": jsonb,
"nextBillingDate": timestamptz,
"platformId": "abc123",
"prepaidDeliveryPolicyId": uuid,
"prepaidProductPricesPerDelivery": jsonb,
"shippingAddressId": uuid,
"siteId": uuid,
"status": "xyz789",
"statusContext": "xyz789",
"storefrontUserId": uuid,
"updatedAt": timestamptz
}
}
}
SubscriptionLines
Description
An array relationship
Response
Returns [SubscriptionLine!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [SubscriptionLine_order_by!]
|
sort the rows by one or more columns |
where - SubscriptionLine_bool_exp
|
filter the rows returned |
Example
Query
query SubscriptionLines(
$limit: Int,
$offset: Int,
$order_by: [SubscriptionLine_order_by!],
$where: SubscriptionLine_bool_exp
) {
SubscriptionLines(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
Discounts {
...DiscountFragment
}
Group {
...GroupFragment
}
OrderLineItems {
...OrderLineItemFragment
}
OriginalSellingPlan {
...SellingPlanFragment
}
PrepaidSubscription {
...SubscriptionFragment
}
ProductVariant {
...ProductVariantFragment
}
Subscription {
...SubscriptionFragment
}
createdAt
customAttributes
groupId
id
ordersRemaining
platformId
priceWithoutDiscount
productVariantId
quantity
removedAt
sellingPlanId
subscriptionId
taxable
titleOverride
updatedAt
}
}
Variables
{
"limit": 987,
"offset": 123,
"order_by": [SubscriptionLine_order_by],
"where": SubscriptionLine_bool_exp
}
Response
{
"data": {
"SubscriptionLines": [
{
"Discounts": [Discount],
"Group": Group,
"OrderLineItems": [OrderLineItem],
"OriginalSellingPlan": SellingPlan,
"PrepaidSubscription": Subscription,
"ProductVariant": ProductVariant,
"Subscription": Subscription,
"createdAt": timestamptz,
"customAttributes": jsonb,
"groupId": uuid,
"id": uuid,
"ordersRemaining": 987,
"platformId": "abc123",
"priceWithoutDiscount": numeric,
"productVariantId": uuid,
"quantity": 987,
"removedAt": timestamptz,
"sellingPlanId": uuid,
"subscriptionId": uuid,
"taxable": false,
"titleOverride": "xyz789",
"updatedAt": timestamptz
}
]
}
}
Subscriptions
Description
An array relationship
Response
Returns [Subscription!]!
Arguments
Name | Description |
---|---|
limit - Int
|
limit the number of rows returned |
offset - Int
|
skip the first n rows. Use only with order_by |
order_by - [Subscription_order_by!]
|
sort the rows by one or more columns |
where - Subscription_bool_exp
|
filter the rows returned |
Example
Query
query Subscriptions(
$limit: Int,
$offset: Int,
$order_by: [Subscription_order_by!],
$where: Subscription_bool_exp
) {
Subscriptions(
limit: $limit,
offset: $offset,
order_by: $order_by,
where: $where
) {
AuditLogs {
...AuditLogFragment
}
BillingPolicy {
...PolicyFragment
}
CancelFlowSessions {
...CancelFlowSessionFragment
}
DeliveryPolicy {
...PolicyFragment
}
Discounts {
...DiscountFragment
}
FulfillmentOrders {
...OrderFragment
}
NotificationLogs {
...NotificationLogFragment
}
PaymentMethod {
...PaymentMethodFragment
}
PrepaidDeliveryPolicy {
...PolicyFragment
}
PrepaidSubscriptionLines {
...SubscriptionLineFragment
}
ShippingAddress {
...AddressFragment
}
Site {
...SiteFragment
}
StorefrontUser {
...StorefrontUserFragment
}
SubscriptionLines {
...SubscriptionLineFragment
}
billingPolicyId
cancelledAt
createdAt
currencyCode
customAttributes
cyclesCompleted
deliveryPolicyId
deliveryPrice
deliveryPriceOverride
id
lastBillingAttemptAt
metadata
nextBillingDate
platformId
prepaidDeliveryPolicyId
prepaidProductPricesPerDelivery
shippingAddressId
siteId
status
statusContext
storefrontUserId
updatedAt
}
}
Variables
{
"limit": 987,
"offset": 123,
"order_by": [Subscription_order_by],
"where": Subscription_bool_exp
}
Response
{
"data": {
"Subscriptions": [
{
"AuditLogs": [AuditLog],
"BillingPolicy": Policy,
"CancelFlowSessions": [CancelFlowSession],
"DeliveryPolicy": Policy,
"Discounts": [Discount],
"FulfillmentOrders": [Order],
"NotificationLogs": [NotificationLog],
"PaymentMethod": PaymentMethod,
"PrepaidDeliveryPolicy": Policy,
"PrepaidSubscriptionLines": [SubscriptionLine],
"ShippingAddress": Address,
"Site": Site,
"StorefrontUser": StorefrontUser,
"SubscriptionLines": [SubscriptionLine],
"billingPolicyId": uuid,
"cancelledAt": timestamptz,
"createdAt": timestamptz,
"currencyCode": "abc123",
"customAttributes": jsonb,
"cyclesCompleted": 123,
"deliveryPolicyId": uuid,
"deliveryPrice": numeric,
"deliveryPriceOverride": 987,
"id": uuid,
"lastBillingAttemptAt": timestamptz,
"metadata": jsonb,
"nextBillingDate": timestamptz,
"platformId": "abc123",
"prepaidDeliveryPolicyId": uuid,
"prepaidProductPricesPerDelivery": jsonb,
"shippingAddressId": uuid,
"siteId": uuid,
"status": "abc123",
"statusContext": "xyz789",
"storefrontUserId": uuid,
"updatedAt": timestamptz
}
]
}
}
Mutations
addSubscriptionLine
Description
Adds a product to a subscription, with the option of adding it as a one time item (only valid for the next order). The price is optional, by default it will use the price from Shopify with the closest matching selling plan discount. This doesn't support prepaid subscriptions.
Response
Returns an AddSubscriptionLineOutput
Arguments
Name | Description |
---|---|
input - AddSubscriptionLineInput!
|
Example
Query
mutation addSubscriptionLine($input: AddSubscriptionLineInput!) {
addSubscriptionLine(input: $input) {
ok
}
}
Variables
{"input": AddSubscriptionLineInput}
Response
{"data": {"addSubscriptionLine": {"ok": true}}}
applyDiscountCode
Description
Apply a discount code on a subscription
Response
Returns an ApplyDiscountCodeOutput
Arguments
Name | Description |
---|---|
input - ApplyDiscountCodeInput!
|
Example
Query
mutation applyDiscountCode($input: ApplyDiscountCodeInput!) {
applyDiscountCode(input: $input) {
message
ok
}
}
Variables
{"input": ApplyDiscountCodeInput}
Response
{
"data": {
"applyDiscountCode": {
"message": "xyz789",
"ok": false
}
}
}
cancelSubscription
Description
Cancels a specific subscription and associated SubscriptionContract on Shopify. If the subscription is a prepaid subscription, then first calculate remaining shipments and set maxcycles such that subscription will be killed once remaining shipments are processed.
Response
Returns a CancelSubscriptionOutput
Arguments
Name | Description |
---|---|
input - CancelSubscriptionInput!
|
Example
Query
mutation cancelSubscription($input: CancelSubscriptionInput!) {
cancelSubscription(input: $input) {
ok
}
}
Variables
{"input": CancelSubscriptionInput}
Response
{"data": {"cancelSubscription": {"ok": false}}}
pauseSubscription
Description
Pause a subscription
Response
Returns a pauseSubscriptionOutput
Arguments
Name | Description |
---|---|
input - pauseSubscriptionInput!
|
Example
Query
mutation pauseSubscription($input: pauseSubscriptionInput!) {
pauseSubscription(input: $input) {
message
ok
}
}
Variables
{"input": pauseSubscriptionInput}
Response
{
"data": {
"pauseSubscription": {
"message": "abc123",
"ok": false
}
}
}
unpauseSubscription
Description
UnpauseSubscription
Response
Returns an unpauseSubscriptionOutput
Arguments
Name | Description |
---|---|
input - unpauseSubscriptionInput!
|
Example
Query
mutation unpauseSubscription($input: unpauseSubscriptionInput!) {
unpauseSubscription(input: $input) {
message
ok
}
}
Variables
{"input": unpauseSubscriptionInput}
Response
{
"data": {
"unpauseSubscription": {
"message": "xyz789",
"ok": true
}
}
}
updateNextBillingDate
Description
Change next billing date of a subscription. Date format should be an ISO string (YYYY-MM-DD), e.g 2022-01-01T17:44:49.406+00:00
Response
Returns an UpdateNextBillingDateOutput
Arguments
Name | Description |
---|---|
input - UpdateNextBillingDateInput!
|
Example
Query
mutation updateNextBillingDate($input: UpdateNextBillingDateInput!) {
updateNextBillingDate(input: $input) {
message
ok
}
}
Variables
{"input": UpdateNextBillingDateInput}
Response
{
"data": {
"updateNextBillingDate": {
"message": "abc123",
"ok": true
}
}
}
updateSubscriptionLine
Description
Updates the subscription line (referenced by either a prepaidSubscriptionLineId or a subscriptionLineId) and changes quantity, price, or productVariant. IDs are Skio IDs. Quantity, price, and productVariant are optional, so only provide values for those you want to change.
Response
Returns an UpdateSubscriptionLineOutput
Arguments
Name | Description |
---|---|
input - UpdateSubscriptionLineInput!
|
Example
Query
mutation updateSubscriptionLine($input: UpdateSubscriptionLineInput!) {
updateSubscriptionLine(input: $input) {
ok
}
}
Variables
{"input": UpdateSubscriptionLineInput}
Response
{"data": {"updateSubscriptionLine": {"ok": false}}}
updateSubscriptionShippingAddress
Description
updates a subscriptions shipping address
Response
Returns an UpdateSubscriptionShippingAddressOutput
Arguments
Name | Description |
---|---|
input - UpdateSubscriptionShippingAddressInput!
|
Example
Query
mutation updateSubscriptionShippingAddress($input: UpdateSubscriptionShippingAddressInput!) {
updateSubscriptionShippingAddress(input: $input) {
message
ok
}
}
Variables
{"input": UpdateSubscriptionShippingAddressInput}
Response
{
"data": {
"updateSubscriptionShippingAddress": {
"message": "xyz789",
"ok": true
}
}
}
Types
AddSubscriptionLineInput
AddSubscriptionLineOutput
Fields
Field Name | Description |
---|---|
ok - Boolean!
|
Example
{"ok": true}
Address
Description
first/last nullable for billing fields
Fields
Field Name | Description |
---|---|
PaymentMethod - PaymentMethod
|
An object relationship |
StorefrontUser - StorefrontUser!
|
An object relationship |
Subscriptions - [Subscription!]!
|
An array relationship |
address1 - String
|
|
address2 - String
|
|
city - String
|
|
company - String
|
|
country - String
|
|
createdAt - timestamptz!
|
|
doorCode - String
|
|
firstName - String
|
|
id - uuid!
|
|
lastName - String
|
|
phoneNumber - String
|
|
platformId - String
|
|
province - String
|
|
storefrontUserId - uuid!
|
|
updatedAt - timestamptz!
|
|
zip - String
|
Example
{
"PaymentMethod": PaymentMethod,
"StorefrontUser": StorefrontUser,
"Subscriptions": [Subscription],
"address1": "xyz789",
"address2": "xyz789",
"city": "xyz789",
"company": "xyz789",
"country": "abc123",
"createdAt": timestamptz,
"doorCode": "xyz789",
"firstName": "abc123",
"id": uuid,
"lastName": "abc123",
"phoneNumber": "xyz789",
"platformId": "abc123",
"province": "xyz789",
"storefrontUserId": uuid,
"updatedAt": timestamptz,
"zip": "xyz789"
}
Address_aggregate_order_by
Description
order by aggregate values of table "Address"
Fields
Input Field | Description |
---|---|
max - Address_max_order_by
|
|
min - Address_min_order_by
|
Example
{
"max": Address_max_order_by,
"min": Address_min_order_by
}
Address_bool_exp
Description
Boolean expression to filter rows from the table "Address". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
PaymentMethod - PaymentMethod_bool_exp
|
|
StorefrontUser - StorefrontUser_bool_exp
|
|
Subscriptions - Subscription_bool_exp
|
|
_and - [Address_bool_exp!]
|
|
_not - Address_bool_exp
|
|
_or - [Address_bool_exp!]
|
|
address1 - String_comparison_exp
|
|
address2 - String_comparison_exp
|
|
city - String_comparison_exp
|
|
company - String_comparison_exp
|
|
country - String_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
doorCode - String_comparison_exp
|
|
firstName - String_comparison_exp
|
|
id - uuid_comparison_exp
|
|
lastName - String_comparison_exp
|
|
phoneNumber - String_comparison_exp
|
|
platformId - String_comparison_exp
|
|
province - String_comparison_exp
|
|
storefrontUserId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
|
zip - String_comparison_exp
|
Example
{
"PaymentMethod": PaymentMethod_bool_exp,
"StorefrontUser": StorefrontUser_bool_exp,
"Subscriptions": Subscription_bool_exp,
"_and": [Address_bool_exp],
"_not": Address_bool_exp,
"_or": [Address_bool_exp],
"address1": String_comparison_exp,
"address2": String_comparison_exp,
"city": String_comparison_exp,
"company": String_comparison_exp,
"country": String_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"doorCode": String_comparison_exp,
"firstName": String_comparison_exp,
"id": uuid_comparison_exp,
"lastName": String_comparison_exp,
"phoneNumber": String_comparison_exp,
"platformId": String_comparison_exp,
"province": String_comparison_exp,
"storefrontUserId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp,
"zip": String_comparison_exp
}
Address_max_order_by
Description
order by max() on columns of table "Address"
Example
{}
Address_min_order_by
Description
order by min() on columns of table "Address"
Example
{}
Address_order_by
Description
Ordering options when selecting data from "Address".
Fields
Input Field | Description |
---|---|
PaymentMethod - PaymentMethod_order_by
|
|
StorefrontUser - StorefrontUser_order_by
|
|
Subscriptions_aggregate - Subscription_aggregate_order_by
|
Example
{
"PaymentMethod": PaymentMethod_order_by,
"StorefrontUser": StorefrontUser_order_by,
"Subscriptions_aggregate": Subscription_aggregate_order_by
}
Anchor
Description
storefront user select/insert/update kinda funny. select is for seeing all anchor types (I think?!) and insert/update for modifying date
Example
{
"Policy": Policy,
"createdAt": timestamptz,
"cutoffDay": 123,
"day": 123,
"id": uuid,
"missedAnchorAllowance": 123,
"month": 987,
"policyId": uuid,
"strictness": "xyz789",
"type": "xyz789",
"updatedAt": timestamptz
}
Anchor_aggregate_order_by
Description
order by aggregate values of table "Anchor"
Fields
Input Field | Description |
---|---|
avg - Anchor_avg_order_by
|
|
max - Anchor_max_order_by
|
|
min - Anchor_min_order_by
|
|
stddev - Anchor_stddev_order_by
|
|
stddev_pop - Anchor_stddev_pop_order_by
|
|
stddev_samp - Anchor_stddev_samp_order_by
|
|
sum - Anchor_sum_order_by
|
|
var_pop - Anchor_var_pop_order_by
|
|
var_samp - Anchor_var_samp_order_by
|
|
variance - Anchor_variance_order_by
|
Example
{
"avg": Anchor_avg_order_by,
"max": Anchor_max_order_by,
"min": Anchor_min_order_by,
"stddev": Anchor_stddev_order_by,
"stddev_pop": Anchor_stddev_pop_order_by,
"stddev_samp": Anchor_stddev_samp_order_by,
"sum": Anchor_sum_order_by,
"var_pop": Anchor_var_pop_order_by,
"var_samp": Anchor_var_samp_order_by,
"variance": Anchor_variance_order_by
}
Anchor_avg_order_by
Description
order by avg() on columns of table "Anchor"
Example
{}
Anchor_bool_exp
Description
Boolean expression to filter rows from the table "Anchor". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
Policy - Policy_bool_exp
|
|
_and - [Anchor_bool_exp!]
|
|
_not - Anchor_bool_exp
|
|
_or - [Anchor_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
cutoffDay - Int_comparison_exp
|
|
day - Int_comparison_exp
|
|
id - uuid_comparison_exp
|
|
missedAnchorAllowance - Int_comparison_exp
|
|
month - Int_comparison_exp
|
|
policyId - uuid_comparison_exp
|
|
strictness - String_comparison_exp
|
|
type - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"Policy": Policy_bool_exp,
"_and": [Anchor_bool_exp],
"_not": Anchor_bool_exp,
"_or": [Anchor_bool_exp],
"createdAt": timestamptz_comparison_exp,
"cutoffDay": Int_comparison_exp,
"day": Int_comparison_exp,
"id": uuid_comparison_exp,
"missedAnchorAllowance": Int_comparison_exp,
"month": Int_comparison_exp,
"policyId": uuid_comparison_exp,
"strictness": String_comparison_exp,
"type": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
Anchor_max_order_by
Description
order by max() on columns of table "Anchor"
Example
{}
Anchor_min_order_by
Description
order by min() on columns of table "Anchor"
Example
{}
Anchor_stddev_order_by
Description
order by stddev() on columns of table "Anchor"
Example
{}
Anchor_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "Anchor"
Example
{}
Anchor_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "Anchor"
Example
{}
Anchor_sum_order_by
Description
order by sum() on columns of table "Anchor"
Example
{}
Anchor_var_pop_order_by
Description
order by var_pop() on columns of table "Anchor"
Example
{}
Anchor_var_samp_order_by
Description
order by var_samp() on columns of table "Anchor"
Example
{}
Anchor_variance_order_by
Description
order by variance() on columns of table "Anchor"
Example
{}
ApplyDiscountCodeInput
ApplyDiscountCodeOutput
AuditLog
Description
columns and relationships of "AuditLog"
Fields
Field Name | Description |
---|---|
StorefrontUser - StorefrontUser
|
An object relationship |
Subscription - Subscription
|
An object relationship |
createdAt - timestamptz!
|
|
eventData - jsonb!
|
|
eventType - String!
|
|
id - uuid!
|
|
storefrontUserId - uuid
|
|
subscriptionId - uuid
|
|
updatedAt - timestamptz!
|
Example
{
"StorefrontUser": StorefrontUser,
"Subscription": Subscription,
"createdAt": timestamptz,
"eventData": jsonb,
"eventType": "abc123",
"id": uuid,
"storefrontUserId": uuid,
"subscriptionId": uuid,
"updatedAt": timestamptz
}
AuditLog_aggregate_order_by
Description
order by aggregate values of table "AuditLog"
Fields
Input Field | Description |
---|---|
max - AuditLog_max_order_by
|
|
min - AuditLog_min_order_by
|
Example
{
"max": AuditLog_max_order_by,
"min": AuditLog_min_order_by
}
AuditLog_bool_exp
Description
Boolean expression to filter rows from the table "AuditLog". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
StorefrontUser - StorefrontUser_bool_exp
|
|
Subscription - Subscription_bool_exp
|
|
_and - [AuditLog_bool_exp!]
|
|
_not - AuditLog_bool_exp
|
|
_or - [AuditLog_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
eventData - jsonb_comparison_exp
|
|
eventType - String_comparison_exp
|
|
id - uuid_comparison_exp
|
|
storefrontUserId - uuid_comparison_exp
|
|
subscriptionId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"StorefrontUser": StorefrontUser_bool_exp,
"Subscription": Subscription_bool_exp,
"_and": [AuditLog_bool_exp],
"_not": AuditLog_bool_exp,
"_or": [AuditLog_bool_exp],
"createdAt": timestamptz_comparison_exp,
"eventData": jsonb_comparison_exp,
"eventType": String_comparison_exp,
"id": uuid_comparison_exp,
"storefrontUserId": uuid_comparison_exp,
"subscriptionId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
AuditLog_max_order_by
Description
order by max() on columns of table "AuditLog"
Example
{}
AuditLog_min_order_by
Description
order by min() on columns of table "AuditLog"
Example
{}
BillingAttempt_bool_exp
Description
Boolean expression to filter rows from the table "BillingAttempt". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
Order - Order_bool_exp
|
|
Subscription - Subscription_bool_exp
|
|
_and - [BillingAttempt_bool_exp!]
|
|
_not - BillingAttempt_bool_exp
|
|
_or - [BillingAttempt_bool_exp!]
|
|
billingAttemptedAt - timestamptz_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
errorCode - String_comparison_exp
|
|
errorMessage - String_comparison_exp
|
|
id - uuid_comparison_exp
|
|
orderId - uuid_comparison_exp
|
|
orderPlatformId - String_comparison_exp
|
|
platformId - String_comparison_exp
|
|
subscriptionBillingDate - timestamptz_comparison_exp
|
|
subscriptionId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"Order": Order_bool_exp,
"Subscription": Subscription_bool_exp,
"_and": [BillingAttempt_bool_exp],
"_not": BillingAttempt_bool_exp,
"_or": [BillingAttempt_bool_exp],
"billingAttemptedAt": timestamptz_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"errorCode": String_comparison_exp,
"errorMessage": String_comparison_exp,
"id": uuid_comparison_exp,
"orderId": uuid_comparison_exp,
"orderPlatformId": String_comparison_exp,
"platformId": String_comparison_exp,
"subscriptionBillingDate": timestamptz_comparison_exp,
"subscriptionId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
Boolean
Example
true
Boolean_comparison_exp
Description
Boolean expression to compare columns of type "Boolean". All fields are combined with logical 'AND'.
Fields
Input Field | Description |
---|---|
_eq - Boolean
|
|
_gt - Boolean
|
|
_gte - Boolean
|
|
_in - [Boolean!]
|
|
_is_null - Boolean
|
|
_lt - Boolean
|
|
_lte - Boolean
|
|
_neq - Boolean
|
|
_nin - [Boolean!]
|
Example
{
"_eq": true,
"_gt": true,
"_gte": false,
"_in": [false],
"_is_null": false,
"_lt": false,
"_lte": false,
"_neq": false,
"_nin": [false]
}
CancelFlowReason
Description
columns and relationships of "CancelFlowReason"
Fields
Field Name | Description |
---|---|
CancelFlowSession - CancelFlowSession
|
An object relationship |
cancelFlowId - uuid!
|
|
cancelFlowSessionId - uuid
|
|
createdAt - timestamptz!
|
|
id - uuid!
|
|
order - numeric!
|
|
otherReasonBody - String
|
|
reason - String!
|
|
rebuttal - String
|
|
updatedAt - timestamptz!
|
Example
{
"CancelFlowSession": CancelFlowSession,
"cancelFlowId": uuid,
"cancelFlowSessionId": uuid,
"createdAt": timestamptz,
"id": uuid,
"order": numeric,
"otherReasonBody": "abc123",
"reason": "xyz789",
"rebuttal": "abc123",
"updatedAt": timestamptz
}
CancelFlowReason_bool_exp
Description
Boolean expression to filter rows from the table "CancelFlowReason". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
CancelFlowSession - CancelFlowSession_bool_exp
|
|
_and - [CancelFlowReason_bool_exp!]
|
|
_not - CancelFlowReason_bool_exp
|
|
_or - [CancelFlowReason_bool_exp!]
|
|
cancelFlowId - uuid_comparison_exp
|
|
cancelFlowSessionId - uuid_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
order - numeric_comparison_exp
|
|
otherReasonBody - String_comparison_exp
|
|
reason - String_comparison_exp
|
|
rebuttal - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"CancelFlowSession": CancelFlowSession_bool_exp,
"_and": [CancelFlowReason_bool_exp],
"_not": CancelFlowReason_bool_exp,
"_or": [CancelFlowReason_bool_exp],
"cancelFlowId": uuid_comparison_exp,
"cancelFlowSessionId": uuid_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"order": numeric_comparison_exp,
"otherReasonBody": String_comparison_exp,
"reason": String_comparison_exp,
"rebuttal": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
CancelFlowReason_order_by
Description
Ordering options when selecting data from "CancelFlowReason".
Fields
Input Field | Description |
---|---|
CancelFlowSession - CancelFlowSession_order_by
|
Example
{"CancelFlowSession": CancelFlowSession_order_by}
CancelFlowSession
Description
columns and relationships of "CancelFlowSession"
Fields
Field Name | Description |
---|---|
CancelFlowReason - CancelFlowReason
|
An object relationship |
Discounts - [Discount!]!
|
An array relationship |
Subscription - Subscription!
|
An object relationship |
cancelFlowId - uuid!
|
|
createdAt - timestamptz!
|
|
id - uuid!
|
|
status - String
|
|
subscriptionId - uuid!
|
|
updatedAt - timestamptz!
|
Example
{
"CancelFlowReason": CancelFlowReason,
"Discounts": [Discount],
"Subscription": Subscription,
"cancelFlowId": uuid,
"createdAt": timestamptz,
"id": uuid,
"status": "xyz789",
"subscriptionId": uuid,
"updatedAt": timestamptz
}
CancelFlowSession_aggregate_order_by
Description
order by aggregate values of table "CancelFlowSession"
Fields
Input Field | Description |
---|---|
max - CancelFlowSession_max_order_by
|
|
min - CancelFlowSession_min_order_by
|
Example
{
"max": CancelFlowSession_max_order_by,
"min": CancelFlowSession_min_order_by
}
CancelFlowSession_bool_exp
Description
Boolean expression to filter rows from the table "CancelFlowSession". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
CancelFlowReason - CancelFlowReason_bool_exp
|
|
Discounts - Discount_bool_exp
|
|
Subscription - Subscription_bool_exp
|
|
_and - [CancelFlowSession_bool_exp!]
|
|
_not - CancelFlowSession_bool_exp
|
|
_or - [CancelFlowSession_bool_exp!]
|
|
cancelFlowId - uuid_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
status - String_comparison_exp
|
|
subscriptionId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"CancelFlowReason": CancelFlowReason_bool_exp,
"Discounts": Discount_bool_exp,
"Subscription": Subscription_bool_exp,
"_and": [CancelFlowSession_bool_exp],
"_not": CancelFlowSession_bool_exp,
"_or": [CancelFlowSession_bool_exp],
"cancelFlowId": uuid_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"status": String_comparison_exp,
"subscriptionId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
CancelFlowSession_max_order_by
Description
order by max() on columns of table "CancelFlowSession"
Example
{}
CancelFlowSession_min_order_by
Description
order by min() on columns of table "CancelFlowSession"
Example
{}
CancelFlowSession_order_by
Description
Ordering options when selecting data from "CancelFlowSession".
Fields
Input Field | Description |
---|---|
CancelFlowReason - CancelFlowReason_order_by
|
|
Discounts_aggregate - Discount_aggregate_order_by
|
|
Subscription - Subscription_order_by
|
Example
{
"CancelFlowReason": CancelFlowReason_order_by,
"Discounts_aggregate": Discount_aggregate_order_by,
"Subscription": Subscription_order_by
}
CancelSubscriptionInput
CancelSubscriptionOutput
Fields
Field Name | Description |
---|---|
ok - Boolean!
|
Example
{"ok": false}
Discount
Description
We stick the objects on here since we want to be able to point multiple discounts at them.
Fields
Field Name | Description |
---|---|
CancelFlowSession - CancelFlowSession
|
An object relationship |
Group - Group
|
An object relationship |
GroupPlan - GroupPlan
|
An object relationship |
OrderLineItem - OrderLineItem
|
An object relationship |
ShippingLine - ShippingLine
|
An object relationship |
Subscription - Subscription
|
An object relationship |
SubscriptionLine - SubscriptionLine
|
An object relationship |
cancelFlowSessionId - uuid
|
|
createdAt - timestamptz!
|
|
fixedValue - numeric
|
|
groupId - uuid
|
|
groupPlanId - uuid
|
|
id - uuid!
|
|
maxTimesUsed - Int
|
|
orderLineItemId - uuid
|
|
percentage - numeric
|
|
platformId - String
|
|
redeemCode - String
|
|
shippingLineId - uuid
|
|
subscriptionId - uuid
|
|
subscriptionLineId - uuid
|
|
timesUsed - Int
|
|
type - String
|
|
updatedAt - timestamptz!
|
Example
{
"CancelFlowSession": CancelFlowSession,
"Group": Group,
"GroupPlan": GroupPlan,
"OrderLineItem": OrderLineItem,
"ShippingLine": ShippingLine,
"Subscription": Subscription,
"SubscriptionLine": SubscriptionLine,
"cancelFlowSessionId": uuid,
"createdAt": timestamptz,
"fixedValue": numeric,
"groupId": uuid,
"groupPlanId": uuid,
"id": uuid,
"maxTimesUsed": 123,
"orderLineItemId": uuid,
"percentage": numeric,
"platformId": "xyz789",
"redeemCode": "xyz789",
"shippingLineId": uuid,
"subscriptionId": uuid,
"subscriptionLineId": uuid,
"timesUsed": 987,
"type": "abc123",
"updatedAt": timestamptz
}
Discount_aggregate_order_by
Description
order by aggregate values of table "Discount"
Fields
Input Field | Description |
---|---|
avg - Discount_avg_order_by
|
|
max - Discount_max_order_by
|
|
min - Discount_min_order_by
|
|
stddev - Discount_stddev_order_by
|
|
stddev_pop - Discount_stddev_pop_order_by
|
|
stddev_samp - Discount_stddev_samp_order_by
|
|
sum - Discount_sum_order_by
|
|
var_pop - Discount_var_pop_order_by
|
|
var_samp - Discount_var_samp_order_by
|
|
variance - Discount_variance_order_by
|
Example
{
"avg": Discount_avg_order_by,
"max": Discount_max_order_by,
"min": Discount_min_order_by,
"stddev": Discount_stddev_order_by,
"stddev_pop": Discount_stddev_pop_order_by,
"stddev_samp": Discount_stddev_samp_order_by,
"sum": Discount_sum_order_by,
"var_pop": Discount_var_pop_order_by,
"var_samp": Discount_var_samp_order_by,
"variance": Discount_variance_order_by
}
Discount_avg_order_by
Description
order by avg() on columns of table "Discount"
Example
{}
Discount_bool_exp
Description
Boolean expression to filter rows from the table "Discount". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
CancelFlowSession - CancelFlowSession_bool_exp
|
|
Group - Group_bool_exp
|
|
GroupPlan - GroupPlan_bool_exp
|
|
OrderLineItem - OrderLineItem_bool_exp
|
|
ShippingLine - ShippingLine_bool_exp
|
|
Subscription - Subscription_bool_exp
|
|
SubscriptionLine - SubscriptionLine_bool_exp
|
|
_and - [Discount_bool_exp!]
|
|
_not - Discount_bool_exp
|
|
_or - [Discount_bool_exp!]
|
|
cancelFlowSessionId - uuid_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
fixedValue - numeric_comparison_exp
|
|
groupId - uuid_comparison_exp
|
|
groupPlanId - uuid_comparison_exp
|
|
id - uuid_comparison_exp
|
|
maxTimesUsed - Int_comparison_exp
|
|
orderLineItemId - uuid_comparison_exp
|
|
percentage - numeric_comparison_exp
|
|
platformId - String_comparison_exp
|
|
redeemCode - String_comparison_exp
|
|
shippingLineId - uuid_comparison_exp
|
|
subscriptionId - uuid_comparison_exp
|
|
subscriptionLineId - uuid_comparison_exp
|
|
timesUsed - Int_comparison_exp
|
|
type - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"CancelFlowSession": CancelFlowSession_bool_exp,
"Group": Group_bool_exp,
"GroupPlan": GroupPlan_bool_exp,
"OrderLineItem": OrderLineItem_bool_exp,
"ShippingLine": ShippingLine_bool_exp,
"Subscription": Subscription_bool_exp,
"SubscriptionLine": SubscriptionLine_bool_exp,
"_and": [Discount_bool_exp],
"_not": Discount_bool_exp,
"_or": [Discount_bool_exp],
"cancelFlowSessionId": uuid_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"fixedValue": numeric_comparison_exp,
"groupId": uuid_comparison_exp,
"groupPlanId": uuid_comparison_exp,
"id": uuid_comparison_exp,
"maxTimesUsed": Int_comparison_exp,
"orderLineItemId": uuid_comparison_exp,
"percentage": numeric_comparison_exp,
"platformId": String_comparison_exp,
"redeemCode": String_comparison_exp,
"shippingLineId": uuid_comparison_exp,
"subscriptionId": uuid_comparison_exp,
"subscriptionLineId": uuid_comparison_exp,
"timesUsed": Int_comparison_exp,
"type": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
Discount_max_order_by
Description
order by max() on columns of table "Discount"
Example
{}
Discount_min_order_by
Description
order by min() on columns of table "Discount"
Example
{}
Discount_stddev_order_by
Description
order by stddev() on columns of table "Discount"
Example
{}
Discount_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "Discount"
Example
{}
Discount_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "Discount"
Example
{}
Discount_sum_order_by
Description
order by sum() on columns of table "Discount"
Example
{}
Discount_var_pop_order_by
Description
order by var_pop() on columns of table "Discount"
Example
{}
Discount_var_samp_order_by
Description
order by var_samp() on columns of table "Discount"
Example
{}
Discount_variance_order_by
Description
order by variance() on columns of table "Discount"
Example
{}
DynamicBox
Description
columns and relationships of "DynamicBox"
Example
{
"DynamicBox_SelectableProductVariants": [
DynamicBox_SelectableProductVariant
],
"Product": Product,
"fixedDiscount": jsonb,
"id": uuid,
"percentDiscount": jsonb,
"sizeInterval": jsonb,
"sizeRange": jsonb
}
DynamicBox_SelectableProductVariant
Description
columns and relationships of "DynamicBox_SelectableProductVariant"
Fields
Field Name | Description |
---|---|
DynamicBox - DynamicBox!
|
An object relationship |
SelectableProductVariant - ProductVariant!
|
An object relationship |
deletedAt - timestamp
|
|
dynamicBoxId - uuid!
|
|
productVariantId - uuid!
|
Example
{
"DynamicBox": DynamicBox,
"SelectableProductVariant": ProductVariant,
"deletedAt": timestamp,
"dynamicBoxId": uuid,
"productVariantId": uuid
}
DynamicBox_SelectableProductVariant_aggregate_order_by
Description
order by aggregate values of table "DynamicBox_SelectableProductVariant"
Fields
Input Field | Description |
---|---|
max - DynamicBox_SelectableProductVariant_max_order_by
|
|
min - DynamicBox_SelectableProductVariant_min_order_by
|
Example
{
"max": DynamicBox_SelectableProductVariant_max_order_by,
"min": DynamicBox_SelectableProductVariant_min_order_by
}
DynamicBox_SelectableProductVariant_bool_exp
Description
Boolean expression to filter rows from the table "DynamicBox_SelectableProductVariant". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
DynamicBox - DynamicBox_bool_exp
|
|
SelectableProductVariant - ProductVariant_bool_exp
|
|
_and - [DynamicBox_SelectableProductVariant_bool_exp!]
|
|
_not - DynamicBox_SelectableProductVariant_bool_exp
|
|
_or - [DynamicBox_SelectableProductVariant_bool_exp!]
|
|
deletedAt - timestamp_comparison_exp
|
|
dynamicBoxId - uuid_comparison_exp
|
|
productVariantId - uuid_comparison_exp
|
Example
{
"DynamicBox": DynamicBox_bool_exp,
"SelectableProductVariant": ProductVariant_bool_exp,
"_and": [DynamicBox_SelectableProductVariant_bool_exp],
"_not": DynamicBox_SelectableProductVariant_bool_exp,
"_or": [DynamicBox_SelectableProductVariant_bool_exp],
"deletedAt": timestamp_comparison_exp,
"dynamicBoxId": uuid_comparison_exp,
"productVariantId": uuid_comparison_exp
}
DynamicBox_SelectableProductVariant_max_order_by
Description
order by max() on columns of table "DynamicBox_SelectableProductVariant"
Example
{}
DynamicBox_SelectableProductVariant_min_order_by
Description
order by min() on columns of table "DynamicBox_SelectableProductVariant"
Example
{}
DynamicBox_bool_exp
Description
Boolean expression to filter rows from the table "DynamicBox". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
DynamicBox_SelectableProductVariants - DynamicBox_SelectableProductVariant_bool_exp
|
|
Product - Product_bool_exp
|
|
_and - [DynamicBox_bool_exp!]
|
|
_not - DynamicBox_bool_exp
|
|
_or - [DynamicBox_bool_exp!]
|
|
fixedDiscount - jsonb_comparison_exp
|
|
id - uuid_comparison_exp
|
|
percentDiscount - jsonb_comparison_exp
|
|
sizeInterval - jsonb_comparison_exp
|
|
sizeRange - jsonb_comparison_exp
|
Example
{
"DynamicBox_SelectableProductVariants": DynamicBox_SelectableProductVariant_bool_exp,
"Product": Product_bool_exp,
"_and": [DynamicBox_bool_exp],
"_not": DynamicBox_bool_exp,
"_or": [DynamicBox_bool_exp],
"fixedDiscount": jsonb_comparison_exp,
"id": uuid_comparison_exp,
"percentDiscount": jsonb_comparison_exp,
"sizeInterval": jsonb_comparison_exp,
"sizeRange": jsonb_comparison_exp
}
DynamicBox_order_by
Description
Ordering options when selecting data from "DynamicBox".
Fields
Input Field | Description |
---|---|
DynamicBox_SelectableProductVariants_aggregate - DynamicBox_SelectableProductVariant_aggregate_order_by
|
|
Product - Product_order_by
|
Example
{
"DynamicBox_SelectableProductVariants_aggregate": DynamicBox_SelectableProductVariant_aggregate_order_by,
"Product": Product_order_by
}
Float
Example
123.45
Group
Description
columns and relationships of "Group"
Fields
Field Name | Description |
---|---|
DiscountsPerUser - [Discount!]!
|
An array relationship |
GroupSet - GroupSet
|
An object relationship |
OrderLineItemsIfFirstOrder - [OrderLineItem!]!
|
An array relationship |
SubscriptionLines - [SubscriptionLine!]!
|
An array relationship |
createdAt - timestamptz!
|
|
groupSetId - uuid
|
|
id - uuid!
|
|
maxUsers - Int!
|
|
minUsers - Int!
|
|
updatedAt - timestamptz!
|
Example
{
"DiscountsPerUser": [Discount],
"GroupSet": GroupSet,
"OrderLineItemsIfFirstOrder": [OrderLineItem],
"SubscriptionLines": [SubscriptionLine],
"createdAt": timestamptz,
"groupSetId": uuid,
"id": uuid,
"maxUsers": 987,
"minUsers": 987,
"updatedAt": timestamptz
}
GroupPlan
Description
columns and relationships of "GroupPlan"
Fields
Field Name | Description |
---|---|
DiscountsPerUser - [Discount!]!
|
An array relationship |
GroupSet - GroupSet
|
An object relationship |
SellingPlan - SellingPlan!
|
An object relationship |
createdAt - timestamptz!
|
|
groupSetId - uuid
|
|
id - uuid!
|
|
maxUsers - Int!
|
|
minUsers - Int!
|
|
sellingPlanId - uuid!
|
|
updatedAt - timestamptz!
|
Example
{
"DiscountsPerUser": [Discount],
"GroupSet": GroupSet,
"SellingPlan": SellingPlan,
"createdAt": timestamptz,
"groupSetId": uuid,
"id": uuid,
"maxUsers": 123,
"minUsers": 987,
"sellingPlanId": uuid,
"updatedAt": timestamptz
}
GroupPlan_aggregate_order_by
Description
order by aggregate values of table "GroupPlan"
Fields
Input Field | Description |
---|---|
avg - GroupPlan_avg_order_by
|
|
max - GroupPlan_max_order_by
|
|
min - GroupPlan_min_order_by
|
|
stddev - GroupPlan_stddev_order_by
|
|
stddev_pop - GroupPlan_stddev_pop_order_by
|
|
stddev_samp - GroupPlan_stddev_samp_order_by
|
|
sum - GroupPlan_sum_order_by
|
|
var_pop - GroupPlan_var_pop_order_by
|
|
var_samp - GroupPlan_var_samp_order_by
|
|
variance - GroupPlan_variance_order_by
|
Example
{
"avg": GroupPlan_avg_order_by,
"max": GroupPlan_max_order_by,
"min": GroupPlan_min_order_by,
"stddev": GroupPlan_stddev_order_by,
"stddev_pop": GroupPlan_stddev_pop_order_by,
"stddev_samp": GroupPlan_stddev_samp_order_by,
"sum": GroupPlan_sum_order_by,
"var_pop": GroupPlan_var_pop_order_by,
"var_samp": GroupPlan_var_samp_order_by,
"variance": GroupPlan_variance_order_by
}
GroupPlan_avg_order_by
Description
order by avg() on columns of table "GroupPlan"
Example
{}
GroupPlan_bool_exp
Description
Boolean expression to filter rows from the table "GroupPlan". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
DiscountsPerUser - Discount_bool_exp
|
|
GroupSet - GroupSet_bool_exp
|
|
SellingPlan - SellingPlan_bool_exp
|
|
_and - [GroupPlan_bool_exp!]
|
|
_not - GroupPlan_bool_exp
|
|
_or - [GroupPlan_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
groupSetId - uuid_comparison_exp
|
|
id - uuid_comparison_exp
|
|
maxUsers - Int_comparison_exp
|
|
minUsers - Int_comparison_exp
|
|
sellingPlanId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"DiscountsPerUser": Discount_bool_exp,
"GroupSet": GroupSet_bool_exp,
"SellingPlan": SellingPlan_bool_exp,
"_and": [GroupPlan_bool_exp],
"_not": GroupPlan_bool_exp,
"_or": [GroupPlan_bool_exp],
"createdAt": timestamptz_comparison_exp,
"groupSetId": uuid_comparison_exp,
"id": uuid_comparison_exp,
"maxUsers": Int_comparison_exp,
"minUsers": Int_comparison_exp,
"sellingPlanId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
GroupPlan_max_order_by
Description
order by max() on columns of table "GroupPlan"
Example
{}
GroupPlan_min_order_by
Description
order by min() on columns of table "GroupPlan"
Example
{}
GroupPlan_stddev_order_by
Description
order by stddev() on columns of table "GroupPlan"
Example
{}
GroupPlan_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "GroupPlan"
Example
{}
GroupPlan_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "GroupPlan"
Example
{}
GroupPlan_sum_order_by
Description
order by sum() on columns of table "GroupPlan"
Example
{}
GroupPlan_var_pop_order_by
Description
order by var_pop() on columns of table "GroupPlan"
Example
{}
GroupPlan_var_samp_order_by
Description
order by var_samp() on columns of table "GroupPlan"
Example
{}
GroupPlan_variance_order_by
Description
order by variance() on columns of table "GroupPlan"
Example
{}
GroupSet
Description
columns and relationships of "GroupSet"
Fields
Field Name | Description |
---|---|
GroupPlans - [GroupPlan!]!
|
An array relationship |
Groups - [Group!]!
|
An array relationship |
Site - Site!
|
An object relationship |
createdAt - timestamptz!
|
|
id - uuid!
|
|
name - String!
|
|
siteId - uuid!
|
|
updatedAt - timestamptz!
|
Example
{
"GroupPlans": [GroupPlan],
"Groups": [Group],
"Site": Site,
"createdAt": timestamptz,
"id": uuid,
"name": "abc123",
"siteId": uuid,
"updatedAt": timestamptz
}
GroupSet_bool_exp
Description
Boolean expression to filter rows from the table "GroupSet". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
GroupPlans - GroupPlan_bool_exp
|
|
Groups - Group_bool_exp
|
|
Site - Site_bool_exp
|
|
_and - [GroupSet_bool_exp!]
|
|
_not - GroupSet_bool_exp
|
|
_or - [GroupSet_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
name - String_comparison_exp
|
|
siteId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"GroupPlans": GroupPlan_bool_exp,
"Groups": Group_bool_exp,
"Site": Site_bool_exp,
"_and": [GroupSet_bool_exp],
"_not": GroupSet_bool_exp,
"_or": [GroupSet_bool_exp],
"createdAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"name": String_comparison_exp,
"siteId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
GroupSet_order_by
Description
Ordering options when selecting data from "GroupSet".
Fields
Input Field | Description |
---|---|
GroupPlans_aggregate - GroupPlan_aggregate_order_by
|
|
Groups_aggregate - Group_aggregate_order_by
|
|
Site - Site_order_by
|
Example
{
"GroupPlans_aggregate": GroupPlan_aggregate_order_by,
"Groups_aggregate": Group_aggregate_order_by,
"Site": Site_order_by
}
Group_aggregate_order_by
Description
order by aggregate values of table "Group"
Fields
Input Field | Description |
---|---|
avg - Group_avg_order_by
|
|
max - Group_max_order_by
|
|
min - Group_min_order_by
|
|
stddev - Group_stddev_order_by
|
|
stddev_pop - Group_stddev_pop_order_by
|
|
stddev_samp - Group_stddev_samp_order_by
|
|
sum - Group_sum_order_by
|
|
var_pop - Group_var_pop_order_by
|
|
var_samp - Group_var_samp_order_by
|
|
variance - Group_variance_order_by
|
Example
{
"avg": Group_avg_order_by,
"max": Group_max_order_by,
"min": Group_min_order_by,
"stddev": Group_stddev_order_by,
"stddev_pop": Group_stddev_pop_order_by,
"stddev_samp": Group_stddev_samp_order_by,
"sum": Group_sum_order_by,
"var_pop": Group_var_pop_order_by,
"var_samp": Group_var_samp_order_by,
"variance": Group_variance_order_by
}
Group_avg_order_by
Description
order by avg() on columns of table "Group"
Example
{}
Group_bool_exp
Description
Boolean expression to filter rows from the table "Group". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
DiscountsPerUser - Discount_bool_exp
|
|
GroupSet - GroupSet_bool_exp
|
|
OrderLineItemsIfFirstOrder - OrderLineItem_bool_exp
|
|
SubscriptionLines - SubscriptionLine_bool_exp
|
|
_and - [Group_bool_exp!]
|
|
_not - Group_bool_exp
|
|
_or - [Group_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
groupSetId - uuid_comparison_exp
|
|
id - uuid_comparison_exp
|
|
maxUsers - Int_comparison_exp
|
|
minUsers - Int_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"DiscountsPerUser": Discount_bool_exp,
"GroupSet": GroupSet_bool_exp,
"OrderLineItemsIfFirstOrder": OrderLineItem_bool_exp,
"SubscriptionLines": SubscriptionLine_bool_exp,
"_and": [Group_bool_exp],
"_not": Group_bool_exp,
"_or": [Group_bool_exp],
"createdAt": timestamptz_comparison_exp,
"groupSetId": uuid_comparison_exp,
"id": uuid_comparison_exp,
"maxUsers": Int_comparison_exp,
"minUsers": Int_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
Group_max_order_by
Description
order by max() on columns of table "Group"
Example
{}
Group_min_order_by
Description
order by min() on columns of table "Group"
Example
{}
Group_order_by
Description
Ordering options when selecting data from "Group".
Fields
Input Field | Description |
---|---|
DiscountsPerUser_aggregate - Discount_aggregate_order_by
|
|
GroupSet - GroupSet_order_by
|
|
OrderLineItemsIfFirstOrder_aggregate - OrderLineItem_aggregate_order_by
|
|
SubscriptionLines_aggregate - SubscriptionLine_aggregate_order_by
|
Example
{
"DiscountsPerUser_aggregate": Discount_aggregate_order_by,
"GroupSet": GroupSet_order_by,
"OrderLineItemsIfFirstOrder_aggregate": OrderLineItem_aggregate_order_by,
"SubscriptionLines_aggregate": SubscriptionLine_aggregate_order_by
}
Group_stddev_order_by
Description
order by stddev() on columns of table "Group"
Example
{}
Group_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "Group"
Example
{}
Group_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "Group"
Example
{}
Group_sum_order_by
Description
order by sum() on columns of table "Group"
Example
{}
Group_var_pop_order_by
Description
order by var_pop() on columns of table "Group"
Example
{}
Group_var_samp_order_by
Description
order by var_samp() on columns of table "Group"
Example
{}
Group_variance_order_by
Description
order by variance() on columns of table "Group"
Example
{}
Holiday
Holiday_aggregate_order_by
Description
order by aggregate values of table "Holiday"
Fields
Input Field | Description |
---|---|
max - Holiday_max_order_by
|
|
min - Holiday_min_order_by
|
Example
{
"max": Holiday_max_order_by,
"min": Holiday_min_order_by
}
Holiday_bool_exp
Description
Boolean expression to filter rows from the table "Holiday". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
Site - Site_bool_exp
|
|
_and - [Holiday_bool_exp!]
|
|
_not - Holiday_bool_exp
|
|
_or - [Holiday_bool_exp!]
|
|
id - uuid_comparison_exp
|
Example
{
"Site": Site_bool_exp,
"_and": [Holiday_bool_exp],
"_not": Holiday_bool_exp,
"_or": [Holiday_bool_exp],
"id": uuid_comparison_exp
}
Holiday_max_order_by
Description
order by max() on columns of table "Holiday"
Example
{}
Holiday_min_order_by
Description
order by min() on columns of table "Holiday"
Example
{}
Int
Example
987
Int_comparison_exp
Description
Boolean expression to compare columns of type "Int". All fields are combined with logical 'AND'.
Example
{
"_eq": 987,
"_gt": 987,
"_gte": 123,
"_in": [987],
"_is_null": false,
"_lt": 123,
"_lte": 987,
"_neq": 987,
"_nin": [123]
}
Notification
Description
columns and relationships of "Notification"
Fields
Field Name | Description |
---|---|
NotificationLogs - [NotificationLog!]!
|
An array relationship |
Site - Site!
|
An object relationship |
id - uuid!
|
Example
{
"NotificationLogs": [NotificationLog],
"Site": Site,
"id": uuid
}
NotificationLog
Description
columns and relationships of "NotificationLog"
Fields
Field Name | Description |
---|---|
Notification - Notification!
|
An object relationship |
Subscription - Subscription
|
An object relationship |
body - String
|
|
createdAt - timestamptz!
|
|
email - String
|
|
id - uuid!
|
|
notificationId - uuid!
|
|
phoneNumber - String
|
|
subject - String
|
|
subscriptionId - uuid
|
|
updatedAt - timestamptz!
|
Example
{
"Notification": Notification,
"Subscription": Subscription,
"body": "xyz789",
"createdAt": timestamptz,
"email": "abc123",
"id": uuid,
"notificationId": uuid,
"phoneNumber": "xyz789",
"subject": "abc123",
"subscriptionId": uuid,
"updatedAt": timestamptz
}
NotificationLog_aggregate_order_by
Description
order by aggregate values of table "NotificationLog"
Fields
Input Field | Description |
---|---|
max - NotificationLog_max_order_by
|
|
min - NotificationLog_min_order_by
|
Example
{
"max": NotificationLog_max_order_by,
"min": NotificationLog_min_order_by
}
NotificationLog_bool_exp
Description
Boolean expression to filter rows from the table "NotificationLog". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
Notification - Notification_bool_exp
|
|
Subscription - Subscription_bool_exp
|
|
_and - [NotificationLog_bool_exp!]
|
|
_not - NotificationLog_bool_exp
|
|
_or - [NotificationLog_bool_exp!]
|
|
body - String_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
email - String_comparison_exp
|
|
id - uuid_comparison_exp
|
|
notificationId - uuid_comparison_exp
|
|
phoneNumber - String_comparison_exp
|
|
subject - String_comparison_exp
|
|
subscriptionId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"Notification": Notification_bool_exp,
"Subscription": Subscription_bool_exp,
"_and": [NotificationLog_bool_exp],
"_not": NotificationLog_bool_exp,
"_or": [NotificationLog_bool_exp],
"body": String_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"email": String_comparison_exp,
"id": uuid_comparison_exp,
"notificationId": uuid_comparison_exp,
"phoneNumber": String_comparison_exp,
"subject": String_comparison_exp,
"subscriptionId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
NotificationLog_max_order_by
Description
order by max() on columns of table "NotificationLog"
Example
{}
NotificationLog_min_order_by
Description
order by min() on columns of table "NotificationLog"
Example
{}
Notification_aggregate_order_by
Description
order by aggregate values of table "Notification"
Fields
Input Field | Description |
---|---|
max - Notification_max_order_by
|
|
min - Notification_min_order_by
|
Example
{
"max": Notification_max_order_by,
"min": Notification_min_order_by
}
Notification_bool_exp
Description
Boolean expression to filter rows from the table "Notification". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
NotificationLogs - NotificationLog_bool_exp
|
|
Site - Site_bool_exp
|
|
_and - [Notification_bool_exp!]
|
|
_not - Notification_bool_exp
|
|
_or - [Notification_bool_exp!]
|
|
id - uuid_comparison_exp
|
Example
{
"NotificationLogs": NotificationLog_bool_exp,
"Site": Site_bool_exp,
"_and": [Notification_bool_exp],
"_not": Notification_bool_exp,
"_or": [Notification_bool_exp],
"id": uuid_comparison_exp
}
Notification_max_order_by
Description
order by max() on columns of table "Notification"
Example
{}
Notification_min_order_by
Description
order by min() on columns of table "Notification"
Example
{}
Order
Description
UNIQUE FIELDS WILL NOT WORK WELL WITH DELETEDAT
Fields
Field Name | Description |
---|---|
OrderLineItems - [OrderLineItem!]!
|
An array relationship |
PrepaidSubscription - Subscription
|
An object relationship |
ShippingLines - [ShippingLine!]!
|
An array relationship |
StorefrontUser - StorefrontUser!
|
An object relationship |
cancelledAt - timestamptz
|
|
createdAt - timestamptz!
|
|
deletedAt - timestamptz
|
|
deliveredAt - timestamptz
|
|
id - uuid!
|
|
note - String
|
|
platformId - String
|
|
platformNumber - String!
|
|
storefrontUserId - uuid!
|
|
updatedAt - timestamp!
|
Example
{
"OrderLineItems": [OrderLineItem],
"PrepaidSubscription": Subscription,
"ShippingLines": [ShippingLine],
"StorefrontUser": StorefrontUser,
"cancelledAt": timestamptz,
"createdAt": timestamptz,
"deletedAt": timestamptz,
"deliveredAt": timestamptz,
"id": uuid,
"note": "xyz789",
"platformId": "abc123",
"platformNumber": "abc123",
"storefrontUserId": uuid,
"updatedAt": timestamp
}
OrderLineItem
Description
groupId is only defined on initial order
Fields
Field Name | Description |
---|---|
Discounts - [Discount!]!
|
An array relationship |
GroupIfInitialOrder - Group
|
An object relationship |
Order - Order!
|
An object relationship |
ProductVariant - ProductVariant!
|
An object relationship |
SubscriptionLine - SubscriptionLine
|
An object relationship |
TaxLines - [TaxLine!]!
|
An array relationship |
attributionGroupId - uuid
|
|
createdAt - timestamptz!
|
|
customAttributes - jsonb
|
|
groupId - uuid
|
|
id - uuid!
|
|
orderId - uuid!
|
|
platformId - String
|
|
priceWithoutDiscount - numeric!
|
|
productVariantId - uuid!
|
|
quantity - Int!
|
|
subscriptionLineId - uuid
|
|
updatedAt - timestamptz!
|
Example
{
"Discounts": [Discount],
"GroupIfInitialOrder": Group,
"Order": Order,
"ProductVariant": ProductVariant,
"SubscriptionLine": SubscriptionLine,
"TaxLines": [TaxLine],
"attributionGroupId": uuid,
"createdAt": timestamptz,
"customAttributes": jsonb,
"groupId": uuid,
"id": uuid,
"orderId": uuid,
"platformId": "abc123",
"priceWithoutDiscount": numeric,
"productVariantId": uuid,
"quantity": 123,
"subscriptionLineId": uuid,
"updatedAt": timestamptz
}
OrderLineItem_aggregate_order_by
Description
order by aggregate values of table "OrderLineItem"
Fields
Input Field | Description |
---|---|
avg - OrderLineItem_avg_order_by
|
|
max - OrderLineItem_max_order_by
|
|
min - OrderLineItem_min_order_by
|
|
stddev - OrderLineItem_stddev_order_by
|
|
stddev_pop - OrderLineItem_stddev_pop_order_by
|
|
stddev_samp - OrderLineItem_stddev_samp_order_by
|
|
sum - OrderLineItem_sum_order_by
|
|
var_pop - OrderLineItem_var_pop_order_by
|
|
var_samp - OrderLineItem_var_samp_order_by
|
|
variance - OrderLineItem_variance_order_by
|
Example
{
"avg": OrderLineItem_avg_order_by,
"max": OrderLineItem_max_order_by,
"min": OrderLineItem_min_order_by,
"stddev": OrderLineItem_stddev_order_by,
"stddev_pop": OrderLineItem_stddev_pop_order_by,
"stddev_samp": OrderLineItem_stddev_samp_order_by,
"sum": OrderLineItem_sum_order_by,
"var_pop": OrderLineItem_var_pop_order_by,
"var_samp": OrderLineItem_var_samp_order_by,
"variance": OrderLineItem_variance_order_by
}
OrderLineItem_avg_order_by
Description
order by avg() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_bool_exp
Description
Boolean expression to filter rows from the table "OrderLineItem". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
Discounts - Discount_bool_exp
|
|
GroupIfInitialOrder - Group_bool_exp
|
|
Order - Order_bool_exp
|
|
ProductVariant - ProductVariant_bool_exp
|
|
SubscriptionLine - SubscriptionLine_bool_exp
|
|
TaxLines - TaxLine_bool_exp
|
|
_and - [OrderLineItem_bool_exp!]
|
|
_not - OrderLineItem_bool_exp
|
|
_or - [OrderLineItem_bool_exp!]
|
|
attributionGroupId - uuid_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
customAttributes - jsonb_comparison_exp
|
|
groupId - uuid_comparison_exp
|
|
id - uuid_comparison_exp
|
|
orderId - uuid_comparison_exp
|
|
platformId - String_comparison_exp
|
|
priceWithoutDiscount - numeric_comparison_exp
|
|
productVariantId - uuid_comparison_exp
|
|
quantity - Int_comparison_exp
|
|
subscriptionLineId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"Discounts": Discount_bool_exp,
"GroupIfInitialOrder": Group_bool_exp,
"Order": Order_bool_exp,
"ProductVariant": ProductVariant_bool_exp,
"SubscriptionLine": SubscriptionLine_bool_exp,
"TaxLines": TaxLine_bool_exp,
"_and": [OrderLineItem_bool_exp],
"_not": OrderLineItem_bool_exp,
"_or": [OrderLineItem_bool_exp],
"attributionGroupId": uuid_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"customAttributes": jsonb_comparison_exp,
"groupId": uuid_comparison_exp,
"id": uuid_comparison_exp,
"orderId": uuid_comparison_exp,
"platformId": String_comparison_exp,
"priceWithoutDiscount": numeric_comparison_exp,
"productVariantId": uuid_comparison_exp,
"quantity": Int_comparison_exp,
"subscriptionLineId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
OrderLineItem_max_order_by
Description
order by max() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_min_order_by
Description
order by min() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_order_by
Description
Ordering options when selecting data from "OrderLineItem".
Fields
Input Field | Description |
---|---|
Discounts_aggregate - Discount_aggregate_order_by
|
|
GroupIfInitialOrder - Group_order_by
|
|
Order - Order_order_by
|
|
ProductVariant - ProductVariant_order_by
|
|
SubscriptionLine - SubscriptionLine_order_by
|
|
TaxLines_aggregate - TaxLine_aggregate_order_by
|
Example
{
"Discounts_aggregate": Discount_aggregate_order_by,
"GroupIfInitialOrder": Group_order_by,
"Order": Order_order_by,
"ProductVariant": ProductVariant_order_by,
"SubscriptionLine": SubscriptionLine_order_by,
"TaxLines_aggregate": TaxLine_aggregate_order_by
}
OrderLineItem_stddev_order_by
Description
order by stddev() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_sum_order_by
Description
order by sum() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_var_pop_order_by
Description
order by var_pop() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_var_samp_order_by
Description
order by var_samp() on columns of table "OrderLineItem"
Example
{}
OrderLineItem_variance_order_by
Description
order by variance() on columns of table "OrderLineItem"
Example
{}
Order_aggregate_order_by
Description
order by aggregate values of table "Order"
Fields
Input Field | Description |
---|---|
max - Order_max_order_by
|
|
min - Order_min_order_by
|
Example
{
"max": Order_max_order_by,
"min": Order_min_order_by
}
Order_bool_exp
Description
Boolean expression to filter rows from the table "Order". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
OrderLineItems - OrderLineItem_bool_exp
|
|
PrepaidSubscription - Subscription_bool_exp
|
|
ShippingLines - ShippingLine_bool_exp
|
|
StorefrontUser - StorefrontUser_bool_exp
|
|
_and - [Order_bool_exp!]
|
|
_not - Order_bool_exp
|
|
_or - [Order_bool_exp!]
|
|
cancelledAt - timestamptz_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
deletedAt - timestamptz_comparison_exp
|
|
deliveredAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
note - String_comparison_exp
|
|
platformId - String_comparison_exp
|
|
platformNumber - String_comparison_exp
|
|
storefrontUserId - uuid_comparison_exp
|
|
updatedAt - timestamp_comparison_exp
|
Example
{
"OrderLineItems": OrderLineItem_bool_exp,
"PrepaidSubscription": Subscription_bool_exp,
"ShippingLines": ShippingLine_bool_exp,
"StorefrontUser": StorefrontUser_bool_exp,
"_and": [Order_bool_exp],
"_not": Order_bool_exp,
"_or": [Order_bool_exp],
"cancelledAt": timestamptz_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"deletedAt": timestamptz_comparison_exp,
"deliveredAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"note": String_comparison_exp,
"platformId": String_comparison_exp,
"platformNumber": String_comparison_exp,
"storefrontUserId": uuid_comparison_exp,
"updatedAt": timestamp_comparison_exp
}
Order_max_order_by
Description
order by max() on columns of table "Order"
Example
{}
Order_min_order_by
Description
order by min() on columns of table "Order"
Example
{}
Order_order_by
Description
Ordering options when selecting data from "Order".
Fields
Input Field | Description |
---|---|
OrderLineItems_aggregate - OrderLineItem_aggregate_order_by
|
|
PrepaidSubscription - Subscription_order_by
|
|
ShippingLines_aggregate - ShippingLine_aggregate_order_by
|
|
StorefrontUser - StorefrontUser_order_by
|
Example
{
"OrderLineItems_aggregate": OrderLineItem_aggregate_order_by,
"PrepaidSubscription": Subscription_order_by,
"ShippingLines_aggregate": ShippingLine_aggregate_order_by,
"StorefrontUser": StorefrontUser_order_by
}
PaymentMethod
Description
columns and relationships of "PaymentMethod"
Fields
Field Name | Description |
---|---|
BillingAddress - Address
|
An object relationship |
StorefrontUser - StorefrontUser!
|
An object relationship |
Subscriptions - [Subscription!]!
|
An array relationship |
id - uuid!
|
Example
{
"BillingAddress": Address,
"StorefrontUser": StorefrontUser,
"Subscriptions": [Subscription],
"id": uuid
}
PaymentMethod_aggregate_order_by
Description
order by aggregate values of table "PaymentMethod"
Fields
Input Field | Description |
---|---|
max - PaymentMethod_max_order_by
|
|
min - PaymentMethod_min_order_by
|
Example
{
"max": PaymentMethod_max_order_by,
"min": PaymentMethod_min_order_by
}
PaymentMethod_bool_exp
Description
Boolean expression to filter rows from the table "PaymentMethod". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
BillingAddress - Address_bool_exp
|
|
StorefrontUser - StorefrontUser_bool_exp
|
|
Subscriptions - Subscription_bool_exp
|
|
_and - [PaymentMethod_bool_exp!]
|
|
_not - PaymentMethod_bool_exp
|
|
_or - [PaymentMethod_bool_exp!]
|
|
id - uuid_comparison_exp
|
Example
{
"BillingAddress": Address_bool_exp,
"StorefrontUser": StorefrontUser_bool_exp,
"Subscriptions": Subscription_bool_exp,
"_and": [PaymentMethod_bool_exp],
"_not": PaymentMethod_bool_exp,
"_or": [PaymentMethod_bool_exp],
"id": uuid_comparison_exp
}
PaymentMethod_max_order_by
Description
order by max() on columns of table "PaymentMethod"
Example
{}
PaymentMethod_min_order_by
Description
order by min() on columns of table "PaymentMethod"
Example
{}
PaymentMethod_order_by
Description
Ordering options when selecting data from "PaymentMethod".
Fields
Input Field | Description |
---|---|
BillingAddress - Address_order_by
|
|
StorefrontUser - StorefrontUser_order_by
|
|
Subscriptions_aggregate - Subscription_aggregate_order_by
|
Example
{
"BillingAddress": Address_order_by,
"StorefrontUser": StorefrontUser_order_by,
"Subscriptions_aggregate": Subscription_aggregate_order_by
}
Policy
Description
No check on insert so be careful adding new fields
Fields
Field Name | Description |
---|---|
Anchors - [Anchor!]!
|
An array relationship |
SellingPlansByBillingPolicy - [SellingPlan!]!
|
An array relationship |
SellingPlansByDeliveryPolicy - [SellingPlan!]!
|
An array relationship |
SellingPlansByPrepaidDeliveryPolicy - [SellingPlan!]!
|
An array relationship |
SubscriptionsByBillingPolicy - [Subscription!]!
|
An array relationship |
SubscriptionsByDeliveryPolicy - [Subscription!]!
|
An array relationship |
SubscriptionsByPrepaidDeliveryPolicy - [Subscription!]!
|
An array relationship |
createdAt - timestamptz!
|
|
id - uuid!
|
|
interval - String!
|
|
intervalCount - Int!
|
|
maxCycles - Int
|
|
minCycles - Int
|
|
updatedAt - timestamptz!
|
Example
{
"Anchors": [Anchor],
"SellingPlansByBillingPolicy": [SellingPlan],
"SellingPlansByDeliveryPolicy": [SellingPlan],
"SellingPlansByPrepaidDeliveryPolicy": [SellingPlan],
"SubscriptionsByBillingPolicy": [Subscription],
"SubscriptionsByDeliveryPolicy": [Subscription],
"SubscriptionsByPrepaidDeliveryPolicy": [Subscription],
"createdAt": timestamptz,
"id": uuid,
"interval": "xyz789",
"intervalCount": 123,
"maxCycles": 987,
"minCycles": 123,
"updatedAt": timestamptz
}
Policy_bool_exp
Description
Boolean expression to filter rows from the table "Policy". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
Anchors - Anchor_bool_exp
|
|
SellingPlansByBillingPolicy - SellingPlan_bool_exp
|
|
SellingPlansByDeliveryPolicy - SellingPlan_bool_exp
|
|
SellingPlansByPrepaidDeliveryPolicy - SellingPlan_bool_exp
|
|
SubscriptionsByBillingPolicy - Subscription_bool_exp
|
|
SubscriptionsByDeliveryPolicy - Subscription_bool_exp
|
|
SubscriptionsByPrepaidDeliveryPolicy - Subscription_bool_exp
|
|
_and - [Policy_bool_exp!]
|
|
_not - Policy_bool_exp
|
|
_or - [Policy_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
interval - String_comparison_exp
|
|
intervalCount - Int_comparison_exp
|
|
maxCycles - Int_comparison_exp
|
|
minCycles - Int_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"Anchors": Anchor_bool_exp,
"SellingPlansByBillingPolicy": SellingPlan_bool_exp,
"SellingPlansByDeliveryPolicy": SellingPlan_bool_exp,
"SellingPlansByPrepaidDeliveryPolicy": SellingPlan_bool_exp,
"SubscriptionsByBillingPolicy": Subscription_bool_exp,
"SubscriptionsByDeliveryPolicy": Subscription_bool_exp,
"SubscriptionsByPrepaidDeliveryPolicy": Subscription_bool_exp,
"_and": [Policy_bool_exp],
"_not": Policy_bool_exp,
"_or": [Policy_bool_exp],
"createdAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"interval": String_comparison_exp,
"intervalCount": Int_comparison_exp,
"maxCycles": Int_comparison_exp,
"minCycles": Int_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
Policy_order_by
Description
Ordering options when selecting data from "Policy".
Fields
Input Field | Description |
---|---|
Anchors_aggregate - Anchor_aggregate_order_by
|
|
SellingPlansByBillingPolicy_aggregate - SellingPlan_aggregate_order_by
|
|
SellingPlansByDeliveryPolicy_aggregate - SellingPlan_aggregate_order_by
|
|
SellingPlansByPrepaidDeliveryPolicy_aggregate - SellingPlan_aggregate_order_by
|
|
SubscriptionsByBillingPolicy_aggregate - Subscription_aggregate_order_by
|
|
SubscriptionsByDeliveryPolicy_aggregate - Subscription_aggregate_order_by
|
|
SubscriptionsByPrepaidDeliveryPolicy_aggregate - Subscription_aggregate_order_by
|
Example
{
"Anchors_aggregate": Anchor_aggregate_order_by,
"SellingPlansByBillingPolicy_aggregate": SellingPlan_aggregate_order_by,
"SellingPlansByDeliveryPolicy_aggregate": SellingPlan_aggregate_order_by,
"SellingPlansByPrepaidDeliveryPolicy_aggregate": SellingPlan_aggregate_order_by,
"SubscriptionsByBillingPolicy_aggregate": Subscription_aggregate_order_by,
"SubscriptionsByDeliveryPolicy_aggregate": Subscription_aggregate_order_by,
"SubscriptionsByPrepaidDeliveryPolicy_aggregate": Subscription_aggregate_order_by
}
PricingPolicy
Description
columns and relationships of "PricingPolicy"
Fields
Field Name | Description |
---|---|
SellingPlan - SellingPlan!
|
An object relationship |
createdAt - timestamptz!
|
|
fixedPrice - numeric
|
|
id - uuid!
|
|
percentageOff - numeric
|
|
sellingPlanId - uuid!
|
|
sellingPlanPricingPolicyAdjustmentType - String
|
|
updatedAt - timestamptz!
|
Example
{
"SellingPlan": SellingPlan,
"createdAt": timestamptz,
"fixedPrice": numeric,
"id": uuid,
"percentageOff": numeric,
"sellingPlanId": uuid,
"sellingPlanPricingPolicyAdjustmentType": "xyz789",
"updatedAt": timestamptz
}
PricingPolicy_aggregate_order_by
Description
order by aggregate values of table "PricingPolicy"
Fields
Input Field | Description |
---|---|
avg - PricingPolicy_avg_order_by
|
|
max - PricingPolicy_max_order_by
|
|
min - PricingPolicy_min_order_by
|
|
stddev - PricingPolicy_stddev_order_by
|
|
stddev_pop - PricingPolicy_stddev_pop_order_by
|
|
stddev_samp - PricingPolicy_stddev_samp_order_by
|
|
sum - PricingPolicy_sum_order_by
|
|
var_pop - PricingPolicy_var_pop_order_by
|
|
var_samp - PricingPolicy_var_samp_order_by
|
|
variance - PricingPolicy_variance_order_by
|
Example
{
"avg": PricingPolicy_avg_order_by,
"max": PricingPolicy_max_order_by,
"min": PricingPolicy_min_order_by,
"stddev": PricingPolicy_stddev_order_by,
"stddev_pop": PricingPolicy_stddev_pop_order_by,
"stddev_samp": PricingPolicy_stddev_samp_order_by,
"sum": PricingPolicy_sum_order_by,
"var_pop": PricingPolicy_var_pop_order_by,
"var_samp": PricingPolicy_var_samp_order_by,
"variance": PricingPolicy_variance_order_by
}
PricingPolicy_avg_order_by
Description
order by avg() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_bool_exp
Description
Boolean expression to filter rows from the table "PricingPolicy". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
SellingPlan - SellingPlan_bool_exp
|
|
_and - [PricingPolicy_bool_exp!]
|
|
_not - PricingPolicy_bool_exp
|
|
_or - [PricingPolicy_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
fixedPrice - numeric_comparison_exp
|
|
id - uuid_comparison_exp
|
|
percentageOff - numeric_comparison_exp
|
|
sellingPlanId - uuid_comparison_exp
|
|
sellingPlanPricingPolicyAdjustmentType - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"SellingPlan": SellingPlan_bool_exp,
"_and": [PricingPolicy_bool_exp],
"_not": PricingPolicy_bool_exp,
"_or": [PricingPolicy_bool_exp],
"createdAt": timestamptz_comparison_exp,
"fixedPrice": numeric_comparison_exp,
"id": uuid_comparison_exp,
"percentageOff": numeric_comparison_exp,
"sellingPlanId": uuid_comparison_exp,
"sellingPlanPricingPolicyAdjustmentType": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
PricingPolicy_max_order_by
Description
order by max() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_min_order_by
Description
order by min() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_order_by
Description
Ordering options when selecting data from "PricingPolicy".
Fields
Input Field | Description |
---|---|
SellingPlan - SellingPlan_order_by
|
Example
{"SellingPlan": SellingPlan_order_by}
PricingPolicy_stddev_order_by
Description
order by stddev() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_sum_order_by
Description
order by sum() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_var_pop_order_by
Description
order by var_pop() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_var_samp_order_by
Description
order by var_samp() on columns of table "PricingPolicy"
Example
{}
PricingPolicy_variance_order_by
Description
order by variance() on columns of table "PricingPolicy"
Example
{}
Product
Description
UNIQUE FIELDS WILL NOT WORK WELL WITH DELETEDAT
Fields
Field Name | Description |
---|---|
DynamicBox - DynamicBox
|
An object relationship |
ProductVariants - [ProductVariant!]!
|
An array relationship |
Site - Site!
|
An object relationship |
createdAt - timestamptz!
|
|
deletedAt - timestamptz
|
|
id - uuid!
|
|
imageSrc - String
|
|
metafields - jsonb
|
|
platformId - String!
|
|
siteId - uuid!
|
|
slug - String!
|
|
smsOrder - Int
|
|
status - String
|
|
title - String!
|
|
updatedAt - timestamptz!
|
Example
{
"DynamicBox": DynamicBox,
"ProductVariants": [ProductVariant],
"Site": Site,
"createdAt": timestamptz,
"deletedAt": timestamptz,
"id": uuid,
"imageSrc": "abc123",
"metafields": jsonb,
"platformId": "abc123",
"siteId": uuid,
"slug": "abc123",
"smsOrder": 123,
"status": "xyz789",
"title": "xyz789",
"updatedAt": timestamptz
}
ProductVariant
Description
columns and relationships of "ProductVariant"
Fields
Field Name | Description |
---|---|
DynamicBox_SelectableProductVariants - [DynamicBox_SelectableProductVariant!]!
|
An array relationship |
OrderLineItems - [OrderLineItem!]!
|
An array relationship |
Product - Product!
|
An object relationship |
SellingPlanGroupResources - [SellingPlanGroupResource!]!
|
An array relationship |
SubscriptionLines - [SubscriptionLine!]!
|
An array relationship |
createdAt - timestamptz!
|
|
deletedAt - timestamptz
|
|
id - uuid!
|
|
image - String
|
|
platformId - String!
|
|
price - numeric!
|
|
productId - uuid!
|
|
sku - String
|
|
title - String!
|
|
updatedAt - timestamptz!
|
Example
{
"DynamicBox_SelectableProductVariants": [
DynamicBox_SelectableProductVariant
],
"OrderLineItems": [OrderLineItem],
"Product": Product,
"SellingPlanGroupResources": [SellingPlanGroupResource],
"SubscriptionLines": [SubscriptionLine],
"createdAt": timestamptz,
"deletedAt": timestamptz,
"id": uuid,
"image": "abc123",
"platformId": "abc123",
"price": numeric,
"productId": uuid,
"sku": "xyz789",
"title": "xyz789",
"updatedAt": timestamptz
}
ProductVariant_aggregate_order_by
Description
order by aggregate values of table "ProductVariant"
Fields
Input Field | Description |
---|---|
avg - ProductVariant_avg_order_by
|
|
max - ProductVariant_max_order_by
|
|
min - ProductVariant_min_order_by
|
|
stddev - ProductVariant_stddev_order_by
|
|
stddev_pop - ProductVariant_stddev_pop_order_by
|
|
stddev_samp - ProductVariant_stddev_samp_order_by
|
|
sum - ProductVariant_sum_order_by
|
|
var_pop - ProductVariant_var_pop_order_by
|
|
var_samp - ProductVariant_var_samp_order_by
|
|
variance - ProductVariant_variance_order_by
|
Example
{
"avg": ProductVariant_avg_order_by,
"max": ProductVariant_max_order_by,
"min": ProductVariant_min_order_by,
"stddev": ProductVariant_stddev_order_by,
"stddev_pop": ProductVariant_stddev_pop_order_by,
"stddev_samp": ProductVariant_stddev_samp_order_by,
"sum": ProductVariant_sum_order_by,
"var_pop": ProductVariant_var_pop_order_by,
"var_samp": ProductVariant_var_samp_order_by,
"variance": ProductVariant_variance_order_by
}
ProductVariant_avg_order_by
Description
order by avg() on columns of table "ProductVariant"
Example
{}
ProductVariant_bool_exp
Description
Boolean expression to filter rows from the table "ProductVariant". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
DynamicBox_SelectableProductVariants - DynamicBox_SelectableProductVariant_bool_exp
|
|
OrderLineItems - OrderLineItem_bool_exp
|
|
Product - Product_bool_exp
|
|
SellingPlanGroupResources - SellingPlanGroupResource_bool_exp
|
|
SubscriptionLines - SubscriptionLine_bool_exp
|
|
_and - [ProductVariant_bool_exp!]
|
|
_not - ProductVariant_bool_exp
|
|
_or - [ProductVariant_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
deletedAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
image - String_comparison_exp
|
|
platformId - String_comparison_exp
|
|
price - numeric_comparison_exp
|
|
productId - uuid_comparison_exp
|
|
sku - String_comparison_exp
|
|
title - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"DynamicBox_SelectableProductVariants": DynamicBox_SelectableProductVariant_bool_exp,
"OrderLineItems": OrderLineItem_bool_exp,
"Product": Product_bool_exp,
"SellingPlanGroupResources": SellingPlanGroupResource_bool_exp,
"SubscriptionLines": SubscriptionLine_bool_exp,
"_and": [ProductVariant_bool_exp],
"_not": ProductVariant_bool_exp,
"_or": [ProductVariant_bool_exp],
"createdAt": timestamptz_comparison_exp,
"deletedAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"image": String_comparison_exp,
"platformId": String_comparison_exp,
"price": numeric_comparison_exp,
"productId": uuid_comparison_exp,
"sku": String_comparison_exp,
"title": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
ProductVariant_max_order_by
Description
order by max() on columns of table "ProductVariant"
Example
{}
ProductVariant_min_order_by
Description
order by min() on columns of table "ProductVariant"
Example
{}
ProductVariant_order_by
Description
Ordering options when selecting data from "ProductVariant".
Fields
Input Field | Description |
---|---|
DynamicBox_SelectableProductVariants_aggregate - DynamicBox_SelectableProductVariant_aggregate_order_by
|
|
OrderLineItems_aggregate - OrderLineItem_aggregate_order_by
|
|
Product - Product_order_by
|
|
SellingPlanGroupResources_aggregate - SellingPlanGroupResource_aggregate_order_by
|
|
SubscriptionLines_aggregate - SubscriptionLine_aggregate_order_by
|
Example
{
"DynamicBox_SelectableProductVariants_aggregate": DynamicBox_SelectableProductVariant_aggregate_order_by,
"OrderLineItems_aggregate": OrderLineItem_aggregate_order_by,
"Product": Product_order_by,
"SellingPlanGroupResources_aggregate": SellingPlanGroupResource_aggregate_order_by,
"SubscriptionLines_aggregate": SubscriptionLine_aggregate_order_by
}
ProductVariant_stddev_order_by
Description
order by stddev() on columns of table "ProductVariant"
Example
{}
ProductVariant_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "ProductVariant"
Example
{}
ProductVariant_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "ProductVariant"
Example
{}
ProductVariant_sum_order_by
Description
order by sum() on columns of table "ProductVariant"
Example
{}
ProductVariant_var_pop_order_by
Description
order by var_pop() on columns of table "ProductVariant"
Example
{}
ProductVariant_var_samp_order_by
Description
order by var_samp() on columns of table "ProductVariant"
Example
{}
ProductVariant_variance_order_by
Description
order by variance() on columns of table "ProductVariant"
Example
{}
Product_aggregate_order_by
Description
order by aggregate values of table "Product"
Fields
Input Field | Description |
---|---|
avg - Product_avg_order_by
|
|
max - Product_max_order_by
|
|
min - Product_min_order_by
|
|
stddev - Product_stddev_order_by
|
|
stddev_pop - Product_stddev_pop_order_by
|
|
stddev_samp - Product_stddev_samp_order_by
|
|
sum - Product_sum_order_by
|
|
var_pop - Product_var_pop_order_by
|
|
var_samp - Product_var_samp_order_by
|
|
variance - Product_variance_order_by
|
Example
{
"avg": Product_avg_order_by,
"max": Product_max_order_by,
"min": Product_min_order_by,
"stddev": Product_stddev_order_by,
"stddev_pop": Product_stddev_pop_order_by,
"stddev_samp": Product_stddev_samp_order_by,
"sum": Product_sum_order_by,
"var_pop": Product_var_pop_order_by,
"var_samp": Product_var_samp_order_by,
"variance": Product_variance_order_by
}
Product_avg_order_by
Description
order by avg() on columns of table "Product"
Example
{}
Product_bool_exp
Description
Boolean expression to filter rows from the table "Product". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
DynamicBox - DynamicBox_bool_exp
|
|
ProductVariants - ProductVariant_bool_exp
|
|
Site - Site_bool_exp
|
|
_and - [Product_bool_exp!]
|
|
_not - Product_bool_exp
|
|
_or - [Product_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
deletedAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
imageSrc - String_comparison_exp
|
|
metafields - jsonb_comparison_exp
|
|
platformId - String_comparison_exp
|
|
siteId - uuid_comparison_exp
|
|
slug - String_comparison_exp
|
|
smsOrder - Int_comparison_exp
|
|
status - String_comparison_exp
|
|
title - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"DynamicBox": DynamicBox_bool_exp,
"ProductVariants": ProductVariant_bool_exp,
"Site": Site_bool_exp,
"_and": [Product_bool_exp],
"_not": Product_bool_exp,
"_or": [Product_bool_exp],
"createdAt": timestamptz_comparison_exp,
"deletedAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"imageSrc": String_comparison_exp,
"metafields": jsonb_comparison_exp,
"platformId": String_comparison_exp,
"siteId": uuid_comparison_exp,
"slug": String_comparison_exp,
"smsOrder": Int_comparison_exp,
"status": String_comparison_exp,
"title": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
Product_max_order_by
Description
order by max() on columns of table "Product"
Example
{}
Product_min_order_by
Description
order by min() on columns of table "Product"
Example
{}
Product_order_by
Description
Ordering options when selecting data from "Product".
Fields
Input Field | Description |
---|---|
DynamicBox - DynamicBox_order_by
|
|
ProductVariants_aggregate - ProductVariant_aggregate_order_by
|
|
Site - Site_order_by
|
Example
{
"DynamicBox": DynamicBox_order_by,
"ProductVariants_aggregate": ProductVariant_aggregate_order_by,
"Site": Site_order_by
}
Product_stddev_order_by
Description
order by stddev() on columns of table "Product"
Example
{}
Product_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "Product"
Example
{}
Product_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "Product"
Example
{}
Product_sum_order_by
Description
order by sum() on columns of table "Product"
Example
{}
Product_var_pop_order_by
Description
order by var_pop() on columns of table "Product"
Example
{}
Product_var_samp_order_by
Description
order by var_samp() on columns of table "Product"
Example
{}
Product_variance_order_by
Description
order by variance() on columns of table "Product"
Example
{}
SellingPlan
Description
columns and relationships of "SellingPlan"
Fields
Field Name | Description |
---|---|
BillingPolicy - Policy!
|
An object relationship |
DeliveryPolicy - Policy!
|
An object relationship |
GroupPlans - [GroupPlan!]!
|
An array relationship |
PrepaidDeliveryPolicy - Policy
|
An object relationship |
PricingPolicies - [PricingPolicy!]!
|
An array relationship |
SellingPlanGroup - SellingPlanGroup!
|
An object relationship |
SkuSwaps - [SkuSwap!]!
|
An array relationship |
SubscriptionLines - [SubscriptionLine!]!
|
An array relationship |
billingPolicyId - uuid!
|
|
createdAt - timestamptz!
|
|
deliveryPolicyId - uuid!
|
|
id - uuid!
|
|
name - String!
|
|
option - String!
|
|
platformId - String!
|
|
position - Int!
|
|
prepaidDeliveryPolicyId - uuid
|
|
productVariantIdToSwapToAfterFirstOrder - String
|
|
sellingPlanGroupId - uuid!
|
|
updatedAt - timestamptz!
|
Example
{
"BillingPolicy": Policy,
"DeliveryPolicy": Policy,
"GroupPlans": [GroupPlan],
"PrepaidDeliveryPolicy": Policy,
"PricingPolicies": [PricingPolicy],
"SellingPlanGroup": SellingPlanGroup,
"SkuSwaps": [SkuSwap],
"SubscriptionLines": [SubscriptionLine],
"billingPolicyId": uuid,
"createdAt": timestamptz,
"deliveryPolicyId": uuid,
"id": uuid,
"name": "xyz789",
"option": "abc123",
"platformId": "xyz789",
"position": 987,
"prepaidDeliveryPolicyId": uuid,
"productVariantIdToSwapToAfterFirstOrder": "xyz789",
"sellingPlanGroupId": uuid,
"updatedAt": timestamptz
}
SellingPlanGroup
Description
columns and relationships of "SellingPlanGroup"
Fields
Field Name | Description |
---|---|
SellingPlanGroupResources - [SellingPlanGroupResource!]!
|
An array relationship |
SellingPlans - [SellingPlan!]!
|
An array relationship |
byGroup - Boolean
|
|
createdAt - timestamptz!
|
|
customName - String
|
|
id - uuid!
|
|
name - String!
|
|
platformId - String!
|
|
updatedAt - timestamptz!
|
Example
{
"SellingPlanGroupResources": [SellingPlanGroupResource],
"SellingPlans": [SellingPlan],
"byGroup": false,
"createdAt": timestamptz,
"customName": "abc123",
"id": uuid,
"name": "abc123",
"platformId": "abc123",
"updatedAt": timestamptz
}
SellingPlanGroupResource
Description
columns and relationships of "SellingPlanGroupResource"
Fields
Field Name | Description |
---|---|
ProductVariant - ProductVariant!
|
An object relationship |
SellingPlanGroup - SellingPlanGroup!
|
An object relationship |
createdAt - timestamptz!
|
|
id - uuid!
|
|
productVariantId - uuid!
|
|
sellingPlanGroupId - uuid!
|
|
updatedAt - timestamptz!
|
Example
{
"ProductVariant": ProductVariant,
"SellingPlanGroup": SellingPlanGroup,
"createdAt": timestamptz,
"id": uuid,
"productVariantId": uuid,
"sellingPlanGroupId": uuid,
"updatedAt": timestamptz
}
SellingPlanGroupResource_aggregate_order_by
Description
order by aggregate values of table "SellingPlanGroupResource"
Fields
Input Field | Description |
---|---|
max - SellingPlanGroupResource_max_order_by
|
|
min - SellingPlanGroupResource_min_order_by
|
Example
{
"max": SellingPlanGroupResource_max_order_by,
"min": SellingPlanGroupResource_min_order_by
}
SellingPlanGroupResource_bool_exp
Description
Boolean expression to filter rows from the table "SellingPlanGroupResource". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
ProductVariant - ProductVariant_bool_exp
|
|
SellingPlanGroup - SellingPlanGroup_bool_exp
|
|
_and - [SellingPlanGroupResource_bool_exp!]
|
|
_not - SellingPlanGroupResource_bool_exp
|
|
_or - [SellingPlanGroupResource_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
productVariantId - uuid_comparison_exp
|
|
sellingPlanGroupId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"ProductVariant": ProductVariant_bool_exp,
"SellingPlanGroup": SellingPlanGroup_bool_exp,
"_and": [SellingPlanGroupResource_bool_exp],
"_not": SellingPlanGroupResource_bool_exp,
"_or": [SellingPlanGroupResource_bool_exp],
"createdAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"productVariantId": uuid_comparison_exp,
"sellingPlanGroupId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
SellingPlanGroupResource_max_order_by
Description
order by max() on columns of table "SellingPlanGroupResource"
Example
{}
SellingPlanGroupResource_min_order_by
Description
order by min() on columns of table "SellingPlanGroupResource"
Example
{}
SellingPlanGroup_bool_exp
Description
Boolean expression to filter rows from the table "SellingPlanGroup". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
SellingPlanGroupResources - SellingPlanGroupResource_bool_exp
|
|
SellingPlans - SellingPlan_bool_exp
|
|
_and - [SellingPlanGroup_bool_exp!]
|
|
_not - SellingPlanGroup_bool_exp
|
|
_or - [SellingPlanGroup_bool_exp!]
|
|
byGroup - Boolean_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
customName - String_comparison_exp
|
|
id - uuid_comparison_exp
|
|
name - String_comparison_exp
|
|
platformId - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"SellingPlanGroupResources": SellingPlanGroupResource_bool_exp,
"SellingPlans": SellingPlan_bool_exp,
"_and": [SellingPlanGroup_bool_exp],
"_not": SellingPlanGroup_bool_exp,
"_or": [SellingPlanGroup_bool_exp],
"byGroup": Boolean_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"customName": String_comparison_exp,
"id": uuid_comparison_exp,
"name": String_comparison_exp,
"platformId": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
SellingPlanGroup_order_by
Description
Ordering options when selecting data from "SellingPlanGroup".
Fields
Input Field | Description |
---|---|
SellingPlanGroupResources_aggregate - SellingPlanGroupResource_aggregate_order_by
|
|
SellingPlans_aggregate - SellingPlan_aggregate_order_by
|
Example
{
"SellingPlanGroupResources_aggregate": SellingPlanGroupResource_aggregate_order_by,
"SellingPlans_aggregate": SellingPlan_aggregate_order_by
}
SellingPlan_aggregate_order_by
Description
order by aggregate values of table "SellingPlan"
Fields
Input Field | Description |
---|---|
avg - SellingPlan_avg_order_by
|
|
max - SellingPlan_max_order_by
|
|
min - SellingPlan_min_order_by
|
|
stddev - SellingPlan_stddev_order_by
|
|
stddev_pop - SellingPlan_stddev_pop_order_by
|
|
stddev_samp - SellingPlan_stddev_samp_order_by
|
|
sum - SellingPlan_sum_order_by
|
|
var_pop - SellingPlan_var_pop_order_by
|
|
var_samp - SellingPlan_var_samp_order_by
|
|
variance - SellingPlan_variance_order_by
|
Example
{
"avg": SellingPlan_avg_order_by,
"max": SellingPlan_max_order_by,
"min": SellingPlan_min_order_by,
"stddev": SellingPlan_stddev_order_by,
"stddev_pop": SellingPlan_stddev_pop_order_by,
"stddev_samp": SellingPlan_stddev_samp_order_by,
"sum": SellingPlan_sum_order_by,
"var_pop": SellingPlan_var_pop_order_by,
"var_samp": SellingPlan_var_samp_order_by,
"variance": SellingPlan_variance_order_by
}
SellingPlan_avg_order_by
Description
order by avg() on columns of table "SellingPlan"
Example
{}
SellingPlan_bool_exp
Description
Boolean expression to filter rows from the table "SellingPlan". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
BillingPolicy - Policy_bool_exp
|
|
DeliveryPolicy - Policy_bool_exp
|
|
GroupPlans - GroupPlan_bool_exp
|
|
PrepaidDeliveryPolicy - Policy_bool_exp
|
|
PricingPolicies - PricingPolicy_bool_exp
|
|
SellingPlanGroup - SellingPlanGroup_bool_exp
|
|
SkuSwaps - SkuSwap_bool_exp
|
|
SubscriptionLines - SubscriptionLine_bool_exp
|
|
_and - [SellingPlan_bool_exp!]
|
|
_not - SellingPlan_bool_exp
|
|
_or - [SellingPlan_bool_exp!]
|
|
billingPolicyId - uuid_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
deliveryPolicyId - uuid_comparison_exp
|
|
id - uuid_comparison_exp
|
|
name - String_comparison_exp
|
|
option - String_comparison_exp
|
|
platformId - String_comparison_exp
|
|
position - Int_comparison_exp
|
|
prepaidDeliveryPolicyId - uuid_comparison_exp
|
|
productVariantIdToSwapToAfterFirstOrder - String_comparison_exp
|
|
sellingPlanGroupId - uuid_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"BillingPolicy": Policy_bool_exp,
"DeliveryPolicy": Policy_bool_exp,
"GroupPlans": GroupPlan_bool_exp,
"PrepaidDeliveryPolicy": Policy_bool_exp,
"PricingPolicies": PricingPolicy_bool_exp,
"SellingPlanGroup": SellingPlanGroup_bool_exp,
"SkuSwaps": SkuSwap_bool_exp,
"SubscriptionLines": SubscriptionLine_bool_exp,
"_and": [SellingPlan_bool_exp],
"_not": SellingPlan_bool_exp,
"_or": [SellingPlan_bool_exp],
"billingPolicyId": uuid_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"deliveryPolicyId": uuid_comparison_exp,
"id": uuid_comparison_exp,
"name": String_comparison_exp,
"option": String_comparison_exp,
"platformId": String_comparison_exp,
"position": Int_comparison_exp,
"prepaidDeliveryPolicyId": uuid_comparison_exp,
"productVariantIdToSwapToAfterFirstOrder": String_comparison_exp,
"sellingPlanGroupId": uuid_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
SellingPlan_max_order_by
Description
order by max() on columns of table "SellingPlan"
Example
{}
SellingPlan_min_order_by
Description
order by min() on columns of table "SellingPlan"
Example
{}
SellingPlan_order_by
Description
Ordering options when selecting data from "SellingPlan".
Fields
Input Field | Description |
---|---|
BillingPolicy - Policy_order_by
|
|
DeliveryPolicy - Policy_order_by
|
|
GroupPlans_aggregate - GroupPlan_aggregate_order_by
|
|
PrepaidDeliveryPolicy - Policy_order_by
|
|
PricingPolicies_aggregate - PricingPolicy_aggregate_order_by
|
|
SellingPlanGroup - SellingPlanGroup_order_by
|
|
SkuSwaps_aggregate - SkuSwap_aggregate_order_by
|
|
SubscriptionLines_aggregate - SubscriptionLine_aggregate_order_by
|
Example
{
"BillingPolicy": Policy_order_by,
"DeliveryPolicy": Policy_order_by,
"GroupPlans_aggregate": GroupPlan_aggregate_order_by,
"PrepaidDeliveryPolicy": Policy_order_by,
"PricingPolicies_aggregate": PricingPolicy_aggregate_order_by,
"SellingPlanGroup": SellingPlanGroup_order_by,
"SkuSwaps_aggregate": SkuSwap_aggregate_order_by,
"SubscriptionLines_aggregate": SubscriptionLine_aggregate_order_by
}
SellingPlan_stddev_order_by
Description
order by stddev() on columns of table "SellingPlan"
Example
{}
SellingPlan_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "SellingPlan"
Example
{}
SellingPlan_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "SellingPlan"
Example
{}
SellingPlan_sum_order_by
Description
order by sum() on columns of table "SellingPlan"
Example
{}
SellingPlan_var_pop_order_by
Description
order by var_pop() on columns of table "SellingPlan"
Example
{}
SellingPlan_var_samp_order_by
Description
order by var_samp() on columns of table "SellingPlan"
Example
{}
SellingPlan_variance_order_by
Description
order by variance() on columns of table "SellingPlan"
Example
{}
ShippingLine
Description
columns and relationships of "ShippingLine"
Fields
Field Name | Description |
---|---|
Discounts - [Discount!]!
|
An array relationship |
Order - Order!
|
An object relationship |
TaxLines - [TaxLine!]!
|
An array relationship |
createdAt - timestamptz!
|
|
id - uuid!
|
|
orderId - uuid!
|
|
platformId - String!
|
|
priceWithoutDiscount - numeric!
|
|
title - String!
|
|
updatedAt - timestamptz!
|
Example
{
"Discounts": [Discount],
"Order": Order,
"TaxLines": [TaxLine],
"createdAt": timestamptz,
"id": uuid,
"orderId": uuid,
"platformId": "xyz789",
"priceWithoutDiscount": numeric,
"title": "xyz789",
"updatedAt": timestamptz
}
ShippingLine_aggregate_order_by
Description
order by aggregate values of table "ShippingLine"
Fields
Input Field | Description |
---|---|
avg - ShippingLine_avg_order_by
|
|
max - ShippingLine_max_order_by
|
|
min - ShippingLine_min_order_by
|
|
stddev - ShippingLine_stddev_order_by
|
|
stddev_pop - ShippingLine_stddev_pop_order_by
|
|
stddev_samp - ShippingLine_stddev_samp_order_by
|
|
sum - ShippingLine_sum_order_by
|
|
var_pop - ShippingLine_var_pop_order_by
|
|
var_samp - ShippingLine_var_samp_order_by
|
|
variance - ShippingLine_variance_order_by
|
Example
{
"avg": ShippingLine_avg_order_by,
"max": ShippingLine_max_order_by,
"min": ShippingLine_min_order_by,
"stddev": ShippingLine_stddev_order_by,
"stddev_pop": ShippingLine_stddev_pop_order_by,
"stddev_samp": ShippingLine_stddev_samp_order_by,
"sum": ShippingLine_sum_order_by,
"var_pop": ShippingLine_var_pop_order_by,
"var_samp": ShippingLine_var_samp_order_by,
"variance": ShippingLine_variance_order_by
}
ShippingLine_avg_order_by
Description
order by avg() on columns of table "ShippingLine"
Example
{}
ShippingLine_bool_exp
Description
Boolean expression to filter rows from the table "ShippingLine". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
Discounts - Discount_bool_exp
|
|
Order - Order_bool_exp
|
|
TaxLines - TaxLine_bool_exp
|
|
_and - [ShippingLine_bool_exp!]
|
|
_not - ShippingLine_bool_exp
|
|
_or - [ShippingLine_bool_exp!]
|
|
createdAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
orderId - uuid_comparison_exp
|
|
platformId - String_comparison_exp
|
|
priceWithoutDiscount - numeric_comparison_exp
|
|
title - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"Discounts": Discount_bool_exp,
"Order": Order_bool_exp,
"TaxLines": TaxLine_bool_exp,
"_and": [ShippingLine_bool_exp],
"_not": ShippingLine_bool_exp,
"_or": [ShippingLine_bool_exp],
"createdAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"orderId": uuid_comparison_exp,
"platformId": String_comparison_exp,
"priceWithoutDiscount": numeric_comparison_exp,
"title": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
ShippingLine_max_order_by
Description
order by max() on columns of table "ShippingLine"
Example
{}
ShippingLine_min_order_by
Description
order by min() on columns of table "ShippingLine"
Example
{}
ShippingLine_stddev_order_by
Description
order by stddev() on columns of table "ShippingLine"
Example
{}
ShippingLine_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "ShippingLine"
Example
{}
ShippingLine_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "ShippingLine"
Example
{}
ShippingLine_sum_order_by
Description
order by sum() on columns of table "ShippingLine"
Example
{}
ShippingLine_var_pop_order_by
Description
order by var_pop() on columns of table "ShippingLine"
Example
{}
ShippingLine_var_samp_order_by
Description
order by var_samp() on columns of table "ShippingLine"
Example
{}
ShippingLine_variance_order_by
Description
order by variance() on columns of table "ShippingLine"
Example
{}
Site
Description
Needs to be public for unauth to login.
Fields
Field Name | Description |
---|---|
Holidays - [Holiday!]!
|
An array relationship |
Notifications - [Notification!]!
|
An array relationship |
Products - [Product!]!
|
An array relationship |
StorefrontUsers - [StorefrontUser!]!
|
An array relationship |
Theme - Theme
|
An object relationship |
Theme2 - Theme2
|
An object relationship |
id - uuid!
|
Example
{
"Holidays": [Holiday],
"Notifications": [Notification],
"Products": [Product],
"StorefrontUsers": [StorefrontUser],
"Theme": Theme,
"Theme2": Theme2,
"id": uuid
}
Site_bool_exp
Description
Boolean expression to filter rows from the table "Site". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
Holidays - Holiday_bool_exp
|
|
Notifications - Notification_bool_exp
|
|
Products - Product_bool_exp
|
|
StorefrontUsers - StorefrontUser_bool_exp
|
|
Theme - Theme_bool_exp
|
|
Theme2 - Theme2_bool_exp
|
|
_and - [Site_bool_exp!]
|
|
_not - Site_bool_exp
|
|
_or - [Site_bool_exp!]
|
|
id - uuid_comparison_exp
|
Example
{
"Holidays": Holiday_bool_exp,
"Notifications": Notification_bool_exp,
"Products": Product_bool_exp,
"StorefrontUsers": StorefrontUser_bool_exp,
"Theme": Theme_bool_exp,
"Theme2": Theme2_bool_exp,
"_and": [Site_bool_exp],
"_not": Site_bool_exp,
"_or": [Site_bool_exp],
"id": uuid_comparison_exp
}
Site_order_by
Description
Ordering options when selecting data from "Site".
Fields
Input Field | Description |
---|---|
Holidays_aggregate - Holiday_aggregate_order_by
|
|
Notifications_aggregate - Notification_aggregate_order_by
|
|
Products_aggregate - Product_aggregate_order_by
|
|
StorefrontUsers_aggregate - StorefrontUser_aggregate_order_by
|
|
Theme - Theme_order_by
|
|
Theme2 - Theme2_order_by
|
Example
{
"Holidays_aggregate": Holiday_aggregate_order_by,
"Notifications_aggregate": Notification_aggregate_order_by,
"Products_aggregate": Product_aggregate_order_by,
"StorefrontUsers_aggregate": StorefrontUser_aggregate_order_by,
"Theme": Theme_order_by,
"Theme2": Theme2_order_by
}
SkuSwap
Description
columns and relationships of "SkuSwap"
Fields
Field Name | Description |
---|---|
SellingPlan - SellingPlan!
|
An object relationship |
afterOrderNumber - Int!
|
|
createdAt - timestamptz!
|
|
id - uuid!
|
|
newPrice - numeric
|
|
overrideDaysToNextBilling - Int
|
|
productVariantFromPlatformId - String
|
|
productVariantPlatformId - String
|
|
sellingPlanId - uuid!
|
|
siteId - uuid!
|
|
sku - String
|
|
updatedAt - timestamptz!
|
Example
{
"SellingPlan": SellingPlan,
"afterOrderNumber": 987,
"createdAt": timestamptz,
"id": uuid,
"newPrice": numeric,
"overrideDaysToNextBilling": 987,
"productVariantFromPlatformId": "abc123",
"productVariantPlatformId": "abc123",
"sellingPlanId": uuid,
"siteId": uuid,
"sku": "xyz789",
"updatedAt": timestamptz
}
SkuSwap_aggregate_order_by
Description
order by aggregate values of table "SkuSwap"
Fields
Input Field | Description |
---|---|
avg - SkuSwap_avg_order_by
|
|
max - SkuSwap_max_order_by
|
|
min - SkuSwap_min_order_by
|
|
stddev - SkuSwap_stddev_order_by
|
|
stddev_pop - SkuSwap_stddev_pop_order_by
|
|
stddev_samp - SkuSwap_stddev_samp_order_by
|
|
sum - SkuSwap_sum_order_by
|
|
var_pop - SkuSwap_var_pop_order_by
|
|
var_samp - SkuSwap_var_samp_order_by
|
|
variance - SkuSwap_variance_order_by
|
Example
{
"avg": SkuSwap_avg_order_by,
"max": SkuSwap_max_order_by,
"min": SkuSwap_min_order_by,
"stddev": SkuSwap_stddev_order_by,
"stddev_pop": SkuSwap_stddev_pop_order_by,
"stddev_samp": SkuSwap_stddev_samp_order_by,
"sum": SkuSwap_sum_order_by,
"var_pop": SkuSwap_var_pop_order_by,
"var_samp": SkuSwap_var_samp_order_by,
"variance": SkuSwap_variance_order_by
}
SkuSwap_avg_order_by
Description
order by avg() on columns of table "SkuSwap"
Example
{}
SkuSwap_bool_exp
Description
Boolean expression to filter rows from the table "SkuSwap". All fields are combined with a logical 'AND'.
Fields
Input Field | Description |
---|---|
SellingPlan - SellingPlan_bool_exp
|
|
_and - [SkuSwap_bool_exp!]
|
|
_not - SkuSwap_bool_exp
|
|
_or - [SkuSwap_bool_exp!]
|
|
afterOrderNumber - Int_comparison_exp
|
|
createdAt - timestamptz_comparison_exp
|
|
id - uuid_comparison_exp
|
|
newPrice - numeric_comparison_exp
|
|
overrideDaysToNextBilling - Int_comparison_exp
|
|
productVariantFromPlatformId - String_comparison_exp
|
|
productVariantPlatformId - String_comparison_exp
|
|
sellingPlanId - uuid_comparison_exp
|
|
siteId - uuid_comparison_exp
|
|
sku - String_comparison_exp
|
|
updatedAt - timestamptz_comparison_exp
|
Example
{
"SellingPlan": SellingPlan_bool_exp,
"_and": [SkuSwap_bool_exp],
"_not": SkuSwap_bool_exp,
"_or": [SkuSwap_bool_exp],
"afterOrderNumber": Int_comparison_exp,
"createdAt": timestamptz_comparison_exp,
"id": uuid_comparison_exp,
"newPrice": numeric_comparison_exp,
"overrideDaysToNextBilling": Int_comparison_exp,
"productVariantFromPlatformId": String_comparison_exp,
"productVariantPlatformId": String_comparison_exp,
"sellingPlanId": uuid_comparison_exp,
"siteId": uuid_comparison_exp,
"sku": String_comparison_exp,
"updatedAt": timestamptz_comparison_exp
}
SkuSwap_max_order_by
Description
order by max() on columns of table "SkuSwap"
Example
{}
SkuSwap_min_order_by
Description
order by min() on columns of table "SkuSwap"
Example
{}
SkuSwap_stddev_order_by
Description
order by stddev() on columns of table "SkuSwap"
Example
{}
SkuSwap_stddev_pop_order_by
Description
order by stddev_pop() on columns of table "SkuSwap"
Example
{}
SkuSwap_stddev_samp_order_by
Description
order by stddev_samp() on columns of table "SkuSwap"
Example
{}
SkuSwap_sum_order_by
Description
order by sum() on columns of table "SkuSwap"
Example
{}
SkuSwap_var_pop_order_by
Description
order by var_pop() on columns of table "SkuSwap"
Example
{}