Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

(4) Share

Report

Posted on by Vijay Tailor

2,961

Hi Flow Experts,

I have a flow that will be trigger on "Create of New item in SharePoint List"

Error - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'. Error details: 'The API operation 'GetOnNewItems' is missing required property 'body/value/0/Title'.'

Please provide your valuable suggestion.

Thanks in advance/

All responses (45)

Answers (1)

Krickner 81 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

I've had this issue happen multiple times. Especially since they rolled out the "New Experience." The only surefire way I've worked around this and similar API issues with SharePoint is by editing the flow in the new experience, deleting either your trigger or Get Items action (not copying), adding a new trigger/Get Items, and saving the flow.
ShenolReetz 2 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

I solved this problem by removing the 'Require that this column contains information' option from the edit column settings.
JuanPierreJesus 2 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

In my case, this error occurs if the list I'm trying to retrieve is over the limit of lookup columns. So, my solution was create a view with only the columns that I needed. That's worked for me!
Nelson4 2 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

The solution for me was to open the box and create a new connection in Get Items
Raviteja1992 23 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

Try as mentioned in the attachment.
Last 2 years back I faced this challenge, and finally, I found the solution.
UnicornP 9 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

This is the answer for sure. I removed the blank entry and it worked as expected.
Sam2089 41 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

Which action you had to delete the action? i had the same problem
ndelvalle 4 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

Buenas tardes.
A mi me daba el error:
The API 'sharepointonline' returned an invalid response for workflow operation 'Obtener_archivos_(solo_propiedades)' of type 'OpenApiConnection'. Error details: 'The API operation 'GetFileItems' is missing required property 'body/value/0/Referencia'.'

Solución: Borrar o rellenar campos de Referencia que esten vacios. Si el campo Referencia no tiene datos, dara el error arriba indicado.
vinylmatt 8 on at

Like (0)

Report

Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

I was using a scheduled trigger (not a File Creation). But the same solution worked. Removed it and put it back in and it worked again.
erosenfeld 10 on at

Like (1)

Report
Re: Trying Finding the Root Cause for - The API 'sharepointonline' returned an invalid response for workflow operation 'When_an_item_is_created' of type 'OpenApiConnection'.

@mtiscia's insights worked for me. I got the error when the result set for Get Items SharePoint action returned an item with a blank / empty Title field value. I performed the following actions to mitigate the bug in the Get Items action:
Updated the Flow that creates list items to always include some default value for the Title field
Updated the existing list items whose Title field values were blank to the default value in the Flow that creates new list items.
I would say that this is a workaround rather than a solution. The solution would be for Microsoft to fix the bug in the Get Items SharePoint action to not error out when returning a list item whit an empty Title field value.