This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone had trouble getting the REST API to return opportunity data using SuiteQL?

The opportunities are stored in the Transaction table and flagged as type "Opprtnty." So this should work: `SELECT * FROM Transaction WHERE Type = 'Opprtnty'`

Also, the account that you're using will need to have permissions on: Transactions &gt; Opportunity.

I hope that helps!

Thanks so much!  I had tried that one, but fully spelled out opportunity.

One other related question.  Multiselect fields on custom records seem to return a 500 error.  Is that a known limitation or is there a different way to request multiselect fields?

Are you trying to select the multi-select field, or set it?

Just select/return right now, but will probably eventually want to set it.