topic Reading csv file path from api response JSON in Integration, Extension & APIs

Reading csv file path from api response JSON

ahmad_yar — Thu, 11 Aug 2022 14:59:38 GMT

Hi,

I am using connector to make API call. The API call returns this response as JSON:

{"output_file": "https://rmf-bucket.s3.amazonaws.com/media/user_1/output-sample.csv"}

I want to get the "output_file" path which is a CSV file and load its content.

Thanks in advance

Re: Reading csv file path from api response JSON

ajaykakkar93 — Mon, 15 Aug 2022 10:35:52 GMT

hi,

You can do this by the below method.

using web connector get the above file data & store in a variable
now use the url stored in variable & just do a load * with url using web connector data will load

Re: Reading csv file path from api response JSON

ahmad_yar — Wed, 17 Aug 2022 06:36:50 GMT

Hi @ajaykakkar93 ,

Thanks for the response, I am new to qlik and I am confused about how to add the second connector which will read data from CSV. It will be great if you can provide snippet. Currently, I am using this snippet:

LIB CONNECT TO 'Gedeelde Omgeving:REST_http52.49.233.78apiv1rfm-latest'; RestConnectorMasterTable: SQL SELECT "output_file" FROM JSON (wrap on) "root"; [root]: LOAD [output_file] RESIDENT RestConnectorMasterTable; LET vOutput = peek('output_file', 0, 'root'); SET Output = $(vOutput); LOAD * FROM $(Output)

Re: Reading csv file path from api response JSON

ajaykakkar93 — Thu, 18 Aug 2022 18:33:14 GMT

in LOAD * FROM $(Output). You will get the url now just load the url using qlik web connector