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. {P 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? Thank you.

what is the exact error message you get

Yes, seems I am getting some invalid fields via JSON schema. May you know a way to get the metadata in browser via REST?

You can do

SELECT * FROM table WHERE ROWNUM = 1

to get available fields.

@michoel The first item may not have all the fields of an object.