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

Question

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

garg10may opened this issue 3 years ago · 20 comments

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

Answer 1 · 2022-01-20T01:05:57.000Z

can you provide a sample data?

Answer 2 · 2022-01-20T01:17:11.000Z

[
    {
        "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"
    }
]

Answer 3 · 2022-01-20T02:00:25.000Z

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

Answer 4 · 2022-02-14T12:53:43.000Z

any update?

Answer 5 · 2022-02-15T02:47:19.000Z

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

Answer 6 · 2022-02-15T05:11:27.000Z

I am using the same json structure

Answer 7 · 2022-02-15T07:19:12.000Z

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

Answer 8 · 2022-03-02T17:27:59.000Z

Help me. I am having the same problem

Answer 9 · 2022-03-03T03:36:51.000Z

Help me. I am having the same problem

Please provide repro for contributing debug.

Answer 10 · 2022-08-01T02:41:35.000Z

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

Answer 11 · 2022-08-01T02:42:25.000Z

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

I am using it with react

Answer 12 · 2022-08-01T03:14:00.000Z

@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

Answer 13 · 2022-08-01T05:08:48.000Z

@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

Answer 14 · 2022-08-01T06:05:12.000Z

@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?

Answer 15 · 2022-08-01T06:13:34.000Z

@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.

Answer 16 · 2022-08-01T07:50:06.000Z

@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.

Answer 17 · 2022-08-11T02:10:45.000Z

@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

Answer 18 · 2022-08-11T08:45:40.000Z

@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.

Answer 19 · 2022-08-31T12:37:03.000Z

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

Answer 20 · 2023-01-11T16:35:21.000Z

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: