M Query RESTful webservice as data source

Stefan2902 — Fri, 13 Apr 2018 08:29:46 GMT

Hi,

I am rather new to PBI but hope I can express my problem in a meaningful manner. I want to pull data which comes from a RESTful webservice. Subsequent you can find the details I am using in a RESTful client which returns a proper JSON:

GET / https://myjira.atlassian.net/rest/api/2/search?jql=project="XXX"
Header / Authorization:xxxxxxxxxxxxxxxxxxxx

Now I have tried to implement this in PBI query as follows:

let
address = "https://myjira.atlassian.net/rest/api/2/search",
header = [ #"Authorization" = "xxxxxxxxxxx"],
queryOptions = [#"?jql" = "project=XXX"],
Source = Json.Document(Web.Contents(address , [Headers = header, Query = queryOptions])),
issues = Source[issues]
in
issues

This returns a table but the "issues" are empty?! I do not get the 23 expected issues within the JIRA project.

Im assumption is that it has something to do with the "jqp" part and the multiple "=" symbols

Eventually the address need to be:

https://myjira.atlassian.net/rest/api/2/search?jql=project="XXX"

Do you have any idea how to fix or better troubleshoot?

BR,

Stefan

Re: M Query RESTful webservice as data source

Stefan2902 — Fri, 13 Apr 2018 09:42:10 GMT

I now made some progress. I have compared the Header from the REST client to the Header in PowerBI and added the Cookie Header. Afterwards it worked fine:

let
Source = Json.Document(Web.Contents("https://myjira.atlassian.net/rest/api/2/search?jql=project='BESAD'", [Headers=[Authorization="xxx",Cookie="somecookiestring"]])),
issues = Source[issues],
issues1 = issues{0},
fields = issues1[fields]
in
fields

I have just copied the cookie information from the REST client; but what do I need to use in PowerBI as Cookie information?

BR,

Stefan

topic Re: M Query RESTful webservice as data source in Developer

M Query RESTful webservice as data source

Re: M Query RESTful webservice as data source