topic Re: Delete items from Sharepoint list in Workato Pros Discussion Board

Delete items from Sharepoint list

roland-daane — Thu, 04 Nov 2021 21:55:14 GMT

Hi, I'm trying to delete all items from a SharePoint list, but keep getting this error:

412 Precondition Failed: {"odata.error":{"code":"-1, Microsoft.SharePoint.Client.ClientServiceException","message":{"lang":"en-US","value":"The request ETag value '' does not match the object's ETag value '\"d83ffc2b-6c9f-4db1-b0b1-1c1bfcfd4c16,1\"'."}}}

I found thet the headers needed to include:

X-HTTP-Method: Merge

If-Match: ETag

I first call:

_api/web/lists/getByTitle('B360__Issues')/items

Then in a loop

_api/Web/Lists/getByTitle('B360__Issues')/getItemById(ID from step 2)

Re: Delete items from Sharepoint list

roland-daane — Thu, 04 Nov 2021 23:32:35 GMT

I got the 2 headers in, but still getting the same error.....

Re: Delete items from Sharepoint list

sophat-sam — Thu, 04 Nov 2021 23:38:17 GMT

hi Roland Daane ! here's an example call that worked for me with the headers called out:

Re: Delete items from Sharepoint list

sophat-sam — Thu, 04 Nov 2021 23:39:40 GMT

here's the

step itself with the data outputs from the loop:

Re: Delete items from Sharepoint list

sophat-sam — Thu, 04 Nov 2021 23:43:02 GMT

here's the example recipe: https://app.workato.com/recipes/1833010?st=3f1613

Re: Delete items from Sharepoint list

roland-daane — Fri, 05 Nov 2021 03:15:26 GMT

Hi Sophat,

It runs now without errors.

For some reason the foreach loop just picksup 1 item whilt the Json output for step 2 contains a couple of hundred items.

It does delete that 1 record.

Oh and by the way: had a great discussion with our NL business and they're opening up to using Workato to connect with autodesk Construction Cloud....

Re: Delete items from Sharepoint list

roland-daane — Fri, 05 Nov 2021 15:14:58 GMT

Got it Sophat, thanks.

I really need to get into Workato more.

In the do untill loop you just drag the datapil from the previous step....

It's working now!

What I want to do is undex the ID column where I store the Autodesk Issue ID's.

Then create a list item.

If that fails (the record already exists), then update that record.

This will prevent having to search the list if a record exists.