Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DataFormat.Error: We found additional characters at the end of the JSON entry.

Hi guys,

I need help, I'm trying to connect an API to Power Query, but it always returns the error: "DataFormat.Error: We found additional characters at the end of the JSON entry." Below image of the error and parameters used.

 

 

I've tried everything, looked at all the topics but no solution worked. I already realized that I should probably put some code before pulling the API so that it turns into text, but I did not get the correct way to include this code.

 

Forgive my English, but I don't find a solution in my language.

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    I tested this topic following this article, it should work with your query structure.

    I see the sample code from that article surrounding the entire thing with a bracket to form a valid json doc.

     

    Please check if the json content is the same with that in the API reference document,

    then place your JSON intojsonformatter.org to validate.

    You could also check the solution of the message 27 from this thread or similar thread here.

     

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