Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

serial_number field no longer returned in REST Table API with sysparm_display_value=all

fengg
Tera Contributor

I am querying the table u_asset_audit_scan_data in the REST API Explorer with the following parameters:

  • sysparm_display_value: all

  • sysparm_fields: u_asset.asset_tag,u_asset.serial_number,u_asset.u_rfid_serial

The response I get is:

    {
    "result": [
      {
        "u_asset.u_rfid_serial": {
          "display_value": "***",
          "value": "***"
        },
      "u_asset.asset_tag": {
          "display_value": "***",
          "value": "***"
          }
        }
      ]
}

However, the field u_asset.serial_number is missing from the response.

It appears that this field was returned previously but has recently disappeared from the results.

Why is the serial_number field not returned anymore, and what should I do to resolve this issue?

Thank you.

 

My initial assessment is that this is likely because the display_value cannot be resolved for this field.

 

3 REPLIES 3

Ankur Bawiskar
Tera Patron

@fengg 

is it working with admin user in REST API Explorer?

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Thank you for your response.

Even when I use an admin user, I still cannot get the expected result.

Thank you for your response.

Even when I use an admin user, I still cannot get the expected result.