Unable to find the total number of records in GET request from SNow Change Management API

[tupyy]

This issue is about a potential problem that we have when the generic client is implemented.

Currently, when we list all the records from a service we're continuously fetching records in batch (default size is 1000) by moving the offset sysparm_offset += offset + batch_size. The loop returns when there's no more data to fetch.
To figure out when there is no data left, we rely on two conditions:

• for Table API, the client looks for the header value x-total-count which gives the total count of items available for that request
• for other clients, the client stops when the result list is empty.

But the Change management API link server returns a response with no headers and a weird __meta field in the results list:

curl -s "https://devxxxx.service-now.com/api/sn_chg_rest/v1/change?sysparm_query=active=false^ORDERBYnumber" --header "Accept:application/json" --user "admin":'xxxxx' | jq
{
  "result": [
    {
      "__meta": {
        "encodedQuery": "active=false^ORDERBYnumber"
      }
    }
  ]
}

The presence of this field makes the client never finish fetching items from the server.

The solution would be to introduce a custom json.JSONDecoder that removes this field when the response is parsed into a json obj.

ISSUE TYPE

• Bug Report

COMPONENT NAME

service.itsm.api_info