--- title: "Connect Apaleo to Microsoft SharePoint - APIANT.ai" description: "When \"New Booking\" fires in Apaleo, your agent runs \"Add Attachment To List Item\" in Microsoft SharePoint." canonical: "https://apiant.ai/connect/apaleo-to-microsoft-sharepoint" --- # Connect Apaleo to Microsoft SharePoint When **New Booking** fires in [Apaleo](https://apiant.ai/connections/apaleo), your agent runs **Add Attachment To List Item** in [Microsoft SharePoint](https://apiant.ai/connections/microsoft-sharepoint). Describe the whole flow and it is built, tested on every scenario and kept running. Apaleo **5** triggers Apaleo **66** actions Microsoft SharePoint **100** actions What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it. ## What do you want Apaleo and Microsoft SharePoint to do together? Give your AI client this address. `https://mcp.apiant.ai` One connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser. ### Set it up in your client ### Claude Code Run this in the directory you want to work in. `claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai` Start Claude Code there, approve the server, and sign in in the browser page it opens. [Claude Code guide (opens in a new tab)](https://apiant.ai/docs/mcp/claude-code) ### Claude, web and desktop Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Cursor Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Zed Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Codex and the ChatGPT desktop app Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Any other MCP client Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) Example flows ## What Apaleo can start in Microsoft SharePoint - When **New Booking** in Apaleo then **Add Attachment To List Item** in Microsoft SharePoint - When **New Company** in Apaleo then **Add Role Assignment To Item** in Microsoft SharePoint Starting points drawn from the triggers and actions in the catalog today. Describe the flow you need, at any depth, and your agent builds it and tests every scenario before it ships. Everything your agent can do with Apaleo and Microsoft SharePoint ## Triggers and actions 5 triggers · 166 actions - Trigger **New Booking** Triggers when a new booking is created in Apaleo, returning the booker details and its reservations. - Trigger **New Company** Triggers when a new company is created in Apaleo. - Trigger **New Folio** Triggers when a new folio is created in Apaleo, newest first. - Trigger **New Reservation** Triggers when a new reservation is created in Apaleo, optionally limited to certain properties, statuses or channels. - Trigger **Reservation Updated** Triggers when a reservation is created or changed, including status changes such as check-in, check-out or cancellation. - Action **Add Allowance to Folio** Posts an allowance (a discount or credit) to a folio in Apaleo. - Action **Add Charge to Folio** Adds a charge for a good or service to a folio and posts it immediately. Returns the new charge id and any fee charge ids. - Action **Add Reservations to Booking** Creates one or more new reservations and adds them to an existing booking. Returns the ids of the reservations that were created. - Action **Amend Reservation Stay** Changes the stay details of a reservation: arrival, departure, number of guests and the rate plan for each night. - Action **Assign Unit to Reservation** Assigns a specific unit (room) to a confirmed or in-house reservation, optionally for part of the stay and optionally locking it. - Action **Book Service for Reservation** Books a service (such as breakfast or spa) onto an existing reservation, for the whole stay or for specific dates. - Action **Cancel Block** Cancels a block that is Definite or Tentative, changing its status to Canceled. - Action **Cancel Invoice** Cancels an invoice in Apaleo, creating a cancellation invoice and reopening the folio where applicable. - Action **Cancel Reservation** Cancels a confirmed reservation whose arrival is still in the future, setting its status to Canceled. - Action **Change Unit Condition** Changes the housekeeping condition (Clean, Clean to be inspected, Dirty) of a unit in apaleo. - Action **Check In Reservation** Checks in a confirmed reservation that has a unit assigned, moving it to In House. - Action **Check Out Reservation** Checks out an in-house reservation, setting its status to Checked Out and posting all open folio charges. - Action **Close Folio** Closes a folio so no further charges or payments can be added. Only possible when the folio balance is 0; this cannot be undone. - Action **Confirm Block** Confirms a tentative block, changing its status to Definite. - Action **Create Block** Creates a block of inventory for a group booking at a given rate plan and date range, and returns the new block's id. - Action **Create Booking** Creates a booking in Apaleo containing one or more reservations for a booker. Returns the new booking id and the ids of its reservations. - Action **Create Company** Creates a company (corporate account) for a property in Apaleo, with its address, tax details and bookable rate plans. - Action **Create Folio** Creates an additional guest folio for a reservation, or a new external folio for a property, with the given debitor. - Action **Create Group** Creates a group booking in Apaleo for one or more properties, with the booker's details. Returns the new group's id. - Action **Create Invoice** Creates an invoice for one folio. The folio's debitor must have a name, city, postal code and country. - Action **Create Maintenance** Creates a maintenance window (out of service, out of order or out of inventory) for a unit. - Action **Create Payment** Records a custom payment (cash, cheque, voucher or externally processed) on an Apaleo folio. - Action **Create Payment Link** Creates a link to a payment form where a guest can pay an amount toward a folio. Returns the id of the pending payment. - Action **Create Refund** Creates a refund on an Apaleo folio for the given amount and payment method. The refund is processed asynchronously. - Action **Create Unit** Creates a new unit (room) in an Apaleo property. - Action **Delete Block** Deletes a block, as long as no reservations have been picked up from it. - Action **Delete Company** Deletes a company and removes it from any rate plans that have not used it yet. - Action **Delete Folio** Deletes an empty, non-main folio. This cannot be undone. - Action **Delete Group** Deletes a group booking in Apaleo. Only possible while no blocks are linked to the group. - Action **Delete Maintenance** Deletes a maintenance window from a unit. Maintenances that started yesterday or earlier cannot be deleted. - Action **Get Block** Returns a specific Apaleo block (inventory held for a group booking) by its ID. - Action **Get Booking** Returns a booking with its booker details, reservations and property totals. - Action **Get Company** Returns a company (corporate account) by its ID, including its address, tax details and bookable rate plans. - Action **Get Folio** Returns one folio by ID, including its charges, allowances, payments, balance and debitor details. - Action **Get Group** Returns a specific group booking, optionally including its blocks and available actions. - Action **Get Invoice** Returns an invoice's details, including recipient, line items, payments, tax details and totals. - Action **Get Invoice PDF** Downloads the PDF file of an existing invoice. - Action **Get Maintenance** Returns a scheduled unit maintenance (out of service, out of order or out of inventory) by its ID, including its unit and time window. - Action **Get Payment** Returns a single payment on a folio, including its amount, method, status and dates. - Action **Get Property** Returns a property (hotel) by its id, including its name, address, company details, time zone and currency. - Action **Get Rate Plan** Returns a single rate plan by its ID, including its pricing, policies, restrictions and channels. - Action **Get Reservation** Returns a single reservation, including its guest, stay dates, rate plan, unit and amounts. - Action **Get Service** Returns a specific service (such as breakfast) with its price, availability and accounting settings. - Action **Get Stay Offers** Returns the available room offers (unit groups with rate plans and prices) for a property, arrival and departure date and number of guests. - Action **Get Unit** Returns a single unit (room or space) with its property, unit group, status, and attributes. - Action **Get Unit Group** Returns a unit group (room type) with its property, names, descriptions, capacity and unit count. - Action **List Bookings** Returns the bookings in your Apaleo account, optionally filtered by reservation, group, channel, external code or booker details. - Action **List Folios** Returns the folios in your Apaleo account, optionally filtered by property, reservation, booking, company, status, type, dates or balance. - Action **List Payments** Returns the payments recorded on a folio, newest first, optionally filtered by payment status. - Action **List Properties** Returns the list of properties (hotels) in the Apaleo account, optionally filtered by status or country. - Action **List Rate Plans** Returns the rate plans in your Apaleo account, optionally filtered by property, codes, channels, unit groups and other criteria. - Action **List Rates** Returns the prices and restrictions of a rate plan for each time slice in a date range. - Action **List Reservations** Returns the reservations in your Apaleo account, optionally filtered by booking, property, status, dates, guest text and more. - Action **List Services** Returns the services (extras such as breakfast or parking) set up for your properties, optionally filtered by property, name, channel or type. - Action **List Unit Groups** Returns the unit groups (room types, meeting rooms, parking and similar) defined in Apaleo, optionally for one property. - Action **List Units** Returns the units (rooms) of your Apaleo account, optionally filtered by property, unit group, condition, occupancy or name. - Action **Mark Invoice Paid** Marks an Apaleo invoice as paid, recording the payment method and receipt reference. - Action **Reopen Folio** Reopens a closed folio so charges and payments can be posted again. Only works when no invoice has been created for the folio. - Action **Update Booking** Updates a booking's comment, booker comment, booker or payment account. - Action **Update Company** Updates an existing company's name, contact details, tax IDs, address, invoicing options or rate plans. Fields left blank are not changed. - Action **Update Folio** Updates a folio's debitor or company in Apaleo. - Action **Update Group** Updates a group booking's name, comments, properties, booker or payment account. - Action **Update Maintenance** Updates the start, end or description of an existing maintenance window for a unit. - Action **Update Rates** Creates or overwrites the prices and restrictions of a rate plan for the given time slices. - Action **Update Reservation** Updates a reservation's comments, travel purpose, market segment, company, charge and pre-check-in flags, or applies other allowed changes such as the primary guest. - Action **Update Unit** Updates a unit's name, description, condition, unit group or maximum occupancy in Apaleo. Only the fields you fill in are changed. - Action **Add Attachment To List Item** Tool to add an attachment to a SharePoint list item. Use when you need to upload a binary file as an attachment to a specified list item. - Action **Add Default View Field** Add one existing field to a SharePoint list's default view. This changes view membership but does not create or modify the field itself. - Action **Add Field Link To Content Type** Tool to add a field link to a list content type. Use when you want to associate an existing list field with a content type. - Action **Add Role Assignment To Item** Tool to add a role assignment to a list item. Use when granting specific permissions to a user or group after breaking inheritance if needed. This action is externally visible and permanently alters item permissions; obtain explicit human approval for the target item and `role_definition_id` before executing. - Action **Add Role Assignment To List** Tool to add a role assignment to a SharePoint list. Requires the list to have broken role inheritance first via SHARE_POINT_BREAK_ROLE_INHERITANCE_ON_LIST; inheriting lists will reject unique role assignments. Use when granting permissions to a user or group on a specific list. - Action **Break Role Inheritance On Item** Tool to break permission inheritance on a list item. Call this before adding new role assignments; adding assignments prior leaves the item still inheriting parent permissions, causing unexpected access behavior. Use when you need to uniquely set permissions on an item after copying or clearing parent assignments. - Action **Break Role Inheritance On List** Breaks permission inheritance on a SharePoint list, allowing you to set unique permissions. When you break inheritance, you can choose to: - Copy parent permissions as a starting point (copy_role_assignments=true) - Start fresh with no inherited permissions (copy_role_assignments=false) - Clear unique permissions on child items to re-inherit from this list (clear_subscopes=true) Use this when you need to manage list-level permissions independently from the site. Must be called before SHARE_POINT_ADD_ROLE_ASSIGNMENT_TO_LIST, which fails on lists still inheriting from the parent site. - Action **Check In File** Tool to check in a file. Use after uploading or editing a document and you're ready to finalize changes. - Action **Check Out Site Page** Check out a modern SharePoint page by its positive Site Pages list-item ID. - Action **Clear Default View Fields** Remove every field from a SharePoint list's default view without deleting the fields themselves. This is a destructive view-configuration operation; use it only when the entire current default-view layout should be cleared. - Action **Copy Drive Item** Start an asynchronous copy of a drive item and return Microsoft's monitor URL. A successful call means the copy was accepted, not completed; inspect the monitor outside this action until it reports completed or failed. - Action **Create Content Type** Tool to create a new content type in SharePoint. Use when you need to define a custom content type with specific metadata structure for lists or libraries. - Action **Create Drive Item Sharing Link** Tool to create a sharing link for a drive item in SharePoint or OneDrive. Use when you need to generate a shareable link with specific permissions (view/edit/embed) and scope (anonymous/organization/users). The link can optionally include password protection and expiration date. - Action **Create List Field** Tool to create a new field (column) in a SharePoint list. Use when you need to programmatically add a column after confirming the list GUID. - Action **Create List Item By Id** Tool to create a new item in a SharePoint list using the list's GUID. Use when you have the list GUID rather than the list title. - Action **Create List Item In Folder** Tool to create a list item in a specific folder within a SharePoint list. IMPORTANT: This action works ONLY with SharePoint lists (not document libraries). The folder_url can be either a server-relative URL (e.g., '/Lists/MyList') or an absolute URL. To create files in document libraries, use a different action like upload_file. - Action **Create List View** Create a view in a SharePoint list selected by GUID or exact title. Optional view settings are sent only when provided. - Action **Create Site Field** Create a reusable web-level SharePoint field (site column) in the selected site. Use the returned field GUID and internal name when attaching or updating the site column. - Action **Create Upload Session** Create a resumable upload session for a new file and return its preauthenticated upload URL. - Action **Delete File Item** Deletes a file from a SharePoint document library permanently. This action removes the specified file and moves it to the site's recycle bin. Use this when you need to remove files that are no longer needed. This action is irreversible — the file cannot be recovered once removed from the recycle bin. The operation is idempotent - attempting to delete a non-existent file will succeed without error. Requires the server-relative path of the file (e.g., '/Shared Documents/FileName.ext'). - Action **Delete Folder** Deletes a folder from a SharePoint document library. This action permanently removes the specified folder and moves it to the site's recycle bin. Use this when you need to remove folders that are no longer needed. The operation is idempotent - attempting to delete a non-existent folder will succeed without error. Requires the server-relative path of the folder (e.g., '/Shared Documents/FolderName'). - Action **Delete List** Tool to delete a SharePoint list. Use when you need to remove a list by its GUID after confirming the correct list identifier. - Action **Delete List By Title** Tool to delete a SharePoint list by its title. Use when you need to permanently remove a list and all its contents by specifying the list name. - Action **Delete List Item** Tool to delete a SharePoint list item. Use when you need to permanently remove an item by its ID. Use after obtaining the item's ETag to ensure concurrency control. - Action **Delete List Items** Tool to delete multiple SharePoint list items in bulk. Use when you need to permanently remove multiple items by their IDs. This action is irreversible - deleted items cannot be recovered. For recoverable deletion, use the recycle action instead. Use this action when you have a list of item IDs to delete from the same list. - Action **Delete Recycle Bin Item Permanent** Tool to permanently delete a SharePoint Recycle Bin item. Use after confirming the item's GUID to remove it irrevocably. - Action **Download File By Server Relative Url** Tool to download a file by server-relative URL. Use when you need to fetch the raw bytes of a SharePoint file by its server-relative path. - Action **Ensure User** Ensures a user exists in a SharePoint site by their login name. If the user already exists, returns their info; if not, adds them to the site — this is a write operation with a provisioning side effect, not a read-only presence check. Use when you need to add a user or get their user ID for permissions. The login name must be in SharePoint claims format (e.g., 'i:0#.f|membership|user@domain.com'). This action only registers the user in the site collection and does not grant any permissions. To assign list-level access, pass the returned Id field as principal_id to SHARE_POINT_ADD_ROLE_ASSIGNMENT_TO_LIST. - Action **Follow** Follow a SharePoint user, document, site, or tag. Use to make the authenticated user follow a specified actor. Supports following users (actor_type=0), documents (actor_type=1), sites (actor_type=2), or tags (actor_type=3). - Action **Get Changes** Tool to retrieve changes from SharePoint list change log. Use when processing webhook notifications to get actual changes that occurred. Set boolean flags in query (Add, Item, Update, etc.) to filter change types. Store the ChangeToken from the last change and use as ChangeTokenStart in subsequent calls to track only new changes. - Action **Get Content Type** Tool to retrieve a single SharePoint content type by its ID. Use when you need detailed information about a specific content type including its fields, forms, and metadata. - Action **Get Content Types For List** Tool to retrieve all content types for a specific SharePoint list by GUID. Use when you need the content type IDs, names, and descriptions of every content type in a list. - Action **Get Drive By Id** Get one SharePoint or OneDrive drive by its drive ID from the selected site endpoint. - Action **Get Drive Item Analytics** Tool to get analytics for a SharePoint drive item. Use when you need to retrieve access statistics (view counts, unique viewers) for files or folders in SharePoint/OneDrive. - Action **Get Drive Item By Id** Get metadata for one file or folder by drive ID and item ID from a SharePoint site or provider-derived OneDrive for Business personal-site URL. - Action **Get Drive Item Thumbnails By Path** Retrieve thumbnail URL and dimension sets for a default-drive item by path. - Action **Get Group Users** Retrieves all users who are members of a specified SharePoint group. This action returns user information including IDs, names, email addresses, login names, and permission details. Supports OData query parameters for filtering, sorting, field selection, and pagination. Use this when you need to audit group membership, check user permissions, or list members of a specific group. - Action **Get Group Users By Id** Tool to retrieve all users in a specific SharePoint site group by group ID. Use when you have the numeric group ID and need to list all members of that group, including their IDs, names, email addresses, and permission details. Supports OData query parameters for filtering, sorting, field selection, and pagination. - Action **Get Item Attachment Content** Tool to download an attachment from a SharePoint list item. Use when retrieving the binary contents of a specific attachment after confirming the list title, item ID, and filename. - Action **Get List By Guid** Tool to retrieve a SharePoint list by its GUID. Use when you need to fetch list metadata by its unique identifier. Prefer over name-based lookup tools when the GUID is known, as names may collide across similarly named lists. - Action **Get List By Title** Tool to retrieve a SharePoint list by its title. Use when you need to fetch list metadata by title. - Action **Get List Content Type By Id** Tool to retrieve a specific content type from a SharePoint list by its ID. Use when you need detailed information about a particular content type including its fields, schema, and metadata. - Action **Get List Field** Get one field definition from a SharePoint list by field GUID or exact internal name/title. - Action **Get List Item By Id** Tool to retrieve a SharePoint list item by ID. Use when you need to fetch a specific item after knowing its ID. - Action **Get List Items** Tool to retrieve items from a SharePoint list. Use when you need to fetch list entries with optional OData parameters. - Action **Get List Items By Guid** Tool to retrieve items from a SharePoint list using its GUID. Use when you have the list's unique identifier and need to fetch list entries with optional OData parameters. - Action **Get List Item Version** Tool to retrieve a specific version of a SharePoint list item. Use when you need to access historical versions of list items. - Action **Get Shares** Access a shared SharePoint file or folder by share ID or encoded sharing URL without granting lasting access. - Action **Get Site By Hostname** Retrieve SharePoint site information by hostname or URL. Returns site metadata including site ID, display name, URLs, and timestamps. Use this action when you need to discover a site's identifier or properties using only its hostname, which is essential for subsequent operations requiring siteId. Useful for validating site existence or obtaining site metadata without prior knowledge of internal IDs. - Action **Get Site By Id** Tool to retrieve information about a SharePoint site (web) by its unique identifier. Use this action when you have a specific site GUID and need to fetch its metadata such as title, URL, language, or template information. - Action **Get Site Drive Item By Path** Tool to retrieve a file or folder by its server-relative path in a SharePoint site. Use when you need to get metadata for an item (file or folder) by path. - Action **Get Site Page Content** Tool to retrieve modern SharePoint Site Pages content by reading list item fields. Use when a.aspx page result cannot be downloaded as a file or when you need the structured content (CanvasContent1, LayoutWebpartsContent) of modern pages. - Action **Get Upload Session** Returns the status of a resumable file upload session: which byte ranges are still expected and when the session expires. - Action **Get User Effective Permissions On Web** Get a user's effective permissions on the current SharePoint site (Web). This action retrieves the combined permissions a user has on the site, taking into account direct permissions, group memberships, and permission inheritance. Use this when you need to verify what permissions a user or group has before performing operations. The response contains permission masks as 64-bit integers split into high and low 32-bit values. A value of "0" for both means no permissions. Returns site-level permissions only; list-level or item-level grants and restrictions are not reflected. - Action **Get Webhook Subscriptions** Tool to retrieve all webhook subscriptions on a SharePoint list. Use when you need to view existing webhook configurations for a list. - Action **Is Followed** Tool to check if the current user is following a specified actor. Use when verifying follow status before performing follow or unfollow operations. - Action **List Content Type Field Links** Returns the field links (columns) attached to a SharePoint site content type. - Action **List Default View Fields** List the field internal names currently displayed in a SharePoint list's default view. Use this before adding or clearing default-view fields, and use SHARE_POINT_LIST_LIST_COLUMNS when full field definitions are needed. - Action **List Drive Children** Tool to list children (files and folders) in a SharePoint drive using REST API v2.0. Use when you need to enumerate items in a drive's root folder or a specific folder within the drive. - Action **List Drive Item Permissions** List effective sharing permissions for one drive item. This returns drive-item sharing/link permissions, not SharePoint web role assignments; non-owners may receive only permissions that apply to them. - Action **List Drive Item Versions** List retained versions of a SharePoint drive item, newest first. - Action **List Drive Recent Items** Tool to list recently modified items in a SharePoint drive using Microsoft Graph API. Returns files and folders from the root folder sorted by modification time (most recent first). Note: This action uses the /root/children endpoint with $orderby=lastModifiedDateTime desc to retrieve recently modified items from the root folder. - Action **List Files In Folder** Tool to list files within a SharePoint folder (non-recursive; does not enumerate subfolders). Use when you need to enumerate all files in a folder by its server-relative URL. To cover nested structures, call the tool separately for each subfolder. - Action **List Item Attachments** Tool to list all attachments for a SharePoint list item. Use when you need to retrieve filenames and server-relative URLs of each attachment after confirming the list title and item ID. - Action **List List Columns** List column definitions for a SharePoint list. First use SHARE_POINT_LIST_ALL_LISTS on the target site to obtain the list Id, then call this action with that list_id and the same site_name. Returns field metadata including column names, types, and properties. - Action **List List Views** List saved views for a SharePoint list selected by GUID or exact title, with optional OData projection, filtering, sorting, and offset pagination. - Action **List Scoped Role Assignments** List principals and expanded permission-level bindings on a SharePoint list or list item. The delegated user must have a permission level containing Enumerate Permissions on the selected resource. - Action **List Subfolders In Folder** Tool to list immediate child folders within a SharePoint folder. Use when you need folder navigation or directory discovery by server-relative URL. - Action **Publish Site Page** Publish the latest version of a modern SharePoint site page by its positive item ID. - Action **Recycle File** Tool to move a file to the Recycle Bin. Use when you need to recycle a file after confirming its folder and filename paths. - Action **Recycle List Item** Tool to move a list item to the Recycle Bin. Use when you need to soft-delete an item but preserve the ability to restore it. - Action **Redeem Share** Redeem a SharePoint sharing link and grant the connected account durable access to the shared file or folder. - Action **Rename Folder** Renames a SharePoint folder by updating its list item metadata. To use this action: 1. Provide the folder path and new leaf folder name. 2. The action updates the folder list item fields needed by SharePoint. The rename operation updates both the folder's display name (Title) and actual name (FileLeafRef). Note: This only changes the folder name, not its location in the hierarchy. - Action **Render List Data As Stream** Retrieve list items from SharePoint with rich metadata and formatting. Returns items in the 'Row' array along with pagination info (FirstRow, LastRow, NextHref). Supports CAML queries via ViewXml for filtering and sorting. Use this when you need list data with properly formatted field values, lookup fields, or managed metadata - more capable than standard OData endpoints. - Action **Resolve Sharing Link** Resolve a SharePoint sharing URL or provider share token to its underlying drive item. Provide exactly one of sharing_url or share_token. - Action **Restore Drive Item Version** Tool to restore a previous version of a SharePoint drive item. Use when you need to revert a file to an earlier version. - Action **Restore Recycle Bin Item** Tool to restore a SharePoint Recycle Bin item. Use when you need to recover a deleted item by providing its GUID. - Action **Search Files** Search for files across all SharePoint sites and OneDrive using Keyword Query Language. Returns files matching the query with metadata like title, path, size, author, and modification time. Use this action when you need to discover files broadly across an organization without knowing specific drive IDs or site locations. Results are automatically filtered to show only document content types. A site_name changes the endpoint context but does not isolate results unless restrict_to_site_path is enabled or query contains an equivalent Path restriction. Use from_index and row_limit parameters to paginate through large result sets. - Action **Search Query** Search SharePoint content using Keyword Query Language (KQL). Returns documents, list items, folders, and other content matching your query. Supports filtering by properties (file type, author, date), pagination, and custom property selection. Results are nested under PrimaryQueryResult→RelevantResults→Table→Rows→Cells as Key/Value pairs requiring explicit extraction. Results are security-trimmed: inaccessible content never appears even if it exists. Use contentclass (e.g., STS_Site, STS_Web, STS_ListItem_DocumentLibrary) in querytext to isolate specific item types. A site_name changes the endpoint context but does not isolate results unless restrict_to_site_path is enabled or querytext contains an equivalent Path restriction. - Action **Sharepoint Check Out File** Tool to check out a file in a document library. Use when you need to lock a file before making changes. - Action **Sharepoint Create Folder** Creates a new folder in sharepoint using the rest api. - Action **Sharepoint Create List** Creates a new list in sharepoint using the rest api. - Action **Sharepoint Create List Item** Creates a new item in a sharepoint list. - Action **Sharepoint Create User** Creates a new user in sharepoint. - Action **Sharepoint Find User** Finds a user in both microsoft graph and sharepoint to verify their existence and status. - Action **Sharepoint Remove User** Removes a user from sharepoint. will not fail if user doesn't exist. - Action **Undo Checkout File** Tool to undo a file checkout, discarding any changes made while checked out. Use when you need to cancel edits and unlock the file without saving. - Action **Update Content Type** Tool to update a SharePoint content type's properties such as name, description, group, or hidden status. Use when you need to modify content type metadata. - Action **Update Drive Item** Tool to update the properties of a drive item (file or folder) in SharePoint using SharePoint REST API. Use when you need to rename files/folders or update their title property. - Action **Update File Item** Tool to update metadata fields on a SharePoint file item via its ListItemAllFields. Use this action when you need to modify document properties, custom columns, or metadata without changing the file content itself. This operates on the list item behind the file, allowing you to set Title, Status, Owner, Categories, or any other library column. - Action **Update List** Tool to update properties of an existing SharePoint list. Use when you need to modify list metadata such as title, description, or settings like versioning and attachments. - Action **Update List Field** Update one or more mutable properties of an existing SharePoint list field identified by list and field GUID. Provide at least one of title, description, required, hidden, indexed, or enforce_unique_values. This changes the field schema for the selected list. - Action **Update List Item** Tool to update fields on an existing SharePoint list item. Use when you need to modify an item's properties with proper ETag concurrency control via MERGE. - Action **Update List View Fields** Add, move, or remove all fields in one SharePoint list view selected by GUID or title. - Action **Update Site** Tool to update properties of the current SharePoint site (web). Use when you need to modify site title, description, or other SP.Web properties via MERGE. - Action **Update Site Field** Update mutable properties of an existing SharePoint site field by GUID. Provide at least one of title, description, required, hidden, indexed, or enforce_unique_values. This changes reusable web-level schema for the selected site. - Action **Upload File** Tool to upload a file to a SharePoint document library or folder. Use when you need to programmatically add or update a file in a document library. - Action **Upload From Url** Tool to fetch a file from a URL and upload it to SharePoint. Use when you need to upload files directly from external URLs without downloading them to the client first. When a file with the same name already exists, use conflict_behavior to control the behavior: - 'replace': Overwrites the existing file (fails with HTTP 423 if the file is locked/open) - 'fail': Returns an error if a file with that name exists - 'rename': Uploads with an auto-generated suffix (e.g., 'report 1.docx'), bypassing file locks - Action **Upload Large File** Create a direct-v2 upload session and upload one file in sequential chunks. - Action **Validate And Update Document Fields** Validate and commit document-library field values for a SharePoint file. Inspect every returned HasException and ErrorMessage because HTTP 200 can include rejected fields. ## Each app on its own - [ **Apaleo** Cloud-native, API-first property management system for hotels, apartments, and hospitality operators.](https://apiant.ai/connections/apaleo) - [ **Microsoft SharePoint** SharePoint is a Microsoft platform for document management and intranets, enabling teams to collaborate...](https://apiant.ai/connections/microsoft-sharepoint) Reviews ## What our customers say ## More from Apaleo - [ **Apaleo to HubSpot** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/apaleo-to-hubspot) - [ **Apaleo to Salesforce** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/apaleo-to-salesforce) - [ **Apaleo to Slack** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/apaleo-to-slack) - [ **Apaleo to Google Sheets** Google Sheets](https://apiant.ai/connect/apaleo-to-google-sheets) - [ **Apaleo to Gmail** Gmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...](https://apiant.ai/connect/apaleo-to-gmail) - [ **Apaleo to Google Calendar** Google Calendar is a time management tool providing scheduling features, event reminders, and integration...](https://apiant.ai/connect/apaleo-to-google-calendar) ## More into Microsoft SharePoint - [ **HubSpot to Microsoft SharePoint** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/hubspot-to-microsoft-sharepoint) - [ **Salesforce to Microsoft SharePoint** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/salesforce-to-microsoft-sharepoint) - [ **Slack to Microsoft SharePoint** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/slack-to-microsoft-sharepoint) - [ **Google Sheets to Microsoft SharePoint** Google Sheets](https://apiant.ai/connect/google-sheets-to-microsoft-sharepoint) - [ **Gmail to Microsoft SharePoint** Gmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...](https://apiant.ai/connect/gmail-to-microsoft-sharepoint) - [ **Google Calendar to Microsoft SharePoint** Google Calendar is a time management tool providing scheduling features, event reminders, and integration...](https://apiant.ai/connect/google-calendar-to-microsoft-sharepoint) Questions ## Apaleo and Microsoft SharePoint, answered ### ### What can start an automation from Apaleo? Any of Apaleo's 5 triggers in the catalog, including New Booking, New Company, New Folio and New Reservation. Describe the moment in plain language and your agent picks the right one. ### ### What can your agent do in Microsoft SharePoint when something happens in Apaleo? Any of Microsoft SharePoint's 100 actions, including Create Content Type, Create Drive Item Sharing Link, Create List Field and Create List Item By Id. Your agent maps the data both ways and tests every scenario before it ships. ### ### Can it also run from Microsoft SharePoint to Apaleo? Microsoft SharePoint has no triggers in the catalog today, so automations start in Apaleo. If you need the other direction, ask: your agent reads Microsoft SharePoint's API documentation and adds it. ### ### Do I have to build a connector for Apaleo or Microsoft SharePoint? No. Both are in the catalog with their triggers and actions. You describe the automation; your agent builds it, tests every scenario and keeps it running. ### ### Can my AI client use Apaleo and Microsoft SharePoint without building an automation? Yes. With your AI client connected to APIANT, ask it to do something in either app once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running. One connection covers both. ### ### What happens when something fails? Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships. ### ### Is there a free plan? Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.