Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

lindybrits
New Contributor III

SQL SELECT * FROM --> Qlik REST Connector

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.

7 Replies
Ralf_Heukäufer
Contributor III

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

Yes it is possible.

On what Rest API you trying to connect exactly?

lindybrits
New Contributor III

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

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
Contributor III

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

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
New Contributor III

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

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

Ralf_Heukäufer
Contributor III

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

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
New Contributor III

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

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

sandeep_roy
Contributor

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

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.

Community Browser