JSON Parsing Issue

[zakk92]

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

[Syndicate_Admin]

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.

[v-yingjl · Accepted solution]

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.

[Anonymous]

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