I have a strange one this morning. I'm using Suite...
# suiteqls
Simon
05/23/2022, 2:17 PMI have a strange one this morning. I'm using SuiteQL all over and I love it but this morning, in a new script, a restlet script, I typed this
SELECT id from Transactionline WHERE TransactionLine.transaction = 58916
and the reply is
"message":"Search error occurred: Record 'Transactionline' was not found.","
I changed Transactionline to TransactionLine,
I tested the select in Tim SuiteQL
In the same script, I have other SuiteQL calls without issues.
It looks that the problem is happening only with Transaction and TransactionLine.
Any idea ?
b
battk
05/23/2022, 2:29 PMsounds permission related
battk
05/23/2022, 2:30 PMcheck to see if the role can search transactions
s
Simon
05/23/2022, 2:44 PMWhere can I go to see the permissions on "Transactions" ?
b
battk
05/23/2022, 2:49 PMit should be on the role
s
Simon
05/23/2022, 2:49 PMI'm using Administrator. Let me see
Simon
05/23/2022, 2:51 PMIt looks that you are right
Simon
05/23/2022, 2:52 PMmessage has been deleted
Simon
05/23/2022, 2:52 PMIt looks that administrator cannot access Transactions, quite strange
b
battk
05/23/2022, 2:52 PMthe permission to run transaction related searches is not named transaction
s
Simon
05/23/2022, 2:53 PMah ha. Thanks. What is it ?
b
battk
05/23/2022, 2:54 PMadministrators generally have permission for everything
battk
05/23/2022, 2:55 PMthe usual for learning permissions is to get the url to the page you want to use and visit it in a role that doesnt have that permission
battk
05/23/2022, 2:55 PMnetsuite will give an error message containing the missing permission
battk
05/23/2022, 2:55 PMin this case, creating a transaction search (datasets dont give useful error messages)
s
Simon
05/23/2022, 3:08 PMWell, going back to search for this one. First time I hit a wall with SuiteQL 😞
t
tdietrich
05/23/2022, 3:27 PM@Simon When you're running a query in the SuiteQL Query Tool, you're running using the role that you're logged in as - and in your case, that's Administrator. I suspect that the Access Token that you're using to call the RESTlet is referencing a role that does not have the "Transactions - Find Transaction" permission.
s
Simon
05/23/2022, 3:30 PMMan, you are amazing. It's exactly the issue. It's working fine now.
Thank you very very much !!!!
Simon
05/23/2022, 4:54 PMI was happy too fast. Yes the error is gone but still get a length of 0.
It's a very simple request now : SELECT tranid from transaction where id = 40228419 but it return nothing. On the other hand, in Tim's SuiteQL, I see the data.
As you said, it's something about permission.
t
tdietrich
05/23/2022, 5:23 PMDo you know what type of transaction 40228419 is? Is it a PO? An SO? etc?
s
Simon
05/23/2022, 5:23 PMPO
t
tdietrich
05/23/2022, 5:25 PMOk, so also make sure that the role has permissions on: Transactions - Purchase Order
s
Simon
05/23/2022, 5:55 PMIt's there too 😞
I had pressure from the team. I had to go back to search 😞
I'm hearthbroken.
I know I'm probably wrong, but, maybe transaction is not working with Restlet
Anyway thanks for all your help
4 Views