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.

Contact

Skio Engineering

help@skio.com

Terms of Service

https://skio.com/terms/

API Endpoints
https://graphql.skio.com/v1/graphql

Queries

AddressByPk

Description

fetch data from the table: "Address" using primary key columns

Response

Returns an Address

Arguments
Name Description
id - uuid!

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

Response

Returns a Discount

Arguments
Name Description
id - uuid!

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

Response

Returns an Order

Arguments
Name Description
id - uuid!

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

Response

Returns a Policy

Arguments
Name Description
id - uuid!

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

Response

Returns a Product

Arguments
Name Description
id - uuid!

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

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

Fields
Input Field Description
price - Float
quantity - Int
subscriptionId - uuid!
upsell - Boolean
variantId - uuid!
Example
{
  "price": 987.65,
  "quantity": 123,
  "subscriptionId": uuid,
  "upsell": false,
  "variantId": uuid
}

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'.

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

Fields
Field Name Description
Policy - Policy! An object relationship
createdAt - timestamptz!
cutoffDay - Int
day - Int!
id - uuid!
missedAnchorAllowance - Int
month - Int
policyId - uuid!
strictness - String!
type - String!
updatedAt - timestamptz!
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"

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

Fields
Input Field Description
code - String!
subscriptionId - uuid!
Example
{
  "code": "abc123",
  "subscriptionId": uuid
}

ApplyDiscountCodeOutput

Fields
Field Name Description
message - String!
ok - Boolean!
Example
{"message": "xyz789", "ok": false}

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'.

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'.

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

Fields
Input Field Description
cancelSessionId - String
permanentlyCancel - Boolean
shouldSendNotif - Boolean
subscriptionId - uuid!
Example
{
  "cancelSessionId": "abc123",
  "permanentlyCancel": false,
  "shouldSendNotif": true,
  "subscriptionId": uuid
}

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"

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"

Fields
Field Name Description
DynamicBox_SelectableProductVariants - [DynamicBox_SelectableProductVariant!]! An array relationship
Product - Product! An object relationship
fixedDiscount - jsonb
id - uuid!
percentDiscount - jsonb
sizeInterval - jsonb
sizeRange - jsonb
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"

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'.

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"

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'.

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"

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

Description

columns and relationships of "Holiday"

Fields
Field Name Description
Site - Site! An object relationship
id - uuid!
Example
{"Site": Site, "id": uuid}

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'.

Fields
Input Field Description
_eq - Int
_gt - Int
_gte - Int
_in - [Int!]
_is_null - Boolean
_lt - Int
_lte - Int
_neq - Int
_nin - [Int!]
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'.

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"

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"

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

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'.

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"

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'.

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"

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'.

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'.

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"

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"

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'.

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"

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
{}