{
"workflowId": "my-first-workflow-with-custom-parameters",
"sqlQuery": "SELECT campaign, SUM(IMPRESSIONS) AS Impressions FROM sponsored_ads_traffic WHERE ARRAY_CONTAINS(CUSTOM_PARAMETER('sa_campaigns'), 'ALL') OR ARRAY_CONTAINS(CUSTOM_PARAMETER('sa_campaigns'), campaign) GROUP BY 1",
"inputParameters": [
{
"name": "sa_campaigns",
"dataType": {
"elementDataType": "STRING",
"type": "ARRAY"
},
"column_type": "DIMENSION",
"description": "Enter description for parameter",
"defaultValue": [
"ALL"
]
}
]
}
curl --location -g --request POST 'https://advertising-api.amazon.com/amc/reporting/{{instanceId}}/workflows' \
--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-with-custom-parameters",
"sqlQuery": "SELECT campaign, SUM(IMPRESSIONS) AS Impressions FROM sponsored_ads_traffic WHERE ARRAY_CONTAINS(CUSTOM_PARAMETER('\''sa_campaigns'\''), '\''ALL'\'') OR ARRAY_CONTAINS(CUSTOM_PARAMETER('\''sa_campaigns'\''), campaign) GROUP BY 1",
"inputParameters": [
{
"name": "sa_campaigns",
"dataType": {
"elementDataType": "STRING",
"type": "ARRAY"
},
"column_type": "DIMENSION",
"description": "Enter description for parameter",
"defaultValue": [
"ALL"
]
}
]
}'
{}