List of tables in Service Now

rna
Kilo Explorer

Any documentation link which gives the list of tables present in service now, Can i also find this list dynammically from a API?

1 ACCEPTED SOLUTION

Custom tables always start with u_tablename


View solution in original post

33 REPLIES 33

Thanks Harish,



This API returns the list of ALL the tables, Including system,custom and standard.


I just want the custom and standard tables, can that be achieved?



I want to ignore tables like sc_cat_item_dept_no_mtom, any way to identify from the response received?


yes you can do that at the end give this syparm_query=your condition


Hi Harish, Again thank you for your quick reply,



Yes, but I cannot find a pattern which differentiates a system table with other table (custom and standard).



What values needs to be put along which the API to get only the custom and standard tables?


Custom tables always start with u_tablename


TIME4
Kilo Explorer

Hi,

you can create a filed in your table and reference to sys_db_object (list of tables present in ServiceNow)

find_real_file.png

 

after you can choose table at Field Table

find_real_file.png