Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
Is it possible to use the "SQL SELECT * FROM..." statement in Qlik Sense, when working with a Qlik REST Connector?
I get the error as seen in attached.
Kind Regards,
Lindy Brits.
Yes it is possible.
On what Rest API you trying to connect exactly?
This is a REST API that I have built on NodeJS, connecting to a PostgreSQL database. It works fine if I define the specific fields, for example ' SQL SELECT "name", "surname", ... FROM JSON (wrap on) "root" ', but it doesn't work when I insert "*".
Ok in that case I understand your question wrong.
I think you mean does it work with a from clause.
I think the structur of a rest call from json format makes a call with * difficult because
you can have more than one from clause nested inside each other.
Apologies for being unclear. Do you have a solution for this?
I think you can't use * in that case.
I don't know exactly the use case why you need that but perhabs you can try to set substrings of your call in variables?
Do you mean perhaps --> create a SQL statement from variables, concatenated with strings?
Hi Lindy,
As per my review, You can't use * inside rest statement. This article may help to know usage of statements inside REST connector.
After generating rest statement ,you can try to modify the loaded data using * or any load inline.