Is there something special I need to do in order to give users permissions to query a custom list? We are getting this error when trying run N/query module against the list table… However I don’t see anywhere to grant permissions to the list on their role?

{"type":"error.SuiteScriptError","name":"SSS_SEARCH_ERROR_OCCURRED","message":"Search error occurred: Record 'CUSTOMLIST_OPPORTUNITY_WORK' was not found.

I've dealt with this before. SuiteQL is very permission sensitive. If the user/role doesn't have permissions for that particular object/record it'll just say it doesn't exist, not that you don't have permission.

Yeah I normally encounter that with record types though, not lists. I think I figured it out though. The user needs permissions under setup to view “custom lists” — apparently they can view them in the UI, but without this permission they cannot access via suiteql

K, yeah, I believe there is a specific separate permission for custom lists outside the native ones. It was a real pain getting all the permissions setup for a REST integration to use SuiteQL.