SQL SELECT * FROM --> Qlik REST Connector

[lindybrits]

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.

[Ralf_Heukäufer]

Yes it is possible.

On what Rest API you trying to connect exactly?

[lindybrits]

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 "*".

[Ralf_Heukäufer]

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.

[lindybrits]

Apologies for being unclear. Do you have a solution for this?

[Ralf_Heukäufer]

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?

[lindybrits]

Do you mean perhaps --> create a SQL statement from variables, concatenated with strings?

[Anonymous]

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.

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/1.2/Load-REST-data/Sel...‌

After generating rest statement ,you can try to modify the loaded data using * or any load inline.