Fetch Records in Salesforce Commerce Cloud Using the Query Operation

When you need to fetch records in Salesforce Commerce Cloud, you can use the Salesforce Commerce Cloud Adapter’s query/search feature. You can specify the query statement according to your requirement and fetch records.

This use case describes how to use the query/search operation to fetch the matching records from the Product object.

1. Create an app-driven orchestrated integration.
2. Drag a SOAP Adapter into the integration as a trigger connection.
3. Drag an assign action to the workspace next to the SOAP Adapter.
4. Provide a unique name for this action, and click Create.
5. Drag a Salesforce Commerce Cloud Adapter into the integration.
6. Configure the Salesforce Commerce Cloud endpoint:
   1. On the Basic info page, provide an endpoint name, and click Next.
   2. On the Action page, select Query, and click Next.
   3. On the Operations page, select Query/Search as an operation type, select product_search as an object, select Post Product Search as an operation, and click Click to Configure Query.
   4. Enter the query statement according to your requirement, and click Execute Query. The matching results are displayed in the Query result field.
   5. Review the search results, and click Ok.
   6. On the Summary page, review your selections, and click Done.
7. In the mapper, map the search_data and start parameters in the request mapper and query result elements to the respective fields of Salesforce Commerce Cloud in the response mapper. The completed integration looks as follows.
   
   
   
   
8. Specify the tracking variable, save, and close the integration.
9. Activate the integration.
10. After successful activation, you can submit the integration and monitor the runtime in Oracle Integration. The integration keeps running until it completes the search for fetching product results as the output response.