read

Run an arbitrary read-only Merchant Center reports query (Merchant Query Language) — the Merchant analog of GAQL. Tables

Run an arbitrary read-only Merchant Center reports query (Merchant Query Language) — the Merchant analog of GAQL. Tables: product_view, product_performance_view, price_competitiveness_product_view, best_sellers_product_cluster_view, competitive_visibility_competitor_view, etc. Example: "SELECT offer_id, clicks, impressions FROM product_performance_view WHERE date BETWEEN '2026-06-01' AND '2026-06-30' ORDER BY clicks DESC". Queries the Google Merchant API reports service, see https://developers.google.com/merchant/api/guides/reports/query-language

post/api/v1/tools/merchant_run_report

Request

  • Base URL: https://app.magistry.io
  • URL: https://app.magistry.io/api/v1/tools/merchant_run_report
  • Auth: one of:
    • HTTP bearer
    • OAuth 2 (authorization code, authorization URL https://app.magistry.io/api/oauth/authorize, token URL https://app.magistry.io/api/oauth/token, scopes: merchant:read)

Request body

querystring required

A Merchant Query Language SELECT query.

limitinteger

Max rows (default 500).

Response

Tool result

okboolean required
resultunknown required

Changes

No recorded changes to this operation across all 2 revisions of this API.