topic Re: Download CSV file from API (Talend data preparation) in Talend Studio

Download CSV file from API (Talend data preparation)

sunitha — Sat, 16 Nov 2024 00:59:12 GMT

Hi Team,

I have a scenario in Talend data preparation like below:

Everyday user will delete and upload new file with same file name but different structure , when user does like this, dataset id changes, When dataset id changes data can't retrieve by using 'tdatasetinput' component dynamically. i.e we need to select the dataset every time.

I want to achieve this scenario in dynamic approach, and I found component called 'tFileFetch', by using this component source csv file is not downloading but getting URL source file in xml format which I don't want.

Suggestions for this scenario are helpful to me.

Thanks

Sunitha

Re: Download CSV file from API (Talend data preparation)

Anonymous — Tue, 08 Dec 2020 05:01:57 GMT

@sunitha Bandla I have made a testing and confirmed the problem, I think we need a tDatasetList component to list all of the dataset, the properties of dataset will contain dataset id, this component does not exist yet, it is a new feature.

If you have downloaded successfully the file in XML format using tfilefetch, have you tried to read the file content using tFileInputXML component?

Regards

Shong

Re: Download CSV file from API (Talend data preparation)

sunitha — Tue, 08 Dec 2020 05:34:35 GMT

Hello Shong

Thanks for response

I couldn't able to get any useful fields by using 'tfileInputXML component because saved file is only a source file and doesn't have required information.

Can you please provide any alternate solution to fetch the dataset id or download csv file from Talend Data preparation dynamically

Re: Download CSV file from API (Talend data preparation)

Anonymous — Tue, 08 Dec 2020 05:50:01 GMT

I don't have a workaround at the moment, let me check with our developers.

Regards

Shong

Re: Download CSV file from API (Talend data preparation)

sunitha — Tue, 08 Dec 2020 09:39:12 GMT

Hi Shong

Can we know when new feature will be release.

Please let us know how to download the dataset or read dataset from talend without dataset id

Re: Download CSV file from API (Talend data preparation)

jbrun — Tue, 08 Dec 2020 13:23:29 GMT

Hi @sunitha Bandla ,

Why can't your user update the dataset instead of deleting it ?

Re: Download CSV file from API (Talend data preparation)

sunitha — Wed, 09 Dec 2020 02:21:36 GMT

Hi jbrun

Thanks for the solution, while updating the dataset TDP can update schema and record changes as well.

It works.

Thank you