Is custom list accessible throught SuiteQL Rest we...
# ask-stanley-ai
t
Is custom list accessible throught SuiteQL Rest web services APIs? I am trying something like { “q”:“SELECT * FROM CUSTOMLIST_ABC_FLTRSZELIST” } but getting error
c
AI generated answer (using internal Slack threads):
Based on the conversations, it appears that custom sublists can be accessed through SuiteQL via the REST web services APIs. You can use a SuiteQL query like
SELECT * FROM customlistXXXX
to get the data from a custom list. However, it's important to note that you might encounter errors if you try to access a sublist field that doesn't exist or hasn't been added yet, as indicated by the error
SSS_INVALID_SUBLIST_OPERATION
. If you're trying to pull the possible values of a custom field that is being used to drive a dropdown in a NetSuite form, you can use a SuiteQL query like this:
Copy code
SELECT
    Name, 
    ID
FROM
    customlistX
WHERE
    IsInactive = 'F'
ORDER BY
    Name
This will give you the active values from the custom list. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.871151924
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.84259063
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841852486
Please provide your feedback on this answer.