401 SharePoint - The response is not in a JSON format

[lreinhard7]

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"

[v-bacao-msft]

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,

[lreinhard7]

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

[Thorsten_L]

Hi,

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

regards,

Thorsten