Is there a way to remove duplicates in Select Single based on SDP (Fusion REST API)?
Content
Hello,
I have a Select Single component based on SDP that was created for the following Oracle Fusion Rest API:
https://<host>/fscmRestApi/resources/11.13.18.05/customerAccountSitesLOV?q=CustomerName LIKE Рог%&fields=CustomerName,AccountNumber,PartyNumber&limit=100000&onlyData=true&orderBy=CustomerName,AccountNumber
The API normally returns the list of Customer sites, but I noticed that if I limit data to specific fields as shown above it removes duplicates, e.g. if I only query CustomerName it removes duplicate records (assuming there are multiple sites with the same CustomerName) like below:
If fields = CustomerName,SiteName then 2 records are returned:
{ "CustomerName": "Customer1", "SiteName": "Site1"} { "CustomerName": "Customer1", "SiteName": "Site2"}