Fetch Table Schema using REST API - ServiceNow Community

Fetch Table Schema using REST API

adigelli
Kilo Contributor

‎09-02-2016 04:11 AM

Hi,

How can i fetch the schema of the particular table in serviceNow.

Can any one help.

Thanks.

Labels:
  • 6,816 Views
4 REPLIES 4

Subhajit1
Giga Guru

‎09-02-2016 04:53 AM

You should be able to fetch the primary information from the sys_dictionary table by passing the table name parameter.


0 Helpfuls

adigelli
Kilo Contributor

‎09-02-2016 05:58 AM

Hi Subhajit,



I have tried this command, i am getting big amount of o/p which is too large.



curl   -H "Authorization:Bearer BearerToken" "https://dev.service-now.com/api/now/v1/table/sys_dictionary?sysparm_query=GOTOname%3Dsys_user" -H "Accept:application/json"



Whether it is correct or not.


0 Helpfuls

udaykemburu
ServiceNow Employee
ServiceNow Employee

‎09-20-2016 09:27 AM

Try with this URL: https://myinstance.service-now.com/incident.do?SCHEMA


Max C
Kilo Explorer

‎05-22-2020 08:15 AM

Looks like even with the http header -H "Accept:application/json" it is returning Xml.

 

Is there a way to force it to return Json?

0 Helpfuls