Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
freelensia
Advocate II
Advocate II

We found extra characters at the end of the JSON input

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?

1 ACCEPTED SOLUTION
freelensia
Advocate II
Advocate II

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.

View solution in original post

2 REPLIES 2
freelensia
Advocate II
Advocate II

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.