Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

API Designer - How to upload a csv file

Dear Talend Gurus,

 

       I am trying to create an API which which will accept a csv file as input and load it into a target directory. I tried to use Talend API Designer but I am not able to find the full solution. Could you please guide me what I am missing. I would like to tell in advance that I am quite novice in API. Please accept my apologies in advance if I have made some silly mistakes.

 

       The scenario is something like source team will call this API and they will push the CSV file. They do not want to put file in any shared location and they would like to directly trigger the API by inserting the file as parameter. So I thought REST API using Talend API Designer will be a right use case instead of Route or SFTP.

 

       I have attached the screenshots of the API I have created below. 

0683p000009Ma2Z.png

 

The screen shot of API Tester is as below.

0683p000009Ma2e.png

 

The Studio screenshot is as below.

0683p000009MZkA.png

 

0683p000009Ma2o.png

 

I don't know how I can get the file from this call even though it is showing the request is coming here. Could you please help me? I tried to see some example in Talend Academy but we have example only for basic customer data there and not for file type.

 

@rhall  - I have seen some other posts where you have told to use tFileFetch to extract. I am not sure how to use it for the datatype of file. Could you please guide me?

 

Thanks,

Steph

Labels (5)
1 Reply
Anonymous
Not applicable
Author

Sorry for the delay in responding, I have been a little snowed under recently. However, I saw your question and it reminded me how difficult it can be to figure this problem out. This tutorial should give you enough information to get this working I believe....

 

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/gGH~geaw6_GtmpB6JNViGw