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)
{
"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>"}'Arguments
| Name | Type | Description |
|---|---|---|
storerequired | string | the store ref `<store>-<CC>` (name-country, e.g. 'myStore-US') — one of get_user_context's store_refs, verbatim. |
country_coderequired | string | the Ads profile's 2-letter country code (e.g. 'US'). |
workflow_execution_idrequired | string | data.workflow_execution_id from ads_create_workflow_execution. |
max_rows | integer | rows 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).