Hi :slightly_smiling_face: Just landed here, nice ...
# suiteqla
Anna
10/20/2021, 4:06 PMHi 🙂 Just landed here, nice to meet you all.
I am facing an issue when pulling data from my Netsuite account, using
REST Services & SuiteQLCredit Memosj
jen
10/20/2021, 5:14 PMWhat does your query look like?
a
Anna
10/20/2021, 5:15 PMSELECT * FROM Transaction WHERE type = 'CustCred'Anna
10/20/2021, 5:15 PMThe response:
Copy code
{'links': [{'rel': 'self',
'href': '<https://5413566.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql'}>],
'count': 0,
'hasMore': False,
'items': [],
'offset': 0,
'totalResults': 0}j
jen
10/20/2021, 5:17 PMwell your SQL is fine, so something else is going on. Permissions maybe? What happens if you try a different transaction type, do you get results?
a
Anna
10/20/2021, 5:21 PMYes... I got results from Sales Invoices
Anna
10/20/2021, 5:21 PMPermissions to the user right? With the Transaction permission would it be enough?
j
jen
10/20/2021, 5:31 PMAre you an Administrator for your NetSuite account? Credit Memo is its own permission as are most different types of transactions.
a
Anna
10/20/2021, 5:34 PMYes I do, but I cannot even find it in the list...
j
jen
10/20/2021, 5:49 PMNot sure what to tell you, it’s in there for me:
jen
10/20/2021, 5:50 PMIs it renamed to something else in your NS instance?
a
Anna
10/20/2021, 6:17 PMYes, exactly in this list I cannot find it... It's quite weird. Did you go through beta services enabling first?
j
jen
10/20/2021, 9:48 PMWhat are Credit Memos called in your system? I am guessing they are renamed
jen
10/20/2021, 9:48 PM“Did you go through beta services enabling first?” I don’t know what this means
4 Views