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)
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


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

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   Become a Sponsor   Become a Sponsor