I am running a query using Rest Web services { “q”:“SELECT * FROM CUSTOMLIST_ABC_FLTRSZELIST” } But I am getting this error Invalid search query. Detailed unprocessed description follows. Search error occurred: Record ‘CUSTOMLIST_ABC_FLTRSZELIST’ was not found. I tried with multiple custom list and all are returning same error. Are custom Lists supported using Rest web service Query.

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that you can indeed query custom lists using SuiteQL via REST Web services. The general format for such a query would be

SELECT * FROM customlistXXXX

, where

XXXX

is the ID of your custom list. However, please note that you need to have the necessary permissions to access the "CustomList" record. If you don't have the required permissions, you might encounter errors like the one you're experiencing. Here is an example of how you can fetch a list of all `Custom Item Fields`:

sql
SELECT
    CustomField.description,
    CustomField.fieldType,
    CustomField.internalId,
    CustomField.id,
    CustomField.name,
    CustomField.lastModifiedDate,
    CustomField.fieldValueTypeRecord,
    CustomField.isMandatory,
    CustomField.owner,
    CustomField.recordType,
    CustomField.scriptid,
    CustomField.isShowInList,
    CustomField.isStored,
    CustomField.fieldValueType,
FROM
    CustomField
WHERE 
    CustomField.fieldType = 'ITEM'

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******