> For the complete documentation index, see [llms.txt](https://docs.coherent.global/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coherent.global/build-spark-services/additional-mappings/json-structures-xrichoutput.md).

# JSON structures (Xrichoutput)

{% hint style="warning" %}
We recommend using [/pages/6KSg4ILon6IcoRfdy6jv#id-1.20.0-2024-06-17](https://docs.coherent.global/build-spark-services/additional-mappings/pages/6KSg4ILon6IcoRfdy6jv#id-1.20.0-2024-06-17 "mention") or newer which contains the latest `Xrichoutput` implementation.
{% endhint %}

Syntax: `Xrichoutput_<parameter>`

Compose JSON structures through Excel. The heading row can contain instructions that indicate whether keys will be nested in an object or list. For more complex JSON transformations, we recommend the [Transforms APIs](/spark-apis/transforms-api.md).

## Sample file

This file provides a number of examples that encompass the functionality and notation for `Xrichoutput`.

1. Examine the different examples present in this file.
2. Identify the example that looks the most similar to your target JSON structure.
3. Amend one of the `Xrichoutput` examples to fit your requirements.
4. Upload the file to Spark and test in the [API Tester](/navigation/api-tester.md).
5. Copy the structure into your workbook and tie it into the existing calculations.

{% file src="/files/c7qPzjFnEFld64aMcN1A" %}

The old sample document is included below. Features such as `?` or `=` are no longer supported in newer versions of [Neuron](/build-spark-services/neuron.md).

{% file src="/files/-MdGZv96quIaNL-B2egi" %}