Bulk GraphQL Export Errors

satish_repeat
New Member
2 0 0

Hello,

We've been attempting to export orders for a store using the bulk GraphQL API. After running for ~20 hours we received an "INTERNAL_SERVER_ERROR" after polling for the status of the operation. We've tried similar queries of varying size (by filtering "created_at") with mixed results. We occasionally receive a "COMPLETED" result but not consistently. We'd like a reliable way to export order data. 

 

mutation {
              bulkOperationRunQuery(
              query: """
                {
                  orders(query: "created_at:>='2021-09-01' AND created_at:<'2021-09-14'") {
                    edges {
                      node {
                        id
                        totalPrice
                        subtotalPrice
                        tags
                        cancelledAt
                        createdAt
                        updatedAt
                        closedAt
                        confirmed
                        currencyCode
                        name
                        channel {
                          app {
                            id
                          }
                        }
                        lineItems {
                          edges {
                            node {
                              id
                              variant {
                                id
                              }
                              quantity
                            }
                          }
                        }
                        processedAt
                        customer {
                          id
                          firstName
                          lastName
                          phone
                        }
                        email
                      }
                    }
                  }
                }
              """)
            {
              bulkOperation {
                id
                status
              }
            
              userErrors {
                field
                message
              }
            }
          }

 

 

0 Likes
satish_repeat
New Member
2 0 0

Also, here's a GID for reference: gid://shopify/BulkOperation/421838356585

0 Likes