Forum Discussion

pjose's avatar
pjose
Helper I
5 years ago

Using web as a datasource to JSON data but instead asking to open or save as a JSON source file

Hi all,   I have a url which links to JSON data like below. But when I enter this address in the web data source in POwer BI to connect to the JSON data, I get the below screen instead askin...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi pjose 

Not sure if you are still needing help to query the JSON and use a 2nd query parameter?  Without knowing the API specifications it's hard to assist. Can you point me at any documentation?

It's a bit odd that adding a 2nd query param causes different behaviour, unless that 2nd param actually tells the API to send a file.

Can you share the query without any sensitive info like username and password?

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

  • pjose's avatar
    pjose
    Helper I
    5 years ago

    Hi PhilipTreacy 

     

    Thank you for your response. Unfortunately, the API cannot be accessed externally at the moment, but the API URL looks like this.

    https://insync/admin/AxusGroup/?action=FSM&surveyId=7

     

    Not sure if this would be of any use. But the second parameter don't specify to send a file.

     

    Thanks