topic SQL SELECT * FROM --> Qlik REST Connector in Integration, Extension & APIs

SQL SELECT * FROM --> Qlik REST Connector

lindybrits — Mon, 18 Dec 2017 13:17:39 GMT

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.

Re: SQL SELECT * FROM --> Qlik REST Connector

Ralf_Heukäufer — Mon, 18 Dec 2017 13:33:12 GMT

Yes it is possible.

On what Rest API you trying to connect exactly?

Re: SQL SELECT * FROM --> Qlik REST Connector

lindybrits — Mon, 18 Dec 2017 13:38:36 GMT

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

Re: SQL SELECT * FROM --> Qlik REST Connector

Ralf_Heukäufer — Mon, 18 Dec 2017 13:50:15 GMT

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.

Re: SQL SELECT * FROM --> Qlik REST Connector

lindybrits — Mon, 18 Dec 2017 13:56:21 GMT

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

Re: SQL SELECT * FROM --> Qlik REST Connector

Ralf_Heukäufer — Mon, 18 Dec 2017 14:12:23 GMT

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?

Re: SQL SELECT * FROM --> Qlik REST Connector

lindybrits — Mon, 18 Dec 2017 14:21:18 GMT

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

Re: SQL SELECT * FROM --> Qlik REST Connector

Anonymous — Mon, 18 Dec 2017 14:22:01 GMT

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/Select-statement-syntax…‌

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