Hello every one! Has anyone else had issues with S...
# suiteql
m
Hello every one! Has anyone else had issues with SuiteQL suddenly not working, as if maybe table names have changed? I have a simple query: SELECT id FROM currency WHERE symbol = ? inside of suitescript. The query was working about a month ago when last testing the script. I'm back to working on that script again, but I'm getting an error now saying that the record currency does not exist.
r
have you enabled or turned off any NS features? the fields you can access come and go with features or settings enabled/disabled. For example enabling some feature may require the data to move from one table to another.
BTW, this query wotks for me
SELECT * FROM currency
j
what role is running the SuiteQL?
m
No changes in any features. It's weird, running the query through the SuiteQL Query Tool from Tim, it works fine. But, running it through suitescript on a restlet, it says the record currency doesn't exist.
@jen it's running through a custom integration role.
j
if you can, try with a different role to rule out a permissions issue
m
@jen Thank you, it was apparently a permissions issue. Specifically Lists > Currency.