Convert JSON to CSV API

50 atoms
Base tier

About

This API lets you upload and transform JSON data to CSV format.
This API not only simplifies the conversion process but also ensures that it's done efficiently, reliably, and at scale. Whether you're dealing with large datasets, building automated data pipelines, or simply aiming for data consistency and compatibility, this API tool provides a robust solution for handling JSON data and converting it into a widely usable CSV format.
Try out the JSON to CSV API in the API playground for free and reduce CSV conversion errors with a simple API call.
Select API Endpoints
Input
Output

API Playground

API Documentation

upload file: download file
POST
https://api.apyhub.com/convert/json-file/csv-file

Request example

1
curl --location --request POST 'https://api.apyhub.com/convert/json-file/csv-file?output=sample' \
2
--header 'apy-token: {{token}}' \
3
--form 'file=@"sample.json"'
Method: POST
Content Type: multipart/form-data
Request Body
AttributeTypeMandatoryDescription
fileFileYesThe source json file. (JSON nesting depth is supported upto 20 levels.)
Query Parameter(s)
AttributeTypeMandatoryDescription
outputStringNoThe csv file name for the converted data. If no output attribute is provided, the default file name will be sample-output.csv

HTTP Response Codes

The method may return one of the following HTTP status codes:
Status CodeDescription
200The request was successful.
400Request is invalid.
401Required authentication information is either missing or not valid for the resource.
500There was an error in processing this request.

Authentication

All API requests to ApyHub services need to be authenticated. Currently we support tokens or basic authentication mechanisms. You can generate and view your existing credentials from your workspace settings (on the left side of the navbar) and go to “API Keys".
Points to note:
  • Credential secrets are generated on the fly and are not stored in plain text, so on generating a credential please save the secrets somewhere safe.
  • Use the apy-token as the header parameter to pass the token.
  • Use the Authorization header to send the basic authentication credentials.

Error codes

1
{
2
"error": {
3
"code": 105,
4
"message": "Invalid URL"
5
}
6
}
To search for a specific error code, enter the code in the search box below. Alternatively, you can click on the button to view a complete list of all error codes.