Namespace: microsoft.graph
Importante
As APIs na versão /beta no Microsoft Graph estão sujeitas a alterações. Não há suporte para o uso dessas APIs em aplicativos de produção. Para determinar se uma API está disponível na v1.0, use o seletor Versão.
Criar um novo objeto workbookComment .
Esta API está disponível nas seguintes implementações de cloud nacionais.
| Serviço global |
US Government L4 |
US Government L5 (DOD) |
China operada pela 21Vianet |
| ✅ |
✅ |
✅ |
❌ |
Permissões
Escolha a permissão ou permissões marcadas como menos privilegiadas para esta API. Utilize uma permissão ou permissões com privilégios mais elevados apenas se a sua aplicação o exigir. Para obter detalhes sobre as permissões delegadas e de aplicação, veja Tipos de permissão. Para saber mais sobre estas permissões, veja a referência de permissões.
| Tipo de permissão |
Permissões com menos privilégios |
Permissões com privilégios superiores |
| Delegado (conta corporativa ou de estudante) |
Files.ReadWrite |
Indisponível. |
| Delegado (conta pessoal da Microsoft) |
Sem suporte. |
Sem suporte. |
| Aplicativo |
Sem suporte. |
Sem suporte. |
Solicitação HTTP
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
| Nome |
Descrição |
| Autorização |
{token} de portador. Obrigatório. Saiba mais sobre autenticação e autorização. |
| Content-Type |
application/json. Obrigatório. |
Corpo da solicitação
No corpo do pedido, forneça uma representação JSON de um objeto workbookComment .
Resposta
Se for bem-sucedido, este método devolve um 201 Created código de resposta e um novo objeto workbookComment no corpo da resposta.
Exemplos
O exemplo seguinte mostra como criar um comentário de um plaincontentType.
Solicitação
O exemplo a seguir mostra uma solicitação.
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)
Resposta
O exemplo a seguir mostra a resposta.
Observação: o objeto de resposta mostrado aqui pode ser encurtado para legibilidade.
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": []
}
O exemplo seguinte mostra como criar um comentário de um mentioncontentType.
Solicitação
O exemplo a seguir mostra uma solicitação.
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)
Resposta
O exemplo a seguir mostra a resposta.
Observação: o objeto de resposta mostrado aqui pode ser encurtado para legibilidade.
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"
}