How to upload excel file to Orchestrator Storage Bucket using API?

[tzekailim (Tze Kai)]

Hello everyone,
I am currently transitioning my process from attended to unattended. In the past, I would use an email attachment function to read and write an excel file. And, since it is now an unattended process, I don’t want it to read the email to get an attachment; instead, I want it to read the attachment file from the Orchestrator bucket instead.

Does anyone know how to use the API to upload a file to an Orchestrator Storage Bucket?
Is there a way to override the file after uploading it?

Thanks!

[shreyash_shirbhate]

Hey @tzekailim

Can you please check below thread?

Doing an api request to add a file to bucket with CURL

Hello! Making upload form of a file from web service to orchestrator bucket. (using PHP + CURL) For first i got a dynamicly generated link to upload with GET request: odata/Buckets(1)/UiPath.Server.Configuration.OData.GetWriteUri?path=\&expiryInMinutes=5 So - to upload file to a bucket i need to make a PUT request to link, that i got with previous one. file is in $_FILES, and formated to object with CURLFile function and attached to POSTFIELDS of curl request. The problem → nothing happeni…

[codemonkee (Tim)]

Hello,

This same question is being actively discussed in the following topic.

Orchestrator API - Buckets

You are looking at two API calls GET /odata/Buckets({key})/UiPath.Server.Configuration.OData.GetWriteUri \<orchestrator>/swagger/index.html#/Buckets/Buckets_GetWriteUriByKey PUT /api/BlobFileAccess/Put?... After calling UiPath.Server.Configuration.OData.GetWriteUri you get a Response containing a URI and Verb to make your second request. The File is then attached to the PUT Request as a Binary and sent to the Uri obtained from the first GET request. A good way to determine what the API…

It is a two part process. One call to generate the Upload Uri using a GET and the output Uri of that GET request is then used to issue a PUT Request.

The main thing to note from both linked topics is when sending the file do so as a Binary in the PUT.

[tzekailim (Tze Kai)]

Is there any example that I can use as reference?

[codemonkee (Tim)]

Both the above links have an a sample, one is done using PHP and the other uses Postman.

[tzekailim (Tze Kai)]

Is there ways for me to link up the Bucket with Queues? so my unattended bot could pick up the correct file to process.

[codemonkee (Tim)]

@tzekailim

Is there ways for me to link up the Bucket with Queues?

You would need to add a reference to either the Path/Filename of the blob along with the Bucket it resides in, or store the Uri to the blob location from the UiPath API endpoint /odata/Buckets({key})/UiPath.Server.Configuration.OData.GetReadUri Note that this endpoint has an expiryInMinutes property (default 0) so you might want to opt for just storing the BuckName/Id and the Blob’s Path/Filename as a reference.