Skip to main content
Solved

Automating Group ID Retrieval via ONE Metadata Reader


Forum|alt.badge.img

Hi everyone! I’m currently working on importing terms from ONE Desktop into the ONE web application, and everything’s been going smoothly so far. However, I am running into some challenges related to the Groups metadata. 

Right now, we're using an excel reader, reading a reference table that contains our organization’s existing Group names and the Group IDs, and joining that to a glossary term intake spreadsheet. However, our organization is expected to create many more stewardship groups, and the current excel spreadsheet containing the group names and IDs will have to be updated each time a new group is created which can be timely and error-prone.  

I wanted to test how we could reference Groups, especially when working with glossary term intake spreadsheets that list Group names but not their corresponding IDs. At the moment, I'm trying to read the Group entity type in the ONE Metadata Reader, which works well but the only output I can find is the Parent Group ID, rather than the required child Group IDs. The screenshots provided are the ONE Metadata Reader, reading the Group entity, and the only available attributes I can read.

Ideally, we’d like to have all the group names, and their corresponding ID extracted so that we don’t have to manually update a Group reference table. I’m wondering if anyone has found a way to resolve this, especially within the ONE Metadata reader? 

Any insights would be hugely appreciated!  

 

Best answer by anna.spakova

Hi ​@bobparry ,

thank you for your question. To get ID of the entity you are reading using ONE Metadata Reader, you need to populate the Id Column Name field:

You will create an empty column using e.g. Alter format step, you can call the column e.g. groupId and put it here → the ID will be populated into this column.

The additional columns are not necessary but might be useful in some cases as well:

  • Entity Column Name tells you what subtype the entity is (e.g. businessTerm as a subtype of term)
  • Parent Id Column Name - ID of the parent entity - for example in case of reading attributes, this would give you ID of the parent Catalog Item.

Let me know if this helps or you need a further guidance.

Kind regards,

Anna

View original
Did this topic help you find an answer to your question?

3 replies

anna.spakova
Ataccamer
Forum|alt.badge.img+3
  • Ataccamer
  • 169 replies
  • Answer
  • July 14, 2025

Hi ​@bobparry ,

thank you for your question. To get ID of the entity you are reading using ONE Metadata Reader, you need to populate the Id Column Name field:

You will create an empty column using e.g. Alter format step, you can call the column e.g. groupId and put it here → the ID will be populated into this column.

The additional columns are not necessary but might be useful in some cases as well:

  • Entity Column Name tells you what subtype the entity is (e.g. businessTerm as a subtype of term)
  • Parent Id Column Name - ID of the parent entity - for example in case of reading attributes, this would give you ID of the parent Catalog Item.

Let me know if this helps or you need a further guidance.

Kind regards,

Anna


Forum|alt.badge.img
  • Author
  • Data Voyager
  • 14 replies
  • July 16, 2025

Hi Anna! Thank you for your answer! Adding the groupID helped to retrieve all the missing groups! I used it as for the stewardship expression for the Metadata writer and it referenced the existing groups perfectly into the One Web Application. No need to manually add new Id numbers there! 

Thanks so much!  


anna.spakova
Ataccamer
Forum|alt.badge.img+3

Hi ​@bobparry ,

 

thank you for confirmation, I am happy it works :)

Kind regards,

Anna


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings