How to get custom fields with type as multiple select from item table ?

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”
}
Rookie Asked on September 1, 2020 in SuiteTalk.
Add Comment
3 Answer(s)
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"
}

 

Rookie Answered on September 9, 2020.

Great

Thanks.

 

on September 9, 2020.
Add Comment

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

Intermediate Answered on September 2, 2020.
Add Comment

Export the field for a saved search and use it

Rookie Answered on September 3, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor