HTTP Request - Post an Excel file

Help Studio
, , , , , , ,
1

Hello all,
I’m seeking assistance with a challenge involving sending an Excel file (.xlsx) via API. While I’ve successfully attached it to the binary body in Postman without encountering any issues,
I consistently face HTTP status 500 or 400 errors when attempting the same in UiPath using HTTP requests.

Can anyone offer guidance on resolving this issue? Your help would be greatly appreciated. Thank you

image
image1177×604 57.8 KB

2

Hello DigiSea,

Providing you one pdf file which have all the instructions how to upload a file via API.
Please try following steps on Postman.

Getting Started With File Upload in APIs.pdf (754.1 KB)

Adding one more pdf which will give you guidance how to upload file using postman.

How to Upload a File in Postman.pdf (739.4 KB)

Please let me know if my suggestion resolves your issue.

Thank you :slight_smile:
Happy Automation!!
Hrishikesh Kothale.

3

Thank @hrishikesh.k for your supporting documents

In Postman, I’ve successfully attached it to the binary body in Postman without encountering any issues
In UiPath, I consistently face HTTP status 500 or 400 errors when attempting the same in UiPath using HTTP requests

image
image1266×493 87.6 KB

4

Hello DigiSea,

Please try “PUT” method once!

Please let me know if my suggestion resolves your issue.

Thank you :slight_smile:
Happy Automation!!
Hrishikesh Kothale.

5

Hi @DigiSea ,

There is a file attachment property in HTTP activity. You can try using that

6

@DigiSea,

Attachments with HTTPS request works differently than Postman.
In HTTP request, you will have to pass the attachment in Attachments property.

Thanks,
Ashok :slight_smile:

7

Thank @ashokkarale and @muktadir
I encountered the issue HTTP status 405 errors when attempting to use attachment property.
Could you please provide me a sample of it?

image
image1331×444 85.5 KB

8

@DigiSea,

Suggest me a public domain API which supports attachment upload. I will try to recreate it for you.

9

@DigiSea,

I think it’s the Body Format which is resulting in this issue. Change it to multipart/form-data and it should work if other arguments and attachment file paths passed correctly.

image

Thanks,
Ashok :slight_smile: