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

hello All, has anyone had any luck getting a SuiteQL with a UNION clause to work via REST? I keep getting a "An unexpected error occurred" messages. individual queries work great and the returned column is identical (i.e. SELECT id FROM transaction WHERE id = '40330' UNION SELECT id FROM transaction WHERE id = '40771')

I just tried this, and I'm getting the same response. I suspect that SuiteTalk REST's SuiteQL doesn't support UNION just yet. However, I was able to get a UNION query to run as a SuiteLet.

One more thing. Instead of a UNION, could you simply do this? `SELECT` 
	`ID,` 
	`Type` 
`FROM` 
	`Transaction` 
`WHERE` 
	`ID IN (40330, 40771)`

Thanks. My query is more complex. That was just an example :) 