JSON to CSV and CSV to JSON Converter API

API ID 14221

Convert JSON arrays to CSV (nested objects flattened) and CSV to JSON with delimiter detection, quoted fields and number parsing.

API Documentation

Endpoints

Request
JSON to CSV. Convert JSON arrays (nested objects flattened) to CSV and CSV to JSON with auto delimiter detection, quoted fields and numbers.
Endpoint ID: 35297
POST https://zylalabs.com/api/14221/json+to+csv+and+csv+to+json+converter+api/35297/json+to+csv
INPUT PARAMETERS

JSON to CSV — Endpoint Features

Object Description
delimiter Optional Delimiter (optional)
Request Body Required Json

Free test requests remaining: 3 of 3.


INPUT PARAMETERS

delimiter
API EXAMPLE RESPONSE
JSON
name,address.city
Ana,Madrid
JSON to CSV — CODE SNIPPETS

curl --location --request POST 'https://zylalabs.com/api/14221/json+to+csv+and+csv+to+json+converter+api/35297/json+to+csv?delimiter=,' --header 'Authorization: Bearer YOUR_API_KEY' 

--data-raw '[{"name":"Ana","address":{"city":"Madrid"}}]'

    
Request
CSV to JSON. Convert JSON arrays (nested objects flattened) to CSV and CSV to JSON with auto delimiter detection, quoted fields and numbers.
Endpoint ID: 35298
POST https://zylalabs.com/api/14221/json+to+csv+and+csv+to+json+converter+api/35298/csv+to+json
INPUT PARAMETERS

CSV to JSON — Endpoint Features

Object Description
delimiter Optional Delimiter (auto if empty)
Request Body Required Json

Free test requests remaining: 3 of 3.


INPUT PARAMETERS

delimiter
API EXAMPLE RESPONSE
JSON
{
    "rows": [
        {
            "name": "Ana",
            "age": 30
        }
    ]
}
CSV to JSON — CODE SNIPPETS

curl --location --request POST 'https://zylalabs.com/api/14221/json+to+csv+and+csv+to+json+converter+api/35298/csv+to+json' --header 'Authorization: Bearer YOUR_API_KEY' 

--data-raw 'name,age
Ana,30'

    

API Access Key & Authentication

After signing up, every developer is assigned a personal API access key, a unique combination of letters and digits provided to access to our API endpoint. To authenticate with the JSON to CSV and CSV to JSON Converter API simply include your bearer token in the Authorization header.

Headers
Header Description
Authorization Required Should be Bearer access_key. See "Your API Access Key" above when you are subscribed.

No long-term commitment. Upgrade, downgrade, or cancel anytime. Free Trial includes up to 50 requests.

Starts at
$10,000/Year


  • Custom Volume
  • Custom Rate Limit
  • Specialized Customer Support
  • Real-Time API Monitoring

Overview

Convert JSON arrays to CSV (nested objects flattened) and CSV to JSON with delimiter detection, quoted fields and number parsing.

JSON to CSV and CSV to JSON Converter API FAQs

The POST JSON to CSV endpoint returns a CSV format of the input JSON arrays, with nested objects flattened. The POST CSV to JSON endpoint returns a JSON object containing an array of rows, where each row represents a record from the CSV input.

In the JSON to CSV response, key fields include the headers derived from the JSON keys, such as "name" and "address.city". In the CSV to JSON response, each object in the "rows" array contains fields corresponding to the CSV columns, like "name" and "age".

The JSON to CSV response is organized as a plain text CSV with headers followed by data rows. The CSV to JSON response is structured as a JSON object with a "rows" key, containing an array of objects, each representing a row from the CSV.

The JSON to CSV endpoint can handle any JSON array data, converting it to a CSV format. The CSV to JSON endpoint accepts CSV data, converting it into a structured JSON format, making it suitable for various data types, including strings and numbers.

Users can customize their requests by providing different JSON arrays for conversion to CSV or different CSV strings for conversion to JSON. The API automatically detects delimiters and handles quoted fields, allowing flexibility in input formats.

Users can expect structured data patterns in both formats. For JSON to CSV, the output will have a consistent header row followed by data rows. For CSV to JSON, the output will have an array of objects, each with key-value pairs corresponding to the CSV columns.

The API relies on standard parsing techniques for both JSON and CSV formats, ensuring that data is accurately converted. However, users should validate the output, especially when dealing with complex nested structures or unusual CSV formats.

Typical use cases include data migration between systems, data analysis, and reporting. Users can convert JSON data from APIs into CSV for spreadsheet applications or transform CSV data from legacy systems into JSON for modern web applications.

General FAQs

To obtain your API key, first sign in to your account and navigate to the API you want to use. From the API's Pricing section, choose a plan and complete the subscription process. Once subscribed, return to the API page and you will see your API Access Key displayed at the top of the documentation page. You can use this key to authenticate your requests.

You can’t switch APIs during the free trial. If you subscribe to a different API, your trial will end and the new subscription will start as a paid plan.

The free trial lasts for 7 days and allows you to make up to 50 API requests.

No, the free trial is available only once, so we recommend using it on the API that interests you the most. Most of our APIs offer a free trial, but some may not include this option.

Yes. If the API offers a free trial, you will see a "Free 7-Day Trial" option in its Pricing section. The trial lasts for 7 days and allows up to 50 API requests, enabling you to evaluate the API before subscribing to a paid plan.

Zyla API Hub is like a big store for APIs, where you can find thousands of them all in one place. We also offer dedicated support and real-time monitoring of all APIs. Once you sign up, you can pick and choose which APIs you want to use. Just remember, each API needs its own subscription. But if you subscribe to multiple ones, you'll use the same key for all of them, making things easier for you.

Prices are listed in USD (United States Dollar), EUR (Euro), CAD (Canadian Dollar), AUD (Australian Dollar), and GBP (British Pound). We accept all major debit and credit cards. Our payment system uses the latest security technology and is powered by Stripe, one of the world's most reliable payment companies. If you have any trouble paying by card, just contact us at [email protected]

Additionally, if you already have an active subscription in any of these currencies (USD, EUR, CAD, AUD, GBP), that currency will remain for subsequent subscriptions. You can change the currency at any time as long as you don't have any active subscriptions.
The local currency shown on the pricing page is based on the country of your IP address and is provided for reference only. The actual prices are in USD (United States Dollar). When you make a payment, the charge will appear on your card statement in USD, even if you see the equivalent amount in your local currency on our website. This means you cannot pay directly with your local currency.
Occasionally, a bank may decline the charge due to its fraud protection settings. We suggest reaching out to your bank initially to check if they are blocking our charges. Also, you can access the Billing Portal and change the card associated to make the payment. If these does not work and you need further assistance, please contact our team at [email protected]
Prices are determined by a recurring monthly or yearly subscription, depending on the chosen plan.
API calls are deducted from your plan based on successful requests. Each plan comes with a specific number of calls that you can make per month. Only successful calls, indicated by a Status 200 response, will be counted against your total. This ensures that failed or incomplete requests do not impact your monthly quota.
Zyla API Hub works on a recurring monthly subscription system. Your billing cycle will start the day you purchase one of the paid plans, and it will renew the same day of the next month. So be aware to cancel your subscription beforehand if you want to avoid future charges.
To upgrade your current subscription plan, simply go to the pricing page of the API and select the plan you want to upgrade to. The upgrade will be instant, allowing you to immediately enjoy the features of the new plan. Please note that any remaining calls from your previous plan will not be carried over to the new plan, so be aware of this when upgrading. You will be charged the full amount of the new plan.
To check how many API calls you have left for the current month, refer to the 'X-Zyla-API-Calls-Monthly-Remaining' field in the response header. For example, if your plan allows 1,000 requests per month and you've used 100, this field in the response header will indicate 900 remaining calls.

You can monitor your API usage through the response headers included with every request:

x-zyla-api-calls-monthly-used: Shows the total number of API requests you have used during the current billing period.
x-zyla-api-calls-monthly-remaining: Shows the number of API requests you have remaining for the current billing period.

The 'X-Zyla-RateLimit-Reset' header shows the number of seconds until your rate limit resets. This tells you when your request count will start fresh. For example, if it displays 3,600, it means 3,600 seconds are left until the limit resets.

Yes, you can cancel your subscription at any time. Simply go to the Pricing section of the API you're subscribed to and click the "Unsubscribe" button.

Please note that upgrades, downgrades, and cancellations take effect immediately. Once your subscription is canceled, access to the service will end immediately, regardless of any remaining API calls in your quota.

After 7 days, you will be charged the full amount for the plan you were subscribed to during the trial. Therefore, it's important to cancel before the trial period ends. Refund requests for forgetting to cancel on time are not accepted.
When you subscribe to an API free trial, you can make up to 50 API calls. If you wish to make additional API calls beyond this limit, the API will prompt you to perform an "Start Your Paid Plan." You can find the "Start Your Paid Plan" button in your profile under Subscription -> Choose the API you are subscribed to -> Pricing tab.
You can contact us through our chat channel to receive immediate assistance. We are always online from 8 am to 5 pm (EST). If you reach us after that time, we will get back to you as soon as possible. Additionally, you can contact us via email at [email protected]

Please have a look at our Refund Policy: https://zylalabs.com/terms#refund


Related APIs