use tRest to extract csv api file and add to database

[Cherichoc-]

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

[Cherichoc-]

@Xiaodi Shi​ 

[Anonymous]

@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

[Cherichoc-]

The issue was with our firewall. Thank you