Skip to main content
Solved

How to Export Business Term History / Version History from Ataccama ONE

  • May 18, 2026
  • 2 replies
  • 38 views
S
Data Pioneer

Hello,

I am trying to export the information displayed in the “History” tab of Glossary / Business Terms in Ataccama ONE using the ONE Metadata Reader component.

On the Business Term page in the UI, the History tab displays details such as:

  • Version number
  • Published on date/time
  • Published by user

It also shows when a term was newly created or updated, including the timestamp and the name of the user who made the change, similar to an audit/history log.

I would like to export this information together with my glossary/business term metadata.

However, in the ONE Metadata Reader, I can only see the standard business term attributes, and I cannot find any entities or columns related to:

  • history
  • version history
  • revisions
  • published by
  • published on
  • audit information

I am therefore trying to understand where this information is stored and how it can be exported.

Could you please clarify:

  1. Which entity/table/object stores the data displayed in the History tab?
  2. Is this history/version information accessible through the ONE Metadata Reader?
  3. If not, what is the recommended way to export Business Terms together with their version history/publication history?

Best answer by Albert de Ruiter

Hi ​@Susan24us ,

You can retrieve the information by adding a json call step after the metadata reader. In the json call step you can use the following query

{"query":"query getDetails {
    businessTerm(gid: \"#ID#\") {
        gid
        publishedVersion {
           name
            _effectiveFrom {
                id
                timestamp
                author {
              ... on Person {
                firstName
                lastName
               }
              }
            }
        }
    }
}"}

You can retrieve the ‘ID’ from the metadata reader. The path of the data stream (in ‘Reader') is $.data.businessTerm.

Best regards,

Albert

2 replies

Albert de Ruiter
Rocket Pioneer L1
Forum|alt.badge.img+4

Hi ​@Susan24us ,

You can retrieve the information by adding a json call step after the metadata reader. In the json call step you can use the following query

{"query":"query getDetails {
    businessTerm(gid: \"#ID#\") {
        gid
        publishedVersion {
           name
            _effectiveFrom {
                id
                timestamp
                author {
              ... on Person {
                firstName
                lastName
               }
              }
            }
        }
    }
}"}

You can retrieve the ‘ID’ from the metadata reader. The path of the data stream (in ‘Reader') is $.data.businessTerm.

Best regards,

Albert

S
Data Pioneer
  • Susan24usData Pioneer
  • Author
  • Data Pioneer
  • May 31, 2026

Hello Albert,

Thank you again for your earlier guidance. I was able to resolve the initial issue and successfully call the GetEntityHistoryListing_term GraphQL query from a JSON Call step in ONE Desktop.

I am now able to retrieve history records for Business Terms and have successfully parameterized the query so that it returns history for all terms. However, I am struggling to derive the correct "Created Date" and "Last Modified Date" values.

My goal is to produce a single row per Business Term containing:

  • Business Term Name
  • Created Date
  • Created By
  • Last Modified Date
  • Last Modified By

The challenge I am facing is that the values returned by the history query do not seem to align with what is displayed in the ONE UI.

For example, for the term "Absenteeism", the History tab in the UI shows that the earliest version available dates back to September 14, 2025. However, when I query the history data and use the timestamp fields returned by the response, I am getting May 26, 2026, which appears to correspond to the most recent modification rather than the original creation date.

The query I am currently using is:

{
  "query": "query GetEntityHistoryListing_term { term(gid: \"#Id#\") { nodePath history(skip: 0, size: 1) { edges { node { _from { id timestamp author { numericalIdentifier ... on Person { username firstName lastName email userId } } } _effectiveFrom { id timestamp author { numericalIdentifier ... on Person { username firstName lastName email userId } } } _displayName _draftType } } totalCount } } }"
}

To try to derive the Created Date and Last Modified Date, I also added an Aggregating Column Assigner in my ONE Desktop plan. My assumption was that the history records are returned in chronological order, allowing me to identify the earliest timestamp as the creation date and the latest timestamp as the modification date. However, the resulting values still do not match what is shown in the UI, which makes me think I may be using the wrong history fields or misunderstanding how the history records are represented.

Could you please advise:

  1. Which field in the GetEntityHistoryListing_term response should be used to determine the original creation date of a Business Term?
  2. Is _from.timestamp the correct field, or should another history field be used?
  3. What is the recommended approach to derive:
    • Created Date / Created By
    • Last Modified Date / Last Modified By
  4. Is there a field that directly identifies the first published version or original creation event for a term?
  5. Does the History tab in the UI use the same GraphQL fields, or is there additional logic applied to determine the earliest version displayed?

Based on the information shown in the UI, I would expect the Created Date for Absenteeism to be September 14, 2025, but I have not yet been able to identify which field in the GraphQL response corresponds to that value.

Any guidance on the correct history fields or recommended approach would be greatly appreciated.

Best regards,

 

Community Terms of Use & ConditionsAccessibility statement