Namespace: microsoft.graph
Wichtig
Die APIs unter der /beta Version in Microsoft Graph können sich ändern. Die Verwendung dieser APIs in Produktionsanwendungen wird nicht unterstützt. Um festzustellen, ob eine API in v1.0 verfügbar ist, verwenden Sie die Version Selektor.
Erstellen Sie ein neues WorkbookComment-Objekt .
Diese API ist in den folgenden nationalen Cloudbereitstellungen verfügbar.
| Weltweiter Service |
US Government L4 |
US Government L5 (DOD) |
China, betrieben von 21Vianet |
| ✅ |
✅ |
✅ |
❌ |
Berechtigungen
Wählen Sie die Berechtigungen aus, die für diese API als am wenigsten privilegiert markiert sind. Verwenden Sie eine höhere Berechtigung oder Berechtigungen nur, wenn Ihre App dies erfordert. Ausführliche Informationen zu delegierten Berechtigungen und Anwendungsberechtigungen finden Sie unter Berechtigungstypen. Weitere Informationen zu diesen Berechtigungen finden Sie in der Berechtigungsreferenz.
| Berechtigungstyp |
Berechtigungen mit den geringsten Berechtigungen |
Berechtigungen mit höheren Berechtigungen |
| Delegiert (Geschäfts-, Schul- oder Unikonto) |
Files.ReadWrite |
Nicht verfügbar. |
| Delegiert (persönliches Microsoft-Konto) |
Nicht unterstützt |
Nicht unterstützt |
| Application |
Nicht unterstützt |
Nicht unterstützt |
HTTP-Anforderung
POST /me/drive/items/{id}/workbook/comments
POST /me/drive/root:/{item-path}:/workbook/comments
POST /users/{id}/drive/items/{id}/workbook/comments
POST /users/{id}/drive/root:/{id}:/workbook/comments
Anforderungstext
Geben Sie im Anforderungstext eine JSON-Darstellung eines workbookComment-Objekts an .
Antwort
Bei erfolgreicher Ausführung gibt die Methode einen 201 Created Antwortcode und ein neues workbookComment-Objekt im Antworttext zurück.
Beispiele
Das folgende Beispiel zeigt, wie Sie einen Kommentar eines plaincontentType-Typs erstellen.
Anforderung
Das folgende Beispiel zeigt eine Anfrage.
POST https://graph.microsoft.com/beta/me/drive/items/01CYZLFJGUJ7JHBSZDFZFL25KSZGQTVAUN/workbook/comments
Content-Type: application/json
{
"cellAddress": "Sheet1!A1",
"content": "This is my comment.",
"contentType": "plain"
}
// Code snippets are only available for the latest version. Current version is 5.x
// Dependencies
using Microsoft.Graph.Beta.Models;
var requestBody = new WorkbookComment
{
CellAddress = "Sheet1!A1",
Content = "This is my comment.",
ContentType = "plain",
};
// To initialize your graphClient, see https://learn.microsoft.com/en-us/graph/sdks/create-client?from=snippets&tabs=csharp
var result = await graphClient.Drives["{drive-id}"].Items["{driveItem-id}"].Workbook.Comments.PostAsync(requestBody);
// Code snippets are only available for the latest major version. Current major version is $v0.*
// Dependencies
import (
"context"
msgraphsdk "github.com/microsoftgraph/msgraph-beta-sdk-go"
graphmodels "github.com/microsoftgraph/msgraph-beta-sdk-go/models"
//other-imports
)
requestBody := graphmodels.NewWorkbookComment()
cellAddress := "Sheet1!A1"
requestBody.SetCellAddress(&cellAddress)
content := "This is my comment."
requestBody.SetContent(&content)
contentType := "plain"
requestBody.SetContentType(&contentType)
// To initialize your graphClient, see https://learn.microsoft.com/en-us/graph/sdks/create-client?from=snippets&tabs=go
comments, err := graphClient.Drives().ByDriveId("drive-id").Items().ByDriveItemId("driveItem-id").Workbook().Comments().Post(context.Background(), requestBody, nil)
// Code snippets are only available for the latest version. Current version is 6.x
GraphServiceClient graphClient = new GraphServiceClient(requestAdapter);
WorkbookComment workbookComment = new WorkbookComment();
workbookComment.setCellAddress("Sheet1!A1");
workbookComment.setContent("This is my comment.");
workbookComment.setContentType("plain");
WorkbookComment result = graphClient.drives().byDriveId("{drive-id}").items().byDriveItemId("{driveItem-id}").workbook().comments().post(workbookComment);
const options = {
authProvider,
};
const client = Client.init(options);
const workbookComment = {
cellAddress: 'Sheet1!A1',
content: 'This is my comment.',
contentType: 'plain'
};
await client.api('/me/drive/items/01CYZLFJGUJ7JHBSZDFZFL25KSZGQTVAUN/workbook/comments')
.version('beta')
.post(workbookComment);
<?php
use Microsoft\Graph\Beta\GraphServiceClient;
use Microsoft\Graph\Beta\Generated\Models\WorkbookComment;
$graphServiceClient = new GraphServiceClient($tokenRequestContext, $scopes);
$requestBody = new WorkbookComment();
$requestBody->setCellAddress('Sheet1!A1');
$requestBody->setContent('This is my comment.');
$requestBody->setContentType('plain');
$result = $graphServiceClient->drives()->byDriveId('drive-id')->items()->byDriveItemId('driveItem-id')->workbook()->comments()->post($requestBody)->wait();
# Code snippets are only available for the latest version. Current version is 1.x
from msgraph_beta import GraphServiceClient
from msgraph_beta.generated.models.workbook_comment import WorkbookComment
# To initialize your graph_client, see https://learn.microsoft.com/en-us/graph/sdks/create-client?from=snippets&tabs=python
request_body = WorkbookComment(
cell_address = "Sheet1!A1",
content = "This is my comment.",
content_type = "plain",
)
result = await graph_client.drives.by_drive_id('drive-id').items.by_drive_item_id('driveItem-id').workbook.comments.post(request_body)
Antwort
Das folgende Beispiel zeigt die Antwort.
Hinweis: Das hier gezeigte Antwortobjekt kann zur besseren Lesbarkeit gekürzt werden.
HTTP/1.1 201 Created
Content-Type: application/json
{
"content": "This is my comment.",
"contentType": "plain",
"id": "{97A21473-8339-4BF0-BCB6-F55E4909FFB8}",
"cellAddress": "Sheet1!A1",
"richContent": "",
"mentions": []
}
Das folgende Beispiel zeigt, wie Sie einen Kommentar eines mentioncontentType-Typs erstellen.
Anforderung
Das folgende Beispiel zeigt eine Anfrage.
POST https://graph.microsoft.com/beta/me/drive/items/01CYZLFJGUJ7JHBSZDFZFL25KSZGQTVAUN/workbook/comments
Content-Type: application/json
{
"cellAddress": "Sheet1!A1",
"richContent": "<at id=\"0\">Kate Kristensen</at> - This is my comment.",
"mentions": [
{
"id": 0,
"name": "Kate Kristensen",
"email": "kakri@contoso.com"
}
],
"contentType": "mention"
}
// Code snippets are only available for the latest version. Current version is 5.x
// Dependencies
using Microsoft.Graph.Beta.Models;
var requestBody = new WorkbookComment
{
CellAddress = "Sheet1!A1",
RichContent = "<at id=\"0\">Kate Kristensen</at> - This is my comment.",
Mentions = new List<WorkbookCommentMention>
{
new WorkbookCommentMention
{
Id = 0,
Name = "Kate Kristensen",
Email = "kakri@contoso.com",
},
},
ContentType = "mention",
};
// To initialize your graphClient, see https://learn.microsoft.com/en-us/graph/sdks/create-client?from=snippets&tabs=csharp
var result = await graphClient.Drives["{drive-id}"].Items["{driveItem-id}"].Workbook.Comments.PostAsync(requestBody);
// Code snippets are only available for the latest major version. Current major version is $v0.*
// Dependencies
import (
"context"
msgraphsdk "github.com/microsoftgraph/msgraph-beta-sdk-go"
graphmodels "github.com/microsoftgraph/msgraph-beta-sdk-go/models"
//other-imports
)
requestBody := graphmodels.NewWorkbookComment()
cellAddress := "Sheet1!A1"
requestBody.SetCellAddress(&cellAddress)
richContent := "<at id=\"0\">Kate Kristensen</at> - This is my comment."
requestBody.SetRichContent(&richContent)
workbookCommentMention := graphmodels.NewWorkbookCommentMention()
id := int32(0)
workbookCommentMention.SetId(&id)
name := "Kate Kristensen"
workbookCommentMention.SetName(&name)
email := "kakri@contoso.com"
workbookCommentMention.SetEmail(&email)
mentions := []graphmodels.WorkbookCommentMentionable {
workbookCommentMention,
}
requestBody.SetMentions(mentions)
contentType := "mention"
requestBody.SetContentType(&contentType)
// To initialize your graphClient, see https://learn.microsoft.com/en-us/graph/sdks/create-client?from=snippets&tabs=go
comments, err := graphClient.Drives().ByDriveId("drive-id").Items().ByDriveItemId("driveItem-id").Workbook().Comments().Post(context.Background(), requestBody, nil)
// Code snippets are only available for the latest version. Current version is 6.x
GraphServiceClient graphClient = new GraphServiceClient(requestAdapter);
WorkbookComment workbookComment = new WorkbookComment();
workbookComment.setCellAddress("Sheet1!A1");
workbookComment.setRichContent("<at id=\"0\">Kate Kristensen</at> - This is my comment.");
LinkedList<WorkbookCommentMention> mentions = new LinkedList<WorkbookCommentMention>();
WorkbookCommentMention workbookCommentMention = new WorkbookCommentMention();
workbookCommentMention.setId(0);
workbookCommentMention.setName("Kate Kristensen");
workbookCommentMention.setEmail("kakri@contoso.com");
mentions.add(workbookCommentMention);
workbookComment.setMentions(mentions);
workbookComment.setContentType("mention");
WorkbookComment result = graphClient.drives().byDriveId("{drive-id}").items().byDriveItemId("{driveItem-id}").workbook().comments().post(workbookComment);
const options = {
authProvider,
};
const client = Client.init(options);
const workbookComment = {
cellAddress: 'Sheet1!A1',
richContent: '<at id=\"0\">Kate Kristensen</at> - This is my comment.',
mentions: [
{
id: 0,
name: 'Kate Kristensen',
email: 'kakri@contoso.com'
}
],
contentType: 'mention'
};
await client.api('/me/drive/items/01CYZLFJGUJ7JHBSZDFZFL25KSZGQTVAUN/workbook/comments')
.version('beta')
.post(workbookComment);
<?php
use Microsoft\Graph\Beta\GraphServiceClient;
use Microsoft\Graph\Beta\Generated\Models\WorkbookComment;
use Microsoft\Graph\Beta\Generated\Models\WorkbookCommentMention;
$graphServiceClient = new GraphServiceClient($tokenRequestContext, $scopes);
$requestBody = new WorkbookComment();
$requestBody->setCellAddress('Sheet1!A1');
$requestBody->setRichContent('<at id=\"0\">Kate Kristensen</at> - This is my comment.');
$mentionsWorkbookCommentMention1 = new WorkbookCommentMention();
$mentionsWorkbookCommentMention1->setId(0);
$mentionsWorkbookCommentMention1->setName('Kate Kristensen');
$mentionsWorkbookCommentMention1->setEmail('kakri@contoso.com');
$mentionsArray []= $mentionsWorkbookCommentMention1;
$requestBody->setMentions($mentionsArray);
$requestBody->setContentType('mention');
$result = $graphServiceClient->drives()->byDriveId('drive-id')->items()->byDriveItemId('driveItem-id')->workbook()->comments()->post($requestBody)->wait();
# Code snippets are only available for the latest version. Current version is 1.x
from msgraph_beta import GraphServiceClient
from msgraph_beta.generated.models.workbook_comment import WorkbookComment
from msgraph_beta.generated.models.workbook_comment_mention import WorkbookCommentMention
# To initialize your graph_client, see https://learn.microsoft.com/en-us/graph/sdks/create-client?from=snippets&tabs=python
request_body = WorkbookComment(
cell_address = "Sheet1!A1",
rich_content = "<at id=\"0\">Kate Kristensen</at> - This is my comment.",
mentions = [
WorkbookCommentMention(
id = 0,
name = "Kate Kristensen",
email = "kakri@contoso.com",
),
],
content_type = "mention",
)
result = await graph_client.drives.by_drive_id('drive-id').items.by_drive_item_id('driveItem-id').workbook.comments.post(request_body)
Antwort
Das folgende Beispiel zeigt die Antwort.
Hinweis: Das hier gezeigte Antwortobjekt kann zur besseren Lesbarkeit gekürzt werden.
HTTP/1.1 201 Created
Content-Type: application/json
{
"content": "@Kate Kristensen - This is my comment.",
"contentType": "mention",
"id": "{97A21473-8339-4BF0-BCB6-F55E4909FFB8}",
"richContent": "<at id=\"0\">Kate Kristensen</at> - This is my comment.",
"mentions": [
{
"id": 0,
"name": "Kate Kristensen",
"email": "kakri@contoso.com"
}
],
"cellAddress": "Sheet1!A1"
}