Formatted CSV Responses

Overview

Most API requests allow setting the format to CSV. CSV responses only return a subset of fields formatted for readability and sharing. For a full export of data, you should use JSON Exports. This page describes the syntax of CSV exports for each resource type.

  • Users

  • Organizations

  • Sources

  • Collections

  • Repository Versions

  • Concepts

  • Mappings

  • References

Content below is out of date!

Users

Columns - excludes extras and navigation URLs

  • type

  • uuid

  • username

  • company

  • location

  • email

  • preferred_locale

  • website

  • url

  • orgs

  • public_collections

  • public_sources

  • created_on

  • created_by

  • updated_on

  • updated_by

Organizations

Columns - excludes extras, short_code, and navigation URLs

  • type

  • id

  • uuid

  • external_id

  • url

  • name

  • company

  • website

  • location

  • public_access

  • members - CSV - “username”

  • public_collecions

  • public_sources

  • created_on

  • created_by

  • updated_on

  • updated_by

Organization Members

Columns - excludes ??

Sources

Columns - excludes extras, short_code, and navigation URLs

  • type

  • id

  • uuid

  • external_id

  • url

  • name

  • full_name

  • source_type

  • public_access

  • default_locale

  • supported_locales

  • website

  • description

  • owner

  • owner_type

  • owner_url

  • versions

  • active_concepts

  • active_mappings

  • created_on

  • created_by

  • updated_on

  • updated_by

Collections

Columns - excludes extras, short_code, and navigation URLs

  • type

  • id

  • uuid

  • external_id

  • url

  • name

  • full_name

  • collection_type

  • public_access

  • default_locale

  • supported_locales

  • website

  • description

  • owner

  • owner_type

  • owner_url

  • versions

  • active_concepts

  • active_mappings

  • created_on

  • created_by

  • updated_on

  • updated_by

Repository Versions

Columns - excludes extras, root/previous/parent urls

  • type - e.g. “Source Version” or “Collection Version”

  • id

  • external_id

  • url

  • released

  • retired (if implemented)

  • description

  • created_on

  • created_by

  • updated_on

  • updated_by

Mappings

Simplified

  • from_concept - [:owner]:[:source]:[:fromConceptCode]

  • map_type

  • to_concept - [:owner]:[:source]:[:toConceptCode]

  • to_concept_name (if available)

  • internal_external - “Internal” or “External” mapping?

  • owner

  • owner_type

  • owner_url

  • url (for the mapping)

Columns - excludes extras

  • type

  • uuid

  • external_id

  • url

  • retired

  • map_type

  • from_source_owner

  • from_source_owner_type

  • from_source_name

  • from_concept_code

  • from_concept_name

  • from_concept_url

  • to_source_owner

  • to_source_owner_type

  • to_source_name

  • to_concept_code

  • to_concept_name (optional)

  • to_concept_url (only present if “internal” mapping)

  • internal_external - “Internal” or “External” mapping?

  • owner

  • owner_type

  • owner_url

  • source

  • created_on

  • created_by

  • updated_on

  • updated_by

Concepts

Columns - excludes extras, navigation URLs

  • type

  • id

  • uuid

  • external_id

  • url

  • concept_class

  • datatype

  • retired

  • display_name

  • display_locale

  • names: CSV - “name [locale] [name type]”

  • descriptions: CSV - “description [locale] [description type]”

  • mappings: CSV of direct mappings stored in same source with map_type, to_concept ([:owner]:[:source]:[:toConceptCode]), to_concept_name (if available), and internal/external flag

  • owner

  • owner_type

  • owner_url

  • source

  • concept_version = version

  • versions

  • created_on

  • created_by

  • updated_on

  • updated_by