xBRL-JSON: mapping from Open Information Model 1.0

Candidate Recommendation 12 June 2019

Copyright © XBRL International Inc., All Rights Reserved.

This version:
<http://www.xbrl.org/Specification/xbrl-json/CR-2019-06-12/xbrl-json-CR-2019-06-12.html>
Editors:
Paul Warren, XBRL International Inc. <pdw@xbrl.org>
Herm Fischer, Mark V Systems Limited <fischer@markv.com>
Contributors:
Daniel Dracott, CoreFiling <djd@corefiling.com>
Mark Goodhand, CoreFiling <mrg@corefiling.com>
Eleanor Joslin, CoreFiling <ejj@corefiling.com>
Harald Schmitt, ABZ Reporting <harald.schmitt@abz-reporting.com>

Status

Circulation of this Candidate Recommendation is unrestricted. This document is normative. Other documents may supersede this document. Recipients are invited to submit comments to oim@xbrl.org, and to submit notification of any relevant patent rights of which they are aware and provide supporting documentation.

Abstract

This document defines xBRL-JSON, a standardised JSON-based representation of data in an XBRL Report. The format is defined in the form of mappings from the XBRL Open Information Model, a syntax-independent definition of the data represented by an XBRL v2.1 instance document.

Table of Contents

1 Introduction
1.1 Terminology
1.2 Documentation conventions
1.2.1 Error codes
1.2.2 JSON mapping documentation conventions
1.3 Namespaces and namespace prefixes
1.4 URIs and URI aliases
1.5 Validation
2 Identifiers in xBRL-JSON
3 JSON representation constraints
4 Extensibility
5 XBRL Report Model
5.1 Facts
5.2 Dimensions
5.3 Links
6 Features
6.1 Standard features
6.1.1 The Canonical Values feature

Appendices

A References
B Intellectual property status (non-normative)
C Document History (non-normative)
D Errata Corrections incorporated in this document

Tables

1 Namespaces and namespace prefixes
2 URIs and URI aliases

Examples

1 JSON example: fact
2 JSON example: period dimension (duration)
3 JSON example: period dimension (instant)
4 JSON example: unit dimension (US dollars per share)
5 JSON example: language dimension
6 JSON example: taxonomy-defined dimensions
7 JSON example: a text footnote
8 JSON example: a fact footnote

Definitions

Canonical form
Dimensions (JSON Object)
Document info (JSON Object)
Fact (JSON Object)
Facts (JSON Object)
Feature
Features (JSON Object)
Link group (JSON Object)
Link groups (JSON object)
Link types (JSON object)
Links (JSON Object)
Namespaces (JSON object)
Report (JSON Object)
Space-separated list
URI map (JSON Object)

Error codes

xbrlje:invalidCharacterEncoding
xbrlje:invalidJSONMemberType
xbrlje:invalidJSONStructure 2 3 4 5
xbrlje:invalidURIMap
xbrlje:invalidUnitString
xbrlje:unboundPrefix
xbrlje:unknownLinkGroup
xbrlje:unknownLinkType


1 Introduction

1.1 Terminology

The key words MUST, MUST NOT, REQUIRED, SHALL, SHALL NOT, SHOULD, SHOULD NOT, RECOMMENDED, MAY, and OPTIONAL, in this specification, are to be interpreted as described in [IETF RFC 2119].

The keywords expanded name, NCName and QName are to be interpreted as described in the XML Names specification [XML Names].

The keywords report, numeric fact, text fact and enumeration fact are to be interpreted as described in the Open Information Model specification [OIM].

The keywords SQName, prefix, prefix map and unit string representation are to be interpreted as described in the OIM Common Definitions specification [OIMCOMMON].

The keywords canonical lexical representation are to be interpreted as described in the XML Schema Part 2 specification [XML Schema Datatypes].

The keywords member and object are to be interpreted as described in the JavaScript Object Notation specification [JSON].

1.2 Documentation conventions

1.2.1 Error codes

QNames in parenthetical red text after a "MUST" or "MUST NOT" statement prescribe standardised error codes to be used if the preceding condition is violated.

1.2.2 JSON mapping documentation conventions

This document is intended to define a bi-directional mapping between the Open Information Model and an xBRL-JSON document. The transformation from xBRL-JSON back to the model not explicitly described, but may be inferred from the model to JSON mappings, taken in conjunction with the constraints defined in the Open Information Model, and those defined in the XBRL v2.1 [XBRL 2.1] and XBRL Dimensions v1.0 [DIMENSIONS] specifications applied to the xBRL-XML representation of that model.

The mapping is defined as a series of tables describing JSON objects that represent components in the XBRL Open Information Model [OIM].

Tables define the members of JSON objects. The table lists the name of each member, the JSON value type, and a description of how the value is obtained from the model. Where a key is denoted as "(required)" it MUST be present in each occurrence of the object (xbrlje:invalidJSONStructure).

Each value within a JSON Object MUST have the specified JSON value type (xbrlje:invalidJSONMemberType).

References to components defined by the Open Information Model [OIM] are denoted by curly braces, e.g. {facts}.

1.3 Namespaces and namespace prefixes

This specification makes use of QName notation to refer to XML expanded names (the combination of a namespace URI and a localname, and the xBRL-JSON format make use of abbreviated forms for these identifiers. The prefixes used by this specification are shown in the table below.

The xBRL-JSON format also makes use of both the QName and SQName format. All prefixes defined in the table below are reserved prefixes as described in [OIMCOMMON].

Table 1: Namespaces and namespace prefixes
Prefix Namespace URI
xbrl http://www.xbrl.org/CR/2019-06-12
xbrli http://www.xbrl.org/2003/instance
xsd http://www.w3.org/2001/XMLSchema
xbrljehttp://www.xbrl.org/CR/2019-06-12/xbrl-json/error

1.4 URIs and URI aliases

The xBRL-JSON format make use of URI aliases as an abbreviated representation of URIs, as described in [OIMCOMMON]. The table below defines reserved URI aliases for the link types and link groups URI maps.

Table 2: URIs and URI aliases
URI alias URI
footnote http://www.xbrl.org/2003/arcrole/fact-footnote
explanatoryFact http://www.xbrl.org/2009/arcrole/fact-explanatoryFact
defaultGroup http://www.xbrl.org/2003/role/link

1.5 Validation

A processor that consumes xBRL-JSON documents MUST raise an error with the specified error code if the document does not conform to the constraints defined in this specification. Additionally, such a processor MUST perform the validation required of a conformant processor, as defined in the Open Information Model [OIM]. A processor MAY apply the validation required of a validating conformant processor.

2 Identifiers in xBRL-JSON

xBRL-JSON makes use of QNames to represent expanded names and SQNames to represent some other values. The prefix map for resolving QNames and SQNames is provided by the namespaces object. Any prefixes used in a QName or SQName MUST be defined in the prefix map (xbrlje:unboundPrefix).

3 JSON representation constraints

RFC 7159 [JSON] does not prohibit a JSON object from having multiple occurrences of the same key, but states that behaviour of such objects is unpredictable. In order to avoid interoperability issues, objects within JSON documents conforming to this specification MUST have unique keys (xbrlje:invalidJSONStructure).

xBRL-JSON reports MUST use the UTF-8 character encoding (xbrlje:invalidCharacterEncoding), and MAY include a Unicode Byte Order Mark, although this is neither required nor recommended.

4 Extensibility

In order to facilitate the inclusion of additional information within an xBRL-JSON report, additional properties beyond those defined in this specification MAY be included within the following objects:

Additional properties MUST NOT be included elsewhere (xbrlje:invalidJSONStructure).

Unless defined in a specification published by XBRL International, any such additional properties included in the above objects MUST have names that are QName values (xbrlje:invalidJSONStructure), and MUST have a prefix that identifies a namespace that does not use the xbrl.org domain name (xbrlje:invalidJSONStructure).

The content of any such additional properties is not constrained by this specification.

5 XBRL Report Model

The section describes how each component defined in the Open Information Model is mapped to a corresponding JSON representation.

An xBRL-JSON document consists of a report object, as defined below.

JSON Object: Report
This object represents an OIM report component.
Members:
facts (object)
(required) A facts object.
documentInfo (object)
(required) A document info object.
JSON Object: Document info

The document info object contains metadata information necessary to correctly process the rest of the document.

Members:
documentType (string)
(required) This property MUST be present with the value "http://www.xbrl.org/CR/2019-06-12/xbrl-json", and identifies the document as being a report covered by this specification.
features (object)
(required) A features object.
namespaces (object)
(required) A URI map object defining the prefix map for QName and SQName values in this report (see Section 2).
linkTypes (object)
(optional) A URI map object defining URI aliases used to identify link types in this report.
linkGroups (object)
(optional) A URI map object defining URI aliases used to identify link groups in this report.
taxonomy (array)
(required) An array of URLs corresponding to the {href} properties of the members of the {dts-references} property for the {report}.
JSON Object: Features

The features object is used to indicate that the document conforms to additional constraints, beyond those required for xBRL-JSON itself. For example, it can be used to indicate that all values are represented in their canonical form. See Section 6 for more information, including the standard features defined by this specification.

Members:
name
A QName corresponding to the name of the feature.
value (any)
Any JSON value, indicating the state of the feature. A value of false is equivalent to omitting the property, and indicates that the feature is disabled. Any other value indicates that the feature is enabled. Values other than true may be used to indicate specific additional properties of the feature.
JSON Object: URI map

A JSON object providing a map of URI aliases to full URIs. The URI map MUST conform to the constraints defined in [OIMCOMMON] for URI maps (xbrlje:invalidURIMap).

Members:
name
The URI alias to be defined.
value (string)
The URI to be associated with the URI alias [URI].

5.1 Facts

JSON Object: Facts

The {facts} property of a {report} is represented by an object containing members of the following form:

Members:
name
The value of the {id} property of the fact.
value (object)
A fact object.
JSON Object: Fact

A fact component is represented by an object with the following members.

Members:
value (string)

(required) The value of the {value} property of the fact in a lexical representation that is valid according to the XML Schema datatype [XML Schema Datatypes], or in the case of nil-valued facts, the JSON literal null.

Facts of type xsd:QName and enumeration facts are expressed as QNames, and MUST use a prefix that is defined in the namespaces object. In the case of set-valued enumeration facts, the value is a space-separated list of QNames.

decimals (number)
The value of the {decimals} property, or absent if the value is infinitely precise or not applicable (for non-numeric facts).
dimensions (object)
(required) An dimensions object with properties corresponding to the members of the {dimensions} property.
links (object)
A links object, cormesponding to the link groups associated with the fact. This member MUST be absent if there are no link groups associated with the fact.

A space-separated list is a string containing items that are separated by a single space character (unicode 0x20). The list MUST NOT contain sequences of more than one space character, or space characters at the beginning or end of the string.

Example 1: JSON example: fact

{ "f923": { "value": "1234", "dimensions": { "concept": "tax:NumericConcept", "entity": "cid:123456789", "period": "2015-01-01T00:00:00/2016-01-01T00:00:00", "unit": "iso4217:GBP", "tax:RegionDimension": "tax:Europe" } } }

5.2 Dimensions

JSON Object: Dimensions

This object represents the dimensions associated with a fact. Each property of the object corresponds to an dimension. For core dimensions, the name of the property is a simple string, as documented below. For taxonomy-defined dimensions the property name is a QName.

Members:
concept (string)
(required) The {value} property of the concept core dimension expressed as a QName.
entity (string)
An SQName representing the {scheme} and {identifier} properties of the entity core dimension as the URI and localpart, respectively.
period (string)

If the {interval} property denotes a duration of non-zero length then ISO 8601 date time representations of the start and end of that duration, separated by the "/" character, otherwise, a single ISO 8601 date time representation of the instant denoted by the {interval} property. See Example 2 and Example 3.

The date time representations used in this property MUST be valid according to the xsd:dateTime datatype. It should be noted that unlike the xbrli:dateUnion type used in xBRL-XML, the xsd:dateTime datatype used here does not allow the time component to be omitted.

unit (string)
A value corresponding to the unit string representation of the unit core dimension component. See Example 4. The value MUST be a valid unit string representation (xbrlje:invalidUnitString).
language (string)
The value of the {language} property of the language core dimension. See Example 5.
noteId (string)
The value of the {id} property of the note ID core dimension. See Example 7.
Any QName (string)

Any taxonomy-defined dimensions on the fact are included as properties with a name corresponding to the {name} property of the dimension, expressed as a QName. The value is the {value} property of the taxonomy-defined dimension expressed in a lexical representation that is valid according to the XML Schema datatype of the dimension, or in the case of nil-valued dimensions, the JSON literal null. See Example 6.

Dimensions of type xsd:QName are expressed as QNames, and MUST use a prefix that is defined in the namespaces object.

Example 2: JSON example: period dimension (duration)

"period": "2017-01-01T00:00:00/2018-01-01T00:00:00"

Example 3: JSON example: period dimension (instant)

"period": "2018-01-01T00:00:00"

Example 4: JSON example: unit dimension (US dollars per share)

"unit": "iso4217:USD/xbrli:shares"

Example 5: JSON example: language dimension

"language": "en-US"

Example 6: JSON example: taxonomy-defined dimensions

"tax:RegionDimension": "tax:Europe", "tax:CounterPartyLEI": "254900ARU0VC1WY6GJ71"

5.3 Links

JSON Object: Links
This object represents the link groups associated with an OIM fact.
Members:
name
A URI alias for the {link type} OIM property for the link group. The URI alias MUST be defined in the link types object (xbrlje:unknownLinkType).
value (object)
A link group object.
JSON Object: Link group
A link group object represents the link group OIM component.
Members:
name
A URI alias for the {group} OIM property. The URI alias MUST be defined in the linkGroups object (xbrlje:unknownLinkGroup).
value (array)
An array of the {id} properties for the facts that are the targets of the relationships in this link group.

Example 7: JSON example: a text footnote

{ "f923": { "value": "1234", "dimensions": { "concept": "tax:NumericConcept", "entity": "cid:123456789", "period": "2015-01-01T00:00:00/2016-01-01T00:00:00", "unit": "iso4217:GBP", }, "links": { "footnote": { "defaultGroup": [ "f123", "f456" ] } } }, "f123": { "value": "This is an <b>important</b> footnote", "dimensions": { "concept": "xbrl:note", "noteId": "f123", "language": "en" }, } "f456": { "value": "This is a second footnote", "dimensions": { "noteId": "f456", "concept": "xbrl:note", "language": "en" }, } }

Example 8: JSON example: a fact footnote

{ "f923": { "value": "1234", "dimensions": { "concept": "tax:NumericConcept", "entity": "cid:123456789", "period": "2015-01-01T00:00:00/2016-01-01T00:00:00", "unit": "iso4217:GBP" }, "links": { "explanatoryFacts": { "defaultGroup": [ "f924" ] } } }, "f924": { "value": "Some text explaining the other fact", "dimensions": { "concept": "tax:StringConcept", "entity": "cid:123456789", "period": "2014-01-01T00:00:00/2015-01-01T00:00:00", } } }

6 Features

The features mechanism allows an xBRL-JSON document to assert that it conforms to additional constraints beyond those required by this specification. This can be used by consuming software to safely make simplifying assumptions about how data can be processed.

A feature is a specific property of the document, identified by an expanded name. This specification defines standard features. Additional features MAY be defined by other specifications. Such specifications that are not published by XBRL International MUST NOT use a namespace that uses the xbrl.org domain name.

6.1 Standard features

This specification defines a single feature, the Canonical Values feature.

6.1.1 The Canonical Values feature

The Canonical Values feature is identified by the QName xbrl:canonicalValues, and takes a simple boolean value to indicate its enablement.

An xBRL-JSON document that declares this feature MUST use the canonical form for the following values:

  • the values of properties of dimensions objects; and
  • the values of the value property of fact objects.

The canonical form of a value is the canonical lexical representation [XML Schema Datatypes] for the value's datatype, with the following special cases:

  • The period dimension should be treated as either a single xsd:dateTime value or a pair of xsd:dateTimes separated by the "/" character.
  • The language dimension, and any other values with a datatype of, or derived from, xsd:language, MUST be respresented as lowercase strings.

Appendix A References

DIMENSIONS
XBRL International Inc.. "XBRL Dimensions 1.0"
Ignacio Hernández-Ros
, and Hugh Wallis.
(See http://www.xbrl.org/Specification/XDT-REC-2006-09-18.htm)
IETF RFC 2119
IETF (Internet Engineering Task Force). "RFC 2119: Key words for use in RFCs to Indicate Requirement Levels"
Scott Bradner.

(See http://www.ietf.org/rfc/rfc2119.txt)
JSON
Internet Engineering Task Force. "The JavaScript Object Notation (JSON) Data Interchange Format"
(See https://tools.ietf.org/html/rfc7159)
OIM
XBRL International Inc.. "XBRL Open Information Model"
Paul Warren.

(See https://specifications.xbrl.org/release-history-open-information-model-oim.html)
OIMCOMMON
XBRL International Inc.. "XBRL Open Information Model Common Definitions"
Herm Fischer
, Mark Goodhand, and Paul Warren.
(See https://specifications.xbrl.org/release-history-open-information-model-oim-common.html)
URI
IETF (Internet Engineering Task Force). "RFC 3986: Uniform Resource Identifier (URI): Generic Syntax"
T. Berners-Lee
, L. Masinter, and R. Fielding.
(See http://tools.ietf.org/html/rfc3986)
XBRL 2.1
XBRL International Inc.. "Extensible Business Reporting Language (XBRL) 2.1 Includes Corrected Errata Up To 2013-02-20"
Phillip Engel
, Walter Hamscher, Geoff Shuetrim, David vun Kannon, and Hugh Wallis.
(See http://www.xbrl.org/Specification/XBRL-2.1/REC-2003-12-31/XBRL-2.1-REC-2003-12-31+corrected-errata-2013-02-20.html)
XML Names
W3C (World Wide Web Consortium). "Namespaces in XML 1.0 (Third Edition)"
(See http://www.w3.org/TR/2009/REC-xml-names-20091208)
XML Schema Datatypes
W3C (World Wide Web Consortium). "XML Schema Part 2: Datatypes Second Edition"
Paul V. Biron
, and Ashok Malhotra.
(See http://www.w3.org/TR/xmlschema-2/)

Appendix B Intellectual property status (non-normative)

This document and translations of it may be copied and furnished to others, and derivative works that comment on or otherwise explain it or assist in its implementation may be prepared, copied, published and distributed, in whole or in part, without restriction of any kind, provided that the above copyright notice and this paragraph are included on all such copies and derivative works. However, this document itself may not be modified in any way, such as by removing the copyright notice or references to XBRL International or XBRL organizations, except as required to translate it into languages other than English. Members of XBRL International agree to grant certain licenses under the XBRL International Intellectual Property Policy (www.xbrl.org/legal).

This document and the information contained herein is provided on an "AS IS" basis and XBRL INTERNATIONAL DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO ANY WARRANTY THAT THE USE OF THE INFORMATION HEREIN WILL NOT INFRINGE ANY RIGHTS OR ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.

The attention of users of this document is directed to the possibility that compliance with or adoption of XBRL International specifications may require use of an invention covered by patent rights. XBRL International shall not be responsible for identifying patents for which a license may be required by any XBRL International specification, or for conducting legal inquiries into the legal validity or scope of those patents that are brought to its attention. XBRL International specifications are prospective and advisory only. Prospective users are responsible for protecting themselves against liability for infringement of patents. XBRL International takes no position regarding the validity or scope of any intellectual property or other rights that might be claimed to pertain to the implementation or use of the technology described in this document or the extent to which any license under such rights might or might not be available; neither does it represent that it has made any effort to identify any such rights. Members of XBRL International agree to grant certain licenses under the XBRL International Intellectual Property Policy (www.xbrl.org/legal).

Appendix C Document History (non-normative)

DateAuthorDetails
04 June 2015Paul Warren

First Public Working Draft

14 December 2016Paul Warren

Candidate Recommendation

02 May 2017Paul Warren

Second Candidate Recommendation

12 December 2018Paul Warren

Third Candidate Recommendation

12 June 2019Paul Warren

Fourth Candidate Recommendation

Appendix D Errata Corrections incorporated in this document

This appendix contains a list of the errata that have been incorporated into this document. This represents all those errata corrections that have been approved by the XBRL International Specification Maintenance Working Group (SWG) up to and including 12 June 2019. Hyperlinks to relevant e-mail threads may only be followed by those who have access to the relevant mailing lists. Access to internal XBRL mailing lists is restricted to members of XBRL International Inc.

No errata have been incorporated into this document.