Icon

SAP - Web Services for blog

SAP - Web Services Call
SAP Web Service call with data extraction via XPath or JSON - you need a SAP Web Service created from a SAP function module (RFC enabled) - single values or data tables can be extracted from SAP with this method (depends on the SAP function module's params) Recommendation: 1. create SAP function module (RFC enebled) based on your needs, 2. create a Web Service (via SE37 and SOAMANAGER transactions) 3. test the Web Service with SE80 transaction, 4. test external call of the Web Service, e.g. with the SoapUI tool (small programm available for free) 5. copy the body of the call as you see it in SoapUI to the POST Request node to the Request body tab XPath - how to extract data:Column name XPath query TypeMy_variable_1 //TABLE_1//Field1 String(Multiple Rows)My_variable_2 //TABLE_1//Field2 String(Multiple Rows) Get SAP DataFiltrfor XML BodyGet JSONData to tableGet - DATUMGet - PERIODGet StatusStatus - lightsJoin 1Join 2Join 3Split W and YSTATUS_TABLEGet All POST Request Column Filter XML To JSON JSON to Table XPath XPath XPath XPath Joiner Joiner Joiner Nominal ValueRow Splitter XPath SAP Web Service call with data extraction via XPath or JSON - you need a SAP Web Service created from a SAP function module (RFC enabled) - single values or data tables can be extracted from SAP with this method (depends on the SAP function module's params) Recommendation: 1. create SAP function module (RFC enebled) based on your needs, 2. create a Web Service (via SE37 and SOAMANAGER transactions) 3. test the Web Service with SE80 transaction, 4. test external call of the Web Service, e.g. with the SoapUI tool (small programm available for free) 5. copy the body of the call as you see it in SoapUI to the POST Request node to the Request body tab XPath - how to extract data:Column name XPath query TypeMy_variable_1 //TABLE_1//Field1 String(Multiple Rows)My_variable_2 //TABLE_1//Field2 String(Multiple Rows) Get SAP DataFiltrfor XML BodyGet JSONData to tableGet - DATUMGet - PERIODGet StatusStatus - lightsJoin 1Join 2Join 3Split W and YSTATUS_TABLEGet All POST Request Column Filter XML To JSON JSON to Table XPath XPath XPath XPath Joiner Joiner Joiner Nominal ValueRow Splitter XPath

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Loeffler
Created at: 2020-10-19
On NodePit since: 2021-03-15
Last update: 2024-04-26
Created with KNIME version: v4.2.1
Tags: SAPweb servicelofflerautomationrfc

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!