Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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

 

 

Need Help
Show and Tell

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.