B1iF 2.0 How To Send Attachments PDF
B1iF 2.0 How To Send Attachments PDF
B1iF 2.0 How To Send Attachments PDF
PUBLIC
Scenario Description: HTTP/RESTful Call from SAP Business One
Multiple Tabs
Error Handling
Navigation Tree
Design Elements
Design Area
1. Subscription of inbound to an SAP Business One event for Purchase Order provided by the event
sender and handed over to the integration framework
2. Definition of data retrieval for the concrete SAP Business One event
3. If attachments exist: Definition of an SQL statement to look up the file path and file details of the
attachments in the ACT1 table in relation to the value in the object “AttachmentEntry”
4. Running of the SQL Statement as defined by using the JDBC adapter
5. If attachments exist: Definition of the upload process for attachments, otherwise skip task
6. Definition of the outgoing message based on the previous results using XSL or JavaScript
7. Hand over the message to the HTTA adapter for sending
8. Usage of the HTTP call response to update SAP Business One with the call status information by using
the SAP Business One call atom.
1 right click
2
3 right-click
4
4 Result: sap.SendPurchaseOrder
3 XPath Expression:
/*[number(/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/BOM/BO/Documents/row/AttachmentEntry)>0]
1
4
Split XPath:
/vpf:Msg/vpf:Body/vpf:Payload[./@id='SQLCall']/jdbc:ResultSet/jdbc:Row
© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 12
Split and Join („for-each“) Atoms for Reading All Attachments (2)
5
© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 13
Code Snippet of the XSL/JavaScript Transformation “prepFilePath.xsl”
Message Envelope
Message Part 1
containing the XML data
4
3
2
Dietmar-Hopp-Allee 16
69190 Walldorf/Baden
Germany
nicolas.fuchs@sap.com
www.sap.com/contactsap