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-
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.
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