We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a way to remove duplicates in Select Single based on SDP (Fusion REST API)?

Received Response
13
Views
5
Comments
edited Mar 23, 2021 2:53PM in Visual Builder 5 comments

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"}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!