{
"workflowId": "my-first-workflow",
"sqlQuery": "SELECT campaign_id,SUM(impressions) AS impressions FROM dsp_impressions GROUP by campaign_id"
}
curl --location -g --request PUT 'https://advertising-api.amazon.com/amc/reporting/{{instanceId}}/workflows/my-first-workflow' \
--header 'Amazon-Advertising-API-ClientId: {{client_id}}' \
--header 'Amazon-Advertising-API-MarketplaceId: {{marketplace_id}}' \
--header 'Amazon-Advertising-API-AdvertiserId: {{advertiser_id}}' \
--header 'Authorization: Bearer {{access_token}}' \
--header 'Content-Type: application/json' \
--data-raw '{
"workflowId": "my-first-workflow",
"sqlQuery": "SELECT campaign_id,SUM(impressions) AS impressions FROM dsp_impressions GROUP by campaign_id"
}'
{}