It’s a very simple query just hoping I can query a...
# suiteqlt
Todd Epple
10/31/2022, 2:48 PMIt’s a very simple query just hoping I can query all messages not just mine.
m
Mark Oriend
10/31/2022, 2:50 PMFrom your external reporting app, how to run this query or get query result ?
Mark Oriend
10/31/2022, 2:51 PMRestlet ?
Mark Oriend
10/31/2022, 2:52 PMIn that case, I usually use Suitelet with administrator role access and external allow.
t
Todd Epple
10/31/2022, 2:54 PMI’m POSTing it to url = “https://${realm}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql” using non-Admin keys. It works great it just returns 3 rows instead of the 600 messages that really happened last week.
Todd Epple
10/31/2022, 2:55 PMThe TBA keys I am using are myself and some limited role (which should have enough rights to see all rows)
Todd Epple
10/31/2022, 2:55 PMWhen I use Tim’s query tool as Administrator in the UI that same query returns all rows.
m
Mark Oriend
10/31/2022, 2:57 PMI understand.
Please create Suitelet, and call that from your external api.
Mark Oriend
10/31/2022, 2:57 PMFor Suitetalk, without administrator token, impossible.
👍 1
t
Todd Epple
10/31/2022, 2:58 PMHmmm.. okay. Thanks for the workaround. I’m sure it will work!
👍 1
b
battk
11/01/2022, 4:05 AMt
Todd Epple
11/01/2022, 12:21 PM@battk Yes thanks for the advice. That looked promising so I added that to the role I am using for my TBA and it’s still only showing me 3 rows not all 600. Also tried “do not restrict employee fields” and same result.
b
battk
11/01/2022, 3:59 PMtry it using a saved search based option
battk
11/01/2022, 4:00 PMyou can probably do it in the ui and compare a message saved search to a message dataset
2 Views