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

REST API customerAccountSitesLOV does not remove duplicates anymore

edited Mar 24, 2021 8:32AM in Receivables & Collections 2 comments

Summary

REST API customerAccountSitesLOV does not remove duplicates anymore. Is that expected?

Content

Hi,

It seems the logic of the API below changed in 21A, is that expected?

https://<host>/fscmRestApi/resources/11.13.18.05/customerAccountSitesLOV?q=CustomerName LIKE Рог%&fields=CustomerName,AccountNumber,PartyNumber&limit=100000&onlyData=true&orderBy=CustomerName,AccountNumber

I know it is supposed to return Customer Sites, but before 21A 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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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