401 SharePoint - The response is not in a JSON format

(0) Share

Report

Posted on by Ludwig Reinhard

Hi,

A user received the following error - see below - when trying to grab data from SharePoint.

All days before things worked fine but now it failed.

Why is that?

Best regards,

Ludwig

error": {

"code": 401,

"source": "flow-apim-europe-001-westeurope-01.azure-apim.net",

"clientRequestId": "ef01ca07-ac09-4e47-8e84-3b5127116e42",

"message": "The response is not in a JSON format.",

"innerError": "No connection could be made because the target machine actively refused it 127.0.0.1:32843"

Categories:

Using connectors

I have the same question (0)

All responses (8)

Answers (0)

Sort by

v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @lreinhard7 ,

What is the current test result on your side, I have tested it on my side, and the SharePoint connector related actions can be used normally.

It seems that your data comes from an On-prem data source, please check if the status of the connection is successfully connected.

Alternatively, you could try to update or recreate the connection and see if a similar error still exists.

Best Regards,

Was this reply helpful? Yes No
Ludwig Reinhard on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
We tested once again over the last two days but could not replicate the issue.
I have no clue what happened but now the problem seems gone.
The SharePoint is actually not an on-prem but a cloud hosted one.
Will continue to watch whether the issue comes up again .
For the moment things seem to be fixed though.
Many thanks and best regards,
Ludwig

Was this reply helpful? Yes No
Thorsten_L 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I actually have the same error NOW. But only if a collegue is triggering the flow.
regards,
Thorsten

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Thorsten_L ,
Did anything help you resolve the issue as I am facing the error only when colleages run it.

Thanks,
Shraddha

Was this reply helpful? Yes No
veer13 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi@Shraddha_B, @Thorsten_L,
were you guys able to solve the problem?

my error error looks like this,
"innerError": "Cannot read server response."

Was this reply helpful? Yes No
eddiefok 4 on at

Like
a
(1)

Report
Copy link

Link copied!

this threat not help at all.

Was this reply helpful? Yes No
RichardD 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Agreed. If someone asks a question and you can't provide the answer in plain english, then don't post.

Was this reply helpful? Yes No
Thorsten_L 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi. I'm sorry. I can't really answer the question. It is long ago. I think it was like I suddenly didn't have a problem anymore. I experienced this several times. It might be related to plattform updates. I didn't do anything to fix it.

Was this reply helpful? Yes No