I deleted the service and recreated it. It is now working. Thanks for your help!

Hi Yurii,

Mapped as requested. Still no values in my dropdown.

Still have same response as above when testing the db service.

Hmm, so I'm trying to populate a dropdown with the distinct values and then get the items that are associated with those distinct values based on the value of the dropdown.

How would I populate the dropdown with just distinct values if I have the entire list?