Forum Discussion

Sibrulotte's avatar
Sibrulotte
Helper IV
5 years ago
Solved

JSON File: reached end of buffer

Hi,  I have a JSON file retrieved from a POST call in Postman. This JSON file was parsed successfully once in my main file, and I was a happy camper.   Unfortunatly, the next day, I refreshed the ...
Need Help
  • Sibrulotte's avatar
    Sibrulotte
    5 years ago

    Well I have been able to locate the problem:

    The POST call returns an incomplete response thus incomplete JSON file is saved. 

    It seems to be an issue with my data provider.

     

    So moral of the story is: incorrect JSON format will give an end of buffer memory error.

     

    Thank your for your time.

     

parry2k's avatar
parry2k
Super User
5 years ago

Sibrulotte not sure why you get this buffer error, can you share a sample pbix file? What kind of transformation are you doing if any? Do you happen to know how many records are in the file?

  • Sibrulotte's avatar
    Sibrulotte
    Helper IV
    5 years ago

    Well I have been able to locate the problem:

    The POST call returns an incomplete response thus incomplete JSON file is saved. 

    It seems to be an issue with my data provider.

     

    So moral of the story is: incorrect JSON format will give an end of buffer memory error.

     

    Thank your for your time.

     

    • PhilipTreacy's avatar
      PhilipTreacy
      Super User
      5 years ago

      Hi Sibrulotte 

      For what it's worth, is the reponse incomplete because the request was invalid or was the request valid but the returned data was badly formatted or truncated JSON?

      If a request is invalid and the expected returned data should be JSON, then what happens is you actually get a HTTP response back (which isn't JSON) and any attempt to parse JSON fails.

      It's always best to check what response is actually received rather than assume you get what you asked for.

      I know you said that your first request worked, so it would look like your request is properly formed. However you can still get an error returned if there's a problem with the service you are connecing to (perhaps a 404 Not Found or a 500 Internal Server Error).

      Anyway, just thought that might be useful to bear in mind for the future.

      regards

      Phil

      • Sibrulotte's avatar
        Sibrulotte
        Helper IV
        5 years ago

        Thanks Phil, the response starts off well, but is just truncated and doesn't end with a JSON synthax closure.

         

        So I need to fix that POST call before I do anything else. 🙂

    • v-robertq-msft's avatar
      v-robertq-msft
      Community Support
      5 years ago

      Hi, Sibrulotte 

      Thanks for your experience sharing. If you have solved your problem by yourself, would you like to mark your own reply as a solution so that others can learn from it too?

      Thanks in advance!

      How to Get Your Question Answered Quickly 

       

      Best Regards,

      Community Support Team _Robert Qin

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.