Skip to content

workbook-tablerowoperationresult.md

Latest commit

 

History

History
132 lines (100 loc) · 5.09 KB

workbook-tablerowoperationresult.md

File metadata and controls

132 lines (100 loc) · 5.09 KB
title workbook: tableRowOperationResult
description Part of an asynchronous create tableRow request.
author lumine2008
ms.localizationpriority medium
ms.subservice excel
doc_type apiPageTypes
ms.date 04/05/2024

workbook: tableRowOperationResult

Namespace: microsoft.graph

[!INCLUDE beta-disclaimer]

This function is the last in a series of steps to create workbookTableRow resources asynchronously.

A best practice to create multiple table rows is to batch them in one create tableRow operation and carry out the operation asynchronously.

An asynchronous request to create table rows involves the following steps:

  1. Issue an async Create tableRow request and get the query URL returned in the Location response header.
  2. Use the query URL returned from step 1 to issue the Get workbookOperation request and get the operation ID for step 3. Alternatively, for convenience, after you get a succeeded operationStatus result, you can get the query URL from the resourceLocation property of the workbookOperation returned in the response, and apply the query URL to step 3.
  3. Use the query URL returned from step 2 as the GET request URL for this function tableRowOperationResult. A successful function call returns the new table rows in a workbookTableRow resource.

This function does not do anything if called independently.

[!INCLUDE national-cloud-support]

Permissions

One of the following permissions is required to call this API. To learn more, including how to choose permissions, see Permissions.

Permission type Permissions (from least to most privileged)
Delegated (work or school account) Files.ReadWrite
Delegated (personal Microsoft account) Not supported.
Application Not supported.

HTTP request

GET /me/drive/items/{id}/workbook/tableRowOperationResult(key={operation-id})
GET /me/drive/root:/{item-path}:/workbook/tableRowOperationResult(key={operation-id})

Function parameters

The request URL requires the following query parameter.

Parameter Type Description
key String The operationId provided in the workbookOperation response returned in a preceding Get workbookOperation request.

Request headers

Name Description
Authorization Bearer {token}. Required. Learn more about authentication and authorization.
Workbook-Session-Id Workbook session ID that determines whether changes are persisted. Optional.

Request body

Don't supply a request body for this method.

Response

If successful, this function returns a 200 OK response code and a workbookTableRow object in the response body.

Examples

Request

The following example shows a request.

HTTP

GET https://graph.microsoft.com/beta/me/drive/items/01CCETFLK7GVZTZHSQNRD2AEI5XWTCU6FJ/workbook/tableRowOperationResult(key='0195cfac-bd22-4f91-b276-dece0aa2378b')

C#

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

Go

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

Java

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

JavaScript

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

PHP

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

Python

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

Response

The following example shows the response.

Note: The response object shown here might be shortened for readability.

HTTP/1.1 200 OK
Content-Type: application/json

{
  "index": 99,
  "values": "[[1, 2, 3]]"
}