ads_get_workflow_execution_download_urls

The finished result of an AMC query as rows: the tool downloads Amazon's result file and returns its rows (no download links).

readAmazon Adsads.amc-reporting

Only for a SUCCEEDED query. Amazon Ads API · getWorkflowExecutionDownloadUrls · GET /amc/reporting/{instanceId}/workflowExecutions/{workflowExecutionId}/downloadUrls Amazon Ads API · getWorkflowExecution · GET /amc/reporting/{instanceId}/workflowExecutions/{workflowExecutionId} Docs: https://advertising.amazon.com/API/docs/en-us/amc-reporting#tag/Workflow-executions/operation/getWorkflowExecutionDownloadUrls Docs: https://advertising.amazon.com/API/docs/en-us/amc-reporting#tag/Workflow-executions/operation/getWorkflowExecution

Call it

In an AI client (MCP)

tools/call
{
  "name": "ads_get_workflow_execution_download_urls",
  "arguments": {
    "store": "myStore-US",
    "country_code": "<country_code>",
    "workflow_execution_id": "<workflow_execution_id>"
  }
}

From code (Tool API)

curl -X POST https://api.sellersheetai.com/api/v1/tools/ads_get_workflow_execution_download_urls \
  -H "Authorization: Bearer $SELLERSHEET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"store":"myStore-US","country_code":"<country_code>","workflow_execution_id":"<workflow_execution_id>"}'
Early access — the Tool API is open on request, contact us.

Arguments

NameTypeDescription
storerequiredstringthe store ref `<store>-<CC>` (name-country, e.g. 'myStore-US') — one of get_user_context's store_refs, verbatim.
country_coderequiredstringthe Ads profile's 2-letter country code (e.g. 'US').
workflow_execution_idrequiredstringdata.workflow_execution_id from ads_create_workflow_execution.
max_rowsintegerrows to return, 1–10000 (default 1000); every row is still counted in data.row_count.Default: 1000

Result

Every tool answers {notification, data, human_action}; data carries:

  • the orchestrated result described below.
  • data.columns — the result's column names.
  • data.rows[] — one dict per row; every value is a string, as in Amazon's CSV.
  • data.row_count — the result's rows; data.returned_rows: the rows in data.rows.
  • data.row_count_complete — false when the result is over 20 MB — row_count then counts only the rows read; aggregate more and run it again.
  • data.truncated — true when data.rows holds fewer rows than the result.
  • data.hidden_rows — rows, of the whole result, whose group columns are blank — AMC hides a group with too few shoppers (an empty value looks the same); their metrics still add up; group more broadly to see them.

Gotchas

  • AMC `purchases` counts the advertised product only; `total_purchases` adds the brand's other products (what the Ads reports call purchases).

On this page

Actions

View as Markdown

Ask an assistant

Ask ChatGPTAsk Claude