Custom connector to API using Python/JavaScript?

[Jonas1]

Hi, 

I am currentely trying to connect to an API using OAuth2, so I figured I try out Power Query SDK and custom data connectors. However, is this possible no matter what programming language the API requires?

I am trying to obtain the API token which contains three steps: 

. Obtaining the API token contains 3 steps:

1. Get Challenge (startlogin probably)
   • POST https://fmsauth.scania.com/auth/S2S4DA/ClientId2Challenge
2. Create Challenge Response (finishlogin?) à and this is where I find it confusing
• The source code for this step is given in multiple languages, but none of them are json or xml, is it still possible to do everything in Power Query SDK?
• Here is the code which should create a challe response from Secret key and challenge:

1. Get Token (still finishlogin)
   • POST https://fmsauth.scania.com/auth/S2S4DA/Response2Token

The response in both step 1 and 3 is in application/json format, while step 2 do not give a response in itself. So I am not quite sure what to do with step 2, is one of these programming languages mandatory or just suggested?

[wes2015]

Hi @Jonas1 , did you manage to get the connector to work?

I'm also working with the scania API and im stuck, can you give any hints on how to proceed?

Thanks

Wes

[ananeto]

Not sure if this helps, but have you considered getting a ready made connector instead of building one from scratch? 

When building a connector from scratch, besides all the hard work getting it to work in the first place, there can a significant maintenance effort every time the API changes... 

Why don't you check an out-of-the-box solution like  https://www.connecting-software.com/connect-bridge/ maybe they have the connector you need? And then you can link to it from Python, no problem.

[Jonas1]

Hi @ananeto ,

I resolved this by setting it up myself in Python. They have designated libraries to connect to APIs and there are lots of forums/blogs that can solve the problems that arrives, so highly recommend it! I have already connected to several APIs and I thinks this is a valuable skill to have.