Have your say in Community Polls: What was/is your greatest motivation to start your own business?
Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

INTERNAL_SERVER_ERROR when retrieving orders for some date combinations.

INTERNAL_SERVER_ERROR when retrieving orders for some date combinations.

Funnel
Shopify Partner
28 0 15

The below query is successful for the dates 2022-05-10 to 2022-05-12, and for 2022-05-13 to 2022-05-15. But when running the same query for 2022-05-11 to 2022-05-15 it fails with INTERNAL_SERVER_ERROR. This must be a bug?

We are running version "2021-07" of the api. Here is the query:

mutation {
  bulkOperationRunQuery(
    query:"""
    {
      orders(
        sortKey: CREATED_AT,
        query: "processed_at:>='2022-05-11' processed_at:<='2022-05-15'"
      ) {
        edges {
          cursor
          node {
            %s
            tags
            name
            id
            test
            physicalLocation {
                name
            }
            createdAt
            updatedAt
            processedAt
            cancelledAt
            customAttributes{
                key
                value
            }
            cancelReason
            currencyCode
            discountCode
            fullyPaid
            publication {
              name
            }
            agreements {
                edges {
                    node {
                        id
                        happenedAt
                        reason
                        sales {
                            edges {
                                node {
                                    id
                                    lineType
                                    actionType
                                    quantity
                                    totalAmount {
                                        shopMoney {
                                            amount
                                        }
                                    }
                                    totalTaxAmount {
                                        shopMoney {
                                            amount
                                        }
                                    }
                                    totalDiscountAmountBeforeTaxes {
                                        shopMoney {
                                            amount
                                        }
                                    }
                                    totalDiscountAmountAfterTaxes {
                                        shopMoney {
                                            amount
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
            customerJourney {
              customerOrderIndex
              daysToConversion
              firstVisit {
                referrerUrl
                source
                utmParameters {
                  term
                  medium
                  source
                  campaign
                  content
                }
              }
              lastVisit {
                referrerUrl
                source
                utmParameters {
                  term
                  medium
                  source
                  campaign
                  content
                }
              }
            }
            shippingAddress {
              country
              province
            }
            billingAddress {
                country
                province
            }
            totalWeight
            totalShippingPriceSet {
              shopMoney {
                amount
              }
            }
            subtotalPriceSet {
                shopMoney {
                    amount
                }
            }
            totalReceivedSet {
              shopMoney {
                amount
              }
            }
            totalPriceSet {
              shopMoney {
                amount
              }
            }
            netPaymentSet {
                shopMoney {
                amount
                }
            }
            totalTaxSet {
              shopMoney {
                amount
              }
            }
            cartDiscountAmountSet {
              shopMoney {
                amount
              }
            }
          }
        }
      }
    }
    """
  ) {
    bulkOperation {
      id
      status
    }
    userErrors {
      field
      message
    }
  }
}
Replies 0 (0)