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



“q”:”SELECT id,custitem_psgss_material FROM Item”



    “type”: “”,
    “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)


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.



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
Best answer


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.




on September 9, 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   Become a Sponsor