topic Re: Retrieving data from an API in App Development

Retrieving data from an API

WernerDC — Tue, 01 Jun 2021 14:41:07 GMT

Hi Guys, I need to retrieve data from an API. Problem is I can only call the data weekly!

I have to go into the API to change the Date to the next week after every reload. How can I automate this? And is it possible when all the historic data is retrieved that I can reload the newest week each week?

Hope I make sense.

Kind regards

Re: Retrieving data from an API

rwunderlich — Tue, 01 Jun 2021 16:15:02 GMT

Does the API dialog generate a FROM url/parameter for the Load statement? If you will post that FROM we can help you with an expression to set it to a dynamic week.

-Rob

Re: Retrieving data from an API

WernerDC — Mon, 07 Jun 2021 09:41:35 GMT

Re: Retrieving data from an API

WernerDC — Wed, 09 Jun 2021 06:35:33 GMT

@rwunderlich see my script here.

Re: Retrieving data from an API

pabloviera — Wed, 09 Jun 2021 07:31:33 GMT

Hello Werner you can loop API calls using the "WITH CONNECTION" feature of the script.

You need to delete the last semicolon and put your call with the variables inserted in the URL below, between parenthesis. Take a look at this example calling SAP HANA (You can nest loops of course)

for i=1 to 12
let vmonth=num($(i),'00');

RestConnectorMasterTable:
SQL SELECT
[...]
FROM XML "feed" PK "__KEY_feed"
WITH CONNECTION
(
URL "https://xxxxx-api.s4hana.ondemand.com/sap/opu/odata/sap/XXXXXXX/XXXXX?$filter=FiscalPeriod eq '$(vmonth)'");

next;

If it is a POST call, you need to add parameters in the section instead of in the URL, check Steve's Dark reply here

https://community.qlik.com/t5/Connectivity-Data-Prep/POST-Data-using-REST-Connector/td-p/1447843

Also an implementation using a variable filled with the entire request body:

https://community.qlik.com/t5/Connectivity-Data-Prep/REST-connection-POST-method-QlikSense/td-p/1216415

https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Rest-Connector-Post-Method/td-p/1412475

Regards