topic Connection to ERPNext via Rest connector in Connectivity & Data Prep

Connection to ERPNext via Rest connector

Anonymous — Fri, 02 Apr 2021 08:12:48 GMT

Hi,

I am new to QlikSense and I am trying to connect my QlikSense Cloud account to my ERPNext instance using the REST connector.

https://frappe.io/docs/user/en/guides/integration/rest_api.html

The problem is that I should first make a POST request to authenticate my user before accessing the resources with GET and I have been struggling with it.

Has anyone any idea on how to enter the parameters correctly to access any resource on ERPNext ?

Thanks in advance for your help!

Re: Connection to ERPNext via Rest connector

stevedark — Fri, 27 Oct 2017 15:47:44 GMT

Hi,

I'm not familiar with ERPNext, but to do both POST and GET requests you will need to create separate REST connections and call each of them separately.

Where you may well hit a problem with the REST connector in Qlik Sense Cloud is that generally you need to pass a token form the authentication phase to the retrieve phase. Typically this is done by amending the URL with variables.

Depending on what needs to be passed in, and how it is passed in, this amending of the second call may not be possible. In Enterprise (or Desktop) you can turn on Legacy mode, which gives more freedom around how URLs are built.

Hope you can get it working though.

Re: Connection to ERPNext via Rest connector

Anonymous — Sat, 28 Oct 2017 12:14:09 GMT

Thanks a lot for your answer Steve.

Unfortunately I haven't managed to make the connection work. Too bad there is no standard MySQL connector, it would have been way easier...

Have a nice week-end!

Re: Connection to ERPNext via Rest connector

CHAY-92 — Tue, 28 Feb 2023 14:25:36 GMT

Hi chdecultot,

Are you managing to connect ERPNEXT to Qliksense? If yes pls guide me .Thanks in Advance 🙏🙏