Showing results for 
Search instead for 
Did you mean: 
Jonas1 Regular Visitor
Regular Visitor

Custom connector to API using Python/JavaScript?




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)
  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:image.png
  1. Get Token (still finishlogin)


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?

ananeto Frequent Visitor
Frequent Visitor

Re: Custom connector to API using Python/JavaScript?

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 maybe they have the connector you need? And then you can link to it from Python, no problem.

Jonas1 Regular Visitor
Regular Visitor

Re: Custom connector to API using Python/JavaScript?

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. 

Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 195 members 2,525 guests
Please welcome our newest community members: