Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-16-2012 05:55 AM
You can query the system dictionary table with web services if you have the proper rights.
WSDL:
https://myinstance.service-now.com/sys_dictionary.do?WSDL
Then perform a "getRecords" query such as:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sys="http://www.service-now.com/sys_dictionary">
<soapenv:Header/>
<soapenv:Body>
<sys:getRecords>
<name>{TABLE NAME GOES HERE}</name>
</sys:getRecords>
</soapenv:Body>
</soapenv:Envelope>
This will give you all of the fields on that table and any information on that field such as data type.
Field names are found in the "element" result. Data types are found in the "internal_type" element.