Extracting data from blob and getting errors in table , please suggest

[Anonymous]

Dear experts

I am extracting data from azure blob, but some of the table we are getting errors as below 

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

these many error are there, pls suggest if there is any alternative, instead of doing filter.

like that we have many transform files (4),(5), (6), and so on  how to fix this extra character issue in our parameter file? 

Please suggest

[Anonymous]

Hi @Anonymous,

Depending on the error message you receive, refer to the following methods for troubleshooting:

1. Open the JSON file and check the end of the file for extra characters or unclosed brackets
2. Use an online JSON formatting tool to validate and format the JSON file to ensure that it is formatted correctly

Best regards,

Joyce

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

[Anonymous]

After performing the invoke 

,
#"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

Please suggest how to get rid this character issue 

Thank you

[Anonymous]

Hi @Anonymous - as checked in azure blob we are getting the json files in location some with one record and some json files we have multiple records as below:

One records in one json

Multiple records in one json files:

Please suggest

[Anonymous]

Hi @Anonymous ,

Thank you for your additional information.

Please try to wrap multiple Json objects in an array by adding [ at the beginning of the first line, ] at the end of the last line, and , between each line to compare the results.

Best regards,

Joyce

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