Skip to main content

Notifications

Community site session details
Power Automate - General Discussion
Answered

Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

Like (1) ShareShare
ReportReport
Posted on 5 Jan 2022 00:56:08 by

Hi there,

 

I have a flow created that uses SQL connector to connect to a database view and pulls records from there and adds few records to excel.

 

The flow is scheduled to run once a day and is generally working fine. But at regular intervals failing with the below error. Without changing anything in the flow the flow again runs successfully on the next day or even if i resubmit the flow on the same day.

 

Http request failed: the content was not a valid JSON. Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

 

Need immediate help on this.

Please suggest.

 

Thanks

Categories:
  • DuneZerna Profile Picture
    2 on 01 Feb 2024 at 09:32:17
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    So, whats the solution?

  • fw100 Profile Picture
    6 on 25 May 2023 at 02:27:48
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    I'm really getting tired of Microsoft's poor programming and lack of quality control.

  • y2kardell Profile Picture
    147 on 17 Nov 2022 at 14:57:15
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    Just received this message from Microsoft as the issue has been resolved:

    Issue - Send an Email (V2) action fails with the following error message. Http request failed: the content was not a valid JSON. Error while parsing JSON: 'Unexpected character encountered while parsing value: R. Path '', line 0, position 0.&#39

    Findings - Our logs indicated that the same role instance LargeDedicatedWebWorkerRole_IN_26 failed to load the certificate around 2022-11-02 at 22:06:15. Typically, this means, that the role instance had trouble getting at its certificate store. Thus, our product team rebooted the worker on 11/09 and that mitigated the issue.

    Outcome - Dev team has mitigated the issue and is working on improving worker health checks in order to ensure the issue does not reoccur.

    Root Cause - A bad worker was intermittently failing in an internal service that handles access tokens, causing unexpected errors to occur for a small subset of users.

  • Verified answer
    Community Power Platform Member Profile Picture
    on 12 Jan 2022 at 07:48:59
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    As posted by @jinivthakkar ,

     

    yesterday

    "Recently someone on the forum was getting the same error because the connector was blocked on the environment, by any chance do you have another environment, if yes please can you move your flow and try running the same ?

    Also implementing a try catch finally would help to pinpoint the error or even help you in overcoming this 

    https://www.youtube.com/watch?v=a6rGbJXsH1U&t=2s

    Please check out the video, hope that helps."

  • Verified answer
    jinivthakkar Profile Picture
    4,179 on 12 Jan 2022 at 06:20:47
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    @Anonymous please accept as solution and close the thread, cheers !

  • Community Power Platform Member Profile Picture
    on 12 Jan 2022 at 03:49:34
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    @jinivthakkar - Thank you, as per your suggestion in another message implementing try,catch,finally in my flow to handle the scenario. I believe that would be the ideal solution to manage the unpredictable error as above.

     

     

  • Community Power Platform Member Profile Picture
    on 11 Jan 2022 at 03:10:59
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    Hi, Please find below the screenshot where i get this error and also the flow is not failing always. Only some of them fail. 

    Svee_0-1641870592471.png

     


    The filter condition used in the query is 
    WO_x0020_Date ge 2022-01-01 AND WO_x0020_Date le 2022-01-31

     

    The same flow when submitted again runs successful.

    Flow runs are like below, suddenly in the middle it fails one or 2 days.. then successful again.

    Svee_1-1641870592476.png

     

     

    Also because the error says unexpected character in Line 0 Position 0, I'm not able to track or spot the issue yet.

     

    Any help would be very useful.

     

    Thanks

  • Community Power Platform Member Profile Picture
    on 10 Jan 2022 at 09:45:27
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    Anyone able to guide as why this error occurs intermittently?

  • Community Power Platform Member Profile Picture
    on 07 Jan 2022 at 09:38:38
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    Hi,

     

    Connector used in SQL.

    Pulling data from a SQL DB View and Filter clause is used to filter the data between a range of dates.

    The filter and the data pulled from view seems to work fine as immediately if i resubmit it gets successful.

  • jinivthakkar Profile Picture
    4,179 on 05 Jan 2022 at 08:06:16
    Re: Error while parsing JSON: 'Unexpected character encountered while parsing value: A. Path '', line 0, position 0.'

    @Anonymous please share for which action you are getting the error, also please can you share a sample value for which you are getting the error

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,751 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started
Loading started