Retrieve list of all table in my ServiceNow instance using Rest API

[KD]

Hi,

I know I can retrieve the list of all table from my ServiceNow instance using REST API?

I am aware to get all data using below URL from a particular table, but how can I get list of all tables.

https://instance.service-now.com/api/now/v1/table/incident

[Community Alums · Accepted solution]

Yes, using that API, check:

GET https://instance.service-now.com/api/now/table/sys_db_object

[KD]

Thanks Mike.

How about all fields for a particular table without any data, just a schema? 

[DrewW]

sys_dictionary for that

[Community Alums]

It's easier to get stuff from using the ?SCHEMA parameter on the URL rather than via the dictionary. Having to try and figure out layers of inheritance is a bit of a pain. 

If you go to https://instance.service-now.com/tableTechnicalName.do?SCHEMA you'll get a good amount of detail, example: 

https://instance.service-now.com/incident.do?SCHEMA   - returns

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<incident>
<element name="promoted_by" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="parent" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="number" reference_table="task" reference_field_max_length="40"/>
<element name="caused_by" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="number" reference_table="change_request" reference_field_max_length="40"/>
<element name="watch_list" internal_type="glide_list" max_length="4000" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="upon_reject" internal_type="string" max_length="40" choice_list="true" active_status="true"/>
<element name="sys_updated_on" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="approval_history" internal_type="journal" max_length="4000" choice_list="false" active_status="true"/>
<element name="skills" internal_type="glide_list" max_length="4000" choice_list="false" active_status="true" display_field="name" reference_table="cmn_skill" reference_field_max_length="100"/>
<element name="proposed_by" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="number" internal_type="string" max_length="40" choice_list="false" active_status="true"/>
<element name="lessons_learned" internal_type="html" max_length="65000" choice_list="false" active_status="true"/>
<element name="state" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="sys_created_by" internal_type="string" max_length="40" choice_list="false" active_status="true"/>
<element name="knowledge" internal_type="boolean" max_length="40" choice_list="false" active_status="true"/>
<element name="order" internal_type="integer" max_length="40" choice_list="false" active_status="true"/>
<element name="cmdb_ci" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="cmdb_ci" reference_field_max_length="255"/>
<element name="delivery_plan" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sc_cat_item_delivery_plan" reference_field_max_length="100"/>
<element name="impact" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="contract" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="vendor_contract" reference_table="ast_contract" reference_field_max_length="40"/>
<element name="active" internal_type="boolean" max_length="40" choice_list="false" active_status="true"/>
<element name="work_notes_list" internal_type="glide_list" max_length="4000" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="priority" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="sys_domain_path" internal_type="domain_path" max_length="255" choice_list="false" active_status="true"/>
<element name="rejection_goto" internal_type="reference" max_length="32" choice_list="false" active_status="false" display_field="number" reference_table="task" reference_field_max_length="40"/>
<element name="business_duration" internal_type="glide_duration" max_length="40" choice_list="false" active_status="true"/>
<element name="group_list" internal_type="glide_list" max_length="4000" choice_list="false" active_status="true" display_field="name" reference_table="sys_user_group" reference_field_max_length="80"/>
<element name="approval_set" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="wf_activity" internal_type="reference" max_length="32" choice_list="false" active_status="false" display_field="name" reference_table="wf_activity" reference_field_max_length="100"/>
<element name="major_incident_state" internal_type="string" max_length="40" choice_list="true" active_status="true"/>
<element name="universal_request" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="number" reference_table="task" reference_field_max_length="40"/>
<element name="short_description" internal_type="string" max_length="160" choice_list="false" active_status="true"/>
<element name="correlation_display" internal_type="string" max_length="100" choice_list="false" active_status="true"/>
<element name="work_start" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="delivery_task" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sc_cat_item_delivery_task" reference_field_max_length="100"/>
<element name="trigger_rule" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="major_incident_trigger_rule" reference_field_max_length="200"/>
<element name="additional_assignee_list" internal_type="glide_list" max_length="4000" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="notify" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="sys_class_name" internal_type="sys_class_name" max_length="80" choice_list="true" active_status="true"/>
<element name="service_offering" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="service_offering" reference_field_max_length="255"/>
<element name="closed_by" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="follow_up" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="parent_incident" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="number" reference_table="incident" reference_field_max_length="40"/>
<element name="reopened_by" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="reassignment_count" internal_type="integer" max_length="40" choice_list="false" active_status="true"/>
<element name="assigned_to" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="variables" internal_type="variables" max_length="40" choice_list="false" active_status="false" display_field="question_text" reference_table="item_option_new" reference_field_max_length="255"/>
<element name="sla_due" internal_type="due_date" max_length="40" choice_list="false" active_status="true"/>
<element name="comments_and_work_notes" internal_type="journal_list" max_length="4000" choice_list="false" active_status="true"/>
<element name="escalation" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="upon_approval" internal_type="string" max_length="40" choice_list="true" active_status="true"/>
<element name="timeline" internal_type="html" max_length="1024000" choice_list="false" active_status="true"/>
<element name="correlation_id" internal_type="string" max_length="100" choice_list="false" active_status="true"/>
<element name="made_sla" internal_type="boolean" max_length="40" choice_list="false" active_status="true"/>
<element name="promoted_on" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="sn_esign_document" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="file_name" reference_table="sys_attachment" reference_field_max_length="100"/>
<element name="child_incidents" internal_type="integer" max_length="40" choice_list="false" active_status="true"/>
<element name="hold_reason" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="task_effective_number" internal_type="string" max_length="40" choice_list="false" active_status="true"/>
<element name="resolved_by" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="sys_updated_by" internal_type="string" max_length="40" choice_list="false" active_status="true"/>
<element name="opened_by" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="user_input" internal_type="user_input" max_length="4000" choice_list="false" active_status="true"/>
<element name="sys_created_on" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="sys_domain" internal_type="domain_id" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user_group" reference_field_max_length="80"/>
<element name="proposed_on" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="actions_taken" internal_type="journal_input" max_length="40" choice_list="false" active_status="true"/>
<element name="route_reason" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="calendar_stc" internal_type="integer" max_length="40" choice_list="false" active_status="true"/>
<element name="closed_at" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="business_service" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="cmdb_ci_service" reference_field_max_length="255"/>
<element name="business_impact" internal_type="string" max_length="4000" choice_list="false" active_status="true"/>
<element name="rfc" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="number" reference_table="change_request" reference_field_max_length="40"/>
<element name="time_worked" internal_type="timer" max_length="40" choice_list="false" active_status="true"/>
<element name="expected_start" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="opened_at" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="work_end" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="reopened_time" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="resolved_at" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="caller_id" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user" reference_field_max_length="151"/>
<element name="subcategory" internal_type="string" max_length="40" choice_list="true" active_status="true"/>
<element name="work_notes" internal_type="journal_input" max_length="4000" choice_list="false" active_status="true"/>
<element name="close_code" internal_type="string" max_length="40" choice_list="true" active_status="true"/>
<element name="assignment_group" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sys_user_group" reference_field_max_length="80"/>
<element name="business_stc" internal_type="integer" max_length="40" choice_list="false" active_status="true"/>
<element name="cause" internal_type="string" max_length="4000" choice_list="false" active_status="true"/>
<element name="description" internal_type="string" max_length="4000" choice_list="false" active_status="true"/>
<element name="calendar_duration" internal_type="glide_duration" max_length="40" choice_list="false" active_status="true"/>
<element name="close_notes" internal_type="string" max_length="4000" choice_list="false" active_status="true"/>
<element name="sys_id" internal_type="GUID" max_length="32" choice_list="false" active_status="true"/>
<element name="sn_esign_esignature_configuration" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="sn_esign_configuration" reference_field_max_length="80"/>
<element name="contact_type" internal_type="string" max_length="40" choice_list="true" active_status="true"/>
<element name="incident_state" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="urgency" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="problem_id" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="number" reference_table="problem" reference_field_max_length="40"/>
<element name="company" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="core_company" reference_field_max_length="80"/>
<element name="activity_due" internal_type="due_date" max_length="40" choice_list="false" active_status="true"/>
<element name="severity" internal_type="integer" max_length="40" choice_list="true" active_status="true"/>
<element name="overview" internal_type="html" max_length="65000" choice_list="false" active_status="true"/>
<element name="comments" internal_type="journal_input" max_length="4000" choice_list="false" active_status="true"/>
<element name="approval" internal_type="string" max_length="40" choice_list="true" active_status="true"/>
<element name="due_date" internal_type="glide_date_time" max_length="40" choice_list="false" active_status="true"/>
<element name="sys_mod_count" internal_type="integer" max_length="40" choice_list="false" active_status="true"/>
<element name="reopen_count" internal_type="integer" max_length="40" choice_list="false" active_status="true"/>
<element name="sys_tags" internal_type="related_tags" max_length="0" choice_list="false" active_status="true"/>
<element name="location" internal_type="reference" max_length="32" choice_list="false" active_status="true" display_field="name" reference_table="cmn_location" reference_field_max_length="100"/>
<element name="category" internal_type="string" max_length="40" choice_list="true" active_status="true"/>
</incident>