To get data from URL in KNIME

Hi,

I want to fetch the data from URL this URL contain file in JSON format and there is need to enter the credentials to download the data from URL , after entering the credentials , I have to fetch the data in KNIME and export or feed this data to POWER BI, so that my PBI report get refresh, I have to create a work- flow in KNIME for the above process.

Please help me out to resolve this issue.
Thanks in advance

Hi @niharikaraghav,

Welcome to the Forum! You can use the Get Request Node (https://kni.me/n/jrLgNd_aIVOrfPsF) to make a GET Request, JSON Path (https://kni.me/n/3IccdLfpFEAp9yoz) o parse the JSON, and Send to Power BI (https://kni.me/n/hC8igqkYYLY-LbBC) to Nodes to make this happen.

Regards,
Wali

2 Likes

Hi Wali,

I have used Get Request node, JSON, Power BI node.
Please see below screenshot:-
image

while we are configuring Get Request node we face this issue, please refer snap below:-

we are getting empty table.

Thank You in advance.

Is the url correct (spelling,…)?
bR

Yes, we are using correct URL and spelling is also correct.
We are first entering the url in chrome then put the credentials and then download the data and then send this to power bi.

So, we want to create KNIME workflow to do this.
Your help is appreciated.
Thanks in advance.

Maybe your request needs additional headers or authentication you need to specify in the get request node first?

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.