Google AdwWords linked service

[API_DCH]

Hi API team,

Looking to bring in Google Ads data for a few Google Ads accounts, so I would like to take advantage of the parameter option to pass the credential values to the Google Ads linked service during the pipeline execution via a lookup activity from a SQL table. This way, I can simply the data retrieval process a lot.

Created a Google Ads linked service with parameter option and when try to test the connection using the same CID it works fantastically,  when I try to use another CID other than I used to create it errors out with following message.

Is it possible to use parameter option in the Google Ads linked service or it is not currently supported. If supported, please provide me a sample or the documentation I can use to achieve this. I greatly appreciate your help.

Failed to decrypt sub-resource 'None' payload on cloud with error: Failed to decrypt sub-resource payload { "name": "GoogleAdWords_ParameterTest", "properties": { "type": "GoogleAdWords", "annotations": [], "parameters": { "CID": { "type": "String" }, "clntId": { "type": "String" }, "clntsecret": { "type": "String" }, "clntrefresh": { "type": "String" } }, "typeProperties": { "clientCustomerID": "********************", "developerToken": "********************", "authenticationType": "********************", "clientId": "********************", "clientSecret": "********************", "refreshToken": "********************", "clientrefresh": "********************", "encryptedCredential": "********************" } } } and error is: Failed to validate the signature because the content is tampered, the expect context is '{"ClientCustomerID":"230-8xx-xx25","authenticationType":"UserAuthentication","dataFactoryName":"Lithia-Data-Platform-Dev-df"}' and the runtime context is '{"ClientCustomerID":"777-0xx-xx37","authenticationType":"UserAuthentication","dataFactoryName":"Lithia-Data-Platform-Dev-df"}'.., status code: BadRequest. . Activity ID: 72314a39-8f5c-4c91-96c0-38c16d7698e4

Thanks

Sam

[Google Ads API Forum Advisor Prod]

Hello,

Thank you for reaching out. Could you please confirm if you are using AdWords API or Google Ads API to pull the details from your Google Ads account as we only provide support to the concerns related to Google Ads API Beta/ AdWords API on this forum. If yes, could you please share the documentation or the screenshot of the services that you are trying to use for the data retrieval process for me to look into this further and assist you better?

P.S. Please use Reply privately to author option while sharing the sensitive details.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001USwwRJ:ref