workbook: tableRowOperationResult

Namespace: microsoft.graph

Important

APIs under the /beta version in Microsoft Graph are subject to change. Use of these APIs in production applications is not supported. To determine whether an API is available in v1.0, use the Version selector.

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.

This API is available in the following national cloud deployments.

Global service US Government L4 US Government L5 (DOD) China operated by 21Vianet

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.

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

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]]"
}