Forum Discussion
Querying json
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
6 Replies
Anonymous , 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
Hi amitchandak I would like to create a connection to this source above and import the data
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.
Hi Anonymous ,
Import is a way to connect json files,so what do you actually wanna do?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Hi Anonymous ,
Try to connect "Web"-"advanced",then fill in as below:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
