topic Custom connector to API using Python/JavaScript? in Developer

Custom connector to API using Python/JavaScript?

Jonas1 — Thu, 18 Jul 2019 08:43:18 GMT

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:

Get Challenge (startlogin probably)
- POST https://fmsauth.scania.com/auth/S2S4DA/ClientId2Challenge
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:

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?

Re: Custom connector to API using Python/JavaScript?

ananeto — Thu, 25 Jul 2019 10:03:31 GMT

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.

Re: Custom connector to API using Python/JavaScript?

Jonas1 — Sun, 04 Aug 2019 20:34:21 GMT

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.

Re: Custom connector to API using Python/JavaScript?

Anonymous — Mon, 25 Apr 2022 10:05:00 GMT

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