I'm trying to use AWS AppFlow to ingest Google Ads supported objects to AWS S3. Though i have successfully created connections using GoogleAds Connector I'm unable to ingest the data to S3.
Steps followed from AWS console:
Step 1: Name of the flow was provided.
Step 2: Configure Source and Destination. Recently created Google Ads Connection was chosen for source and AWS S3 bucket for destination. Flow Trigger is set to ‘Run on Demand’
(Step2 Figure )
Step 3: Map Data Fields: This page throws the error. (Step3 Figure)
I have followed all the steps as it is from AWS Doc
Error Message:
An error occurred while retrieving fields Error while communicating to connector: The request failed because the service Source Customconnector returned the following error: Details: GoogleAds metadata response can not be null or empty, ErrorCode: ServerError.
I also tried changing the mapping method and chose to upload a mapping csv file but even it failed with the error "Couldn't parse rows from the file."
Alternatively when trying to retrieve the campaign object from the python script it returns the desired output.
Any leads around this will be appreciated.
(Also this is my first post on stack overflow :P)
Finally after one month of back and forth with AWS Support team AWS finally added support for Google Ads v11 API version. So after creating the flow with newly modified connection I was able to run the flow and ingest campaign data successfully!
