Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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.