Integrating with Microsoft Access VBA

Retired Boards Appdev Graphql Basics And Troubleshooting

Topic summary

A developer is attempting to integrate Microsoft Access with Shopify using VBA to retrieve Orders and Products data. The current implementation successfully connects to Shopify’s REST API but only returns a maximum of 250 records.

Current Challenge:

  • VBA code retrieves data from Shopify but is limited to 250 most recent records
  • Uncertain how to implement GraphQL with VBA for larger datasets

Suggested Solution:
A respondent explains that the 250-record limit is due to pagination in Shopify’s REST API. Two approaches are recommended:

  1. Pagination approach: Follow Shopify’s REST API pagination documentation to fetch additional pages of data beyond the initial 250 records

  2. Alternative tool: Install the API Blazor app from the Shopify app store, which:

    • Provides an API nearly identical to Shopify’s REST API for reading data
    • Operates faster (uses cached data)
    • Has no rate limiting restrictions
    • Offers a 14-day free trial
    • May eliminate the need for maintaining a separate database

The discussion remains open regarding the specific VBA implementation details.

Summarized with AI on November 25. AI used: claude-sonnet-4-5-20250929.
2

Hi Simon,

The REST API call you are using will be returning data in pages of 250 entries each. This is common for many Shopify API calls. You can access the other pages by following their pagination documentation here.

If you are pulling lots of data from the Shopify API, repeated calls to fetch the data may by a slow process due to rate limiting etc. If you require super fast read access to your shop data, then might I suggest installing the API Blazor app in your Shopify store. It has a 14 day free trial.

This app provides an almost identical API to the Shopify REST API (for reading data), but it is much faster (as it operates from cached data) and does not impose rate limiting.

This may even do away with your need to store your data in your own database?

Hope that is of some help.

Regards,

Wayne