SAP Cloud Integration version 2.44.x comes with enhancement in OData V2 receiver adapter with support of Function Import. For more information on function import (also termed as Service Operation in OData V2) can be found in https://www.odata.org/documentation/odata-version-2-0/
This blog describes on how to make use of this enhancement.
Function Import Enhancement
The support for function import has been added as an operation in the OData V2 receiver adapter/connector and in the Query Modeler/Wizard.
Consider a sample integration flow as below, with which usage of function import is described.
In the adapter properties, you can observe the Function Import operation in Operation Details.
If you have a working URL of function import, you can select this operation and provide the function name in Resource Path and the parameters information in Query Options field.
If you are not aware of the function name of the OData V2 service endpoint, you can make use of Query Modeler/Wizard.
Click on Select button, which opens the wizard. The first screen pre-populates the connectivity information.
Click on ‘Step 2’ button.
In the next screen, select Function Import in operation and click on search icon/key in the function name text field, it will list the available function imports of the OData V2 service as shown in below screenshot.
After selecting the function import, table will be populated with parameters name which will be required to invoke the function.
If a function import is of method GET and returns entity or collection of entity, the wizard will list all the fields of that entity. You can select the individual fields. Also, you can construct filter and sorting queries along with top and skip.
Click on finish button, the constructed query will be put on to the OData V2 adapter’s properties.
Deploy the integration flow project and you can examine the output of function import in the SFTP receiver (as modeled in the sample integration flow project) or you can use the result of function import in the next subsequent flow steps.
As of now, we support the function import with the return type entity or collection of entities. If function import returns complex/collection of complex or primitive/collection of primitive type or void, are not supported.
The support for Function Import in SuccessFactors OData V2 adapter is not available and is work in progress.