[source-amazon-ads] Standard streams missing profileId field

[matthewbelair]

Connector Name

source-amazon-ads

Connector Version

6.2.7

What step the error happened?

Other

Relevant information

Current behaviour

When extracting data from the standard streams, the ProfileId is not populated and synced to the destination. This makes it impossible to know which profile the records originates from when using the connector with multiple profiles. The affected streams are:

• portfolios
• sponsored_brands_campaigns
• sponsored_brands_ad_groups
• sponsored_brands_keywords
• sponsored_display_campaigns
• sponsored_display_ad_groups
• sponsored_display_budget_rules
• sponsored_display_creatives
• sponsored_display_product_ads
• sponsored_display_targetings
• sponsored_product_campaigns
• sponsored_product_ad_groups
• sponsored_product_ads
• sponsored_product_keywords
• sponsored_product_targetings

Expected behaviour

It would greatly improve the connector to have the Profile ID, which is available in all those streams as stream_slice['profileId'], to be exported to the destination along with the API response.

Relevant log output

Contribute

• Yes, I want to contribute

[natikgadzhi]

So roughly, apply an add field transform and add the profile_id to them? @artem1205 should we add this to the scope of Amazon Ads updates you're working on?