API to get display name of all tables in sys_dictionary.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-02-2016 11:39 PM
1.What is the api to get all names and displaynames of all tables in sys_dictionary ?
For eg
There is an Incident(incident) table, where 'Incident' is displayname and 'incident' is table name.
How to get all display names and table names from sys_dictionary using web services.
2. What is the api to get all fields of a particular table providing associative table name ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-11-2016 11:09 AM
You can do this with any number of API's, but for simplicity I would say use REST.
To get the table names and display values, do a GET call on the sys_db_object table.
GET https://INSTANCEPREFIX.service-now.com/api/now/table/sys_db_object
The Label will be the display name, and the Name will be the table name.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-11-2016 11:12 AM
Also for #2, do a GET call on the sys_dictionary table. Add a filter condition by the name of the table.