SAP ERP CONNECTOR - DOWNLOAD BINARY DATA WITH SO_DOCUMENT_READ_API1 FM

Like (1) Share

Report

Posted on 7 May 2024 14:17:41 by ksoze92

Hello!

I would like to know whether it's possible to download binary data with SAP ERP connector (invoke function action). My intention is to download GOS attachments using SO_DOCUMENT_READ_API1 FM, which returns attachments as binary.

Thanks!

Andoni

All responses (3)

Answers (0)

ksoze92 96 on 21 May 2024 at 15:00:18

Like (0)

Report

Re: SAP ERP CONNECTOR - DOWNLOAD BINARY DATA WITH SO_DOCUMENT_READ_API1 FM

Hi @jongilman ,

The CONTENTS_HEX object is hex, not base64 (so I have to convert from hex to base64). How can I handle HEX data in Power Automate?

Thank you!
ksoze92 96 on 15 May 2024 at 09:36:30

Like (0)

Report

Re: SAP ERP CONNECTOR - DOWNLOAD BINARY DATA WITH SO_DOCUMENT_READ_API1 FM

Hey @jongilman , thanks a lot for your answer! I will give this a try once I troubleshoot my error with SAP ERP connector....(https://powerusers.microsoft.com/t5/Using-Connectors/SAP-ERP-connector-Cannot-invoke-RFC-timeout/m-p/2747620/highlight/true#M22860)
jongilman Microsoft Employee on 13 May 2024 at 18:20:01

Like (1)

Report
Re: SAP ERP CONNECTOR - DOWNLOAD BINARY DATA WITH SO_DOCUMENT_READ_API1 FM

Yes, however what SAP calls "binary" is typically base64-encoded data, not actual binary data. Also, if the file is a text file, the data is returned in the OBJECT_CONTENT array. Your logic could be as follows:
If file extension is "txt," concatenate the LINE property from OBJECT_CONTENT into a single string
Else concatenate the LINE property from OBJECT_HEX into a single base64-encoded string