JSON to CSV Converter is a powerful tool for converting JSON arrays into CSV format. It supports custom delimiters, header inclusion, and proper escaping of special characters.
npm install @apiverve/jsontocsvshell
npm install @apiverve/jsontocsv
`
Using yarn:
`shell
yarn add @apiverve/jsontocsv
`
---
Configuration
Before using the JSON to CSV Converter API client, you have to setup your account and obtain your API Key.
You can get it by signing up at https://apiverve.com
---
Quick Start
Get started with the Quick Start Guide
The JSON to CSV Converter API documentation is found here: https://docs.apiverve.com/ref/jsontocsv.
You can find parameters, example responses, and status codes documented here.
$3
`javascript
const jsontocsvAPI = require('@apiverve/jsontocsv');
const api = new jsontocsvAPI({
api_key: '[YOUR_API_KEY]'
});
`
---
Usage
---
$3
Using the API is simple. All you have to do is make a request. The API will return a response with the data you requested.
`javascript
var query = {
"json": [
{
"name": "John Doe",
"age": 30,
"city": "New York"
},
{
"name": "Jane Smith",
"age": 25,
"city": "Los Angeles"
}
],
"delimiter": ",",
"include_header": true
};
api.execute(query, function (error, data) {
if (error) {
return console.error(error);
} else {
console.log(data);
}
});
`
---
$3
You can also use promises to make requests. The API returns a promise that you can use to handle the response.
`javascript
var query = {
"json": [
{
"name": "John Doe",
"age": 30,
"city": "New York"
},
{
"name": "Jane Smith",
"age": 25,
"city": "Los Angeles"
}
],
"delimiter": ",",
"include_header": true
};
api.execute(query)
.then(data => {
console.log(data);
})
.catch(error => {
console.error(error);
});
`
---
$3
You can also use async/await to make requests. The API returns a promise that you can use to handle the response.
`javascript
async function makeRequest() {
var query = {
"json": [
{
"name": "John Doe",
"age": 30,
"city": "New York"
},
{
"name": "Jane Smith",
"age": 25,
"city": "Los Angeles"
}
],
"delimiter": ",",
"include_header": true
};
try {
const data = await api.execute(query);
console.log(data);
} catch (error) {
console.error(error);
}
}
`
---
Example Response
`json
{
"status": "ok",
"error": null,
"data": {
"row_count": 2,
"column_count": 3,
"columns": [
"name",
"age",
"city"
],
"csv": "name,age,city\nJohn Doe,30,New York\nJane Smith,25,Los Angeles"
}
}
``