# JSON

Frends offers seamless integration with [JSON format](https://en.wikipedia.org/wiki/JSON), enabling you to effortlessly connect and automate data flows between your systems using the JSON format.

Frends has tasks for performing all core JSON operations.

By leveraging Frends' task-based approach, you can configure and customize JSON integrations according to your specific requirements. Frends offers a wide range of tasks that facilitate integrations to a variety of systems and protocols.

## Use cases

Below you will find typical use cases for JSON integrations and how they are implemented in Frends.

### Parse a JSON file and save data to database

By using the file trigger and the [`ConvertJSONStringToJToken`](https://docs.frends.com/tasks/tasks/json/convertjsonstringtojtoken) task we can create an integration that parses a JSON coming from a file and saves the data to the database.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-5424b582fd8230085e2ce9419ef475e19608459a%2Fjson-parse.svg?alt=media" alt=""><figcaption><p>Parse</p></figcaption></figure>

### Query the JSON data using JsonPath

By using the [`Query`](https://docs.frends.com/tasks/tasks/json/query) task we can create an integration that queries the JSON document for data using a JSON path expression.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-edd4bd2cdc583a47003fcd9eb6e107d601a07196%2Fjson-query.svg?alt=media" alt=""><figcaption><p>Query</p></figcaption></figure>
