Update List Item SharePoint Block

[brevels]

Hi all, I'm attempting to update an existing SharePoint list item using the 'Update List Item' block in Qlik Automation. I am able to write new items to a SharePoint list using the 'Create List Item' block, but am stuck on the settings of the 'Update List Item' block. Specifically the 'Item Id' field. Does anyone have any experience or documentation on how this field should be populated? Thanks in advance!  

[Shai_E · Accepted solution]

Hi,

This is the documentation for the "Update List Item" endpoint:

Update listItem - Microsoft Graph v1.0 | Microsoft Docs

Json representation of how the listitem  resource looks like:

listItem resource - Microsoft Graph v1.0 | Microsoft Docs

Maybe you can make a request to the "Get List" endpoint, to get back a list, and one of the properties on a list is "items", which is an array of list items, which have a property of "id"

Hope this helps, im no expert on Microsoft SharePoint, but the above seems logical to me.

[brevels]

Just to close this out, the main issue was my lack of knowledge about SharePoint. As stated above, I had to pull the auto-generated id from the SharePoint list into my Qlik app to have something to link to. Other than hitting a 200 item limit, the updating works fine now. Thanks everyone!