# JSON to CSV

## Description

This operation converts JSON data into a CSV file.

***

## Data types

These are the input/output expected data types for this operation:

### Input data

![](https://965373739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkxZeV4nlXcIAjMGZxzLI%2Fuploads%2FZmr35bwgundYfOW63E3q%2Fimage.png?alt=media\&token=2ba8baff-b40b-4dd4-ae2c-2a2ad5696788) - JSON data you want to transform into CSV. They must be strings formatted as JSON data.

### Output data <a href="#output-data" id="output-data"></a>

![](https://965373739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkxZeV4nlXcIAjMGZxzLI%2Fuploads%2FRDngsaxu99O216cFqn81%2Fimage.png?alt=media\&token=53e171be-7591-4c56-acdb-4e8e8646241d) - Resulting CSV files.

***

## Parameters

These are the parameters you need to configure to use this operation (mandatory parameters are marked with a <mark style="color:red;">**\***</mark>):

<details>

<summary>Cell delimiter<mark style="color:red;"><strong>*</strong></mark></summary>

This setting defines the character used to separate cells (or columns) in the resulting CSV

</details>

<details>

<summary>Row delimiter<mark style="color:red;"><strong>*</strong></mark></summary>

This setting defines the character used to separate rows in the resulting CSV.

</details>

***

## Example

Suppose you want to convert a series of events in **JSON** format into **CSV**:

1. In your Pipeline, open the required [Action](https://onum.gitbook.io/onum-docs/the-workspace/pipelines/actions) configuration and select the input **Field**.
2. In the **Operation** field, choose **JSON to CSV**.
3. Set **Cell delimiter** to `,` (comma).
4. Set **Row delimiter** to `\n` (new line)
5. Give your **Output field** a name and click **Save**. The JSON-formatted strings in your input field will be transformed into CSV.&#x20;

For example, the following JSON:

```json
[
  {
    "First name": "John",
    "Last name": "Wick",
    "Age": "20",
    "City": "New-York"
  },
  {
    "First name": "Tony",
    "Last name": "Stark",
    "Age": "30",
    "City": "Madrid"
  }
]
```

will be transformed into this CSV:

<pre class="language-csv"><code class="lang-csv"><strong>First name,Last name,Age,City       
</strong>John,Wick,20,New-York
Tony,Stark,30,Madrid
</code></pre>

{% hint style="info" %}
You can try out operations with specific values using the **Input** field above the operation. You can enter the value in the example above and check the result in the **Output** field.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.onum.com/the-workspace/pipelines/actions/transformation/field-transformation/field-transformation-operations/format-conversion/json-to-csv.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.