Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
shmkmr1990
Contributor II
Contributor II

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

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.

Labels (2)
6 Replies
marksouzacosta

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

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

shmkmr1990
Contributor II
Contributor II
Author

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.

marksouzacosta

I'll give it a try tonight @shmkmr1990 

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

shmkmr1990
Contributor II
Contributor II
Author

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

Thanks,

Shyam

marksouzacosta

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

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

marksouzacosta

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

marksouzacosta_0-1721007456868.png


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

marksouzacosta_1-1721007487088.png

.NET: Worked.

marksouzacosta_2-1721007541028.png


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

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com