List of tables in Service Now

[rna]

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

[rna]

I am currently checking the API, sys_db_object.do?SOAP   -   getRecords operation

with the admin user - which has the "admin" role.

Req:

<soapenv:Body>

          <sys:getRecords>

                <sys_created_by>admin</sys_created_by>

          </sys:getRecords>

    </soapenv:Body>

Response:

Table names and their information

Table names - asmt_metric_result, asmt_metric_category, all the custom tables created by admin.

I wanted this API to return the list of all the tables,

I think I am missing on the request, can you give me a valid request for which will return all the list of tables?

[Harish Murikina]

Use json to get all table names

https://yourinstancename.service-now.com/sys_db_object.do?JSONv2&sysparm_action=getRecords;

Regards,

Harish.

[rna]

Thanks Harish, this was helpful,

Any wiki link which gives more details about the same and different parameters which can be passed using json?

But Can we not do it in SOAP?

[Anurag Tripathi]

Hi Rohit,

SOAP is very much possible

SOAP Web Service - ServiceNow Wiki

ANd this is the basic start for webservice in SN

Web Services - ServiceNow Wiki      

Start from here and navigate through the connecting pages

[Harish Murikina]

Hi Rohit,

                Below is the link how to pass parameters using json.

http://wiki.servicenow.com/index.php?title=Legacy:JSON_Web_Service

Regards,

Harish Murikinati.