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. Sites

Get Sites

Retrieves SharePoint sites accessible via 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 sites from sharepoint [whose [condition]]

Retrieves SharePoint sites accessible via the Microsoft Graph API. It can optionally filter based on a given condition.

Base Syntax

get some sites from sharepoint

  • 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? ⛔ No — This part of the phrase does not require input data.

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 sites from sharepoint 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.

Examples

1. Retrieve accessible sites from SharePoint

get sites from sharepoint
process each site as follows
    say the site's name

2. Retrieve a single site by name

get sites from sharepoint whose name is "Human Resources"

Using a Single SharePoint Site

Even if you're getting just one site, SharePoint returns a set of matching results. So after this line:

get sites from sharepoint whose name is "Human Resources"

You'll need to add a line to specify a single site from the set of matching results:

use the first site as the site

Last updated 5 days ago

Was this helpful?