Reference 360

Back Next

Get history of a code list by time range

Retrieves all the change events of a code list for a specific time range.

GET request

To retrieve all the change events of a code list for a specific time range, submit a GET request with the following URI:

/rdm-service/external/v1/codelists/<Code list ID>/summary/audit

GET request query parameters

You can append query parameters to the URI to specify the time range, page number, page size, and modification type.

The following table describes the query parameters:

Parameter	Description
from	Start date and time of a time range. The start date and time is inclusive. Set the time range in the ISO-8601 format: yyyy-MM-dd'T'HH:mm:ss'Z'. For example, you can set 2023-01-01T00:00:00Z .
to	End date and time of a time range. The end date and time is exclusive. Set the time range in the ISO-8601 format: yyyy-MM-dd'T'HH:mm:ss'Z'. For example, you can set 2024-01-01T00:00:00Z .
page	Optional. Page number to display. Default is 0.
pageSize	Optional. The number of records to display on each page. Default is 100. Maximum is 10000.
modificationType	Optional. Type of modification. Value can be CREATE, UPDATE, or DELETE.

GET response

The response contains the change events of a code list for a specific time range.

The following table describes the attributes in the response:

Attribute	Type	Description
pageSize	Number	The number of records displayed on each page.
page	Number	Page number displayed.
numberOfElements	Number	The number of events.
lastPage	Boolean	Indicates whether the current page is the last page in the total result.
firstPage	Boolean	Indicates whether the current page is the first page in the total result.
content	Array	Includes the list of modification events.
asset	Object	Includes details about the code list.
modificationType	String	The type of change made to the code list.
fieldChanges	Object	Displays the previous and new values of the fields with changes.
attributeChanges	Object	Displays the previous and new values of the attributes with changes.
eventTime	String	The date and time the code list was last updated.
userName	String	The user name of the user who initiated the modification.

GET example

To retrieve all the change events of a code list for a specific time range, you might use the following request:

GET https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v1/codelists/9ae8fcf6b8f0327a7bdb7f2c/summary/audit?from=2023-01-01T00:00:00Z&to=2024-01-01T00:00:00Z HTTP/1.1
Accept: application/json
IDS-SESSION-ID: XXXXXXXXXXXXXXXXXXXXXX

The following sample response shows the change events of the code list from 2023-01-01T00:00:00Z to 2024-01-01T00:00:00Z:

HTTP/1.1 200 OK
Content-Type: application/json;charset=UTF-8
Content-Length: 4991

{
   "pageSize":100,
   "page":0,
   "numberOfElements":8,
   "lastPage":true,
   "firstPage":true,
   "content":[
      {
         "asset":{
            "id":"6407014f5b243e32c4b02ce3",
            "name":"ISO 3166-1 numeric",
            "assetType":"CODELIST"
         },
         "modificationType":"UPDATE",
         "eventTime":"2023-03-07T09:23:35Z",
         "userName":"integration-test-admin"
      },
      {
         "asset":{
            "id":"6407014f5b243e32c4b02ce3",
            "name":"ISO 3166-1 numeric",
            "assetType":"CODELIST"
         },
         "modificationType":"UPDATE",
         "fieldChanges":{
            "additionalDescription":{
               "newValue":"(ISO 3166-1)"
            },
            "application":{
               "newValue":{
                  "key":"EnterpriseKey",
                  "label":"Enterprise"
               }
            },
            "approvedById":{
               "newValue":"2L0DXgAOiCObZDT7Yql02R"
            },
            "approvedByName":{
               "newValue":"integration-test-planner"
            },
            "approvedOn":{
               "newValue":"2023-03-08"
            },
            "description":{
               "newValue":"Numeric Codes for Countries"
            },
            "effectiveDate":{
               "newValue":"2023-03-06"
            },
            "status":{
               "newValue":{
                  "key":"ActiveKey",
                  "label":"Active"
               }
            },
            "version":{
               "newValue":"1"
            }
         },
         "eventTime":"2023-03-07T09:23:34Z",
         "userName":"integration-test-admin"
      },
      {
         "asset":{
            "id":"6407014f5b243e32c4b02ce3",
            "name":"ISO 3166-1 numeric",
            "assetType":"CODELIST"
         },
         "modificationType":"UPDATE",
         "attributeChanges":{
            "NumericCode":{
               "name":{
                  "newValue":"NumericCode"
               },
               "type":{
                  "newValue":"String"
               },
               "required":{
                  "newValue":"false"
               }
            }
         },
         "eventTime":"2023-03-07T09:19:29Z",
         "userName":"integration-test-admin"
      },
      {
         "asset":{
            "id":"6407014f5b243e32c4b02ce3",
            "name":"ISO 3166-1 numeric",
            "assetType":"CODELIST"
         },
         "modificationType":"UPDATE",
         "attributeChanges":{
            "NumericCode":{
               "name":{
                  "newValue":"NumericCode"
               },
               "type":{
                  "newValue":"String"
               },
               "required":{
                  "newValue":"false"
               }
            }
         },
         "eventTime":"2023-03-07T09:19:27Z",
         "userName":"integration-test-admin"
      },
      {
         "asset":{
            "id":"6407014f5b243e32c4b02ce3",
            "name":"ISO 3166-1 numeric",
            "assetType":"CODELIST"
         },
         "modificationType":"UPDATE",
         "eventTime":"2023-03-07T09:18:19Z",
         "userName":"integration-test-admin"
      },
      {
         "asset":{
            "id":"6407014f5b243e32c4b02ce3",
            "name":"ISO 3166-1 numeric",
            "assetType":"CODELIST"
         },
         "modificationType":"UPDATE",
         "eventTime":"2023-03-07T09:18:17Z",
         "userName":"integration-test-admin"
      },
      {
         "asset":{
            "id":"6407014f5b243e32c4b02ce3",
            "name":"ISO 3166-1 numeric",
            "assetType":"CODELIST"
         },
         "modificationType":"UPDATE",
         "eventTime":"2023-03-07T09:18:09Z",
         "userName":"integration-test-admin"
      },
      {
         "asset":{
            "id":"6407014f5b243e32c4b02ce3",
            "name":"ISO 3166-1 numeric",
            "assetType":"CODELIST"
         },
         "modificationType":"CREATE",
         "fieldChanges":{
            "displayColumns":{
               "newValue":[
                  "Name"
               ]
            },
            "hierarchical":{
               "newValue":"false"
            },
            "levels":{
               "newValue":"1"
            },
            "name":{
               "newValue":"ISO 3166-1 numeric"
            },
            "termId":{
               "newValue":"6407004f6b19964cc917c7bf"
            }
         },
         "attributeChanges":{
            "Alpha2Code":{
               "name":{
                  "newValue":"Alpha2Code"
               },
               "type":{
                  "newValue":"String"
               },
               "required":{
                  "newValue":"false"
               }
            },
            "Alpha3Code":{
               "name":{
                  "newValue":"Alpha3Code"
               },
               "type":{
                  "newValue":"String"
               },
               "required":{
                  "newValue":"false"
               }
            },
            "Code":{
               "name":{
                  "newValue":"Code"
               },
               "type":{
                  "newValue":"String"
               },
               "required":{
                  "newValue":"true"
               }
            },
            "Description":{
               "name":{
                  "newValue":"Description"
               },
               "type":{
                  "newValue":"String"
               },
               "required":{
                  "newValue":"false"
               }
            },
            "Name":{
               "name":{
                  "newValue":"Name"
               },
               "type":{
                  "newValue":"String"
               },
               "required":{
                  "newValue":"true"
               }
            }
         },
         "eventTime":"2023-03-07T09:18:07Z",
         "userName":"integration-test-admin"
      }
   ]
}

Rename Saved Search

Table of Contents

Reference 360

Reference 360

Get history of a code list by time range

Get history of a code list by time range

GET request

GET request query parameters

GET response

GET example