Get Column Label Names for Incident Table with Rest API

[Tim McFadden]

How do I query the rest API for Column Label Names?  I can query one incident to get all the columns like this.

https://myDev.service-now.com/api/now/v1/table/incident?sysparm_limit=1

But I need to get all the labels for each of the columns

[Tim McFadden]

Hi Harika,

This seems to be exactly what I am looking for but doesn't return all fields.

The query provided only returns 21 fields.  The incident has 88 fields

Can you possible help to return all 88 fields?  What does %3D do in the query?

[Harika Bhupathi]

Hi Tim,

Try this endpoint URL to get all the fields

https://demo1.service-now.com/api/now/table/sys_dictionary?sysparm_query=name%3Dincident%5EORname%3Dtask&sysparm_fields=column_label

Since some the dictionary fields are from task table, above endpoint URL gives you the fields from incidents and task as well.

In the URL - %3D and %5E are URL encodings

URL-encode        ASCII Value

%3D                     =

Refer below link to know about URL encodes

https://www.eso.org/~ndelmott/url_encode.html     

Please do mark my reply as correct or helpful, if it helped you resolve the issue 🙂

Regards,

Harika                

[Ankur Bawiskar]

@Tim McFadden 

few of the fields might be at task level hence it won't give you those fields when you use incident table in your API for dictionary

Regards
Ankur

[John VanBruggen]

This is spot on.

[Ankur Bawiskar]

@Tim McFadden 

Not possible to get using the OOB Table API on incident.

What is the client requirement for this

Approaches

1) Either use table API on the Dictionary table to get the list of columns for incident

OR

2) Use scripted rest api to return the Column Label and it's value by forming custom json response

Regards
Ankur