SharePoint で作成された共有リンクのレポートを作ってみる 1
- SharePoint Online で作成された共有リンクについて調べてみた
- SharePoint で作成された共有リンクのレポートを作ってみる ～準備編～ ※前回記事
- SharePoint で作成された共有リンクのレポートを作ってみる 1
前回は、環境構築を少し熱心に記事にしました
今回は、データを取得するところに焦点をあてて記事にします
Contents
利用する API
実際は根気よく泥臭く調べたんですが、3 分間クッキング方式で出しておきますね
今回使う API は 3 つです
サイトユーザーの情報を取得する API
一番最初の記事「SharePoint Online で作成された共有リンクについて調べてみた」の時に気づいたのですが、共有リンクのデータの中には、名前を表す値がありませんでした
レポートには名前も表示したいので、サイトユーザーとして取得できる値を使うことにします
_api/web/SiteUsers?$select=Id,Title,PrincipalType,Email,IsEmailAuthenticationGuestUser,IsShareByEmailGuestUser,IsSiteAdmin$select では、取得するフィールドを選択しています
共有リンクの情報を取得する API
共有リンクの情報を保持しているリストから、必要な情報を絞って情報を取得します
_api/web/lists/getbytitle('共有リンク')/items?$select=Id,SharingDocId,AvailableLinksドキュメントライブラリの情報を取得する API
共有リンクレポートの対象となる、ドキュメントライブラリの情報を取得します
レポートに出力しそうな情報を取得していますが、実際は必要な部分に絞ったほうが効率が良くなります
_api/web/lists/getbytitle('ドキュメント')/items?$select=HasUniqueRoleAssignments,File/Length,File/Name,File/TimeCreated,File/TimeLastModified,Id,Title,Author/EMail,Author/Title,Editor/EMail,Editor/Title,FileRef,RoleAssignments/Member/Title,RoleAssignments/Member/PrincipalType,RoleAssignments/Member/Users,RoleAssignments/Member/Users/Title,RoleAssignments/Member/Users/Email,RoleAssignments/Member/Users/IsEmailAuthenticationGuestUser,RoleAssignments/Member/Users/IsShareByEmailGuestUser,RoleAssignments/Member/Users/AadObjectId&$expand=File,RoleAssignments/Member,RoleAssignments/Member/Users,Author,Editor&$orderby=Id$select で取得するフィールドを選択しているのは先程と同じですが、 $expand で取得する情報を広げています
Power Automate で確認してみる
早速、利用する API を確認してみるために、Power Automate でフローを作成します
-
https://make.powerautomate.com/ にアクセスし、[マイフロー] -> [ + 新しいフロー ] -> [ インスタント クラウドフロー ] をクリックします
-
フロー名を入力し、「フローを手動でトリガーする」にチェックを入れて、[ 作成 ] をクリックします
-
右上の [ 新しいデザイナー ] のトグルボタンをクリックしてオフにします
※新しいデザイナーのままでもいいとは思うのですが、以前バグや重さに悩まされたことがあり、個人的にはまだ古いインターフェースを利用しています
フローの準備が完了したので、早速 3 つの API を見ていきましょう
サイトユーザーの情報を取得し、データを確認する
- [ + 新しいステップ] をクリック
- 検索窓にsharepoint と入力し、SharePoint に HTTP 要求を送信します を選択することで、コネクタが追加される
- コネクタ右上の三点リーダーをクリック、[ 名前の変更 ] を選択し、コネクタの名前を変更
- 下記のように設定する
- サイトのアドレス: https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport
- 方法: GET
- URI:
_api/web/SiteUsers?$select=Id,Title,PrincipalType,Email,IsEmailAuthenticationGuestUser,IsShareByEmailGuestUser,IsSiteAdmin
- 上部メニューから [ 保存 ] をクリックし、その後 [ テスト ] をクリック
- [ 手動 ] を選択し、[ テスト ] をクリック
- 初めてつなぐときは確認ウィンドウが出るので、[ 続行 ] をクリック
- [ フローの実行 ] をクリック
- [ 完了 ] をクリック
- サイトユーザーの取得をクリック、出力欄の body が取得したデータとなる
出力欄のデータに対して、一部マスクを施したデータが以下となります
{
"d": {
"results": [
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(7)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(7)",
"type": "SP.User"
},
"Id": 7,
"Title": "miyamiya",
"PrincipalType": 1,
"Email": "miyamiya@<your-tenant>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"type": "SP.User"
},
"Id": 37,
"Title": "[email protected]",
"PrincipalType": 1,
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": true,
"IsShareByEmailGuestUser": true,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(11)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(11)",
"type": "SP.User"
},
"Id": 11,
"Title": "NT Service\\spsearch",
"PrincipalType": 1,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"type": "SP.User"
},
"Id": 8,
"Title": "SharedLinksReport メンバー",
"PrincipalType": 4,
"Email": "SharedLinksReport@<your-tenant>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"type": "SP.User"
},
"Id": 6,
"Title": "SharedLinksReport 所有者",
"PrincipalType": 4,
"Email": "SharedLinksReport@<your-tenant>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": true
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741822)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741822)",
"type": "SP.User"
},
"Id": 1073741822,
"Title": "SharePoint アプリ",
"PrincipalType": 1,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"type": "SP.User"
},
"Id": 14,
"Title": "SLinkClaim.587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx.9d95585c-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 4,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"type": "SP.User"
},
"Id": 34,
"Title": "SLinkClaim.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.30f68d91-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 4,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Id": 25,
"Title": "ゲストユーザー",
"PrincipalType": 1,
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(13)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(13)",
"type": "SP.User"
},
"Id": 13,
"Title": "ゲスト投稿者",
"PrincipalType": 1,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(33)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(33)",
"type": "SP.User"
},
"Id": 33,
"Title": "ゲスト投稿者",
"PrincipalType": 1,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"type": "SP.User"
},
"Id": 1073741823,
"Title": "システム アカウント",
"PrincipalType": 1,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(10)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(10)",
"type": "SP.User"
},
"Id": 10,
"Title": "すべてのユーザー",
"PrincipalType": 4,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Id": 35,
"Title": "テストグループ メンバー",
"PrincipalType": 4,
"Email": "TestGroup@<your-tenant>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Id": 17,
"Title": "テストユーザー 01",
"PrincipalType": 1,
"Email": "testuser01@<your-tenant>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Id": 18,
"Title": "テストユーザー 02",
"PrincipalType": 1,
"Email": "testuser02@<your-tenant>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Id": 21,
"Title": "テストユーザー 03",
"PrincipalType": 1,
"Email": "testuser03@<your-tenant>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Id": 22,
"Title": "テストユーザー 04",
"PrincipalType": 1,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Id": 23,
"Title": "テストユーザー 05",
"PrincipalType": 1,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Id": 29,
"Title": "テストユーザー 06",
"PrincipalType": 1,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
},
{
"__metadata": {
"id": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(9)",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(9)",
"type": "SP.User"
},
"Id": 9,
"Title": "外部ユーザー以外のすべてのユーザー",
"PrincipalType": 4,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false,
"IsSiteAdmin": false
}
]
}
}共有リンクの情報を取得し、データを確認する
- 手順 2.1 と同じようにして、コネクタを追加し、下記のように設定する
- サイトのアドレス: https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport
- 方法: GET
- URI:
_api/web/lists/getbytitle('共有リンク')/items?$select=Id,SharingDocId,AvailableLinks
- その後、手順 2.1 と同じようにフローを実行する
出力欄のデータに対して、一部マスクを施したデータが以下となります
{
"d": {
"results": [
{
"__metadata": {
"id": "6f39e18c-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'eac41245-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)",
"etag": "\"2\"",
"type": "SP.Data.ListItem"
},
"Id": 1,
"SharingDocId": "587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AvailableLinks": "[{\"LinkKind\":4,\"ExpirationDateTime\":\"\\/Date(1719507407000)\\/\",\"ExpirationModifiedDate\":\"\\/Date(1718643453312)\\/\",\"IsActive\":true,\"ShareId\":\"9d95585c-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"AfLGRPWXeEWLsN8k21jq-8o\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718643451718)\\/\",\"LastModifiedDate\":\"\\/Date(1718643451718)\\/\",\"ObjectType\":1,\"Flags\":66574,\"GroupId\":12,\"LinkClaimId\":14,\"RoleDefinitionId\":1073741826,\"IsDeleted\":false,\"HasLinkClaim\":true,\"IsDefault\":true},{\"LinkKind\":6,\"ExpirationDateTime\":null,\"ExpirationModifiedDate\":\"\\/Date(1718643548591)\\/\",\"IsActive\":true,\"ShareId\":\"84b84043-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"Ae5-bJeTU_4UOBLw9ZtaKCU\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718643548591)\\/\",\"LastModifiedDate\":\"\\/Date(1718643548591)\\/\",\"ObjectType\":1,\"Flags\":66584,\"GroupId\":19,\"RoleDefinitionId\":1073741826,\"IsDeleted\":false,\"HasLinkClaim\":false,\"IsDefault\":true,\"Invitees\":[{\"Type\":1,\"PId\":17,\"ObjectId\":\"3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718643548326)\\/\"},{\"Type\":1,\"PId\":18,\"ObjectId\":\"9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718643548326)\\/\"},{\"Type\":3,\"Email\":\"[email protected]\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718643548326)\\/\"}]}]",
"ID": 1
},
{
"__metadata": {
"id": "9b7066ca-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'eac41245-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)",
"etag": "\"2\"",
"type": "SP.Data.ListItem"
},
"Id": 2,
"SharingDocId": "977459b8-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AvailableLinks": "[{\"LinkKind\":3,\"ExpirationDateTime\":null,\"ExpirationModifiedDate\":\"\\/Date(1718644195054)\\/\",\"IsActive\":true,\"ShareId\":\"da69e5cd-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"AUVO9Ux4G7iYohPppFN1qTE\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718644195054)\\/\",\"LastModifiedDate\":\"\\/Date(1718644195054)\\/\",\"ObjectType\":1,\"Flags\":66562,\"GroupId\":24,\"RoleDefinitionId\":1073741827,\"IsDeleted\":false,\"HasLinkClaim\":false,\"IsDefault\":true},{\"LinkKind\":6,\"ExpirationDateTime\":null,\"ExpirationModifiedDate\":\"\\/Date(1718644303039)\\/\",\"IsActive\":true,\"ShareId\":\"2b65ad30-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"AXyURlZCxp4h0Ed6C7sHnkU\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718644303024)\\/\",\"LastModifiedDate\":\"\\/Date(1718644303024)\\/\",\"ObjectType\":1,\"Flags\":66584,\"GroupId\":26,\"RoleDefinitionId\":1073741826,\"IsDeleted\":false,\"HasLinkClaim\":false,\"IsDefault\":true,\"Invitees\":[{\"Type\":1,\"PId\":25,\"ShareByEmailGuest\":true,\"ObjectId\":\"1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644302727)\\/\"},{\"Type\":3,\"Email\":\"[email protected]\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644302727)\\/\"}]}]",
"ID": 2
},
{
"__metadata": {
"id": "4a632da1-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'eac41245-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)",
"etag": "\"3\"",
"type": "SP.Data.ListItem"
},
"Id": 3,
"SharingDocId": "bfa52784-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AvailableLinks": "[{\"LinkKind\":6,\"ExpirationDateTime\":null,\"ExpirationModifiedDate\":\"\\/Date(1718644348195)\\/\",\"IsActive\":true,\"ShareId\":\"40c441c1-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"AZ8T0cOlQiqIERb9kSXD9D8\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718644348164)\\/\",\"LastModifiedDate\":\"\\/Date(1718644348164)\\/\",\"ObjectType\":1,\"Flags\":66584,\"GroupId\":27,\"RoleDefinitionId\":1073741827,\"IsDeleted\":false,\"HasLinkClaim\":false,\"IsDefault\":true,\"Invitees\":[{\"Type\":1,\"PId\":17,\"ObjectId\":\"3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644347773)\\/\"},{\"Type\":1,\"PId\":18,\"ObjectId\":\"9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644347773)\\/\"},{\"Type\":1,\"PId\":21,\"ObjectId\":\"51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644347773)\\/\"}]},{\"LinkKind\":6,\"ExpirationDateTime\":null,\"ExpirationModifiedDate\":\"\\/Date(1718644410710)\\/\",\"IsActive\":true,\"ShareId\":\"0c8960b2-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"AaHbRcE4eyW9FpMENM6r6S8\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718644410679)\\/\",\"LastModifiedDate\":\"\\/Date(1718644410679)\\/\",\"ObjectType\":1,\"Flags\":66584,\"GroupId\":28,\"RoleDefinitionId\":1073741826,\"IsDeleted\":false,\"HasLinkClaim\":false,\"IsDefault\":true,\"Invitees\":[{\"Type\":1,\"PId\":22,\"ObjectId\":\"600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644410398)\\/\"},{\"Type\":1,\"PId\":23,\"ObjectId\":\"134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644410398)\\/\"},{\"Type\":1,\"PId\":25,\"ShareByEmailGuest\":true,\"ObjectId\":\"1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644410398)\\/\"}]},{\"LinkKind\":6,\"ExpirationDateTime\":null,\"ExpirationModifiedDate\":\"\\/Date(1718644478648)\\/\",\"IsActive\":true,\"ShareId\":\"3fe572ea-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"Ab_Jazkq1VACjbilv6bmI5k\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718644478648)\\/\",\"LastModifiedDate\":\"\\/Date(1718644478648)\\/\",\"ObjectType\":1,\"Flags\":66584,\"GroupId\":30,\"RoleDefinitionId\":1073741832,\"IsDeleted\":false,\"HasLinkClaim\":false,\"IsDefault\":true,\"Invitees\":[{\"Type\":1,\"PId\":29,\"ObjectId\":\"bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644478429)\\/\"},{\"Type\":3,\"Email\":\"[email protected]\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644478429)\\/\"}]}]",
"ID": 3
},
{
"__metadata": {
"id": "642df972-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"uri": "https://<your-tenant>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'eac41245-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)",
"etag": "\"4\"",
"type": "SP.Data.ListItem"
},
"Id": 4,
"SharingDocId": "79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AvailableLinks": "[{\"LinkKind\":6,\"ExpirationDateTime\":null,\"ExpirationModifiedDate\":\"\\/Date(1718644544108)\\/\",\"IsActive\":true,\"ShareId\":\"60324fec-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"AcZ-u5tvCqjipgh7kU4y7SE\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718644544108)\\/\",\"LastModifiedDate\":\"\\/Date(1718644593879)\\/\",\"ObjectType\":1,\"Flags\":66584,\"GroupId\":31,\"RoleDefinitionId\":1073741827,\"IsDeleted\":false,\"HasLinkClaim\":false,\"IsDefault\":true,\"Invitees\":[{\"Type\":1,\"PId\":17,\"ObjectId\":\"3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644543952)\\/\"},{\"Type\":1,\"PId\":18,\"ObjectId\":\"9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644543952)\\/\"},{\"Type\":1,\"PId\":21,\"ObjectId\":\"51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644543952)\\/\"},{\"Type\":1,\"PId\":22,\"ObjectId\":\"600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644593833)\\/\"},{\"Type\":1,\"PId\":23,\"ObjectId\":\"134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644593833)\\/\"},{\"Type\":1,\"PId\":25,\"ShareByEmailGuest\":true,\"ObjectId\":\"1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644593833)\\/\"}]},{\"LinkKind\":6,\"ExpirationDateTime\":\"\\/Date(1719508602000)\\/\",\"ExpirationModifiedDate\":\"\\/Date(1718644639500)\\/\",\"IsActive\":true,\"ShareId\":\"30f68d91-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"AdvuhcyKwYEhvV0pu5izRv0\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718644639500)\\/\",\"LastModifiedDate\":\"\\/Date(1718644639500)\\/\",\"ObjectType\":1,\"Flags\":66572,\"GroupId\":32,\"LinkClaimId\":34,\"RoleDefinitionId\":1073741832,\"IsDeleted\":false,\"HasLinkClaim\":true,\"IsDefault\":true},{\"LinkKind\":6,\"ExpirationDateTime\":null,\"ExpirationModifiedDate\":\"\\/Date(1718644727378)\\/\",\"IsActive\":true,\"ShareId\":\"493d64e5-xxxx-xxxx-xxxx-xxxxxxxxxxxx\",\"AuthKey\":\"Ae-PAAjy6vbXfVOEqJIoy18\",\"CreatedById\":7,\"LastModifiedById\":7,\"CreatedDate\":\"\\/Date(1718644727378)\\/\",\"LastModifiedDate\":\"\\/Date(1718644727378)\\/\",\"ObjectType\":1,\"Flags\":66584,\"GroupId\":36,\"RoleDefinitionId\":1073741826,\"IsDeleted\":false,\"HasLinkClaim\":false,\"IsDefault\":true,\"Invitees\":[{\"Type\":2,\"PId\":35,\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644727206)\\/\"},{\"Type\":3,\"Email\":\"[email protected]\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644727206)\\/\"},{\"Type\":3,\"Email\":\"[email protected]\",\"InvitedBy\":7,\"InvitedOn\":\"\\/Date(1718644727206)\\/\"}]}]",
"ID": 4
}
]
}
}共有リンクの情報を取得し、データを確認する
- 手順 2.1 と同じようにして、コネクタを追加し、下記のように設定する
- サイトのアドレス: https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport
- 方法: GET
- URI:
_api/web/lists/getbytitle('ドキュメント')/items?$select=HasUniqueRoleAssignments,File/Length,File/Name,File/TimeCreated,File/TimeLastModified,Id,Title,Author/EMail,Author/Title,Editor/EMail,Editor/Title,FileRef,RoleAssignments/Member/Title,RoleAssignments/Member/PrincipalType,RoleAssignments/Member/Users,RoleAssignments/Member/Users/Title,RoleAssignments/Member/Users/Email,RoleAssignments/Member/Users/IsEmailAuthenticationGuestUser,RoleAssignments/Member/Users/IsShareByEmailGuestUser,RoleAssignments/Member/Users/AadObjectId&$expand=File,RoleAssignments/Member,RoleAssignments/Member/Users,Author,Editor&$orderby=Id
- その後、手順 2.1 と同じようにフローを実行する
出力欄のデータに対して、一部マスクを施したデータが以下となります
{
"d": {
"results": [
{
"__metadata": {
"id": "65a83d25-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)",
"etag": "\"1\"",
"type": "SP.Data.Shared_x0020_DocumentsItem"
},
"RoleAssignments": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(3)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(3)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(3)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(3)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"type": "SP.User"
},
"Title": "SharedLinksReport 所有者",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b8da97bd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "SharedLinksReport@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"type": "SP.User"
},
"Title": "システム アカウント",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharedLinksReport 所有者",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(4)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(4)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(4)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(4)/Member",
"type": "SP.Group"
},
"Users": {
"results": []
},
"Title": "SharedLinksReport 閲覧者",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(5)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(5)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(5)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(5)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"type": "SP.User"
},
"Title": "SharedLinksReport メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b8da97bd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "SharedLinksReport@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharedLinksReport メンバー",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(12)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(12)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(12)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(12)/Member",
"type": "SP.Group"
},
"Users": {
"results": []
},
"Title": "SharingLinks.587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx.AnonymousView.9d95585c-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(14)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(14)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(14)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(14)/Member",
"type": "SP.User"
},
"Title": "SLinkClaim.587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx.9d95585c-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 4
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(15)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(15)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(15)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(15)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"type": "SP.User"
},
"Title": "[email protected]",
"AadObjectId": null,
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": true,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"type": "SP.User"
},
"Title": "SLinkClaim.587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx.9d95585c-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"type": "SP.User"
},
"Title": "SLinkClaim.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.30f68d91-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "Limited Access System Group For List 2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(19)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(19)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(19)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(19)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharingLinks.587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Flexible.84b84043-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(20)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(20)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(20)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/RoleAssignments/GetByPrincipalId(20)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "Limited Access System Group",
"PrincipalType": 8
}
}
]
},
"File": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/File",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(1)/File",
"type": "SP.File"
},
"Length": "14123",
"Name": "共有テスト用.xlsx",
"TimeCreated": "2024-06-15T19:36:40Z",
"TimeLastModified": "2024-06-15T19:36:40Z"
},
"Author": {
"__metadata": {
"id": "4d167379-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"type": "SP.Data.UserInfoItem"
},
"EMail": "miyamiya@<your-organization-name>.onmicrosoft.com",
"Title": "miyamiya"
},
"Editor": {
"__metadata": {
"id": "923d693e-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"type": "SP.Data.UserInfoItem"
},
"EMail": "miyamiya@<your-organization-name>.onmicrosoft.com",
"Title": "miyamiya"
},
"HasUniqueRoleAssignments": true,
"Id": 1,
"Title": null,
"ID": 1,
"FileRef": "/sites/SharedLinksReport/Shared Documents/共有テスト用.xlsx"
},
{
"__metadata": {
"id": "2def0c63-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)",
"etag": "\"1\"",
"type": "SP.Data.Shared_x0020_DocumentsItem"
},
"RoleAssignments": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(3)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(3)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(3)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(3)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"type": "SP.User"
},
"Title": "SharedLinksReport 所有者",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b8da97bd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "SharedLinksReport@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"type": "SP.User"
},
"Title": "システム アカウント",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharedLinksReport 所有者",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(4)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(4)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(4)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(4)/Member",
"type": "SP.Group"
},
"Users": {
"results": []
},
"Title": "SharedLinksReport 閲覧者",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(5)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(5)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(5)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(5)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"type": "SP.User"
},
"Title": "SharedLinksReport メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b8da97bd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "SharedLinksReport@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharedLinksReport メンバー",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(15)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(15)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(15)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(15)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"type": "SP.User"
},
"Title": "[email protected]",
"AadObjectId": null,
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": true,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"type": "SP.User"
},
"Title": "SLinkClaim.587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx.9d95585c-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"type": "SP.User"
},
"Title": "SLinkClaim.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.30f68d91-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "Limited Access System Group For List 2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(20)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(20)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(20)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(20)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "Limited Access System Group",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(24)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(24)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(24)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(24)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharingLinks.977459b8-xxxx-xxxx-xxxx-xxxxxxxxxxxx.OrganizationEdit.da69e5cd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(26)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(26)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(26)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/RoleAssignments/GetByPrincipalId(26)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"type": "SP.User"
},
"Title": "[email protected]",
"AadObjectId": null,
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": true,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
}
]
},
"Title": "SharingLinks.977459b8-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Flexible.2b65ad30-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
}
]
},
"File": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/File",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(2)/File",
"type": "SP.File"
},
"Length": "14431",
"Name": "共有テスト用2.xlsx",
"TimeCreated": "2024-06-15T19:38:32Z",
"TimeLastModified": "2024-06-15T19:38:32Z"
},
"Author": {
"__metadata": {
"id": "d6161722-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"type": "SP.Data.UserInfoItem"
},
"EMail": "miyamiya@<your-organization-name>.onmicrosoft.com",
"Title": "miyamiya"
},
"Editor": {
"__metadata": {
"id": "c82c4222-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"type": "SP.Data.UserInfoItem"
},
"EMail": "miyamiya@<your-organization-name>.onmicrosoft.com",
"Title": "miyamiya"
},
"HasUniqueRoleAssignments": true,
"Id": 2,
"Title": null,
"ID": 2,
"FileRef": "/sites/SharedLinksReport/Shared Documents/共有テスト用2.xlsx"
},
{
"__metadata": {
"id": "be909349-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)",
"etag": "\"1\"",
"type": "SP.Data.Shared_x0020_DocumentsItem"
},
"RoleAssignments": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(3)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(3)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(3)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(3)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"type": "SP.User"
},
"Title": "SharedLinksReport 所有者",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b8da97bd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "SharedLinksReport@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"type": "SP.User"
},
"Title": "システム アカウント",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharedLinksReport 所有者",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(4)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(4)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(4)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(4)/Member",
"type": "SP.Group"
},
"Users": {
"results": []
},
"Title": "SharedLinksReport 閲覧者",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(5)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(5)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(5)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(5)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"type": "SP.User"
},
"Title": "SharedLinksReport メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b8da97bd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "SharedLinksReport@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharedLinksReport メンバー",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(15)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(15)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(15)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(15)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"type": "SP.User"
},
"Title": "[email protected]",
"AadObjectId": null,
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": true,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"type": "SP.User"
},
"Title": "SLinkClaim.587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx.9d95585c-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"type": "SP.User"
},
"Title": "SLinkClaim.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.30f68d91-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "Limited Access System Group For List 2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(20)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(20)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(20)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(20)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "Limited Access System Group",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(27)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(27)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(27)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(27)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharingLinks.bfa52784-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Flexible.40c441c1-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(28)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(28)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(28)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(28)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharingLinks.bfa52784-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Flexible.0c8960b2-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(30)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(30)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(30)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/RoleAssignments/GetByPrincipalId(30)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharingLinks.bfa52784-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Flexible.3fe572ea-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
}
]
},
"File": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/File",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(3)/File",
"type": "SP.File"
},
"Length": "14427",
"Name": "共有テスト用3.xlsx",
"TimeCreated": "2024-06-15T19:38:44Z",
"TimeLastModified": "2024-06-15T19:38:44Z"
},
"Author": {
"__metadata": {
"id": "9987fe20-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"type": "SP.Data.UserInfoItem"
},
"EMail": "miyamiya@<your-organization-name>.onmicrosoft.com",
"Title": "miyamiya"
},
"Editor": {
"__metadata": {
"id": "dfb40769-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"type": "SP.Data.UserInfoItem"
},
"EMail": "miyamiya@<your-organization-name>.onmicrosoft.com",
"Title": "miyamiya"
},
"HasUniqueRoleAssignments": true,
"Id": 3,
"Title": null,
"ID": 3,
"FileRef": "/sites/SharedLinksReport/Shared Documents/共有テスト用3.xlsx"
},
{
"__metadata": {
"id": "43f194bb-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)",
"etag": "\"1\"",
"type": "SP.Data.Shared_x0020_DocumentsItem"
},
"RoleAssignments": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(3)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(3)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(3)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(3)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(6)",
"type": "SP.User"
},
"Title": "SharedLinksReport 所有者",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b8da97bd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "SharedLinksReport@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(1073741823)",
"type": "SP.User"
},
"Title": "システム アカウント",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharedLinksReport 所有者",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(4)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(4)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(4)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(4)/Member",
"type": "SP.Group"
},
"Users": {
"results": []
},
"Title": "SharedLinksReport 閲覧者",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(5)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(5)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(5)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(5)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(8)",
"type": "SP.User"
},
"Title": "SharedLinksReport メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b8da97bd-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "SharedLinksReport@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharedLinksReport メンバー",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(15)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(15)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(15)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(15)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"type": "SP.User"
},
"Title": "[email protected]",
"AadObjectId": null,
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": true,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(14)",
"type": "SP.User"
},
"Title": "SLinkClaim.587d26b0-xxxx-xxxx-xxxx-xxxxxxxxxxxx.9d95585c-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(34)",
"type": "SP.User"
},
"Title": "SLinkClaim.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.30f68d91-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"AadObjectId": null,
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "Limited Access System Group For List 2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(20)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(20)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(20)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(20)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(29)",
"type": "SP.User"
},
"Title": "テストユーザー 06",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "bc56aa72-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "Limited Access System Group",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(31)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(31)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(31)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(31)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(25)",
"type": "SP.User"
},
"Title": "ゲストユーザー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "1a427b01-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(17)",
"type": "SP.User"
},
"Title": "テストユーザー 01",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "3b708155-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser01@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(18)",
"type": "SP.User"
},
"Title": "テストユーザー 02",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "9a9f48ce-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser02@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(21)",
"type": "SP.User"
},
"Title": "テストユーザー 03",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "51f494d4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "testuser03@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(22)",
"type": "SP.User"
},
"Title": "テストユーザー 04",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "600f47a4-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(23)",
"type": "SP.User"
},
"Title": "テストユーザー 05",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "134e591f-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharingLinks.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Flexible.60324fec-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(32)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(32)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(32)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(32)/Member",
"type": "SP.Group"
},
"Users": {
"results": []
},
"Title": "SharingLinks.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Flexible.30f68d91-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(34)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(34)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(34)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(34)/Member",
"type": "SP.User"
},
"Title": "SLinkClaim.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.30f68d91-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 4
}
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(36)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(36)",
"type": "SP.RoleAssignment"
},
"Member": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(36)/Member",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/RoleAssignments/GetByPrincipalId(36)/Member",
"type": "SP.Group"
},
"Users": {
"results": [
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(37)",
"type": "SP.User"
},
"Title": "[email protected]",
"AadObjectId": null,
"Email": "[email protected]",
"IsEmailAuthenticationGuestUser": true,
"IsShareByEmailGuestUser": true
},
{
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/GetUserById(35)",
"type": "SP.User"
},
"Title": "テストグループ メンバー",
"AadObjectId": {
"__metadata": {
"type": "SP.UserIdInfo"
},
"NameId": "b4bd9442-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"NameIdIssuer": "urn:federation:microsoftonline"
},
"Email": "TestGroup@<your-organization-name>.onmicrosoft.com",
"IsEmailAuthenticationGuestUser": false,
"IsShareByEmailGuestUser": false
}
]
},
"Title": "SharingLinks.79a3dfcb-xxxx-xxxx-xxxx-xxxxxxxxxxxx.Flexible.493d64e5-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"PrincipalType": 8
}
}
]
},
"File": {
"__metadata": {
"id": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/File",
"uri": "https://<your-organization-name>.sharepoint.com/sites/SharedLinksReport/_api/Web/Lists(guid'2c38592d-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/Items(4)/File",
"type": "SP.File"
},
"Length": "14430",
"Name": "共有テスト用4.xlsx",
"TimeCreated": "2024-06-15T19:38:54Z",
"TimeLastModified": "2024-06-15T19:38:54Z"
},
"Author": {
"__metadata": {
"id": "c92b2371-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"type": "SP.Data.UserInfoItem"
},
"EMail": "miyamiya@<your-organization-name>.onmicrosoft.com",
"Title": "miyamiya"
},
"Editor": {
"__metadata": {
"id": "b45d75c8-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"type": "SP.Data.UserInfoItem"
},
"EMail": "miyamiya@<your-organization-name>.onmicrosoft.com",
"Title": "miyamiya"
},
"HasUniqueRoleAssignments": true,
"Id": 4,
"Title": null,
"ID": 4,
"FileRef": "/sites/SharedLinksReport/Shared Documents/共有テスト用4.xlsx"
}
]
}
}考察
本記事では、今回使う API とその返り値を確認しました
返り値を抜粋もせず、全部載せたのは、実際に動かさなくても雰囲気を掴み取りやすいと思ったからですがいかがでしたでしょうか？
どういう思考で 2.1 ～ 2.3 までのデータを使うことにしたのかというと、以前の記事で、目標は下記のような Excel を出力することとしました
つまり、まずは、完成予想図が必要ということで、そこから必要な情報を考え、上記の JSON データから、どういう風にデータをつなぐか想像したのが次の図となります
※実際は感圧式タッチパネル式のメモパッドに手書きをして、脳内を整理していました
※実際に合っているかどうかはともかく想像です
次はいよいよ、これらの情報を使って、Power Automate でフローを作って行こうと思います