topic Using TREST how to upload local csv file to azure blob. in Talend Studio

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

Attunity_user — Sat, 16 Nov 2024 07:47:48 GMT

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,

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

Attunity_user — Tue, 21 Aug 2018 22:09:14 GMT

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

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

iamabhishek — Wed, 22 Aug 2018 08:30:12 GMT

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

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

Attunity_user — Wed, 02 Jan 2019 20:20:42 GMT

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!