How to get custom fields with type as multiple select from item table ?
Answered
url=https://0000-sb1.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql
data={
“q”:”SELECT id,custitem_psgss_material FROM Item”
}
response=
{
“type”: “https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1”,
“title”: “An unexpected error occurred. Error ID: kekvvbn61c2gsn1zfeq7e”,
“status”: 500,
“o:errorCode”: “UNEXPECTED_ERROR”
}
Hi,
I also get an unexpected error when I try to access a mutiselect field via SuiteQL in REST Web Services.
Do you specifically require SuiteQL in this instance or could you use the standard list operations? I can confirm that I don’t receive any error using those.
Thanks,
Chris
Export the field for a saved search and use it
Best answer
Hello,
It’s because the field has no header name on it since its a custom one. Therefore, you must set an alias on it before calling it directly to the table.
{
"q": "SELECT id, custitem_psgss_material as pggs_materials FROM Item"
}
Great
Thanks.
