Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

JSON data not valid with error #20

Open
tdyhacker opened this issue May 24, 2016 · 2 comments
Open

JSON data not valid with error #20

tdyhacker opened this issue May 24, 2016 · 2 comments
Labels

Comments

@tdyhacker
Copy link

I use mysql workbench export data to json file,when I use jsonpyes to import the json file,it display some error:

JSON data not valid with error
 Expecting value: line 2 column 1 (char 69)

my json file:

[{"id":"10155", "username":"", "password":""},
 {"id":"10156", "username":"", "password":""},
 {"id":"10157", "username":"", "password":""},
 {"id":"10158", "username":"", "password":""},
 {"id":"10159", "username":"", "password":""},
 {"id":"10160", "username":"", "password":""},
 {"id":"10161", "username":"", "password":""},
 {"id":"10162", "username":"", "password":""},

I don't know how the stand json file should be?

@xros
Copy link
Owner

xros commented Jul 1, 2016

@tdyhacker hey, actually the JSON file you got should be without symbol "[" and without "," at the end

The valid format for your scenario could be like this.

 {"id":"10155", "username":"", "password":""}
 {"id":"10156", "username":"", "password":""}
 {"id":"10157", "username":"", "password":""}
 {"id":"10158", "username":"", "password":""}
 {"id":"10159", "username":"", "password":""}
 {"id":"10160", "username":"", "password":""}
 {"id":"10161", "username":"", "password":""}
 {"id":"10162", "username":"", "password":""}

Feel free to contact me

@xros xros added the question label Jul 18, 2016
@xros
Copy link
Owner

xros commented Aug 3, 2016

@tdyhacker And you can check this file https://github.com/xros/jsonpyes/blob/master/raw_data.json for instance. This is a valid JSON file shipped with jsonpyes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants