topic Re: Passing a parameter to REST connector URL in Connectivity & Data Prep

topic Re: Passing a parameter to REST connector URL in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60935#M360 <HTML><HEAD></HEAD><BODY><P>Maxwell,</P><P>I was mistaken - my example involved the web html pull vs. the RESTFUL part.</P><P><BR />That being said, I think this particular is covered very well by the brilliant Michael Tarallo <A href="https://community.qlik.com/qlik-users/77808">mto</A>‌</P><P></P><P>on the following page (using the STAR WAR API):</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/5130">Working with the Qlik REST Connector, Pagination and Multiple JSON Schemas</A></P><P></P><P>I hope this helps guide you to the right answer.</P><P><BR />Robert</P></BODY></HTML> Fri, 22 Jun 2018 04:21:47 GMT Anonymous 2018-06-22T04:21:47Z Passing a parameter to REST connector URL https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60932#M357 <HTML><HEAD></HEAD><BODY><P>Hi I'd like a way to dynamically change the URL connector string. This is an example:</P><P></P><P style="padding-left: 60px;">LIB CONNECT TO 'StarWarsREST';</P><P style="padding-left: 60px;"></P><P style="padding-left: 60px;"></P><P style="padding-left: 60px;">LET extension = "/people";</P><P style="padding-left: 60px;"></P><P style="padding-left: 60px;"></P><P style="padding-left: 60px;">RestConnectorMasterTable:</P><P style="padding-left: 60px;">SQL SELECT </P><P style="padding-left: 60px;">"__KEY_root",</P><P style="padding-left: 60px;">(SELECT </P><P style="padding-left: 60px;">"name",</P><P style="padding-left: 60px;">"created",</P><P style="padding-left: 60px;">"__FK_results",</P><P style="padding-left: 60px;">"__KEY_results"</P><P style="padding-left: 60px;">FROM "results" PK "__KEY_results" FK "__FK_results")</P><P style="padding-left: 60px;">FROM JSON (wrap on) "root"</P><P style="padding-left: 60px;">WITH CONNECTION (</P><P style="padding-left: 60px;">URL "$(extension)");</P><P style="padding-left: 60px;"></P><P style="padding-left: 60px;">[root]:</P><P style="padding-left: 60px;">LOAD [name] AS [name],</P><P style="padding-left: 60px;">[created] AS [created]</P><P style="padding-left: 60px;">RESIDENT RestConnectorMasterTable</P><P style="padding-left: 60px;">WHERE NOT IsNull([__FK_results]);</P><P style="padding-left: 60px;"></P><P style="padding-left: 60px;">DROP TABLE RestConnectorMasterTable;</P><P style="padding-left: 60px;"></P><P></P><P><SPAN>'StarWarsREST' has the URL </SPAN><A class="jive-link-external-small" href="http://swapi.co/api" rel="nofollow" target="_blank">http://swapi.co/api</A><SPAN> and I want to make a connection to </SPAN><A class="jive-link-external-small" href="http://swapi.co/api/people" rel="nofollow" target="_blank">http://swapi.co/api/people</A><SPAN>. When I run this script to load data, if finishes without failure, but does not load any data. This is just an example. The ultimate goal is to change the extension variable in a nodejs script based on user input.</SPAN></P><P></P><P>Thanks!</P></BODY></HTML> Wed, 22 Dec 2021 14:19:47 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60932#M357 Anonymous 2021-12-22T14:19:47Z Re: Passing a parameter to REST connector URL https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60933#M358 <HTML><HEAD></HEAD><BODY><P>I did something similar where I had to go through a few pages (with a parm tweaked), but did this on the QLIK Sense Desktop.</P><P></P><P>Article that was useful:</P><P><A _jive_internal="true" href="https://community.qlik.com/thread/287822">https://community.qlik.com/thread/287822</A></P><P></P><P></P><P>You switch to legacy loading - but in doing so it can open up some security issues (other article did better explaining it).</P><P></P><P></P><P>While this code was from a prior way of doing it:</P><P></P><P>(looping through i a few times)</P><P></P><P><SPAN>Set vUrl = '</SPAN><A class="jive-link-external-small" href="http://whateverurl.html/results.aspx?p=$(i)&ps=20" rel="nofollow" target="_blank">http://whateverurl.html/results.aspx?p=$(i)&ps=20</A><SPAN>'</SPAN></P><P></P><P> TriathlonResults:</P><P>    LOAD</P><P>FROM </P><P>    $(vUrl)</P><P>    (html, utf8, embedded labels, table is @1); </P><P></P><P></P><P>Hope this helps in solving your issue.</P><P><BR />RSC</P><DIV> </DIV></BODY></HTML> Thu, 21 Jun 2018 15:12:30 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60933#M358 Anonymous 2018-06-21T15:12:30Z Re: Passing a parameter to REST connector URL https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60934#M359 <HTML><HEAD></HEAD><BODY><P>Could you better describe what a script needs to look like on Qlik Sense Desktop to accomplish this? I am new to Qlik Sense and Scripting.</P></BODY></HTML> Thu, 21 Jun 2018 15:54:59 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60934#M359 Anonymous 2018-06-21T15:54:59Z Re: Passing a parameter to REST connector URL https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60935#M360 <HTML><HEAD></HEAD><BODY><P>Maxwell,</P><P>I was mistaken - my example involved the web html pull vs. the RESTFUL part.</P><P><BR />That being said, I think this particular is covered very well by the brilliant Michael Tarallo <A href="https://community.qlik.com/qlik-users/77808">mto</A>‌</P><P></P><P>on the following page (using the STAR WAR API):</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/5130">Working with the Qlik REST Connector, Pagination and Multiple JSON Schemas</A></P><P></P><P>I hope this helps guide you to the right answer.</P><P><BR />Robert</P></BODY></HTML> Fri, 22 Jun 2018 04:21:47 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60935#M360 Anonymous 2018-06-22T04:21:47Z Re: Passing a parameter to REST connector URL https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60936#M361 <HTML><HEAD></HEAD><BODY><P>The youtube video on the page:</P><P><A href="https://www.youtube.com/watch?v=QlCT55_712I&feature=youtu.be" title="https://www.youtube.com/watch?v=QlCT55_712I&feature=youtu.be">Using the Qlik REST Connector - Pagination and Multiple JSON Schemas - YouTube</A></P></BODY></HTML> Fri, 22 Jun 2018 04:23:56 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60936#M361 Anonymous 2018-06-22T04:23:56Z Re: Passing a parameter to REST connector URL https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60937#M362 <HTML><HEAD></HEAD><BODY><P>I just use the</P><P><SPAN style="color: #000000; font-family: Consolas, Monaco, 'Andale Mono', monospace; font-size: 12px; background-color: #fafafa;"><SPAN>WITH CONNECTION(Url "</SPAN><A class="jive-link-external-small" href="https://content.googleapis.com/calendar/v3/calendars/primary/events?key=AIzaS" rel="nofollow" target="_blank">https://content.googleapis.com/calendar/v3/calendars/primary/events?key=AIzaS</A><SPAN>...");</SPAN></SPAN></P><P><SPAN style="color: #000000; font-family: Consolas, Monaco, 'Andale Mono', monospace; font-size: 12px; background-color: #fafafa;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Consolas, Monaco, 'Andale Mono', monospace; font-size: 12px; background-color: #fafafa;">as mentioned in the help <A href="https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Create-REST-connection/Pagination-scenarios.htm" title="https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Create-REST-connection/Pagination-scenarios.htm">https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Create-REST-connection/Pagination-scenario…</A> like <A href="https://community.qlik.com/qlik-users/232464">rscampbell</A>‌ mentions.</SPAN></P><P><SPAN style="color: #000000; font-family: Consolas, Monaco, 'Andale Mono', monospace; font-size: 12px; background-color: #fafafa;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Consolas, Monaco, 'Andale Mono', monospace; font-size: 12px; background-color: #fafafa;">Just use a variable for the URL.</SPAN></P><P><SPAN style="color: #000000; font-family: Consolas, Monaco, 'Andale Mono', monospace; font-size: 12px; background-color: #fafafa;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Consolas, Monaco, 'Andale Mono', monospace; font-size: 12px; background-color: #fafafa;">Select .... WITH CONNECTION(Url "$(web_page_variable)");</SPAN></P></BODY></HTML> Thu, 23 Aug 2018 20:27:29 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Passing-a-parameter-to-REST-connector-URL/m-p/60937#M362 Tyler_Waterfall 2018-08-23T20:27:29Z