Forum Discussion

zakk92's avatar
zakk92
Frequent Visitor
5 years ago
Solved

JSON Parsing Issue

Hi,


I'm trying to parse a JSON field in power query, but I get the error:

 

DataFormat.Error: We found extra characters at the end of JSON input.
Details:
Value=]
Position=1544

 

The confusing part is that the extra character is the square bracket which should close off the JSON. I have checked and its not that there are 2 square brackets at the end, looking at the JSON, it actually finishes as shown below:

 

{"name":"General Operator (EW)"}]

 

This looks normal to me, but I was wondering if anyone else has faced a similar issue? I have seen similar topics but the issue seemed to be that they lacked the square brackets entirely. Any advice here would be greatly appreciated. 

 

Thanks,

Zakk

Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi zakk92 ,

    If it is the end of your json file, the end character of it should be } instead of ].

    ] is combine with [ to use inside {} as the json content, like:

    {
    xxx: [
        {
            xxx: xxx,
            "xxx": [
                {
                    "xxx": "xxx"
                },
                {
                    "xxx": "xxx"
                }
            ]
        },
        {
            "xxx": "xxx",
            "xxx": [
                {
                    "xxx": "xxx"
                },
                {
                    "xxx": "xxx"
                }
            ]
        }
    ]
}

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Is that the very end of the JSON object, in which case you'd need ]}   ?

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi zakk92 ,

    If it is the end of your json file, the end character of it should be } instead of ].

    ] is combine with [ to use inside {} as the json content, like:

    {
    xxx: [
        {
            xxx: xxx,
            "xxx": [
                {
                    "xxx": "xxx"
                },
                {
                    "xxx": "xxx"
                }
            ]
        },
        {
            "xxx": "xxx",
            "xxx": [
                {
                    "xxx": "xxx"
                },
                {
                    "xxx": "xxx"
                }
            ]
        }
    ]
}

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Hi,

     

    I am getting same kind of error. Could you please help me understand it?

     

    DataFormat.Error: We found extra characters at the end of the JSON input.
    Details:
    Value=<
    Position=2

     

    I checked. There's no < character in my query.

     

    Thanks.