REST API Unexpected Number of Results For Account Object When Ordering By Contact Attributes
(Doc ID 2650702.1)
Last updated on DECEMBER 22, 2020
Applies to:Oracle Fusion B2B Service Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.
Integration user was fetching in pagination way, Accounts, by doing Get call to REST API, and passing query parameters and conditions in the WS API.
I.e. the user was using a API like this : https:// <pod url >/crmRestApi/resources/latest/accounts?onlyData=true&offset=20&limit=20&totalResults=true&q=OrganizationName like '*Test*'&orderBy=PrimaryContactName:asc
If certain fields were passed in the "orderBy" parameter on query, the results and their count on the response are returned with different values than the standard SQL queries done for the fusion tables i.e. SELECT * FROM FUSION.HZ_PARTIES WHERE PARTY_NAME LIKE ''%Test% AND STATUS = 'A'.
The ordering fields that were observed to do this are the ones that relate the Account to a contact, namely:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document