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

KD
Kilo Contributor

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

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Yes, using that API, check:

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

View solution in original post

10 REPLIES 10

If that is all you need then great but it does not give you mandatory and read only along with a lot of other info the table has so you have to get that from sys_dictionary.  Querying for all of the fields for incident is as simple as adding

name=incident

as the query.  You can also use

nameINSTANCEOFincident

 

Sven3
Tera Contributor

Can I use sysparam_limit and sysparam_offset  in this url , I tried it and not work.

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

KD
Kilo Contributor

Thanks guys, this is helpful.

I am actually trying to get all the fields from Program on particular tab, like Financial. How can I make sure to get those with Schema or which table it is in?

That is a lot more complex.  You have to query the views table to find the section you want and that will have all of the fields that are for that section and view.

KD
Kilo Contributor

Looks like I found everything under pm_program itself. But just let me know if I am missing anything.

Thanks.