Datatypes

JSON document in a text field

ID json_text

DatatypeNot PIIDraft

This record is a draft: it has not been reviewed yet and may be incomplete or wrong. Do not rely on it for compliance decisions. Help improve it (see CONTRIBUTING.md).

JSON object or array stored as text in one field of a table or a record, as exports of APIs and databases write nested values: [{"id": "BEL-469", "displayName": "S Mini"}]. A GeoJSON geometry is geojson.

Categories
Software development
Countries
Global (not tied to a country)
Languages
Common to most languages
Quality
65/100 · missing: regexp, mapping (Wikidata, Schema.org, ...), translation
Metacrafter rules
1 rule (0 by field name, 1 by value)
Supported by tools
metacrafter

Examples

ValueDescription
[{"id": "BEL-469", "displayName": "S Mini"}]
{"a": 1, "b": [2, 3]}
{'a': 1} invalidPython notation, not JSON

Sources

Use this record