How to retrieve schema for service Now table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 04:55 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 10:16 PM - edited 09-25-2024 10:17 PM
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