Rest API get all records from a table runs into columns which are records

[VL10]

I am using Table API with GET all records from a table and run into some columns which are records like a user.  How do I expand this to get a field from the record?

My exact use case is the CMDB Application class, and I want to get the list of applications, with the owners (and a few other columns) but the owner for example is a user record.

[pablo_itguy_pl]

Hi,

You might need to run a secondary call to obtain owner details -  you will get the endpoint in original response for apps:

"owned_by": {
      "link": "https://dev202555.service-now.com/api/now/table/sys_user/62826bf03710200044e0bfc8bcbe5df1",
      "value": "62826bf03710200044e0bfc8bcbe5df1"
    }

[AshishKM]

Hi @VL10 ,

Use the below parameter in URI,  for display value of reference fields.

sysparm_display_value=true

Sample in REST API Explorer 

-Thanks,

AshishKM

[VL10]

Many thanks, that helped.   I can see the display_value in my query tool (Postman).   Any idea how to make Excel display the display_value rather than the record if I embed this in Excel?