# Semi-structured data functions

[Read this page in HTML](https://www.scopedb.io/docs/reference/functions/semi-structured-data)

Semi-structured data functions work with data whose fields or nested structure can vary, such as event payloads. They operate on [`array`, `object`, and `any` values](https://www.scopedb.io/docs/reference/data-types/semi-structured.md).

## List of functions

* [{} (object construction)](https://www.scopedb.io/docs/reference/functions/semi-structured-data/object_construct.md)
* [\[\] (array construction)](https://www.scopedb.io/docs/reference/functions/semi-structured-data/array_construct.md)
* [\[\] (element access)](https://www.scopedb.io/docs/reference/functions/semi-structured-data/get.md)
* [Array slicing](https://www.scopedb.io/docs/reference/functions/semi-structured-data/slice.md)
* [|| (arrays and objects)](https://www.scopedb.io/docs/reference/functions/semi-structured-data/concat.md)
* [append](https://www.scopedb.io/docs/reference/functions/semi-structured-data/append.md)
* [contains](https://www.scopedb.io/docs/reference/functions/semi-structured-data/contains.md)
* [dedup](https://www.scopedb.io/docs/reference/functions/semi-structured-data/dedup.md)
* [exclude](https://www.scopedb.io/docs/reference/functions/semi-structured-data/exclude.md)
* [keys](https://www.scopedb.io/docs/reference/functions/semi-structured-data/keys.md)
* [length](https://www.scopedb.io/docs/reference/functions/semi-structured-data/length.md)
* [parse\_json](https://www.scopedb.io/docs/reference/functions/semi-structured-data/parse_json.md)
* [to\_json](https://www.scopedb.io/docs/reference/functions/semi-structured-data/to_json.md)
* [typeof](https://www.scopedb.io/docs/reference/functions/semi-structured-data/typeof.md)

## Related contents

* [Semi-structured data type](https://www.scopedb.io/docs/reference/data-types/semi-structured.md)