Reference 360

Back Next

Get history of a reference data set by time range (v2)

Retrieves all the change events of a reference data set for a specific time range based on the internal ID or alias.

GET request

To retrieve all the change events of a reference data set for a specific time range based on an internal ID or alias, submit a GET request with the following URI:

/rdm-service/external/v2/rds/{assetKey}/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
assetKey	Internal ID or alias of the reference data set. When you provide an invalid assetKey in the request URL, the rds version 2 REST API returns an error if the request contains invalid internal IDs or aliases.
from	Start date and time of the time range, which is inclusive. Time range must be in the following ISO-8601 format: yyyy-MM-dd'T'HH:mm:ss'Z'. For example, you might use 2019-12-12T14:04:04Z .
to	End date and time of the time range, which is exclusive. Time range must be in the following ISO-8601 format: yyyy-MM-dd’T’HH:mm:ss’Z'. For example, you might use 2019-12-15T14:04:04Z .
page	Optional. Page number to display. Default is 0 .
pageSize	Optional. Number of records to display per page. Default value is 100 . Maximum value is 10000 .
modificationType	Optional. Type of modification. Value can be CREATE, UPDATE, or DELETE.

GET response

The response contains the change events of a reference data set for a specific time range.

The following table describes the attributes in the response body:

Attribute	Type	Description
pageSize	Number	The number of records displayed on each page.
page	Number	Page number displayed.
numberOfElements	Number	Total number of reference data sets found.
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 reference data set.
id	String	ID of the reference data set.
name	String	Name of the reference data set.
internalId	String	Unique identifier of the reference data set.
alias	String	Alternative identifier of the reference data set.
assetType	String	Type of reference data asset.
modificationType	String	The type of change made to the reference data set. Value can be CREATE, UPDATE, or DELETE.
fieldChanges	Object	Includes details about the previous and new values of the fields with changes.
attributeChanges	Object	Includes details about the previous and new values of the attributes with changes.
eventTime	String	Date and time when the reference data set was last updated.
userName	String	User name of the user who initiated the modification.

GET example

To retrieve all the change events of a reference data set for a specific time range based on the internal ID or alias, you might use the following request:

GET https://use4-mdm.dm-us.informaticacloud.com/rdm-service/external/v2/rds/country/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 reference data set 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: 4803
{
  "pageSize": 100,
  "page": 0,
  "numberOfElements": 9,
  "lastPage": true,
  "firstPage": true,
  "content": [
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Country",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "UPDATE",
      "fieldChanges": {
        "confidentiality": {
          "newValue": {
            "key": "PublicKey",
            "label": "Public"
          }
        },
        "domain": {
          "newValue": {
            "key": "GeographyKey",
            "label": "Geography"
          }
        },
        "effectiveDate": {
          "newValue": "2023-03-05"
        },
        "priority": {
          "newValue": {
            "key": "Priority3",
            "label": "Medium"
          }
        },
        "status": {
          "newValue": {
            "key": "ActiveKey",
            "label": "Active"
          }
        }
      },
      "eventTime": "2023-03-07T09:28:08Z",
      "userName": "integration-test-admin"
    },
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Country",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "UPDATE",
      "fieldChanges": {
        "name": {
          "previousValue": "Countary",
          "newValue": "Country"
        }
      },
      "eventTime": "2023-03-07T09:17:46Z",
      "userName": "integration-test-admin"
    },
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Countary",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "UPDATE",
      "eventTime": "2023-03-07T09:15:28Z",
      "userName": "integration-test-admin"
    },
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Countary",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "UPDATE",
      "attributeChanges": {
        "Alpha3Code": {
          "name": {
            "newValue": "Alpha3Code"
          },
          "type": {
            "newValue": "String"
          },
          "required": {
            "newValue": "false"
          }
        }
      },
      "eventTime": "2023-03-07T09:14:47Z",
      "userName": "integration-test-admin"
    },
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Countary",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "UPDATE",
      "attributeChanges": {
        "Alpha2Code": {
          "name": {
            "newValue": "Alpha2Code"
          },
          "type": {
            "newValue": "String"
          },
          "required": {
            "newValue": "false"
          }
        }
      },
      "eventTime": "2023-03-07T09:14:37Z",
      "userName": "integration-test-admin"
    },
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Countary",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "UPDATE",
      "eventTime": "2023-03-07T09:13:55Z",
      "userName": "mdm-rdm-service"
    },
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Countary",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "UPDATE",
      "eventTime": "2023-03-07T09:13:54Z",
      "userName": "integration-test-admin"
    },
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Countary",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "UPDATE",
      "fieldChanges": {
        "defaultList": {
          "newValue": "6407004f5b243e32c4b02bb8"
        }
      },
      "eventTime": "2023-03-07T09:13:54Z",
      "userName": "integration-test-admin"
    },
    {
      "asset": {
        "id": "6407004f6b19964cc917c7bf",
        "name": "Countary",
        "internalId": "country",
        "alias": "als_country",
        "assetType": "REFERENCEDATASET"
      },
      "modificationType": "CREATE",
      "fieldChanges": {
        "description": {
          "newValue": "A Business Term named Country"
        },
        "displayColumns": {
          "newValue": [
            "Name"
          ]
        },
        "hierarchical": {
          "newValue": "false"
        },
        "levels": {
          "newValue": "1"
        },
        "name": {
          "newValue": "Countary"
        }
      },
      "attributeChanges": {
        "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:13:51Z",
      "userName": "integration-test-admin"
    }
  ]
}

Rename Saved Search

Table of Contents

Reference 360

Reference 360

Get history of a reference data set by time range (v2)

Get history of a reference data set by time range (v2)

GET request

GET request query parameters

GET response

GET example