Filtering organisations where they have a value in a specific custom field
I would like to be able to get a filtered list of organisations for those organisations that have any value of a specific custom field.
We have a multi-select dropdown and I want to retrieve a list of orgs where any value is selected. Is this possible?
Because the value of these is one a string of the multiselect values separated by a semi-colon, I am wondering if this is at all possible. It was not possible to simply put the custom field name in the endpoint without a value so I am wondering if this is at all possible to do.
The alternative would be to retrieve all organisations and loop through them checking every record's custom fields which would seem a little excessive.