Source: Amazon Ads - Add support for Sponsored Display Video Stream

[ryjabe]

Tell us about the problem you're trying to solve

Our users would like Airbyte to support the Sponsored Display Video Ads stream for the Amazon Ads Connector.

Describe the solution you’d like

Describe the alternative you’ve considered or used

Additional context

Link to a PR for more info about the stream: https://advertising.amazon.com/resources/whats-new/sponsored-display-video-creative

Docs: https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi?ref_=a20m_us_unbxd22_wn_sdvdcrtv_102622#/Creatives

Are you willing to submit a PR?

Remove this with your answer :-)

[YowanR]

Note: We expect this new stream to be incremental

[btkcodedev]

Please assign it to me

[justinbchau]

Thanks for taking this @btkcodedev Just assigned it to you!

[btkcodedev]

🔥🔥🔥Thanks

[btkcodedev]

Investigation update:
API documentation: https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi?ref_=a20m_us_unbxd22_wn_sdvdcrtv_102622#/Creatives/listCreatives

API URL: https://advertising-api-eu.amazon.com/sd/creatives

Required to be passed in the header:
Amazon-Advertising-API-ClientId: The identifier of a client associated with a "Login with Amazon" account.
Amazon-Advertising-API-Scope: The identifier of a profile associated with the advertiser account. Use GET method on Profiles resource to list profiles associated with the access token passed in the HTTP Authorization header.

Example Response:
{
"name": "string",
"budgetType": "daily",
"budget": "3.00",
"startDate": "20190101",
"endDate": null,
"costType": "cpc",
"state": "enabled",
"portfolioId": null,
"campaignId": 0,
"tactic": "T00020",
"deliveryProfile": "as_soon_as_possible"
}

[btkcodedev]

Will startadding stream soon

[btkcodedev]

Update: stream will be delayed as there are problems while retrieving the response data due to authorization grant failure

[btkcodedev]

@igrankova @justinbchau Could I get any credentials for the Amazon Ads connector
It would be really helpful for solving the issue