Airbyte Open Source and BingAds

[dimini]

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]

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]

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]

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.

[dimini]

Hmm the option was indeed set to no, but it didnt solve the exception

What kind of app do you use? Web or Mobile&Desktop? What Redirect URIs did you set?

And: were you able to set up BingAds source in Airbyte with that?

[alafanechere]

were you able to set up BingAds source in Airbyte with that?

Yes because this is the app we are using to run our acceptance tests and the latest builds are green.

What Redirect URIs did you set?

https://login.microsoftonline.com/common/oauth2/nativeclient

Web or Mobile&Desktop

Mobile and desktop applications

Below is the exhaustive list of permissions we set on this app:

I hope this will help!

[dimini]

Hey Augustin,

I forgot to check on this topic again.

One last question:

where do you see that permissions list?

Is it in Microsoft Azure under Token Configuration → Add optional claim / group claim?

Or under API permissions? There I would go to Add permission → API my organization uses → Bing and then there? But there I can only see Read.All rights for the sub-permissions?

Best regards

[marcosmarxm]

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.