<@UK8V1Q1FE> with ODBC you can use the system tabl...
# generalm
michoel
09/14/2020, 12:54 AM@Munish Singla with ODBC you can use the system tables (https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4407755805.html). For SuiteQL probably your best bet is the metadata endpoint (https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1540810174.html)
m
Munish Singla
09/14/2020, 12:56 AMI am trying to send sql query via suitescript as
{
"sql": "select id from oa_tables"
}
Munish Singla
09/14/2020, 12:56 AMbut is eturns error
m
michoel
09/14/2020, 12:57 AMwill only work with ODBC (SuiteAnalytics Connect), not SuiteQL
m
Munish Singla
09/14/2020, 12:59 AMI am able to run other queries. but how can I retrieve list object with below in postman
m
michoel
09/14/2020, 1:00 AMyou can't with SuiteQL
m
Munish Singla
09/14/2020, 1:12 AMapart from this, is there any way in netsuite gui that I can see all objects?
m
michoel
09/14/2020, 1:13 AMif you are already on 2020.2 use the new Record Catalog
m
Munish Singla
09/14/2020, 1:14 AMin which section>
m
michoel
09/14/2020, 1:14 AMSetup > Records Catalog
michoel
09/14/2020, 1:15 AMm
Munish Singla
09/14/2020, 1:20 AMPage Not Found
m
michoel
09/14/2020, 1:50 AMhave you been upgraded to 2020.2 yet?
m
Munish Singla
09/14/2020, 5:00 AMI understand there is limitation of 5000 records by suitescript. But is there any way by some logic I can return all records?
8 Views