Airbyte Open Source and BingAds

dimini · June 21, 2022, 12:50pm

Hey Airbyte Team,

I just started to play around with Airbyte and deployed the open source version as you documented:
On AWS (EC2) | Airbyte Documentation

I have no a problem seeting up BingAds as a source.
I cannot get it to work allthough I followed these instructions.

I get following error when I click on Set up source:

The connection tests failed.
OAuthTokenRequestException(‘invalid_client’, “AADSTS700025: Client is public so neither ‘client_assertion’ nor ‘client_secret’ should be presented.\r\nTrace ID: 7548d8f2-7c02-456f-a00a-744add096300\r\nCorrelation ID: ce766f83-a3a4-4ece-8aca-67337ae17e62\r\nTimestamp: 2022-06-21 12:26:34Z”)

Did anyone have had this error and could solve this or knows what the problem is? I dont see any step in your documentation that would relate to this? I added the localhost to the Redirect Uri. What else could it be?

In the Cloud Version I was able to authentificate with the same developer token.

Is this your first time deploying Airbyte?: Yes
OS Version / Instance: Linux
Memory / Disk: 4gb 2Core
Deployment: Docker
Airbyte Version: What version are you using now?
Source name/version: BingAds
Step: Set up the source

alafanechere · June 21, 2022, 2:48pm

Hey Dimitriy,
I think this error comes from the settings of app you registered on Azure side. I think you should set this app as a public client.
I found this StackOverflow that might be helpful.
In any case this error is raised during the connection to Azure and there is a problem with your token. I suggest you reach Azure support with your Trace ID.

dimini · June 22, 2022, 6:26pm

Hey Augustin,

thanks. Where do I find this setting? How do I set it as a public client?

I couldnt find that option yet.

alafanechere · June 23, 2022, 12:55pm

I checked how our App is set up on our Azure console. You can list your existing application here.
The Allow public client flow is set to Yes.
Please make sure you have the same setting and let me know if it works.