Hey everyone! Just wondering—is there a way to dow...
# suiteql
m
Hey everyone! Just wondering—is there a way to download the table reference for all of the tables in our database?
m
The closes thing I'm aware of is Tim's post here: https://timdietrich.me/blog/netsuite-records-catalog-api/
💯 1
m
This looks great, thanks! Relatedly—do you happen to know if the table reference in SuiteQL is created only once when SuiteQL is installed? I’m having an issue where tables and fields appear in the SuiteQL table reference, but result in errors when I try to run queries on them, and when I cross reference with the records catalogue no such table seems to exist. I’m starting to suspect that the table-reference might be out of date.
m
I'm assuming you're talking about installing the SuiteQL console from Tim. Looking at the code for this utility, it looks like the table reference is created from scratch each time the table reference page is loaded.
m
Gotcha, thanks! Must be something else then.