Symptom
• Adding an 'orderBy' clause in Boomi is a standard SAP recommendation to avoid duplicates being fetched by the query.
• This KBA explains how to add the 'orderBy' clause in a Boomi operation.
Image / Data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental
Environment
- Boomi
- Standard SF to 3rd Party Boomi content
- SuccessFactors
Reproducing the Issue
1. This issue is not reproducible as it is a configuration-related query.
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
Boomi operation, orderBy clause, API query, Sorts tab, redeploy process, Boomi configuration, duplicate avoidance, field selection, KBA #2272937, query optimization , KBA , ss_anonymizedkba , LOD-SF-INT-BOM , Standard SF to 3rd Party Boomi Content , LOD-SF-INT , Integrations , How To
SAP Knowledge Base Article - Public