Lodol Docs

Microsoft SharePoint

API actions for the Microsoft SharePoint integration.

Microsoft SharePoint

Manage SharePoint lists and files: create lists, add and update list items, and upload files.


Add list item

Add a new item to a SharePoint list.

Parameters

ParameterTypeRequiredDescription
site_idstringYesThe web address of your SharePoint site (for example, contoso.sharepoint.com).
list_idstringYesThe SharePoint list ID.
fieldsobjectYesThe column values for the new item. A basic list only has a 'Title' column; custom columns must be added to the list before they can be used.

Response

{
  "fields": {},
  "id": "item123"
}

Create list

Create a new SharePoint list in a site.

Parameters

ParameterTypeRequiredDescription
site_idstringYesThe web address of your SharePoint site (for example, contoso.sharepoint.com).
list_namestringYesName for the list.
descriptionstringNoOptional list description.
templatestringNoOptional type of list to create, such as genericList or documentLibrary.

Response

{
  "displayName": "New List",
  "id": "list123"
}

Delete list item

Delete an item from a SharePoint list.

Parameters

ParameterTypeRequiredDescription
site_idstringYesThe web address of your SharePoint site (for example, contoso.sharepoint.com).
list_idstringYesThe SharePoint list ID.
item_idstringYesThe item ID to delete.

Response

{
  "deleted": true
}

Get list items

Get items from a SharePoint list.

Parameters

ParameterTypeRequiredDescription
site_idstringYesThe web address of your SharePoint site (for example, contoso.sharepoint.com).
list_idstringYesThe SharePoint list ID.
topnumberNoOptional limit for the number of items to return.
filter_querystringNoOptional filter to narrow the results, written as an OData $filter (for example, fields/Title eq 'Invoice').

Response

{
  "value": [
    {
      "id": "item1"
    }
  ]
}

Update list item

Update an existing item in a SharePoint list.

Parameters

ParameterTypeRequiredDescription
site_idstringYesThe web address of your SharePoint site (for example, contoso.sharepoint.com).
list_idstringYesThe SharePoint list ID.
item_idstringYesThe item ID to update.
fieldsobjectYesThe column values to update. A basic list only has a 'Title' column; custom columns must already exist on the list.

Response

{
  "fields": {},
  "id": "item123"
}

Upload file

Upload a file to a SharePoint document library.

Parameters

ParameterTypeRequiredDescription
site_idstringYesThe web address of your SharePoint site (for example, contoso.sharepoint.com).
file_pathstringYesThe file to upload. Use a file from an earlier step in your workflow.
folder_pathstringNoOptional folder in the site's document library to upload into (for example, Reports/2026).
conflict_behaviorstringNoWhat to do if a file with the same name already exists: rename, replace, or fail.

Response

{
  "id": "file123",
  "name": "file.txt",
  "webUrl": "https://..."
}

On this page