Filter out fields from orders API query

Retired Boards Appdev Customers Discounts And Orders
1

Having got all my shop order data after running:

https://xxxxxxx3f9840198bfb38fc98bb469a7:xxxxxxxcfd467eeb65c7b573dcd2d230@myshop.myshopify.com/admin/api/2019-07/orders.json?status=any in

There’s a lot of fields that I don’t need, really I only need a few of them, what do I add to the URL to cut down on what results I am given?

Also bonus question: what do I use once I am happy with the data it gives me to export it to say an Excel file, a python script?

Thanks

2

You should add an extra parameter fields and provide a comma separated list of fields you want back. Please note that you can use only first level fields, i.e. you can’t tell you only want address1 and address2 fields of the billing_address field. An example would be:

https://xxxxxxx3f9840198bfb38fc98bb469a7:xxxxxxxcfd467eeb65c7b573dcd2d230@myshop.myshopify.com/admin/api/2019-07/orders.json?status=any&fields=id,billing_address,customer
2 Likes
3

Thank you!