---
id: "json_text"
kind: "datatype"
status: "draft"
is_pii: false
categories: ["software"]
langs: ["common"]
quality: 65
url: "https://registry.apicrafter.io/datatype/json_text"
---

# JSON document in a text field (`json_text`)

> **Draft.** Draft records have not been reviewed yet and may be incomplete or wrong; do not treat them as authoritative for legal or compliance decisions.

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.

- Personal data (PII): no
- Categories: Software development (software)
- Countries: global
- Languages: Common to most languages (common)

## Examples

- `[{"id": "BEL-469", "displayName": "S Mini"}]`
- `{"a": 1, "b": [2, 3]}`
- `{'a': 1}` (invalid example) — Python notation, not JSON

## Metacrafter rules

1 rules: 0 match the field name, 1 match values.

- `jsontextbyvalue` (data, `common/software.yaml`)

## Supported by tools

- `metacrafter`

## Sources

- wikipedia: <https://en.wikipedia.org/wiki/JSON>

## Quality

Score 65/100. Missing: regexp, mapping (Wikidata, Schema.org, ...), translation.

JSON: <https://registry.apicrafter.io/api/v1/datatypes/json_text.json> · Edit: <https://github.com/apicrafter/metacrafter-registry/edit/main/data/datatypes/any/software/json_text.yaml>