Forum Discussion

VinceG0214's avatar
VinceG0214
Frequent Visitor
7 years ago

Custom Data Connector Oauth2

I am trying to build a custom data connector to get our IT ticket information from our ticketing system. Our ticketing system does offer an API that uses Oauth2 and a new refresh token every 60 minut...
Need Help
Nolock's avatar
Nolock
Resident Rockstar
7 years ago

Hi VinceG0214,

as v-juanli-msft said, the code is long, we can't test it and therefore it is complicated to help. But I think I see a problem because I've had a similar one.

The function GTAConnector.Contents expects an URL but you get a JSON file where the first element is url - you can see it on the screenshot in PBI Service.

It is described somewhere here: https://docs.microsoft.com/en-us/power-query/samples/trippin/readme but unfortunately I can't find the exact spot right now :(

Try followings:

[DataSource.Kind="GTAConnector", Publish="GTAConnector.Publish"]
shared GTAConnector.Contents = (json as text) =>
    let
        source = Web.Contents(json[url])
    in
        source;