Hi Windsor.ai team,
We’re using the Windsor.ai API (via the MCP integration with Claude) to pull Shopify data for weekly marketing performance reports. However, we’re consistently hitting the response size limit when querying more than 1–2 days of data, even when using the minimum number of fields (e.g. date, order_gross_sales, order_net_sales, order_total_discounts, order_count).
From our testing, the issue is that the Shopify connector returns one row per order rather than pre-aggregated daily totals. At our order volumes, this means a 7-day query exceeds the size limit regardless of how few fields we request.
We’d like to request one of the following:
A daily / weekly / monthly rollup / aggregated view for our Shopify account, so that querying a 7–30 day date range via the API returns one row per day rather than one row per order.
Alternatively, guidance on whether there is a connector option, query parameter, or endpoint configuration that would allow us to retrieve pre-aggregated Shopify data.
Being able to pull a full week or month, or year of Shopify revenue data in a single API call is important for the automated reporting we’re building, so any solution that enables this would be very helpful.