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

Queries

`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"
      }
    ]
  }
}

Queries

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

Queries

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

Queries

`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
      }
    ]
  }
}

Queries

`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
      }
    ]
  }
}

Queries

`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
      }
    ]
  }
}

Queries

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

Queries

`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
      }
    ]
  }
}

Queries

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

Queries

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

Queries

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

Queries

`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
      }
    ]
  }
}

Queries

`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
      }
    ]
  }
}

Queries

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

Queries

`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
      }
    ]
  }
}

Queries

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

Mutations

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

Mutations

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

Mutations

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

Mutations

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

Mutations

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

Mutations

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

Mutations

`updateSubscriptionShippingAddress`

Description

updates a subscriptions shipping address

Response

Returns an UpdateSubscriptionShippingAddressOutput

Arguments

Name	Description
`input` - `UpdateSubscriptionShippingAddressInput!`

Example

Query

mutation updateSubscriptionShippingAddress($input: UpdateSubscriptionShippingAddressInput!) {
  updateSubscriptionShippingAddress(input: $input) {
    message
    ok
  }
}

Variables

{"input": UpdateSubscriptionShippingAddressInput}

Response

{
  "data": {
    "updateSubscriptionShippingAddress": {
      "message": "xyz789",
      "ok": true
    }
  }
}

Types

AddSubscriptionLineInput

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
}

Types

AddSubscriptionLineOutput

Fields

Field Name	Description
`ok` - `Boolean!`

Example

{"ok": true}

Types

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

Types

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
}

Types

Address_bool_exp

Description

Boolean expression to filter rows from the table "Address". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`PaymentMethod` - `PaymentMethod_bool_exp`
`StorefrontUser` - `StorefrontUser_bool_exp`
`Subscriptions` - `Subscription_bool_exp`
`_and` - `[Address_bool_exp!]`
`_not` - `Address_bool_exp`
`_or` - `[Address_bool_exp!]`
`address1` - `String_comparison_exp`
`address2` - `String_comparison_exp`
`city` - `String_comparison_exp`
`company` - `String_comparison_exp`
`country` - `String_comparison_exp`
`createdAt` - `timestamptz_comparison_exp`
`doorCode` - `String_comparison_exp`
`firstName` - `String_comparison_exp`
`id` - `uuid_comparison_exp`
`lastName` - `String_comparison_exp`
`phoneNumber` - `String_comparison_exp`
`platformId` - `String_comparison_exp`
`province` - `String_comparison_exp`
`storefrontUserId` - `uuid_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`
`zip` - `String_comparison_exp`

Example

{
  "PaymentMethod": PaymentMethod_bool_exp,
  "StorefrontUser": StorefrontUser_bool_exp,
  "Subscriptions": Subscription_bool_exp,
  "_and": [Address_bool_exp],
  "_not": Address_bool_exp,
  "_or": [Address_bool_exp],
  "address1": String_comparison_exp,
  "address2": String_comparison_exp,
  "city": String_comparison_exp,
  "company": String_comparison_exp,
  "country": String_comparison_exp,
  "createdAt": timestamptz_comparison_exp,
  "doorCode": String_comparison_exp,
  "firstName": String_comparison_exp,
  "id": uuid_comparison_exp,
  "lastName": String_comparison_exp,
  "phoneNumber": String_comparison_exp,
  "platformId": String_comparison_exp,
  "province": String_comparison_exp,
  "storefrontUserId": uuid_comparison_exp,
  "updatedAt": timestamptz_comparison_exp,
  "zip": String_comparison_exp
}

Types

Address_max_order_by

Description

order by max() on columns of table "Address"

Example

{}

Types

Address_min_order_by

Description

order by min() on columns of table "Address"

Example

{}

Types

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
}

Types

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
}

Types

Anchor_aggregate_order_by

Description

order by aggregate values of table "Anchor"

Fields

Input Field	Description
`avg` - `Anchor_avg_order_by`
`max` - `Anchor_max_order_by`
`min` - `Anchor_min_order_by`
`stddev` - `Anchor_stddev_order_by`
`stddev_pop` - `Anchor_stddev_pop_order_by`
`stddev_samp` - `Anchor_stddev_samp_order_by`
`sum` - `Anchor_sum_order_by`
`var_pop` - `Anchor_var_pop_order_by`
`var_samp` - `Anchor_var_samp_order_by`
`variance` - `Anchor_variance_order_by`

Example

{
  "avg": Anchor_avg_order_by,
  "max": Anchor_max_order_by,
  "min": Anchor_min_order_by,
  "stddev": Anchor_stddev_order_by,
  "stddev_pop": Anchor_stddev_pop_order_by,
  "stddev_samp": Anchor_stddev_samp_order_by,
  "sum": Anchor_sum_order_by,
  "var_pop": Anchor_var_pop_order_by,
  "var_samp": Anchor_var_samp_order_by,
  "variance": Anchor_variance_order_by
}

Types

Anchor_avg_order_by

Description

order by avg() on columns of table "Anchor"

Example

{}

Types

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
}

Types

Anchor_max_order_by

Description

order by max() on columns of table "Anchor"

Example

{}

Types

Anchor_min_order_by

Description

order by min() on columns of table "Anchor"

Example

{}

Types

Anchor_stddev_order_by

Description

order by stddev() on columns of table "Anchor"

Example

{}

Types

Anchor_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "Anchor"

Example

{}

Types

Anchor_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "Anchor"

Example

{}

Types

Anchor_sum_order_by

Description

order by sum() on columns of table "Anchor"

Example

{}

Types

Anchor_var_pop_order_by

Description

order by var_pop() on columns of table "Anchor"

Example

{}

Types

Anchor_var_samp_order_by

Description

order by var_samp() on columns of table "Anchor"

Example

{}

Types

Anchor_variance_order_by

Description

order by variance() on columns of table "Anchor"

Example

{}

Types

ApplyDiscountCodeInput

Fields

Input Field	Description
`code` - `String!`
`subscriptionId` - `uuid!`

Example

{
  "code": "abc123",
  "subscriptionId": uuid
}

Types

ApplyDiscountCodeOutput

Fields

Field Name	Description
`message` - `String!`
`ok` - `Boolean!`

Example

{"message": "xyz789", "ok": false}

Types

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
}

Types

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
}

Types

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
}

Types

AuditLog_max_order_by

Description

order by max() on columns of table "AuditLog"

Example

{}

Types

AuditLog_min_order_by

Description

order by min() on columns of table "AuditLog"

Example

{}

Types

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
}

Types

Boolean

Example

true

Types

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

Types

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
}

Types

CancelFlowReason_bool_exp

Description

Boolean expression to filter rows from the table "CancelFlowReason". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`CancelFlowSession` - `CancelFlowSession_bool_exp`
`_and` - `[CancelFlowReason_bool_exp!]`
`_not` - `CancelFlowReason_bool_exp`
`_or` - `[CancelFlowReason_bool_exp!]`
`cancelFlowId` - `uuid_comparison_exp`
`cancelFlowSessionId` - `uuid_comparison_exp`
`createdAt` - `timestamptz_comparison_exp`
`id` - `uuid_comparison_exp`
`order` - `numeric_comparison_exp`
`otherReasonBody` - `String_comparison_exp`
`reason` - `String_comparison_exp`
`rebuttal` - `String_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "CancelFlowSession": CancelFlowSession_bool_exp,
  "_and": [CancelFlowReason_bool_exp],
  "_not": CancelFlowReason_bool_exp,
  "_or": [CancelFlowReason_bool_exp],
  "cancelFlowId": uuid_comparison_exp,
  "cancelFlowSessionId": uuid_comparison_exp,
  "createdAt": timestamptz_comparison_exp,
  "id": uuid_comparison_exp,
  "order": numeric_comparison_exp,
  "otherReasonBody": String_comparison_exp,
  "reason": String_comparison_exp,
  "rebuttal": String_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

CancelFlowReason_order_by

Description

Ordering options when selecting data from "CancelFlowReason".

Fields

Input Field	Description
`CancelFlowSession` - `CancelFlowSession_order_by`

Example

{"CancelFlowSession": CancelFlowSession_order_by}

Types

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
}

Types

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
}

Types

CancelFlowSession_bool_exp

Description

Boolean expression to filter rows from the table "CancelFlowSession". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`CancelFlowReason` - `CancelFlowReason_bool_exp`
`Discounts` - `Discount_bool_exp`
`Subscription` - `Subscription_bool_exp`
`_and` - `[CancelFlowSession_bool_exp!]`
`_not` - `CancelFlowSession_bool_exp`
`_or` - `[CancelFlowSession_bool_exp!]`
`cancelFlowId` - `uuid_comparison_exp`
`createdAt` - `timestamptz_comparison_exp`
`id` - `uuid_comparison_exp`
`status` - `String_comparison_exp`
`subscriptionId` - `uuid_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "CancelFlowReason": CancelFlowReason_bool_exp,
  "Discounts": Discount_bool_exp,
  "Subscription": Subscription_bool_exp,
  "_and": [CancelFlowSession_bool_exp],
  "_not": CancelFlowSession_bool_exp,
  "_or": [CancelFlowSession_bool_exp],
  "cancelFlowId": uuid_comparison_exp,
  "createdAt": timestamptz_comparison_exp,
  "id": uuid_comparison_exp,
  "status": String_comparison_exp,
  "subscriptionId": uuid_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

CancelFlowSession_max_order_by

Description

order by max() on columns of table "CancelFlowSession"

Example

{}

Types

CancelFlowSession_min_order_by

Description

order by min() on columns of table "CancelFlowSession"

Example

{}

Types

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
}

Types

CancelSubscriptionInput

Fields

Input Field	Description
`cancelSessionId` - `String`
`permanentlyCancel` - `Boolean`
`shouldSendNotif` - `Boolean`
`subscriptionId` - `uuid!`

Example

{
  "cancelSessionId": "abc123",
  "permanentlyCancel": false,
  "shouldSendNotif": true,
  "subscriptionId": uuid
}

Types

CancelSubscriptionOutput

Fields

Field Name	Description
`ok` - `Boolean!`

Example

{"ok": false}

Types

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
}

Types

Discount_aggregate_order_by

Description

order by aggregate values of table "Discount"

Fields

Input Field	Description
`avg` - `Discount_avg_order_by`
`max` - `Discount_max_order_by`
`min` - `Discount_min_order_by`
`stddev` - `Discount_stddev_order_by`
`stddev_pop` - `Discount_stddev_pop_order_by`
`stddev_samp` - `Discount_stddev_samp_order_by`
`sum` - `Discount_sum_order_by`
`var_pop` - `Discount_var_pop_order_by`
`var_samp` - `Discount_var_samp_order_by`
`variance` - `Discount_variance_order_by`

Example

{
  "avg": Discount_avg_order_by,
  "max": Discount_max_order_by,
  "min": Discount_min_order_by,
  "stddev": Discount_stddev_order_by,
  "stddev_pop": Discount_stddev_pop_order_by,
  "stddev_samp": Discount_stddev_samp_order_by,
  "sum": Discount_sum_order_by,
  "var_pop": Discount_var_pop_order_by,
  "var_samp": Discount_var_samp_order_by,
  "variance": Discount_variance_order_by
}

Types

Discount_avg_order_by

Description

order by avg() on columns of table "Discount"

Example

{}

Types

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
}

Types

Discount_max_order_by

Description

order by max() on columns of table "Discount"

Example

{}

Types

Discount_min_order_by

Description

order by min() on columns of table "Discount"

Example

{}

Types

Discount_stddev_order_by

Description

order by stddev() on columns of table "Discount"

Example

{}

Types

Discount_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "Discount"

Example

{}

Types

Discount_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "Discount"

Example

{}

Types

Discount_sum_order_by

Description

order by sum() on columns of table "Discount"

Example

{}

Types

Discount_var_pop_order_by

Description

order by var_pop() on columns of table "Discount"

Example

{}

Types

Discount_var_samp_order_by

Description

order by var_samp() on columns of table "Discount"

Example

{}

Types

Discount_variance_order_by

Description

order by variance() on columns of table "Discount"

Example

{}

Types

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
}

Types

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
}

Types

DynamicBox_SelectableProductVariant_aggregate_order_by

Description

order by aggregate values of table "DynamicBox_SelectableProductVariant"

Fields

Input Field	Description
`max` - `DynamicBox_SelectableProductVariant_max_order_by`
`min` - `DynamicBox_SelectableProductVariant_min_order_by`

Example

{
  "max": DynamicBox_SelectableProductVariant_max_order_by,
  "min": DynamicBox_SelectableProductVariant_min_order_by
}

Types

DynamicBox_SelectableProductVariant_bool_exp

Description

Boolean expression to filter rows from the table "DynamicBox_SelectableProductVariant". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`DynamicBox` - `DynamicBox_bool_exp`
`SelectableProductVariant` - `ProductVariant_bool_exp`
`_and` - `[DynamicBox_SelectableProductVariant_bool_exp!]`
`_not` - `DynamicBox_SelectableProductVariant_bool_exp`
`_or` - `[DynamicBox_SelectableProductVariant_bool_exp!]`
`deletedAt` - `timestamp_comparison_exp`
`dynamicBoxId` - `uuid_comparison_exp`
`productVariantId` - `uuid_comparison_exp`

Example

{
  "DynamicBox": DynamicBox_bool_exp,
  "SelectableProductVariant": ProductVariant_bool_exp,
  "_and": [DynamicBox_SelectableProductVariant_bool_exp],
  "_not": DynamicBox_SelectableProductVariant_bool_exp,
  "_or": [DynamicBox_SelectableProductVariant_bool_exp],
  "deletedAt": timestamp_comparison_exp,
  "dynamicBoxId": uuid_comparison_exp,
  "productVariantId": uuid_comparison_exp
}

Types

DynamicBox_SelectableProductVariant_max_order_by

Description

order by max() on columns of table "DynamicBox_SelectableProductVariant"

Example

{}

Types

DynamicBox_SelectableProductVariant_min_order_by

Description

order by min() on columns of table "DynamicBox_SelectableProductVariant"

Example

{}

Types

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
}

Types

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
}

Types

Float

Example

123.45

Types

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
}

Types

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
}

Types

GroupPlan_aggregate_order_by

Description

order by aggregate values of table "GroupPlan"

Fields

Input Field	Description
`avg` - `GroupPlan_avg_order_by`
`max` - `GroupPlan_max_order_by`
`min` - `GroupPlan_min_order_by`
`stddev` - `GroupPlan_stddev_order_by`
`stddev_pop` - `GroupPlan_stddev_pop_order_by`
`stddev_samp` - `GroupPlan_stddev_samp_order_by`
`sum` - `GroupPlan_sum_order_by`
`var_pop` - `GroupPlan_var_pop_order_by`
`var_samp` - `GroupPlan_var_samp_order_by`
`variance` - `GroupPlan_variance_order_by`

Example

{
  "avg": GroupPlan_avg_order_by,
  "max": GroupPlan_max_order_by,
  "min": GroupPlan_min_order_by,
  "stddev": GroupPlan_stddev_order_by,
  "stddev_pop": GroupPlan_stddev_pop_order_by,
  "stddev_samp": GroupPlan_stddev_samp_order_by,
  "sum": GroupPlan_sum_order_by,
  "var_pop": GroupPlan_var_pop_order_by,
  "var_samp": GroupPlan_var_samp_order_by,
  "variance": GroupPlan_variance_order_by
}

Types

GroupPlan_avg_order_by

Description

order by avg() on columns of table "GroupPlan"

Example

{}

Types

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
}

Types

GroupPlan_max_order_by

Description

order by max() on columns of table "GroupPlan"

Example

{}

Types

GroupPlan_min_order_by

Description

order by min() on columns of table "GroupPlan"

Example

{}

Types

GroupPlan_stddev_order_by

Description

order by stddev() on columns of table "GroupPlan"

Example

{}

Types

GroupPlan_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "GroupPlan"

Example

{}

Types

GroupPlan_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "GroupPlan"

Example

{}

Types

GroupPlan_sum_order_by

Description

order by sum() on columns of table "GroupPlan"

Example

{}

Types

GroupPlan_var_pop_order_by

Description

order by var_pop() on columns of table "GroupPlan"

Example

{}

Types

GroupPlan_var_samp_order_by

Description

order by var_samp() on columns of table "GroupPlan"

Example

{}

Types

GroupPlan_variance_order_by

Description

order by variance() on columns of table "GroupPlan"

Example

{}

Types

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
}

Types

GroupSet_bool_exp

Description

Boolean expression to filter rows from the table "GroupSet". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`GroupPlans` - `GroupPlan_bool_exp`
`Groups` - `Group_bool_exp`
`Site` - `Site_bool_exp`
`_and` - `[GroupSet_bool_exp!]`
`_not` - `GroupSet_bool_exp`
`_or` - `[GroupSet_bool_exp!]`
`createdAt` - `timestamptz_comparison_exp`
`id` - `uuid_comparison_exp`
`name` - `String_comparison_exp`
`siteId` - `uuid_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "GroupPlans": GroupPlan_bool_exp,
  "Groups": Group_bool_exp,
  "Site": Site_bool_exp,
  "_and": [GroupSet_bool_exp],
  "_not": GroupSet_bool_exp,
  "_or": [GroupSet_bool_exp],
  "createdAt": timestamptz_comparison_exp,
  "id": uuid_comparison_exp,
  "name": String_comparison_exp,
  "siteId": uuid_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

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
}

Types

Group_aggregate_order_by

Description

order by aggregate values of table "Group"

Fields

Input Field	Description
`avg` - `Group_avg_order_by`
`max` - `Group_max_order_by`
`min` - `Group_min_order_by`
`stddev` - `Group_stddev_order_by`
`stddev_pop` - `Group_stddev_pop_order_by`
`stddev_samp` - `Group_stddev_samp_order_by`
`sum` - `Group_sum_order_by`
`var_pop` - `Group_var_pop_order_by`
`var_samp` - `Group_var_samp_order_by`
`variance` - `Group_variance_order_by`

Example

{
  "avg": Group_avg_order_by,
  "max": Group_max_order_by,
  "min": Group_min_order_by,
  "stddev": Group_stddev_order_by,
  "stddev_pop": Group_stddev_pop_order_by,
  "stddev_samp": Group_stddev_samp_order_by,
  "sum": Group_sum_order_by,
  "var_pop": Group_var_pop_order_by,
  "var_samp": Group_var_samp_order_by,
  "variance": Group_variance_order_by
}

Types

Group_avg_order_by

Description

order by avg() on columns of table "Group"

Example

{}

Types

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
}

Types

Group_max_order_by

Description

order by max() on columns of table "Group"

Example

{}

Types

Group_min_order_by

Description

order by min() on columns of table "Group"

Example

{}

Types

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
}

Types

Group_stddev_order_by

Description

order by stddev() on columns of table "Group"

Example

{}

Types

Group_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "Group"

Example

{}

Types

Group_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "Group"

Example

{}

Types

Group_sum_order_by

Description

order by sum() on columns of table "Group"

Example

{}

Types

Group_var_pop_order_by

Description

order by var_pop() on columns of table "Group"

Example

{}

Types

Group_var_samp_order_by

Description

order by var_samp() on columns of table "Group"

Example

{}

Types

Group_variance_order_by

Description

order by variance() on columns of table "Group"

Example

{}

Types

Holiday

Description

columns and relationships of "Holiday"

Fields

Field Name	Description
`Site` - `Site!`	An object relationship
`id` - `uuid!`

Example

{"Site": Site, "id": uuid}

Types

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
}

Types

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
}

Types

Holiday_max_order_by

Description

order by max() on columns of table "Holiday"

Example

{}

Types

Holiday_min_order_by

Description

order by min() on columns of table "Holiday"

Example

{}

Types

Int

Example

Types

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

Types

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
}

Types

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
}

Types

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
}

Types

NotificationLog_bool_exp

Description

Boolean expression to filter rows from the table "NotificationLog". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`Notification` - `Notification_bool_exp`
`Subscription` - `Subscription_bool_exp`
`_and` - `[NotificationLog_bool_exp!]`
`_not` - `NotificationLog_bool_exp`
`_or` - `[NotificationLog_bool_exp!]`
`body` - `String_comparison_exp`
`createdAt` - `timestamptz_comparison_exp`
`email` - `String_comparison_exp`
`id` - `uuid_comparison_exp`
`notificationId` - `uuid_comparison_exp`
`phoneNumber` - `String_comparison_exp`
`subject` - `String_comparison_exp`
`subscriptionId` - `uuid_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "Notification": Notification_bool_exp,
  "Subscription": Subscription_bool_exp,
  "_and": [NotificationLog_bool_exp],
  "_not": NotificationLog_bool_exp,
  "_or": [NotificationLog_bool_exp],
  "body": String_comparison_exp,
  "createdAt": timestamptz_comparison_exp,
  "email": String_comparison_exp,
  "id": uuid_comparison_exp,
  "notificationId": uuid_comparison_exp,
  "phoneNumber": String_comparison_exp,
  "subject": String_comparison_exp,
  "subscriptionId": uuid_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

NotificationLog_max_order_by

Description

order by max() on columns of table "NotificationLog"

Example

{}

Types

NotificationLog_min_order_by

Description

order by min() on columns of table "NotificationLog"

Example

{}

Types

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
}

Types

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
}

Types

Notification_max_order_by

Description

order by max() on columns of table "Notification"

Example

{}

Types

Notification_min_order_by

Description

order by min() on columns of table "Notification"

Example

{}

Types

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
}

Types

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
}

Types

OrderLineItem_aggregate_order_by

Description

order by aggregate values of table "OrderLineItem"

Fields

Input Field	Description
`avg` - `OrderLineItem_avg_order_by`
`max` - `OrderLineItem_max_order_by`
`min` - `OrderLineItem_min_order_by`
`stddev` - `OrderLineItem_stddev_order_by`
`stddev_pop` - `OrderLineItem_stddev_pop_order_by`
`stddev_samp` - `OrderLineItem_stddev_samp_order_by`
`sum` - `OrderLineItem_sum_order_by`
`var_pop` - `OrderLineItem_var_pop_order_by`
`var_samp` - `OrderLineItem_var_samp_order_by`
`variance` - `OrderLineItem_variance_order_by`

Example

{
  "avg": OrderLineItem_avg_order_by,
  "max": OrderLineItem_max_order_by,
  "min": OrderLineItem_min_order_by,
  "stddev": OrderLineItem_stddev_order_by,
  "stddev_pop": OrderLineItem_stddev_pop_order_by,
  "stddev_samp": OrderLineItem_stddev_samp_order_by,
  "sum": OrderLineItem_sum_order_by,
  "var_pop": OrderLineItem_var_pop_order_by,
  "var_samp": OrderLineItem_var_samp_order_by,
  "variance": OrderLineItem_variance_order_by
}

Types

OrderLineItem_avg_order_by

Description

order by avg() on columns of table "OrderLineItem"

Example

{}

Types

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
}

Types

OrderLineItem_max_order_by

Description

order by max() on columns of table "OrderLineItem"

Example

{}

Types

OrderLineItem_min_order_by

Description

order by min() on columns of table "OrderLineItem"

Example

{}

Types

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
}

Types

OrderLineItem_stddev_order_by

Description

order by stddev() on columns of table "OrderLineItem"

Example

{}

Types

OrderLineItem_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "OrderLineItem"

Example

{}

Types

OrderLineItem_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "OrderLineItem"

Example

{}

Types

OrderLineItem_sum_order_by

Description

order by sum() on columns of table "OrderLineItem"

Example

{}

Types

OrderLineItem_var_pop_order_by

Description

order by var_pop() on columns of table "OrderLineItem"

Example

{}

Types

OrderLineItem_var_samp_order_by

Description

order by var_samp() on columns of table "OrderLineItem"

Example

{}

Types

OrderLineItem_variance_order_by

Description

order by variance() on columns of table "OrderLineItem"

Example

{}

Types

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
}

Types

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
}

Types

Order_max_order_by

Description

order by max() on columns of table "Order"

Example

{}

Types

Order_min_order_by

Description

order by min() on columns of table "Order"

Example

{}

Types

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
}

Types

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
}

Types

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
}

Types

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
}

Types

PaymentMethod_max_order_by

Description

order by max() on columns of table "PaymentMethod"

Example

{}

Types

PaymentMethod_min_order_by

Description

order by min() on columns of table "PaymentMethod"

Example

{}

Types

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
}

Types

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
}

Types

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
}

Types

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
}

Types

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
}

Types

PricingPolicy_aggregate_order_by

Description

order by aggregate values of table "PricingPolicy"

Fields

Input Field	Description
`avg` - `PricingPolicy_avg_order_by`
`max` - `PricingPolicy_max_order_by`
`min` - `PricingPolicy_min_order_by`
`stddev` - `PricingPolicy_stddev_order_by`
`stddev_pop` - `PricingPolicy_stddev_pop_order_by`
`stddev_samp` - `PricingPolicy_stddev_samp_order_by`
`sum` - `PricingPolicy_sum_order_by`
`var_pop` - `PricingPolicy_var_pop_order_by`
`var_samp` - `PricingPolicy_var_samp_order_by`
`variance` - `PricingPolicy_variance_order_by`

Example

{
  "avg": PricingPolicy_avg_order_by,
  "max": PricingPolicy_max_order_by,
  "min": PricingPolicy_min_order_by,
  "stddev": PricingPolicy_stddev_order_by,
  "stddev_pop": PricingPolicy_stddev_pop_order_by,
  "stddev_samp": PricingPolicy_stddev_samp_order_by,
  "sum": PricingPolicy_sum_order_by,
  "var_pop": PricingPolicy_var_pop_order_by,
  "var_samp": PricingPolicy_var_samp_order_by,
  "variance": PricingPolicy_variance_order_by
}

Types

PricingPolicy_avg_order_by

Description

order by avg() on columns of table "PricingPolicy"

Example

{}

Types

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
}

Types

PricingPolicy_max_order_by

Description

order by max() on columns of table "PricingPolicy"

Example

{}

Types

PricingPolicy_min_order_by

Description

order by min() on columns of table "PricingPolicy"

Example

{}

Types

PricingPolicy_order_by

Description

Ordering options when selecting data from "PricingPolicy".

Fields

Input Field	Description
`SellingPlan` - `SellingPlan_order_by`

Example

{"SellingPlan": SellingPlan_order_by}

Types

PricingPolicy_stddev_order_by

Description

order by stddev() on columns of table "PricingPolicy"

Example

{}

Types

PricingPolicy_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "PricingPolicy"

Example

{}

Types

PricingPolicy_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "PricingPolicy"

Example

{}

Types

PricingPolicy_sum_order_by

Description

order by sum() on columns of table "PricingPolicy"

Example

{}

Types

PricingPolicy_var_pop_order_by

Description

order by var_pop() on columns of table "PricingPolicy"

Example

{}

Types

PricingPolicy_var_samp_order_by

Description

order by var_samp() on columns of table "PricingPolicy"

Example

{}

Types

PricingPolicy_variance_order_by

Description

order by variance() on columns of table "PricingPolicy"

Example

{}

Types

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
}

Types

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
}

Types

ProductVariant_aggregate_order_by

Description

order by aggregate values of table "ProductVariant"

Fields

Input Field	Description
`avg` - `ProductVariant_avg_order_by`
`max` - `ProductVariant_max_order_by`
`min` - `ProductVariant_min_order_by`
`stddev` - `ProductVariant_stddev_order_by`
`stddev_pop` - `ProductVariant_stddev_pop_order_by`
`stddev_samp` - `ProductVariant_stddev_samp_order_by`
`sum` - `ProductVariant_sum_order_by`
`var_pop` - `ProductVariant_var_pop_order_by`
`var_samp` - `ProductVariant_var_samp_order_by`
`variance` - `ProductVariant_variance_order_by`

Example

{
  "avg": ProductVariant_avg_order_by,
  "max": ProductVariant_max_order_by,
  "min": ProductVariant_min_order_by,
  "stddev": ProductVariant_stddev_order_by,
  "stddev_pop": ProductVariant_stddev_pop_order_by,
  "stddev_samp": ProductVariant_stddev_samp_order_by,
  "sum": ProductVariant_sum_order_by,
  "var_pop": ProductVariant_var_pop_order_by,
  "var_samp": ProductVariant_var_samp_order_by,
  "variance": ProductVariant_variance_order_by
}

Types

ProductVariant_avg_order_by

Description

order by avg() on columns of table "ProductVariant"

Example

{}

Types

ProductVariant_bool_exp

Description

Boolean expression to filter rows from the table "ProductVariant". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`DynamicBox_SelectableProductVariants` - `DynamicBox_SelectableProductVariant_bool_exp`
`OrderLineItems` - `OrderLineItem_bool_exp`
`Product` - `Product_bool_exp`
`SellingPlanGroupResources` - `SellingPlanGroupResource_bool_exp`
`SubscriptionLines` - `SubscriptionLine_bool_exp`
`_and` - `[ProductVariant_bool_exp!]`
`_not` - `ProductVariant_bool_exp`
`_or` - `[ProductVariant_bool_exp!]`
`createdAt` - `timestamptz_comparison_exp`
`deletedAt` - `timestamptz_comparison_exp`
`id` - `uuid_comparison_exp`
`image` - `String_comparison_exp`
`platformId` - `String_comparison_exp`
`price` - `numeric_comparison_exp`
`productId` - `uuid_comparison_exp`
`sku` - `String_comparison_exp`
`title` - `String_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "DynamicBox_SelectableProductVariants": DynamicBox_SelectableProductVariant_bool_exp,
  "OrderLineItems": OrderLineItem_bool_exp,
  "Product": Product_bool_exp,
  "SellingPlanGroupResources": SellingPlanGroupResource_bool_exp,
  "SubscriptionLines": SubscriptionLine_bool_exp,
  "_and": [ProductVariant_bool_exp],
  "_not": ProductVariant_bool_exp,
  "_or": [ProductVariant_bool_exp],
  "createdAt": timestamptz_comparison_exp,
  "deletedAt": timestamptz_comparison_exp,
  "id": uuid_comparison_exp,
  "image": String_comparison_exp,
  "platformId": String_comparison_exp,
  "price": numeric_comparison_exp,
  "productId": uuid_comparison_exp,
  "sku": String_comparison_exp,
  "title": String_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

ProductVariant_max_order_by

Description

order by max() on columns of table "ProductVariant"

Example

{}

Types

ProductVariant_min_order_by

Description

order by min() on columns of table "ProductVariant"

Example

{}

Types

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
}

Types

ProductVariant_stddev_order_by

Description

order by stddev() on columns of table "ProductVariant"

Example

{}

Types

ProductVariant_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "ProductVariant"

Example

{}

Types

ProductVariant_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "ProductVariant"

Example

{}

Types

ProductVariant_sum_order_by

Description

order by sum() on columns of table "ProductVariant"

Example

{}

Types

ProductVariant_var_pop_order_by

Description

order by var_pop() on columns of table "ProductVariant"

Example

{}

Types

ProductVariant_var_samp_order_by

Description

order by var_samp() on columns of table "ProductVariant"

Example

{}

Types

ProductVariant_variance_order_by

Description

order by variance() on columns of table "ProductVariant"

Example

{}

Types

Product_aggregate_order_by

Description

order by aggregate values of table "Product"

Fields

Input Field	Description
`avg` - `Product_avg_order_by`
`max` - `Product_max_order_by`
`min` - `Product_min_order_by`
`stddev` - `Product_stddev_order_by`
`stddev_pop` - `Product_stddev_pop_order_by`
`stddev_samp` - `Product_stddev_samp_order_by`
`sum` - `Product_sum_order_by`
`var_pop` - `Product_var_pop_order_by`
`var_samp` - `Product_var_samp_order_by`
`variance` - `Product_variance_order_by`

Example

{
  "avg": Product_avg_order_by,
  "max": Product_max_order_by,
  "min": Product_min_order_by,
  "stddev": Product_stddev_order_by,
  "stddev_pop": Product_stddev_pop_order_by,
  "stddev_samp": Product_stddev_samp_order_by,
  "sum": Product_sum_order_by,
  "var_pop": Product_var_pop_order_by,
  "var_samp": Product_var_samp_order_by,
  "variance": Product_variance_order_by
}

Types

Product_avg_order_by

Description

order by avg() on columns of table "Product"

Example

{}

Types

Product_bool_exp

Description

Boolean expression to filter rows from the table "Product". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`DynamicBox` - `DynamicBox_bool_exp`
`ProductVariants` - `ProductVariant_bool_exp`
`Site` - `Site_bool_exp`
`_and` - `[Product_bool_exp!]`
`_not` - `Product_bool_exp`
`_or` - `[Product_bool_exp!]`
`createdAt` - `timestamptz_comparison_exp`
`deletedAt` - `timestamptz_comparison_exp`
`id` - `uuid_comparison_exp`
`imageSrc` - `String_comparison_exp`
`metafields` - `jsonb_comparison_exp`
`platformId` - `String_comparison_exp`
`siteId` - `uuid_comparison_exp`
`slug` - `String_comparison_exp`
`smsOrder` - `Int_comparison_exp`
`status` - `String_comparison_exp`
`title` - `String_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "DynamicBox": DynamicBox_bool_exp,
  "ProductVariants": ProductVariant_bool_exp,
  "Site": Site_bool_exp,
  "_and": [Product_bool_exp],
  "_not": Product_bool_exp,
  "_or": [Product_bool_exp],
  "createdAt": timestamptz_comparison_exp,
  "deletedAt": timestamptz_comparison_exp,
  "id": uuid_comparison_exp,
  "imageSrc": String_comparison_exp,
  "metafields": jsonb_comparison_exp,
  "platformId": String_comparison_exp,
  "siteId": uuid_comparison_exp,
  "slug": String_comparison_exp,
  "smsOrder": Int_comparison_exp,
  "status": String_comparison_exp,
  "title": String_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

Product_max_order_by

Description

order by max() on columns of table "Product"

Example

{}

Types

Product_min_order_by

Description

order by min() on columns of table "Product"

Example

{}

Types

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
}

Types

Product_stddev_order_by

Description

order by stddev() on columns of table "Product"

Example

{}

Types

Product_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "Product"

Example

{}

Types

Product_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "Product"

Example

{}

Types

Product_sum_order_by

Description

order by sum() on columns of table "Product"

Example

{}

Types

Product_var_pop_order_by

Description

order by var_pop() on columns of table "Product"

Example

{}

Types

Product_var_samp_order_by

Description

order by var_samp() on columns of table "Product"

Example

{}

Types

Product_variance_order_by

Description

order by variance() on columns of table "Product"

Example

{}

Types

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
}

Types

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
}

Types

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
}

Types

SellingPlanGroupResource_aggregate_order_by

Description

order by aggregate values of table "SellingPlanGroupResource"

Fields

Input Field	Description
`max` - `SellingPlanGroupResource_max_order_by`
`min` - `SellingPlanGroupResource_min_order_by`

Example

{
  "max": SellingPlanGroupResource_max_order_by,
  "min": SellingPlanGroupResource_min_order_by
}

Types

SellingPlanGroupResource_bool_exp

Description

Boolean expression to filter rows from the table "SellingPlanGroupResource". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`ProductVariant` - `ProductVariant_bool_exp`
`SellingPlanGroup` - `SellingPlanGroup_bool_exp`
`_and` - `[SellingPlanGroupResource_bool_exp!]`
`_not` - `SellingPlanGroupResource_bool_exp`
`_or` - `[SellingPlanGroupResource_bool_exp!]`
`createdAt` - `timestamptz_comparison_exp`
`id` - `uuid_comparison_exp`
`productVariantId` - `uuid_comparison_exp`
`sellingPlanGroupId` - `uuid_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "ProductVariant": ProductVariant_bool_exp,
  "SellingPlanGroup": SellingPlanGroup_bool_exp,
  "_and": [SellingPlanGroupResource_bool_exp],
  "_not": SellingPlanGroupResource_bool_exp,
  "_or": [SellingPlanGroupResource_bool_exp],
  "createdAt": timestamptz_comparison_exp,
  "id": uuid_comparison_exp,
  "productVariantId": uuid_comparison_exp,
  "sellingPlanGroupId": uuid_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

SellingPlanGroupResource_max_order_by

Description

order by max() on columns of table "SellingPlanGroupResource"

Example

{}

Types

SellingPlanGroupResource_min_order_by

Description

order by min() on columns of table "SellingPlanGroupResource"

Example

{}

Types

SellingPlanGroup_bool_exp

Description

Boolean expression to filter rows from the table "SellingPlanGroup". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`SellingPlanGroupResources` - `SellingPlanGroupResource_bool_exp`
`SellingPlans` - `SellingPlan_bool_exp`
`_and` - `[SellingPlanGroup_bool_exp!]`
`_not` - `SellingPlanGroup_bool_exp`
`_or` - `[SellingPlanGroup_bool_exp!]`
`byGroup` - `Boolean_comparison_exp`
`createdAt` - `timestamptz_comparison_exp`
`customName` - `String_comparison_exp`
`id` - `uuid_comparison_exp`
`name` - `String_comparison_exp`
`platformId` - `String_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "SellingPlanGroupResources": SellingPlanGroupResource_bool_exp,
  "SellingPlans": SellingPlan_bool_exp,
  "_and": [SellingPlanGroup_bool_exp],
  "_not": SellingPlanGroup_bool_exp,
  "_or": [SellingPlanGroup_bool_exp],
  "byGroup": Boolean_comparison_exp,
  "createdAt": timestamptz_comparison_exp,
  "customName": String_comparison_exp,
  "id": uuid_comparison_exp,
  "name": String_comparison_exp,
  "platformId": String_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

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
}

Types

SellingPlan_aggregate_order_by

Description

order by aggregate values of table "SellingPlan"

Fields

Input Field	Description
`avg` - `SellingPlan_avg_order_by`
`max` - `SellingPlan_max_order_by`
`min` - `SellingPlan_min_order_by`
`stddev` - `SellingPlan_stddev_order_by`
`stddev_pop` - `SellingPlan_stddev_pop_order_by`
`stddev_samp` - `SellingPlan_stddev_samp_order_by`
`sum` - `SellingPlan_sum_order_by`
`var_pop` - `SellingPlan_var_pop_order_by`
`var_samp` - `SellingPlan_var_samp_order_by`
`variance` - `SellingPlan_variance_order_by`

Example

{
  "avg": SellingPlan_avg_order_by,
  "max": SellingPlan_max_order_by,
  "min": SellingPlan_min_order_by,
  "stddev": SellingPlan_stddev_order_by,
  "stddev_pop": SellingPlan_stddev_pop_order_by,
  "stddev_samp": SellingPlan_stddev_samp_order_by,
  "sum": SellingPlan_sum_order_by,
  "var_pop": SellingPlan_var_pop_order_by,
  "var_samp": SellingPlan_var_samp_order_by,
  "variance": SellingPlan_variance_order_by
}

Types

SellingPlan_avg_order_by

Description

order by avg() on columns of table "SellingPlan"

Example

{}

Types

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
}

Types

SellingPlan_max_order_by

Description

order by max() on columns of table "SellingPlan"

Example

{}

Types

SellingPlan_min_order_by

Description

order by min() on columns of table "SellingPlan"

Example

{}

Types

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
}

Types

SellingPlan_stddev_order_by

Description

order by stddev() on columns of table "SellingPlan"

Example

{}

Types

SellingPlan_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "SellingPlan"

Example

{}

Types

SellingPlan_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "SellingPlan"

Example

{}

Types

SellingPlan_sum_order_by

Description

order by sum() on columns of table "SellingPlan"

Example

{}

Types

SellingPlan_var_pop_order_by

Description

order by var_pop() on columns of table "SellingPlan"

Example

{}

Types

SellingPlan_var_samp_order_by

Description

order by var_samp() on columns of table "SellingPlan"

Example

{}

Types

SellingPlan_variance_order_by

Description

order by variance() on columns of table "SellingPlan"

Example

{}

Types

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
}

Types

ShippingLine_aggregate_order_by

Description

order by aggregate values of table "ShippingLine"

Fields

Input Field	Description
`avg` - `ShippingLine_avg_order_by`
`max` - `ShippingLine_max_order_by`
`min` - `ShippingLine_min_order_by`
`stddev` - `ShippingLine_stddev_order_by`
`stddev_pop` - `ShippingLine_stddev_pop_order_by`
`stddev_samp` - `ShippingLine_stddev_samp_order_by`
`sum` - `ShippingLine_sum_order_by`
`var_pop` - `ShippingLine_var_pop_order_by`
`var_samp` - `ShippingLine_var_samp_order_by`
`variance` - `ShippingLine_variance_order_by`

Example

{
  "avg": ShippingLine_avg_order_by,
  "max": ShippingLine_max_order_by,
  "min": ShippingLine_min_order_by,
  "stddev": ShippingLine_stddev_order_by,
  "stddev_pop": ShippingLine_stddev_pop_order_by,
  "stddev_samp": ShippingLine_stddev_samp_order_by,
  "sum": ShippingLine_sum_order_by,
  "var_pop": ShippingLine_var_pop_order_by,
  "var_samp": ShippingLine_var_samp_order_by,
  "variance": ShippingLine_variance_order_by
}

Types

ShippingLine_avg_order_by

Description

order by avg() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_bool_exp

Description

Boolean expression to filter rows from the table "ShippingLine". All fields are combined with a logical 'AND'.

Fields

Input Field	Description
`Discounts` - `Discount_bool_exp`
`Order` - `Order_bool_exp`
`TaxLines` - `TaxLine_bool_exp`
`_and` - `[ShippingLine_bool_exp!]`
`_not` - `ShippingLine_bool_exp`
`_or` - `[ShippingLine_bool_exp!]`
`createdAt` - `timestamptz_comparison_exp`
`id` - `uuid_comparison_exp`
`orderId` - `uuid_comparison_exp`
`platformId` - `String_comparison_exp`
`priceWithoutDiscount` - `numeric_comparison_exp`
`title` - `String_comparison_exp`
`updatedAt` - `timestamptz_comparison_exp`

Example

{
  "Discounts": Discount_bool_exp,
  "Order": Order_bool_exp,
  "TaxLines": TaxLine_bool_exp,
  "_and": [ShippingLine_bool_exp],
  "_not": ShippingLine_bool_exp,
  "_or": [ShippingLine_bool_exp],
  "createdAt": timestamptz_comparison_exp,
  "id": uuid_comparison_exp,
  "orderId": uuid_comparison_exp,
  "platformId": String_comparison_exp,
  "priceWithoutDiscount": numeric_comparison_exp,
  "title": String_comparison_exp,
  "updatedAt": timestamptz_comparison_exp
}

Types

ShippingLine_max_order_by

Description

order by max() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_min_order_by

Description

order by min() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_stddev_order_by

Description

order by stddev() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_sum_order_by

Description

order by sum() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_var_pop_order_by

Description

order by var_pop() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_var_samp_order_by

Description

order by var_samp() on columns of table "ShippingLine"

Example

{}

Types

ShippingLine_variance_order_by

Description

order by variance() on columns of table "ShippingLine"

Example

{}

Types

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
}

Types

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
}

Types

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
}

Types

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
}

Types

SkuSwap_aggregate_order_by

Description

order by aggregate values of table "SkuSwap"

Fields

Input Field	Description
`avg` - `SkuSwap_avg_order_by`
`max` - `SkuSwap_max_order_by`
`min` - `SkuSwap_min_order_by`
`stddev` - `SkuSwap_stddev_order_by`
`stddev_pop` - `SkuSwap_stddev_pop_order_by`
`stddev_samp` - `SkuSwap_stddev_samp_order_by`
`sum` - `SkuSwap_sum_order_by`
`var_pop` - `SkuSwap_var_pop_order_by`
`var_samp` - `SkuSwap_var_samp_order_by`
`variance` - `SkuSwap_variance_order_by`

Example

{
  "avg": SkuSwap_avg_order_by,
  "max": SkuSwap_max_order_by,
  "min": SkuSwap_min_order_by,
  "stddev": SkuSwap_stddev_order_by,
  "stddev_pop": SkuSwap_stddev_pop_order_by,
  "stddev_samp": SkuSwap_stddev_samp_order_by,
  "sum": SkuSwap_sum_order_by,
  "var_pop": SkuSwap_var_pop_order_by,
  "var_samp": SkuSwap_var_samp_order_by,
  "variance": SkuSwap_variance_order_by
}

Types

SkuSwap_avg_order_by

Description

order by avg() on columns of table "SkuSwap"

Example

{}

Types

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
}

Types

SkuSwap_max_order_by

Description

order by max() on columns of table "SkuSwap"

Example

{}

Types

SkuSwap_min_order_by

Description

order by min() on columns of table "SkuSwap"

Example

{}

Types

SkuSwap_stddev_order_by

Description

order by stddev() on columns of table "SkuSwap"

Example

{}

Types

SkuSwap_stddev_pop_order_by

Description

order by stddev_pop() on columns of table "SkuSwap"

Example

{}

Types

SkuSwap_stddev_samp_order_by

Description

order by stddev_samp() on columns of table "SkuSwap"

Example

{}

Types

SkuSwap_sum_order_by

Description

order by sum() on columns of table "SkuSwap"

Example

{}

Types

SkuSwap_var_pop_order_by

Description

order by var_pop() on columns of table "SkuSwap"

Example

{}

Types