Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.
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.
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.
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.