Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

With Connection statement - What are all the parameters possible?

Hello,

I am trying to figure out what are all the possibilities in the WITH CONNECTION statement when using the REST connector.

I've been through all of this and I am currently using the "Url" parameter.

When I am trying to use Url and QUERY parameters in the same statement I can't make it work.

Would someone have the right syntax and all the parameters possible.

It looks like we can also override the body parameter when using a method POST, any help would be welcome on that matter too.

Another question: is it possible to override the method too (so having GET and POST for the same connection but overridden when useful to use POST instead of the GET method).

To summarize: what is the exact WITH CONNECTION statement syntax?

Exemple :

WITH CONNECTION (Url "YourURL"; Method : POST; Query Header: "Content-Type: application/json; charset=utf8", "OtherHeaderName: OtherHeaderValue"; Query Parameters : "Field1: Value1","Field2: Value2"; Body : "{"ids":[ 1, 2, 5, 10 ]}")

Many thanks in advance!

12 Replies
mmaragos_witside
Partner - Contributor
Partner - Contributor

Hello Everybody!

QUERY "fromName" "NoReply" is translated to "fromName" EQUAL "NoReply" 

If we want to filter according to NOT EQUAL ?

 

 

 

 

marksouzacosta

Hi,

I have a complete video that covers all the topics related to REST Connections (pagination, with connection, loops, etc) here https://youtu.be/lFwar30BNkQ?si=g-MIwnivViqRDuXK

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

mmaragos_witside
Partner - Contributor
Partner - Contributor

Thanks