The response is not in a JSON format.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a flow that I've been using for over a year that just stopped working yesterday.

the error details say: The response is not in a JSON format.

Please help!

Categories:

Using flows

I have the same question (0)

All responses (11)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Can you provide additional details?

Have you re-saved the Flow?

Are there connection issues? If so, have you tried to fix them?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I am having troubles also with me JSON format.
I am trying to get an attachment from my forms to a sharepoint using power automate.
But it not working because of the same mistake here:The response is not in a JSON format.
Can anybody help me?

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Please post a screen shot of your Flow (the more detail the better) and I'll try to assist.

Was this reply helpful? Yes No
RMS_MP 6 on at

Like (0)

Report
Copy link

Link copied!

On the "Mark as read or unread (v3), I'm now getting the below error.

{
  "error": {
    "code": 404,
    "source": "flow-apim-msmanaged-na-centralus-01.azure-apim.net",
    "clientRequestId": "26f6558b-dc70-462f-8ba8-9ed4079bbee5",
    "message": "The response is not in a JSON format.",
    "innerError": "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\"/>\r\n<title>404 - File or directory not found.</title>\r\n<style type=\"text/css\">\r\n\r\n</style>\r\n</head>\r\n<body>\r\n<div id=\"header\"><h1>Server Error</h1></div>\r\n<div id=\"content\">\r\n <div class=\"content-container\"><fieldset>\r\n  <h2>404 - File or directory not found.</h2>\r\n  <h3>The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.</h3>\r\n </fieldset></div>\r\n</div>\r\n</body>\r\n</html>\r\n"
  }
}

Was this reply helpful? Yes No
DavidOni 10 on at

Like (0)

Report
Copy link

Link copied!

I put it in the template document as words that I want to be replaced in square brackets [] as I saw in the example: https://blog.encodian.com/2020/05/populate-a-word-or-pdf-document-using -power-automate / Does the document word have to be capitalized? the text it will replace is dynamic data collected from excel forms and tables. When the stream is displayed the following error: The response is not in JSON format.

Was this reply helpful? Yes No
DavidOni 10 on at

Like (2)

Report
Copy link

Link copied!

I got it, solved my problem, went to the encodian website, changed the API key, updated the data connection menu in power automate.

Was this reply helpful? Yes No
DavidOni 10 on at

Like (0)

Report
Copy link

Link copied!

no need to put a bracket, he searches for words and exchanges for others, simple

Was this reply helpful? Yes No
ulanbator 6 on at

Like (0)

Report
Copy link

Link copied!

that has done it for me. Thx!

Was this reply helpful? Yes No
Joeygreco 6 on at

Like (0)

Report
Copy link

Link copied!
I'm getting the same error on what should be a pretty simple job. Trying to email anyone that submits a response via MS Forms with an email that contains a unique ID:
{"statusCode":502,"headers":{"X-Cache":"CONFIG_NOCACHE","X-MSEdge-Ref":"Ref A: 5CE39B9F16884549B3FAAEC33FE64B84 Ref B: BLUEDGE1716 Ref C: 2023-03-08T20:20:05Z","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","x-ms-apihub-obo":"false","retry-after":"3600","Date":"Wed, 08 Mar 2023 20:20:04 GMT","Content-Length":"256","Content-Type":"application/json"},"body":{"error":{"code":502,"source":"canada-001.azure-apim.net","clientRequestId":"04a244e2-9b9a-457b-93f3-0af2f738d333","message":"The response is not in a JSON format.","innerError":"Cannot read server response."}}}

Was this reply helpful? Yes No
Joeygreco 6 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer

Was this reply helpful? Yes No