Getting 500 intermittent error from count orders API for few of our customers

[Avalara]

Hi Shopify Support team,

We have built the Extractor for Shopify application which helps the seller to prepare their data for filling the returns. We are using GET/ Count Orders API in our use case.

Problem Statement 

For two of our customers when we are calling get orders count endpoint we are getting 500 intermittent error on daily basis. This causes our extractor to fail to pull any transactions for those users.

Question

Could you please help us, How we can resolve and support this API failing error?

Curl Request

curl --location --request GET 'https://baltic-born.myshopify.com/admin/api/2021-10/orders/count.json?status=any&limit=100&updated_at_min=2021-11-29&order=updated_at asc&financial_status=paid,refunded,partially_paid,partially_refunded' \
--header 'Content-Type: application/json' \
--header 'X-Shopify-Access-Token: ****************'

Please let us know if you need more details.

[ShopifyDevSup]

Hi Avalara,

Thanks for your post. For issues specific to certain stores please reach out [to Partner Support using the email option] and select the 'App Development & API' topic to enable a more direct investigation. 

Including the date, time, and timezone, as well as x-request-id for a specific example from each store from within the past 7 days in the report would be greatly appreciated.