Hey all. I’m trying pull the possible values of a custom field that is being used to drive a dropdown in a NS form. Via. a REST call to services/rest/record/v1/customlist<id>,I can get a list of items, and each of those items (services/rest/record/v1/customlist<id>/1) contains the actual value of the list item I would like to pull this data via SuiteQL if possible. I can pull the field data for my customlist with:

SELECT  *
FROM    CustomField
WHERE   fieldtype = 'BODY'
AND     name = '<Name of custom list>'

but I don’t know which table would actually hold the available values of this custom list. I can do the 5 or 6 API calls if I have to, but obviously I’d prefer a more efficient one API call (SuiteQL query).

@Wes Gamble I think you want something like this.

@tdietrich This is exactly what I needed! Thanks a million. That’s worth two beers easy 🙂