For certain scenarios, you need to query data from Salesforce, e.g., the Account’s status in Salesforce. The query functionality allows you to query data from SAP-PO using the Skyvva API and the Salesforce standard REST api. Refer to this documentation https://docs.skyvva-dev.com/docs/29-how-to-create-an-interface-using-skyvva-rest-query-using-sap-pi-po-with-skyvva-v3-connector-module/ to understand the query option.
The old query method is called the V2 query and is invoked by the Skyvva SOAP API “searchService”. With this query operation, we can query a small amount of data e.g. the query result is not huge. The new query operation provides the ability to query huge amounts of data using the Salesforce REST and BULK Query API.
4.1 V2 searchService query #
You use the module “Skyvva/V2/RestIntegration” here. Note that the OAuth configuration is the same as you have seen for the operation “Integrate XX” and is not repeated here.
Here is an example of the V2 module. Note that the parameter value “searchService” has been renamed to “Query”. You have to set this parameter to indicate the operation mode. Other parameters such as “SforceRequestPayload” and “SforceShowSAPChannelParameters” are optional when you want to set the trace for debugging.
4.2 V3 query service #
Coming Soon….