Querying json

[Alex_0201]

Hi and thanks for all the support so far!

Another question, this time about querying from an application that generates data in json format. Is it possible at all? Or do you need to create a script in another application and then import data from a generated json file into PowerBI?

I've recieved this from the software supplier (edited):

# Authentication

curl --silent --cookie-jar cookies.txt --data-urlencode "username=ttr" --data-urlencode "password=osj" https://abc.com/login > /dev/null

# Get ST by ID

curl --cookie cookies.txt --header "Content-Type: application/json" --request GET https://abc.com/rest/json/1234 > results.json

# Log out

curl --cookie cookies.txt https://abc.com/logout

[v-kelly-msft]

Hi  @Alex_0201 ,

Try to connect "Web"-"advanced",then fill in as below:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Alex_0201 , You can connect directly to a source that return json.  or are looking for connectivity using json input ?

refer my video  :how to use json data

https://www.youtube.com/watch?v=MPYfEetvFH4

[Alex_0201]

@amitchandak this video is about importing from json file. I am looking for ways to create a connection to this source above and import the data.

[v-kelly-msft]

Hi  @Alex_0201 ,

Import is a way to connect json files,so what do you actually wanna do?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Alex_0201]

@v-kelly-msft  hi 🙂 I guess I am looking for a way to import this data using those three lines (presume it's API, but this is the only info they could provide me with)

[Alex_0201]

Hi @amitchandak I would like to create a connection to this source above and import the data