Microsoft SharePoint Items API

List item operations

Operations 5

GET /web/lists/getbytitle('{list_title}')/items SharePoint Get List Items #
POST /web/lists/getbytitle('{list_title}')/items SharePoint Create List Item #
GET /web/lists/getbytitle('{list_title}')/items({item_id}) SharePoint Get List Item by ID #
POST /web/lists/getbytitle('{list_title}')/items({item_id}) SharePoint Update List Item #
DELETE /web/lists/getbytitle('{list_title}')/items({item_id}) SharePoint Delete List Item #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/sharepoint-items-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

sharepoint-items-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: SharePoint REST Files Items API
  description: The SharePoint REST API enables developers to interact remotely with SharePoint data using any technology that supports REST web requests. Provides CRUD operations on sites, lists, items, files, folders, permissions, and user profiles using OData protocol standards.
  version: '1.0'
  x-generated-from: documentation
  contact:
    name: Microsoft
    url: https://learn.microsoft.com/en-us/sharepoint/dev/
servers:
- url: https://{site_url}/_api
  description: SharePoint REST API endpoint
  variables:
    site_url:
      default: contoso.sharepoint.com/sites/mysite
      description: SharePoint site URL
tags:
- name: Items
  description: List item operations
paths:
  /web/lists/getbytitle('{list_title}')/items:
    get:
      operationId: getListItems
      summary: SharePoint Get List Items
      description: Retrieve items from a list.
      tags:
      - Items
      parameters:
      - name: list_title
        in: path
        required: true
        schema:
          type: string
        description: Title of the list.
        example: Tasks
      - name: $select
        in: query
        schema:
          type: string
      - name: $filter
        in: query
        schema:
          type: string
      - name: $orderby
        in: query
        schema:
          type: string
      - name: $top
        in: query
        schema:
          type: integer
      - name: $skip
        in: query
        schema:
          type: integer
      - name: $expand
        in: query
        schema:
          type: string
      responses:
        '200':
          description: Collection of list items.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ListItemCollection'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
    post:
      operationId: createListItem
      summary: SharePoint Create List Item
      description: Add a new item to a list.
      tags:
      - Items
      parameters:
      - name: list_title
        in: path
        required: true
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ListItemCreateRequest'
      responses:
        '201':
          description: Item created.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ListItem'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /web/lists/getbytitle('{list_title}')/items({item_id}):
    get:
      operationId: getListItemById
      summary: SharePoint Get List Item by ID
      description: Retrieve a specific list item by ID.
      tags:
      - Items
      parameters:
      - name: list_title
        in: path
        required: true
        schema:
          type: string
      - name: item_id
        in: path
        required: true
        schema:
          type: integer
        example: 1
      responses:
        '200':
          description: List item.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ListItem'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
    post:
      operationId: updateListItem
      summary: SharePoint Update List Item
      description: Update properties of a list item.
      tags:
      - Items
      parameters:
      - name: list_title
        in: path
        required: true
        schema:
          type: string
      - name: item_id
        in: path
        required: true
        schema:
          type: integer
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ListItemCreateRequest'
      responses:
        '204':
          description: Item updated.
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
    delete:
      operationId: deleteListItem
      summary: SharePoint Delete List Item
      description: Delete a list item (moves to recycle bin).
      tags:
      - Items
      parameters:
      - name: list_title
        in: path
        required: true
        schema:
          type: string
      - name: item_id
        in: path
        required: true
        schema:
          type: integer
      responses:
        '200':
          description: Item deleted.
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
components:
  schemas:
    ListItem:
      type: object
      description: SharePoint list item.
      properties:
        Id:
          type: integer
          example: 1
        Title:
          type: string
          example: My Task
        Created:
          type: string
          format: date-time
          example: '2026-04-17T09:00:00Z'
        Modified:
          type: string
          format: date-time
          example: '2026-04-17T10:30:00Z'
        AuthorId:
          type: integer
          example: 7
        EditorId:
          type: integer
          example: 7
    ListItemCreateRequest:
      type: object
      properties:
        __metadata:
          type: object
          properties:
            type:
              type: string
              example: SP.Data.MyListListItem
        Title:
          type: string
          example: New Item
    ListItemCollection:
      type: object
      properties:
        value:
          type: array
          items:
            $ref: '#/components/schemas/ListItem'
  securitySchemes:
    oauth2:
      type: oauth2
      description: OAuth 2.0 via Azure AD / Microsoft Identity Platform.
      flows:
        authorizationCode:
          authorizationUrl: https://login.microsoftonline.com/{tenant}/oauth2/v2.0/authorize
          tokenUrl: https://login.microsoftonline.com/{tenant}/oauth2/v2.0/token
          scopes:
            Sites.Read.All: Read all site collections.
            Sites.ReadWrite.All: Read and write all site collections.
            Sites.Manage.All: Create, edit, and delete items and lists.
            Sites.FullControl.All: Full control of all site collections.