get fields of table for suiteQL
- When using a suiteQL and running such a query it return status 400 and the call fails. After removing image field it works, but the image field is from the schema of employee object.
POST "q": "SELECT id, image FROM employee" to /services/rest/query/v1/suiteql
How can I dynamically get the fields that can be used in suiteQL queries?
- I have found this
select * from oa_columns where table_name = 'TABLE_NAME';
from this documentation https://3289332-sb1.app.netsuite.com/app/help/helpcenter.nl?fid=section_4410183892.html
But to which endpoint should I pass this query? It does not work with /suiteql
Rookie Asked on October 29, 2020 in SuiteAnalytics Connect.
Finding Record Type and Field Names
Dont confuse the Data Sources and Browsers.
on October 30, 2020.
Thank you battk. I was looking if there is a way to get those fields programmatically. But seems there is no way.