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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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