SAP ERP CONNECTOR - DOWNLOAD BINARY DATA WITH SO_DOCUMENT_READ_API1 FM

(1) Share

Report

Posted on by ksoze92

103

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

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

jongilman Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
ksoze92 103 on at

Like
a
(0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
ksoze92 103 on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No