Error: Invalid export data. Please provide an array of object

[garg10may]

Error: Invalid export data. Please provide an array of object for a valid object

[zheeeng]

can you provide a sample data?

[garg10may]

[
    {
        "Test Cohort Version": "5",
        "Study": "CINC280X2105C",
        "Category": "Screen Testing",
        "CheckId": "sdfsdf",
        "Description": "f",
        "Instructions": "sdfds"
    },
    {
        "Test Cohort Version": "5",
        "Study": "CINC280X2105C",
        "Category": "Screen Testing",
        "CheckId": "sfadsfds",
        "Description": "f",
        "Instructions": "sdfds"
    }
]

[zheeeng]

Can't reproduce your case. You can fork a repro on https://codepen.io/zheeeng/pen/PQxBKr, I will dig into your issue.

[subhadeepchakraborty]

any update?

[zheeeng]

This example https://codepen.io/zheeeng/pen/PQxBKr is using your sample data. Can you provide a more concrete example?

[subhadeepchakraborty]

I am using the same json structure

[zheeeng]

This example works correctly. If any reproduction can be provided will be much helpful to solve your problem.

[atakanyurttutann]

Help me. I am having the same problem

[zheeeng]

Help me. I am having the same problem

Please provide repro for contributing debug.

[rajukumar-rjk]

I am facing the same issue. check the screenshot. It's correct data types.

[rajukumar-rjk]

I am facing the same issue. check the screenshot. It's correct data types.

I am using it with react

[zheeeng]

@rajukumar-rjk Hey, thx for using. Would you mind posting your sample data here for contributing debug this issue? https://codesandbox.io/s/test-export-from-json-p9qgz2

[rajukumar-rjk]

@rajukumar-rjk Hey, thx for using. Would you mind posting your sample data here for contributing debug this issue? https://codesandbox.io/s/test-export-from-json-p9qgz2

It worked there. but it gives error when I use same data in the react project. I have attached the json exportFromJsonData.txt

[zheeeng]

@rajukumar-rjk Hey, thx for using. Would you mind posting your sample data here for contributing debug this issue? https://codesandbox.io/s/test-export-from-json-p9qgz2

It worked there. but it gives error when I use same data in the react project. I have attached the json exportFromJsonData.txt

Is there some wrapped data structure passed? For example, reactive data created by Mobx or others?

[rajukumar-rjk]

@rajukumar-rjk Hey, thx for using. Would you mind posting your sample data here for contributing debug this issue? https://codesandbox.io/s/test-export-from-json-p9qgz2

It worked there. but it gives error when I use same data in the react project. I have attached the json exportFromJsonData.txt

Is there some wrapped data structure passed? For example, reactive data created by Mobx or others?

No. it just simple array, exactly what I have shared with you.

[zheeeng]

@rajukumar-rjk export-from-json asserts input data is Array via such implementation https://github.com/zheeeng/export-from-json/blob/master/src/utils.ts#L1-L3, if possible you can try test your input's type.

[ricko-v]

@garg10may try this

let data = [
    {
        "Test Cohort Version": "5",
        "Study": "CINC280X2105C",
        "Category": "Screen Testing",
        "CheckId": "sdfsdf",
        "Description": "f",
        "Instructions": "sdfds"
    },
    {
        "Test Cohort Version": "5",
        "Study": "CINC280X2105C",
        "Category": "Screen Testing",
        "CheckId": "sfadsfds",
        "Description": "f",
        "Instructions": "sdfds"
    }
]

let fileName = 'example'
let exportType = exportFromJSON.types.xls;
exportFromJSON({ data: data, fileName: fileName, exportType: exportType })

it's work in my case

[rajukumar-rjk]

@garg10may try this

let data = [
    {
        "Test Cohort Version": "5",
        "Study": "CINC280X2105C",
        "Category": "Screen Testing",
        "CheckId": "sdfsdf",
        "Description": "f",
        "Instructions": "sdfds"
    },
    {
        "Test Cohort Version": "5",
        "Study": "CINC280X2105C",
        "Category": "Screen Testing",
        "CheckId": "sfadsfds",
        "Description": "f",
        "Instructions": "sdfds"
    }
]

let fileName = 'example'
let exportType = exportFromJSON.types.xls;
exportFromJSON({ data: data, fileName: fileName, exportType: exportType })

it's work in my case

This solve my problem too.

[PaulleDemon]

Arrays are a special type of object. The typeof operator in JavaScript returns "object" for arrays.

When I console logged my data, I found that my data was structured as

So the solution was to use const data = Object.values(result) and pass the data to the exportFromJSON

[anil-pamerapu]

Hi Is there any way to add (sep=, ) in an export JSON file top? for some European users, we are seeing in something diff format.

add Like this: