LogoLogo
About
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
  • BDK Books
  • AWS S3
    • Copy Item To a Folder
    • Create Folder In Another Folder
    • Delete Item
    • Download a File
    • Get Folder At a Path
    • Get Root folder From a Bucket
    • Get Buckets From S3
    • Get a Folder's Items
    • Move Item To a Folder
    • Rename Item
    • Upload File To a Folder
  • GitHub
    • Get Commits
    • Get a User
    • Get a Team
    • Get Teams
    • Get Repositories
    • Issues
      • Get Issues
      • Create an Issue
      • Update an Issue
    • Pull Requests
      • Get a Pull Request
      • Get Pull Requests
      • Create a Pull Request
      • Update a Pull Request
      • Request Reviewers
  • HTTP
    • DELETE Request
    • GET Request
    • HEAD Request
    • PATCH Request
    • POST Request
    • PUT Request
  • Microsoft Excel
    • Clear the Worksheet Range
    • Create a Table on a Worksheet Range
    • Create a Worksheet Range in a Sheet
    • Delete a Column from the Table
    • Delete a Row from the Table
    • Get the Cell's Color
    • Get the Cell's Formula
    • Get the Cell's Value
    • Get the Column's Cells from the Table
    • Get the Column Count in a Table
    • Get the Column Count in a Worksheet Range
    • Get the File's Sheets
    • Get the Following Row Range In a Worksheet Range
    • Get the Row's Cells from the Table
    • Get the Row's Cells From the Worksheet Range
    • Get the Row Count in a Table
    • Get the Row Count in a Worksheet Range
    • Get the Sheet's Tables
    • Get the Sheet's Used Range
    • Get the Worksheet Range's Rows
    • Get the Worksheet Range from the Table
    • Insert a New Column in the Table
    • Insert a New Row in the Table
    • Read the Content from a Table
    • Read the Content from a Worksheet Range
    • Retrieve the Columns from the Table
    • Retrieve the Rows from the Table
    • Retrieve the Worksheet Range from a Table
    • Set the Cell's Content to a Value
    • Set the Cell's Formula to a Formula Value
    • Write the Content in a Table
    • Write the Content in a Worksheet Range
  • Microsoft Outlook
    • Delete Emails
    • Download an Attachment
    • Forward an Email
    • Get a User's Events
    • Get an Email's Attachments
    • Get Event's Attachments
    • Get Email Folders for a User
    • Get Email Folders
    • Get Events in Calendar
    • Get Events
    • Get Outlook Emails
    • Mark Emails
    • Move Outlook Emails
    • Reply to an Email
    • Send an Email
  • Microsoft SharePoint
    • Examples
    • Document Libraries
      • Create a Folder
      • Create a Folder in Another Folder
      • Copy an Item to a Folder
      • Delete an Item
      • Download a File
      • Edit an Item
      • Get a Folder
      • Get a Folder's Items
      • Get a Root Folder
      • Get Items From a Document Library
      • Get Document Libraries
      • Move an Item To a Folder
      • Rename an Item
      • Upload a File to a Folder
    • Lists
      • Add a Column
      • Add an Item
      • Create a List
      • Delete a Column
      • Delete a List
      • Delete an Item
      • Get Items
      • Rename a Column
      • Rename a List
      • Retrieve a List as a Table
      • Retrieve a List's Column Definitions
      • Retrieve Lists
    • Sites
      • Get Sites
  • OpenWeather
    • Get the Current Temperature
  • Slack
    • Read Messages
    • Retrieve a Channel
    • Retrieve a User
    • Send a Message
  • ServiceNow
    • Create Record
    • Delete Records
    • Retrieve Records
    • Update Record
  • Truckmate
    • Create An Order in Truckmate
    • Update An Order in Truckmate
  • Twilio
    • To Read Some SMS Messages
    • To Send an SMS Message
Powered by GitBook
On this page
  • Syntax
  • Examples

Was this helpful?

Export as PDF
  1. Microsoft SharePoint
  2. Lists

Get Items

Retrieves all items within a given SharePoint list using the Microsoft Graph API.

To use this procedure, make sure your agent has learned the Sharepoint Book (BDK).

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

get some slist's items [whose [condition]]

When using it, it is very important to mark the item you are working with as a "slist" (Sharepoint list) so that the Brain matches this procedure. It can optionally filter based on a given condition.

Base Syntax

get some slist's items

  • What does it do? This is the base syntax for the procedure.

  • Where does it go? This phrase should be written on a new line.

  • Is it required? ✅ Yes — This part of the phrase is required.

  • Does it require input data? ✅ Yes — The list from which to retrieve items must be specified for the slist.

Filter Condition Syntax

whose [condition]

  • What does it do? This is an optional clause used to specify a condition for filtering.

  • Where does it go? If used, this clause immediately follows the get some slist's items phrase on the same line.

  • Is it required? 🌟 No — This clause is optional in the syntax.

  • Does it require input data? ✅ Yes — This clause requires a condition (a filter expression) to be specified.

the include empty columns are

What does it do? Specifies whether to include empty columns in the table.

Where does it go? This phrase should be indented beneath the main procedure syntax.

Is it required? 🌟 No — This phrase is optional in the syntax.

Does it require input data? ✅ Yes — A boolean whether to include empty columns in the table must be specified for the include empty columns.

Default: False

Examples

1. Get the items in a list

get the list as the slist
get the slist's items

2. Get the items in a list filtered by a column

get the list as the slist
get the slist's items whose "Title" is "First Item"

3. Get the items in a list filtered by a column and include empty columns

get the list as the slist
get the slist's items whose "Title" is "First Item"
    the include empty columns is "True"

Last updated 6 days ago

Was this helpful?