How can I get a list of fields for tables or views from NetSuite using a SuiteQL connection?
I tried select * from oa_columns where table_name = 'account';
but that did not work.
I'm using the CDATA ODBC Connector
How can I get a list of fields for tables or views from NetSuite using a SuiteQL connection?
I tried select * from oa_columns where table_name = 'account';
but that did not work.
I'm using the CDATA ODBC Connector
Copyright © 2021 Jogjafile Inc.
SELECT ColumnName FROM sys_tablecolumns WHERE TableName='Account'
does the trick