sending .xlsx file using POST API.

[kirtish.trivedi]

I have a requirement of sending .xlsx file using POST API.

I guess Ideal way of doing this is to use Single File option in WEB API configuration and passing Binary file from process.

But unfortunately the WEB API definition does not support the Binary File, even when used Binary File option from POSTMAN , it throws server error.

There are two options available it seems

1 ) Form-data : When I use this option in POSTMAN, it works fine but not sure how to use this option in Blueprism as Blueprism supports only below option

------------------------------
Kirtish Trivedi
------------------------------

[ewilson]

Hello @sushma Achar,

The FieldMetadata collection is designed to hold Name/Value pairs that are essentially text data that needs to be added to the multipart request body. Whether you need to include these or not is based on the specific platform you're trying to communicate with. For example, ServiceNow exposes a REST API for uploading attachments. If you perform a multipart POST to their API, they require that you include two parameters in the request body (i.e. table_name and table_sys_id). So, is that case we would populate the FieldMetadata collection like this:


Hopefully that helps.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[sushmaAchar]

Hello @ewilson, Will work with this, Thank you​​​

------------------------------
sushma Achar
------------------------------