Mapping ID Values to Text Values - State, Priority on Cases.

[Grant Culp]

I am new to Service Now - I am working on pulling data out of Service Now. I am starting with the Case Table within Service Now. I see that on the data pull fields like state, priority, action_status return a Number/ID instead of the Text Value.

What table in service now holds the lookup values?

Thank you!

[Dan H]

Hi Grant,

What exactly do you mean by pulling data out of ServiceNow? Do you want to export a record to XLS for example?

For example, you can export all of the records that are on the case table to a spreadsheet.

Back to your question

Looking at the Case [sn_customerservice_case] table if you right click a field you want to see the choice values for and then select view choice list, you'll be navigated to the Choices table where you can see the label/value pairs.

Alternatively, on the record itself, if you click the burger menu and "Show XML" you can see the value for each field in the record:

If this has helped or solved your query, please mark it as so 🙂

[Grant Culp]

Hi, I am pulling the data through the API - the values for those fields come through as the integer value. So is the table that shows how Priority 1 maps to Critical called 'Choices'?

[Dan H · Accepted solution]

Hi Grant,

Technical name is: sys_choice

Label is: Choice