How do I get a list of item custom fields via the SuiteQL API?

AI generated answer (using internal Slack threads):

To get a list of item custom fields via the SuiteQL API, you can use the

CustomField

table in SuiteQL. Here is an example of how you can do this:

sql
SELECT scriptid FROM CustomField WHERE fieldtype = 'COLUMN'

This query will return a list of all custom fields where the field type is 'COLUMN'. If you want to get a list of all custom fields, you can use the following query:

sql
SELECT * FROM CustomField

Please note that you need to have the necessary permissions to access these records. If you encounter a 'field not found' error, it could be due to permissions issues or the field might be a calculated field or comes from somewhere else. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******