How to retrieve schema for service Now table?

ajithcnambi
Tera Contributor

I would like to retrieve the schema of a few tables such as Incident, Maintenance Schedule and Schedule Entry. I know that this can be viewed in the UI. But how do I export it into a file? Is there an REST API to do that?

1 REPLY 1

Ravi Chandra_K
Kilo Patron
Kilo Patron

Hello @ajithcnambi 

If you are looking for all the fields along with labels in a table, you can go to sys_dictionary table and export all the fields along with labels and field types into spreadsheet. works for creating a json payload 

 

Please mark this answer as helpful and correct if helped.

Kind Regards,

Ravi Chandra