We found extra characters at the end of the JSON input

[Anonymous]

Hi Experts,

I am extracting data from azure blob we are getting the json files format in location some json we have one record and some json files we have multiple records in each json as below:

One records in one json

Multiple records in one json files:

Is due to that after invoke function, in transform file, getting table (single record) , errors are coming having multiple records.

#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (2)", each #"Transform File (2)"([Content]))

An error occurred in the ‘Transform File (2)’ query. DataFormat.Error: We found extra characters at the end of the JSON input.
Details:
Value={
Position=2118

Checked in json viewer invalid due to multiple records.  i was stuck is there any possible to bring the error record ?

Please suggest

[v-xianjtan-msft · Accepted solution]

Hi @Anonymous 

Please try adding “[”at the beginning, “]”at the end, and “,” after every line. 

Here is my test result, checked in Json Viewer is valid.

Here are similar cases for your reference:

Solved: We found extra characters at the end of the JSON i... - Microsoft Fabric Community

We Found Extra Characters at End of JSON Line - Microsoft Community Hub

^{Best Regards,}

^{Jarvis Tang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}