Using table api with the following query
https://<site>/api/now/table/sys_choice?name=sometable&element=somecolumn
returns json
{
"result": [
{
"label": "High"
},
{
"label": "Medium"
},
//etc
]
}
How do you get the value column to be returned? I've tried "sysparm_display_value=all". I've tried "sysparm_fields=label,value". Nothing works...when I specify a column that exists on the sys_choice table that is not "label" i get empty results...the correct number of results, but all empty
{
"result": [
{},
{},
//etc
]
}
What i want is
{
"result": [
{
"label": "High",
"value": "1"
},
{
"label": "Medium",
"value": 2
},
//etc
]
}
Seems like a simple thing to do...can't seem to figure it out...when i query another table like incident with no filters or field specifications all the fields are dumped as expected...
