RE: get fields of table for suiteQL

  1. 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?
  2. 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

    Thank you

Add Comment
1 Answers
Intermediate Answered on October 29, 2020.

Thank you battk. I was looking if there is a way to get those fields programmatically. But seems there is no way.

on October 30, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.