topic Re: use tRest to extract csv api file and add to database in Talend Studio

use tRest to extract csv api file and add to database

Cherichoc- — Sat, 16 Nov 2024 01:08:56 GMT

I have an HTTP API link which extracts a csv file and load the data to a DB. Problem is I cannot use tFetchFile as our Architects says our sql server cannot link to internet , so tFetchFile component wont work on our sql server environment.

So i tried using tRest (not tRestClient) but cant figure a way to convert body column to the multiple columns on the csv file.

Reason why i couldnt use tRestClient is cos I get HTTP 404 error , but with tRest i can read the data on the csv file from the link

Re: use tRest to extract csv api file and add to database

Cherichoc- — Mon, 09 Nov 2020 17:45:43 GMT

@Xiaodi Shi

Re: use tRest to extract csv api file and add to database

Anonymous — Wed, 11 Nov 2020 03:32:19 GMT

@Phumla Qwabe , do you have the file content in body column? Can you please use a tLogRow after tRest to see what data it returns?

Regards

Shong

Re: use tRest to extract csv api file and add to database

Cherichoc- — Thu, 19 Nov 2020 09:59:42 GMT

The issue was with our firewall. Thank you