API Designer - How to upload a csv file

Anonymous — Sat, 16 Nov 2024 02:29:03 GMT

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.

The screen shot of API Tester is as below.

The Studio screenshot is as below.

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

Re: API Designer - How to upload a csv file

Anonymous — Fri, 15 May 2020 14:44:53 GMT

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

topic API Designer - How to upload a csv file in Talend Studio

API Designer - How to upload a csv file

Re: API Designer - How to upload a csv file