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.

We're moving the community! Starting July 7, the current community will be read-only for approx. 2 weeks. You can browse content, but posting will be temporarily unavailable. Learn more

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)