RE: 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