SOLVED

Connect Azure Data Factory to Google Ads Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1668109%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20Azure%20Data%20Factory%20to%20Google%20Ads%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1668109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F794071%22%20target%3D%22_blank%22%3E%40Ivan_Arribas%3C%2FA%3E%26nbsp%3Bthe%20json%20file%20is%20in%20a%20public%20blobstoarge%20and%20I%20can%20see%20the%20file%20if%20I%20write%20the%20url%20in%20a%20web%20browser.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1668092%22%20slang%3D%22en-US%22%3EConnect%20Azure%20Data%20Factory%20to%20Google%20Ads%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1668092%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20conecting%20Azure%20Data%20Factory%20to%20our%20Google%20Ads%20account%20in%20order%20to%20export%20some%20data.%20We%20want%20to%20use%20Service%20account%20but%20when%20I%20setup%20the%20ADF%20LinkedService%20(Google%20Ads%20type)%20and%20enter%20the%20Developer%20token%2C%20Auth%20Type%3A%20Service%20Authetication%2C%20Email%2C%20Key%20File%20path%20and%20trusted%20cert%20path%20in%20give%20me%20an%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConnection%20Failed%3A%3C%2FP%3E%3CP%3EERROR%20%5B28000%5D%20%5BMicrosoft%5D%5BDriverOAuthSupport%5D%20(8706)%20Unable%20to%20find%20or%20open%20file%20from%3A%26nbsp%3B%20url.json%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20help%20us%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1668092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Data%20Integration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi all,

 

I am conecting Azure Data Factory to our Google Ads account in order to export some data. We want to use Service account but when I setup the ADF LinkedService (Google Ads type) and enter the Developer token, Auth Type: Service Authetication, Email, Key File path and trusted cert path in give me an error:

 

Connection Failed:

ERROR [28000] [Microsoft][DriverOAuthSupport] (8706) Unable to find or open file from:  url.json

 

Could someone help us?

 

Regards!

1 Reply
best response confirmed by Ivan_Arribas (New Contributor)
Solution

@Ivan_Arribas the json file is in a public blobstoarge and I can see the file if I write the url in a web browser.