title | description | author | ms.localizationpriority | ms.subservice | doc_type |
---|---|---|---|---|---|
workbook: tableRowOperationResult |
Part of an asynchronous create tableRow request. |
lumine2008 |
medium |
excel |
apiPageType |
Namespace: microsoft.graph
This function is the last in a series of steps to create a workbookTableRow resource 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:
- Issue an async Create tableRow request and get the query URL returned in the
Location
response header. - 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. - 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]
Choose the permission or permissions marked as least privileged for this API. Use a higher privileged permission or permissions only if your app requires it. For details about delegated and application permissions, see Permission types. To learn more about these permissions, see the permissions reference.
[!INCLUDE permissions-table]
GET /me/drive/items/{id}/workbook/tableRowOperationResult(key={operation-id})
GET /me/drive/root:/{item-path}:/workbook/tableRowOperationResult(key={operation-id})
The request URL requires the following query parameter.
Parameter | Type | Description |
---|---|---|
key | String | The operationId provided in the workbookOperation response returned in the preceding Get workbookOperation request. |
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. |
Don't supply a request body for this method.
If successful, this function returns a 200 OK
response code and a workbookTableRow object in the response body.
The following example shows a request.
GET https://graph.microsoft.com/beta/me/drive/items/01CCETFLK7GVZTZHSQNRD2AEI5XWTCU6FJ/workbook/tableRowOperationResult(key='0195cfac-bd22-4f91-b276-dece0aa2378b')
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
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]]"
}