Using TREST how to upload local csv file to azure blob.

Four Stars

Using TREST how to upload local csv file to azure blob.

Hi,

 

Could someone please suggest how to upload local file saved in a network drive to Azure blob?  I cannot use tfilefetch because of file is saved in the local drive and upload to Azure blob.  It works in reverse.  Fetching file from blob and dropping it to local drive.  Tried TREST component and it only saves the header and not the file content.  I am not able to make below code work that provided as a solution for TREST.

 

OkHttpClient client = new OkHttpClient();
File sourceFile = new File("C:drive/text.csv");
MediaType mediaType = MediaType.parse("multipart/form-data");
RequestBody body = new MultipartBody.Builder()
.setType(MultipartBody.FORM)
.addFormDataPart("file", "C:drive/text.csv",RequestBody.create(MediaType.parse("/csv"), sourceFile) )
.addFormDataPart("objectName", "project")
.addFormDataPart("objectProperty", "documents")
.addFormDataPart("objectId", context.newProjectId)
.build();
Request request = new Request.Builder()
.url("https://azur")
.post(body)
.addHeader("content-type", "application/csv")
.addHeader("cache-control", "no-cache")
.build();
Response response = client.newCall(request).execute();
String json = response.body().string();
System.out.println(json.toString());

 

Please help.

 

Thanks,

pk

Four Stars

Re: Using TREST how to upload local csv file to azure blob.

Anybody??

 

Is there an http web service put component that can be used to load csv file to an external location?  We cannot use storageblob component for this solution.

 

Thanks,

Quest

Nine Stars

Re: Using TREST how to upload local csv file to azure blob.

How about tAzureStoragePut? This component does put files from Local Folder to Azure Storage (container/blobs).
Four Stars

Re: Using TREST how to upload local csv file to azure blob.

Hi Abhishek,

 

Sorry for the late response. No, I cannot use tAzureStoragePut.  I have to either use trestclient or trest.  I tried trest and it only saves header.  thttprequest works but now thrown error of 413 error code.  It worked sometimes when files are smaller. I cannot use tfilefetch, it only works in reverse.  I need to fetch a file from local drive and drop to Azure. Any suggestions?

 

Thanks!

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads