SAP Knowledge Base Article - Public

2273492 - How to add 'orderBy' clause in Boomi Operation

Symptom

Adding 'orderBy' clause in Boomi is a standard SAP recommendation to avoid any duplicates to be fetched by the query.

But how how to add this in a Boomi Operation is explained in this KBA.

Environment

Boomi

Reproducing the Issue

NA

Cause

NA

Resolution

Below are the steps that you need to follow in order to add the 'orderBy' clause in your API query via Boomi

1. Login to Boomi and navigate to Build tab-> Boomi process -> Operation.

2. Now in the operation, click on the 'Sorts' tab and then on the '+' sign as shown below-

Sort_KB.jpg

3. After clicking on the '+' option, you will see below screen from where you need to select the fields that you want to be added in the 'orderBy' clause.

sort_KB(2).jpg

4. From here you can select the fields and click on 'Save' and then redeploy the process to have the changes reflected in next executions.

NOTE: On more information on which field you should choose among the whole list displayed, you can refer the KBA #2272937.

Keywords

KBA , LOD-SF-INT-BOM , Standard SF to 3rd Party Boomi Content , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM Core all versions