topic Automate POST API with Send file option in Digital Exchange

Automate POST API with Send file option

kirtish.trivedi — Fri, 16 Jul 2021 15:59:00 GMT

I have a requirement to send .xlsx file daily using POST API.

I have configured POST Method And I have selected "Send File" option.

While I use API in BP Action, it asks for Binary. I have imported file as binary and passed the variable. It is working fine
My problem is I want to Automate this .xlsx file import in Binary variable process since .xlsx file content will be different everyday . D
Please assist how to achieve this

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

RE: Automate POST API with Send file option

ritansh.jatwani — Sat, 17 Jul 2021 09:20:00 GMT

Hi @Kirtish Trivedi.

Please use the inbuilt function "LoadBinaryFile" available in File-->LoadBinaryFile to load the file. The filepath can be passed from a variable. PFB the screenshot for the same:

Please let me know if you still faces any issue.

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
------------------------------

RE: Automate POST API with Send file option

kirtish.trivedi — Mon, 19 Jul 2021 03:30:00 GMT

Hi @ritansh.jatwani,

Thank you for letting me know this Built in Function. It works.

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