Querying for endpoint fields - REST API

[dominique_penni]

Hey all,

I'm working on a REST api integration and I'm having trouble finding a way to programmatically find the fields that are to be expected by a particular endpoint.

Is there a way perform a query, such that, I could make a call to an endpoint similar to:

GET https://dev43415.service-now.com/api/now/table/sys_user

Then, in response, get a list of the fields (and hopefully field datatypes) that this will return.

I've seen this referred to as a "describe" request elsewhere.

Thank you!

[prasad48]

Mention the fields in sysparm_fields query string

https://dev43415.service-now.com/api/now/table/sys_user/6816f79cc0a8016401c5a33be04be441?sysparm_fie...

[dominique_penni]

Ah - Thanks sorry.

I made that a bit unclear.

What I meant is... Is there a way to find out what fields the request:

GET https://dev43415.service-now.com/api/now/table/sys_user

will return?

[prasad48]

As you know table API will return all fields in that table .Are you expecting columns under a table?

[dominique_penni]

An example would be retrieving the name of the response results fields for this endpoint.

https://developer.servicenow.com/app.do#!/rest_api_doc?v=jakarta&id=r_TableAPI-GET

So if the endpoint response is:


  "result": [
    {
    "parent": "",
    "made_sla": "true",
    "watch_list": ""



I would want a list of "parent, made_sla, watch_list" and maybe the field data types.