Get all order details from a single graphql query

Topic summary

Users are seeking a way to retrieve all fields from Shopify’s Order object in a single GraphQL query without explicitly listing each field name—similar to SQL’s SELECT * functionality.

Current Challenge:

  • GraphQL requires explicitly specifying field names in queries
  • No built-in wildcard or “select all” mechanism exists for retrieving all fields, including nested ones

Workaround Identified:

  • One user found that Shopify’s REST API /order endpoint successfully retrieves all fields (including nested objects) without explicit specification
  • However, this approach relies on the deprecated REST API rather than the recommended GraphQL API

Status: The discussion remains unresolved for GraphQL specifically, with participants expressing concern about needing to use deprecated APIs as the only viable solution.

Summarized with AI on October 25. AI used: claude-sonnet-4-5-20250929.

Hi, I have been going through shopify graphql and was looking for a way to get all the fields in the orders instead of explicitly mentioning the field names. Similar to what we do in any query with *, i.e. something similar to select * from Object. I’m new to graphql, and went through all the possible blogs but couldn’t find anything similar.
Can anyone help me with this, if anything of this sort exists in Graphql or if there’s a way to replicate the same?

1 Like

We have the same use case. Using GraphQL , need to retrieve all fields on Order object(including nested ones)

As of now i couldn’t find anything for graphQl, however using REST APIs did the work for us. the /order endpoint in shopify rest api does the work retrieving all the nested ones as well.

1 Like

Has anyone found a solution to this? Seems odd the solution is to use the deprecated API.