topic Re: REST API Connector - Multi-table in Connectivity & Data Prep

REST API Connector - Multi-table

Anonymous — Thu, 09 Mar 2017 15:15:50 GMT

I've just started using the REST API connector - which is a great tool.

I am connecting directly to an instance of ServiceNow, and the specified URL is table dependant and wondered if there is a way of 'parameterising' the URL in the connection so that I don't have to create a new connection in Sense for each new table?

https://(instance).service-now.com/api/now/table/tablename

Re: REST API Connector - Multi-table

chancekbarkley — Thu, 09 Mar 2017 16:44:27 GMT

John,

Look into the "With Connection" keyword as documented in Qlik Help‌. This allows you to override the base URL.

You may be able to define a control table with the list of table URLs or table names and pass that value as a parameter within a loop. I've sometimes found that if dollar sign expansion with $() does not work, ${} with brackets will.

I tried this unsuccessfully with another REST API, but that was only because there was a randomly generated parameter per table that I could not statically define in my control table/loop, otherwise the method seemed to work as expected. Perhaps ServiceNow works differently and you won't have this issue.

HTH,

Chance

Re: REST API Connector - Multi-table

Anonymous — Thu, 09 Mar 2017 18:05:17 GMT

Thanks for the response Chance - I'd not heard of that capacity before and certainly looks to be what I need

** Update ** works perfectly, nice one

I did it passing in some limit parameters but I'm sure you could add that to variable if required or a peek if you had a list of tables to spit through a loop.

Re: REST API Connector - Multi-table

devvratparashar — Sun, 04 Feb 2018 18:06:15 GMT

Hello John,

I am also trying to connect service now with rest api connector but I am not able to fetch all the tables & I do not want to create separate connections for each tables , can you please let me know how you are doing this ?

It would be really helpful , if you share the sample code .

I appreciate your help. Thanks in advance .

Re: REST API Connector - Multi-table

Ilhui — Fri, 05 Jun 2020 16:25:11 GMT

Did you solve it?

I'm in the same situation and looking for a solution.

Re: REST API Connector - Multi-table

ilhuicahua — Mon, 27 Jul 2020 14:59:41 GMT

@chancekbarkley , how do I define a control table?

I'm in the same exact situation but I don't know what are you referring to a control table.

Could you or someone else elaborate a little more on the solution?

Re: REST API Connector - Multi-table

Ilhui — Mon, 27 Jul 2020 15:24:37 GMT

@Anonymous could you explain a little bit how did you do it?

I'm confused how to do what you posted.

Re: REST API Connector - Multi-table

marksouzacosta — Sat, 15 Jun 2024 22:12:13 GMT

As an addition to this topic, I'm excited to share my latest tutorial on integrating Asana with Qlik Cloud using REST APIs!

In this step-by-step guide, you'll learn:
- How to use Asana REST APIs with Postman
- Creating REST Data Connections in Qlik Cloud
- Extracting data from Asana and saving as Parquet files
- Enhancing connections with custom parameters and pagination

Check out the full video on YouTube:
Integrate Asana with Qlik Cloud Using REST APIs: A Step-by-Step Guide
https://youtu.be/lFwar30BNkQ?si=UZoM_x9L5amdJSnf

Regards,

Mark Costa