We found extra characters at the end of the JSON input

[freelensia]

I looked at this thread already: https://community.powerbi.com/t5/Desktop/We-found-extra-characters-at-the-end-of-JSON-input/m-p/2069....

The first 2 lines of my input look like this (... is omitted data):

{"_index":"data","type":"hnw_user","_id":"100004477389220",...,"locale":"vi_VN","phone_number":"8496109...6"}}

{"_index":"data","type":"hnw_user","_id":"100013993450651",...,"locale":"vi_VN","phone_number":"8496109...1"}}

 The last 2 rows looks like this:

{"_index":"data","_type":"hnw_facebook_user","_id":"100003943749285",...,"website":"","about_me":"","quotes":"","relationship_status":"Married","cell_phone":"","other_phone":"","contact_email":null,"timezone":null}}

{"_index":"data","_type":"hnw_user","_id":"100011776416175",...,"locale":"vi_VN","website":"","about_me":"","quotes":"","relationship_status":"","cell_phone":"","other_phone":"","contact_email":null,"timezone":null}}

I got the message "We found extra characters at the end of the JSON input"

I cannot change to .txt and treat this file manually because there are many inconsistencies in the data. For example in some cases I will have:

...,"hometown":{"city":"XXX","state":"YYY...

some other case: 

...,"hometown":[],...

I cannot plug this file into some online JSON checker because its size is larger than the limits allowed by most of these sites.

Could some JSON expert tell me if this file has the right syntax from the looks of the 4 rows given above?

[freelensia · Accepted solution]

Thanks for your ideas. I found the solution. I added [ at the beginning, ] at the end, and , after every line. Cuz this was a multi-dimensional JSON file.

[amitchandak]

@freelensia , refer old solution for any help and idea

https://community.powerbi.com/t5/Desktop/quot-We-Found-extra-characters-at-the-end-of-JSON-input-quo...

https://community.powerbi.com/t5/Power-Query/quot-We-found-extra-characters-at-the-end-of-JSON-input...