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 confus...
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.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity 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.