How to extract orders that had a change in buyer address?

GraphQL API
1

Hi,
Is there a way (preferably API) that I can use to pull the order numbers during a given period that had undergone a buyer address update after the initial order was created?
Thank you!
Raj

2

Hey @Raj,

Thanks for reaching out!

It isn’t possible to query an address change that specifically. You can query orders within a set time and sort by the most recently updated. You can add the order_history to the query to see what was updated.

Maybe a query like this could help:

{
  orders(order_date_from: "_____", order_date_to: "_____") {
    request_id
    complexity
    data(sort: "+updated_at", first: 10) {
      edges {
        node {
          id
          legacy_id
          order_number
          order_history {
            information
          }
          shipping_address {
            first_name
            last_name
            company
            address1
            city
            state
            state_code
            zip
            country
            country_code
            email
            phone
          }
        }
      }
    }
  }
}

Please let me know if you have any questions or concerns!

Best,
RayanP

1 Like
3

Thank you @sh-agent , that’s something - I think this will help, even though it’ll consume a LOT more credits than it otherwise would have

1 Like
4

Just to be sure, is there also a dashboard way to extract SOs that had an address change?

5

Hey @Raj,

Thanks for hanging in there!
I don’t believe there is a way to extract that specific information via the webpage either.

Please let me know if there’s anything I can do to assist.

Best,
RayanP

6

Got it, thank you for confirming - cheers

1 Like