- はじめに
- 開発
- HTTP 要求
- コネクタ ノードの動作の仕組み
- コネクションを作成する
- Sales and customer relationships
- Customer support and help desk
- Messaging and meetings
- メール
- Marketing
- Social media
- Files, documents, and e-signature
- Projects, collaboration, and code
- People and recruiting
- Finance and commerce
- AI models and agents
- Speech, vision, and language
- Data and location
- Cloud, identity, and security
- デプロイして実行する
- 例
- 参照
Microsoft OneDrive と SharePoint
Look up the Microsoft OneDrive & SharePoint connector: its actions and events in alphabetical order, and the sign-in methods of a Microsoft OneDrive & SharePoint connection.
The Microsoft OneDrive & SharePoint connector lets a workflow manage files, folders, SharePoint lists, and Excel workbooks in OneDrive and SharePoint. In the Add node panel, it's in the Connector category, under Microsoft OneDrive & SharePoint. How connector nodes work describes how a connector node is set up.
This page lists what the connector can do in Maestro Automate. Select an event to see its details in the Integration Service guide.
アクション
Each action is a node that does one thing in Microsoft OneDrive & SharePoint.
| 操作 | 機能 |
|---|---|
| リスト アイテムを追加 | Add a new item to SharePoint List. |
| シートを追加 | Add a new sheet to the workbook. |
| 秘密度ラベルを割り当て | Assign a sensitivity label to a file in OneDrive. |
| ファイル/フォルダーをコピー | Copy a file or folder to the specified destination folder in OneDrive or SharePoint. |
| フォルダーを作成 | Create a folder at the specified location in OneDrive or SharePoint. |
| ブックを作成 | Create a new workbook in OneDrive or SharePoint Document Library. |
| 列を削除 | Delete a column from a worksheet in workbook. |
| ファイル/フォルダーを削除 | Delete a file or folder at the specific location in OneDrive or SharePoint. |
| リスト アイテムを削除 | Delete an item from a SharePoint List. |
| 範囲を削除 | Delete data from specified range in workbook. |
| 行を削除 | Delete data from specified rows in workbook. |
| シートを削除 | Delete a specified sheet from workbook. |
| ファイルをダウンロード | Download a file or folder from OneDrive & SharePoint. |
| ファイルをチェックイン/チェックアウト | SharePoint ファイルをチェックインまたはチェックアウトします。 |
| ファイルまたはフォルダーの存在を確認 | Check whether a file or folder exists in OneDrive or SharePoint. |
| ファイル/フォルダーを取得 | Get file or folder from OneDrive or SharePoint to use in other activities. |
| Get File or Folder by Sharing Url | Resolve a OneDrive or SharePoint URL into a Reference ID and other identifiers that other activities accept as input. |
| ファイル/フォルダーのリストを取得 | Retrieve a list of files and folders from the specified OneDrive or SharePoint location. |
| ファイルまたはフォルダーのメタデータを取得 | Fetch metadata for a file from OneDrive & SharePoint. |
| リスト アイテムを取得 | Retrieve a list of items from a SharePoint List. |
| 秘密度ラベルを取得 | Retrieve the sensitivity labels applied to a file. |
| 単一のリスト アイテムを取得 | Retrieve a single item from a SharePoint List. |
| ファイル/フォルダーを移動 | Move a file or folder to the specified destination folder in OneDrive or SharePoint. |
| セルを読み込み | Read the value of a cell in a worksheet. |
| 範囲を読み込み | Read data from a range of cells in a worksheet. |
| シート名を変更 | Rename an existing worksheet in a workbook. |
| ファイル/フォルダーを共有 | Share a file or folder. |
| ファイルまたはフォルダーのメタデータを更新 | Update metadata for a file or folder in OneDrive. |
| リストの項目を更新 | Update an item in a SharePoint List. |
| ファイルをアップロード | Upload the specified file to OneDrive or SharePoint. |
| セルに書き込み | Write data into a specified cell of worksheet in workbook. |
| Write Column V2 | Write data into column in specified range of worksheet with advanced options. |
| 範囲に書き込み | Write data into specified range in worksheet. |
| 行を書き込み | Write data into row in specified range of worksheet. |
The panel also lists 5 actions marked (deprecated), which aren't listed here. Use the actions above instead.
イベント
Each event can start a workflow, as a Connector trigger, or pause a run until it happens, as a Connector event. In the connector's list, events have the WAIT tag.
| イベント | 機能 |
|---|---|
| ワークシート内のセルの更新時 | Starts the automation when a cell within a Worksheet is updated. |
| ファイルの作成時 | Triggers when a new file is created in the drive. |
| File Moved to Trash | Triggers when an existing file is moved to trash from the drive. |
| ファイルの更新時 | Triggers when an existing file is updated in the drive. |
| Folder Moved to Trash | Triggers when an existing folder is moved to trash in the drive. |
| リストアイテムの追加時 | When a new item is added to a SharePoint List. |
| リストアイテムの更新時 | When an item is modified in a SharePoint List. |
| テーブルの下部に追加された行 | When a row at the bottom of a table is filled in with appropriate columns as an optional data filter. |
| ワークシートの作成時 | Starts the automation when a new Sheet within a Spreadsheet is created. |
コネクション
A Microsoft OneDrive & SharePoint node signs in through a connection. Create a connection describes how to create one from the node. On the Connect to page, choose one of these sign-in methods:
| Sign-in method | 必要なもの |
|---|---|
| OAuth 2.0 の認可コード | Your Microsoft account. It uses the UiPath public app, with delegated permissions. |
| OAuth 2.0 クライアント資格情報 | A service account, with application permissions. |
| クライアント証明書の認証 | A client certificate instead of a client secret, with application permissions. |
| 独自の OAuth 2.0 アプリ (BYOA) を使用する | A private app that you register in Azure, with delegated permissions. |
| PKCE を使用した OAuth 2.0 認可コード | A private app that you register, without a client secret, with delegated permissions. |
Some methods need an administrator of your Microsoft tenant to grant consent first. PKCE stands for Proof Key for Code Exchange.
Microsoft OneDrive & SharePoint authentication in the Integration Service guide describes the full connection setup, including prerequisites and advanced settings.
次のステップ
- Connector: every connector, grouped by area.
- Create a connection: sign a workflow in to an app.
- コミュニティ: UiPath フォーラムで質問したり、他のビルダーとワークフローを共有したりできます。