Parsing failing for JsonArray type input

[kanibs]

Parsing failing for JsonArray type input

[juanjoDiaz]

You only mistake is to use nfields instead of fields.

const { Parser, transforms: { unwind } } = require('json2csv');

const data = {
    "meta": {
        "request": {
            "page": 1,
            "format": "json",
            "start_date": "2021-11-01",
            "end_date": "2021-11-30",
            "country": "gb"
        },
        "status": "Success",
        "last_updated": "2021-11-30"
    },
    
    "top_sites": [
        {
            "rank": 1,
            "domain": "song1"
        },
        {
            "rank": 2,
            "domain": "song2"
        }
    ]	
    
};


const fields = ['top_sites.rank', 'top_sites.domain'];
const transforms = [unwind({ paths: ['top_sites'] })];
const json2csvParser = new Parser({ fields, transforms });
const csv = json2csvParser.parse(data);

console.log(csv);

works and outputs

"top_sites.rank","top_sites.domain"
1,"song1"
2,"song2"

Using the CLI you should be able to do the same.

[kanibs]

Thanks, @juanjoDiaz for the reply and help.
I am not very versed with JS, so as per your comment, it means we need to have the variable name as fields only and not, say, myFields, or fields_to_scrape?

[juanjoDiaz]

You can name the variable as you want if you use full syntax:

const myRandomVariableContainingTheFields = ['top_sites.rank', 'top_sites.domain'];
const transforms = [unwind({ paths: ['top_sites'] })];
const json2csvParser = new Parser({ fields: myRandomVariableContainingTheFields, transforms });

but using shorthand syntax:

const json2csvParser = new Parser({ myRandomVariableContainingTheFields, transforms });

is equivalent to:

const json2csvParser = new Parser({ myRandomVariableContainingTheFields: myRandomVariableContainingTheFields, transforms: transforms });

The the name of the config options are wrong.

[kanibs]

:) Aah, I realize my fault now. A pretty dumb question that was.

JS Fundamental that was.

Thanks for the Explanation.