REST API Return All Products With Custom Metafields

[ig_dane]

Hello,

I've been trying to figure out how to return all product data including a custom metafield value using the endpoint: admin/api/2023-04/products.json but have had no luck. Would anyone have an insight, or another possible way to do this? The amount of products 10000+ in the store would make looping though each product and making another call not a viable option.

Thank You

[abhiteshs]

Hi,

We don't support querying metafields with other product fields. The workaround is to use metafields.json API https://shopify.dev/docs/api/admin-rest/2023-01/resources/metafield#get-blogs-blog-id-metafields.

Let me know if it works. Thanks

[ig_dane]

Thanks for the reply.

Is there a way to make bulk calls for products? At the 40 requests per min. limit, sending 10,000 single product requests would take over 4h to retrieve the data.

Thank you.