Purview - Importing terms with custom attributes of type Integer Classic Glossary

Ana Martínez 0 Reputation points
2026-03-17T15:54:57.4+00:00 
When we import terms into the Enterprise Glossary (classic types) with metadata defined as integers, and that metadata in the CSV is empty, Purview adds that metadata with zeros, and I need it to leave it blank.
Microsoft Security | Microsoft Purview

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  5. AI answer

    2026-03-17T15:55:12.75+00:00

    Classic Microsoft Purview glossary import only supports the column types and behaviors defined in the selected term template. For numeric custom attributes (such as Integer), an empty value in the CSV is interpreted as the default for that data type, which results in 0 being stored rather than a blank.

    The import pipeline does not expose an option to change this behavior or to treat empty numeric cells as NULL/blank. The only supported way to have a truly blank value is to use an attribute type that allows empty text (for example, a Text custom attribute) instead of an Integer, or to avoid including that column in the CSV for terms where it should remain unset.

    If the attribute must remain numeric for other terms, the behavior cannot be changed via CSV import in the classic glossary; post‑import manual edits or a different attribute design (for example, a Text attribute that is interpreted as a number downstream) are required.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.