Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
SuiteQL does not return messages for non-Admin role
I am trying to get a list of the invoice PDFs that have been sent to a customer. I can do this as administrator using SuiteQL:
select f.id as id, f.url as url, BUILTIN_RESULT.TYPE_STRING(BUILTIN.DF(m.transaction)) as invoice from message m join messagefile mf on m.id = mf.message join file f on mf.file = f.id where m.transaction=?
However when I run this as the API integration role, I get zero records (NOT an authorization error message). I can see other message records - i.e. I have access to the message record, but I can only view message records where I am either the sender or recipient. I can log into the UI with that same role and view the message records and PDFs in the UI for the invoice.
Tagged:
0