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
    But to which endpoint should I pass this query? It does not work with /suiteql

    Thank you

Add Comment
1 Answer(s)
Advanced 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.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor