API Events Shopify on Google Sheets

New Member
2 0 0
Is there a way to query the Events API to return the shipping_label_created_success without having to go through every order?

I try to use this but I have to go through every order:


I try and play with the event https://store.myshopify.com/admin/events.json?verb=shipping_label_created_success I get nothing returned

I am trying to get all the shipping costs that will help me complete my accounting table. At the moment, I have recovered all the data on my Google sheet, but I still have to add the shipping cost. For now, I use this function:

= ImportJSONBasicAuth (" https://store.myshopify.com/admin/api/2020-07/orders/ "& A67 &" /events.json?verb=shipping_label_created_success "," api_key "," api_password "," "," ")\