topic Re: Pass parameter for input file directory while creating a POST Rest data connection in Qlik sense in Integration, Extension & APIs

Pass parameter for input file directory while creating a POST Rest data connection in Qlik sense

shmkmr1990 — Mon, 08 Jul 2024 11:47:00 GMT

Hi,

I'm trying to create a REST API POST connection to push a file from an input directory to the target API. I'm stuck with
1. How to parameterize the input file directory (.txt/.json/parquet files).

2. POST request worked with POSTMAN but not able to succeed with Qlik data connection.

I'm trying this is on Qlik Enterprise, Can you please help me here.

Re: Pass parameter for input file directory while creating a POST Rest data connection in Qlik sense

marksouzacosta — Mon, 08 Jul 2024 12:27:38 GMT

Hi @shmkmr1990,

Regarding parameterizes the input file, I think you'll have to set the Allow With Connection in your REST API Connection. I made a video about that - and more - here: https://youtu.be/lFwar30BNkQ?si=9HOLyqCKFpPm48t2&t=1587

Regards,

Mark Costa

Re: Pass parameter for input file directory while creating a POST Rest data connection in Qlik sense

shmkmr1990 — Mon, 08 Jul 2024 13:56:58 GMT

Thanks Mark, The video is interesting for the GET connection, but i would like to try the POST connections. Do you have any reference for the same.

Re: Pass parameter for input file directory while creating a POST Rest data connection in Qlik sense

marksouzacosta — Mon, 08 Jul 2024 20:16:25 GMT

I'll give it a try tonight @shmkmr1990

Re: Pass parameter for input file directory while creating a POST Rest data connection in Qlik sense

shmkmr1990 — Wed, 10 Jul 2024 11:22:10 GMT

Hi Mark,
did you get a chance to work it out

Thanks,

Shyam

Re: Pass parameter for input file directory while creating a POST Rest data connection in Qlik sense

marksouzacosta — Wed, 10 Jul 2024 14:09:40 GMT

Hi @shmkmr1990,

I did a quick try but without success. Tonight, I will probably have time to focus on that.
This is a very good topic by the way.

Regards,

Mark Costa

Re: Pass parameter for input file directory while creating a POST Rest data connection in Qlik sense

marksouzacosta — Mon, 15 Jul 2024 01:40:55 GMT

Ok, I have tried everything I can think of, but nothing worked in Qlik REST Connection.

I have used the App Import Endpoint for tests - Apps REST | Qlik Developer Portal to import one QVF file:

In Postman: worked

In App Automation: worked. I had to convert the QVF to Base64 - I have used this online tool for that: File to Base64 | Base64 Encode | Base64 Converter | Base64

.NET: Worked.

Qlik Rest Connection: failed miserably!

@Øystein_Kolsrud or @rwunderlich have you ever tried to Post a file using Qlik REST Connector? In Load Script?

Regards,

Mark Costa