23.9 REST Query All

This document describes how to create an inbound interface using SKYVVA "REST Query All" mode in SAP PI/PO with a new SKYVVA V3 connector module.

REST Query All

It will retrieve all archived and deleted records along with the existing records. The SKYVVA search will internally work on your query and will provide the complete result from your query. You can configure in your Interface with operation type as "REST Query All“ to use the REST Query feature. Then you need to configure your SOQL in the SKYVVA interface. Base on your configuration in Interface SkYVVA connector will automatically detect the operation type and work accordingly with the same search operation.

How REST Query All works

Create an inbound interface.
Select the Operation type as REST Query All". As shown below.

Now we will put the SQL statement in the Skyvva Interface. As shown below.

[su_box title="Note" box_color="#2a8af0" title_color="#000000"]For example: The Soql query we can use like. SELECT BillingCity,BillingCountry,BillingPostalCode,BillingState,BillingStreet,Description,Fax,Id,Name,Phone,skyvvasolutions__SAP_Distribution_Channel__c,skyvvasolutions__SAP_Division__c,skyvvasolutions__SAP_Sales_Org__c FROM Account where skyvvasolutions__SAP_Distribution_Channel__c = '{!skyvvasolutions__SAP_Distribution_Channel__c}' and skyvvasolutions__SAP_Sales_Org__c = '{!skyvvasolutions__SAP_Sales_Org__c}' and skyvvasolutions__SAP_Division__c = '{!skyvvasolutions__SAP_Division__c}'[/su_box]

Save the interface.
Follow the below steps to download the WSDL from Lightening

Click on "Generate Metadata" on the Integration detail page as shown below.

Fill all the highlighted fields accordingly, use your interface name.
Click on Export.

Click on view to download the WSDL file

Import WSDL into ESR (Check the link below to know about it).

#article/25-8-rest-query

#### Test the Inbound Interface.

Triggering the data from the Source system.
Here is the result from Salesforce. The highlighted Record is the record from the Recycle bin.

This picture shows the same record in response, which is in the Recycle bin.