What is the correct formatting for an HTTP Request for multiple rows with location specifiers?
I am experiencing an issue with trying to utilize the add_rows API endpoint with:
- Multiple rows
- Location specifiers
This is my Body Request fed into Power Automate - trying to add 2 rows, both are to be at the bottom of an existing parentId (different parentId):
{
"uri": "https://api.smartsheet.com/2.0/sheets/<sheetID>/rows",
"method": "POST",
"headers": {
"Authorization": "*sanitized*",
"Content-Type": "application/json"
},
"body": [
{
"rows": [
{
"parentId": 3549566531080068,
"toBottom": true,
"cells": [
{
"columnId": 5365531952238468,
"value": "test1"
},
{
"columnId": 7617331765923716,
"objectValue": {
"objectType": "MULTI_PICKLIST",
"values": [
"team1",
"team2"
]
}
}
]
},
{
"parentId": 3865014262894468,
"toBottom": true,
"cells": [
{
"columnId": 5365531952238468,
"value": "Test"
}
]
}
]
}
]
}
The response I get is not as expected in 3 ways:
- Only one row is confirmed to added
- The specified location is ignored and it is added at the bottom of the sheet and not the bottom of the parentId
- None of the desired columns are filled in.
RESPONSE
{
"statusCode": 200,
"headers": {
...
},
"body": {
"message": "SUCCESS",
"resultCode": 0,
"version": 93,
"result": [
{
"id": xxxxxxx,
"sheetId": xxxxxxx,
"rowNumber": 133, #this is the bottom of the row, whereas the parentId I specified is row ~101
"siblingId": 8611906339278724,
"expanded": true,
"locked": false,
"lockedForUser": false,
"createdAt": "2025-10-21T21:52:08Z",
"modifiedAt": "2025-10-21T21:52:08Z",
"cells": [
{
"columnId": 963702111817604
},
{
"columnId": 4931695829274500
},
{
"columnId": 8801951526113156
},
{
"columnId": 216964736438148
},
{
"columnId": 5365531952238468
},
{
"columnId": 6649929574076292
},
{
"columnId": 2146329946705796
},
{
"columnId": 4028693853458308
},
{
"columnId": 3113732138553220
},
{
"columnId": 7617331765923716
},
{
"columnId": 1987832231710596
},
{
"columnId": 7775829480918916
},
{
"columnId": 4398129760391044
},
{
"columnId": 8901729387761540
},
{
"columnId": 105636365553540
},
{
"columnId": 6420724013813636
}
]
}
]
}
}
Checks I've completed
- Ensured the parentIds exist
- Ensured the columnIds exist
- I tried running the request with only one row added and without wrapping it "rows:" and it seems to upload as expected
- I checked Smartsheet to see if it actually updated and it hasn't.
I'm unable to reproduce the erroneous response that you've described -- but I can provide some guidance nonetheless.
My sheet initially looks like this (2 columns, 2 rows):
I'll start by sending a Get Sheet request, to see the JSON format of the sheet before I attempt to make any changes:
GET https://api.smartsheet.com/2.0/sheets/2702602705784708
The Get Sheet response (edited to remove excess/irrelevant info) looks like this:
{
"id": 2702602705784708,
...
"columns": [
{
"id": 1330564984426372,
"index": 0,
"primary": true,
"title": "ID",
"type": "TEXT_NUMBER",
...
},
{
"id": 5834164611796868,
"index": 1,
"title": "color",
"type": "TEXT_NUMBER",
...
}
],
...
"rows": [
{
"id": 8807758496862084,
"rowNumber": 1,
...
"cells": [
{
"columnId": 1330564984426372,
"displayValue": "A",
"value": "A"
},
{
"columnId": 5834164611796868,
"displayValue": "BLUES",
"value": "BLUES"
}
]
},
{
"id": 198062507724676,
"rowNumber": 2,
"siblingId": 8807758496862084,
...
"cells": [
{
"columnId": 1330564984426372,
"displayValue": "B",
"value": "B"
},
{
"columnId": 5834164611796868,
"displayValue": "REDS",
"value": "REDS"
}
]
}
],
"totalRowCount": 2,
...
}
This response provides the ID values that I need for my Add Rows request.
Next, I send the Add Rows request -- attempting to add 2 new (child) rows to the sheet:
Add a child row under existing top-level row #1.
Add a child row under existing top-level row #2.
Here's that Add Rows request (using the same scenario as you posted -- a different parentId for each new row, both rows with the toBottom attribute set to true):
POST https://api.smartsheet.com/2.0/sheets/2702602705784708/rows
[
{
"parentId": 8807758496862084,
"toBottom": true,
"cells": [
{
"columnId": 1330564984426372,
"value": "child-id-1"
},
{
"columnId": 5834164611796868,
"value": "child-value-1"
}
]
},
{
"parentId": 198062507724676,
"toBottom": true,
"cells": [
{
"columnId": 1330564984426372,
"value": "child-id-2"
},
{
"columnId": 5834164611796868,
"value": "child-value-2"
}
]
}
]
Here's the response that's returned when I send this request:
{
"refId": "2c4867d2-10e1-4a81-b2b4-a165a3716f84",
"errorCode": 1123,
"message": "Specifying multiple row locations is not yet supported. Each row must use the same row location attribute and value (toBottom, toTop, parentId, siblingId, above)",
"detail": {
"index": 1
}
}
This means that all rows within my Add Rows request must have the exact same row location attributes with the exact same values. My Add Rows request failed because it attempted to add child rows under two different 'parent' rows in the sheet (i.e., different parentId attribute value specified for each of the two rows in the Add Rows request).
To verify that this is what caused the problem -- I will send another Add Rows request -- this time specifying the same parentId attribute value for both new rows in the request -- in this example, I'll try to add both new rows under the second row in the sheet:
POST https://api.smartsheet.com/2.0/sheets/2702602705784708/rows
[
{
"parentId": 198062507724676,
"toBottom": true,
"cells": [
{
"columnId": 1330564984426372,
"value": "child-id-1"
},
{
"columnId": 5834164611796868,
"value": "child-value-1"
}
]
},
{
"parentId": 198062507724676,
"toBottom": true,
"cells": [
{
"columnId": 1330564984426372,
"value": "child-id-2"
},
{
"columnId": 5834164611796868,
"value": "child-value-2"
}
]
}
]
This request succeeds and returns the following response (edited to remove excess/irrelevant attributes):
{
"message": "SUCCESS",
"resultCode": 0,
"version": 90,
"result": [
{
"id": 2555230536929156,
"sheetId": 2702602705784708,
"rowNumber": 3,
...
"cells": [
{
"columnId": 1330564984426372,
"displayValue": "child-id-1",
"value": "child-id-1"
},
{
"columnId": 5834164611796868,
"displayValue": "child-value-1",
"value": "child-value-1"
}
],
"parentId": 198062507724676
},
{
"id": 7058830164299652,
"sheetId": 2702602705784708,
"rowNumber": 4,
"siblingId": 2555230536929156,
...
"cells": [
{
"columnId": 1330564984426372,
"displayValue": "child-id-2",
"value": "child-id-2"
},
{
"columnId": 5834164611796868,
"displayValue": "child-value-2",
"value": "child-value-2"
}
],
"parentId": 198062507724676
}
]
}
As expected, my sheet now looks like the following (both new rows added as child rows under the same parent row in the sheet, as specified by the Add Rows request):
So, to accomplish your goal -- wanting to add multiple new rows to a sheet, but at different locations within the sheet (i.e., under different parent rows) -- you'll need to issue a separate Add Rows request for each location where you want to add rows. For example, if you wanted to add a total of 5 new rows to a sheet -- 2 rows under one parent row and 3 rows under a different parent row -- you'd need to issue two separate Add Rows requests:
Request #1 would specify the two rows to add under the first parent row.
Request #2 would specify the three rows to add under the other parent row.
- What is the correct formatting for an HTTP Request for multiple rows with location specifiers?
- Problem adding new child row to parent row; new row always added to bottom of sheet
- Smartsheet Python API unlock rows 1-30 from 40 sheets
- Smartsheet API Invalid Access Token Exception
- Using Smartsheet API to update Cell value without SDK
- How to add a new row to Smartsheet with a column of type Dropdown List and set multiple options as true
- I can't package my program with Pyinstaller because I have enum34 installed, can't uninstall because a used module needs it. Any suggestions?
- Smartsheet API Add User with Defined Locale
- Smartsheet API cURL - Attach URL to Sheet/Row
- Smartsheet MULTI_PICKLIST turning into TEXT_NUMER despite being level 2
- Assume-user not working in smartsheet api
- Postman API Invalid Content-Type Header
- Cell values not copying over to new sheet using Smartsheet API
- Connect R to Smartsheet via API?
- Smartsheet API create/update reports possible?
- Use Smartsheet API to create an image/screenshot of a Smartsheet dashboard
- Python SDK API to add rows with multiple columns to update to Smartsheet
- Why am I seeing an 'AttributeError' when using the Python Smartsheet SDK to create a new sheet in a folder?
- Smartsheet API failed after switched to new laptop
- Using Smartsheet API, how do I fetch the metadata such as _OUTLINELEVEL_ or _ROWNUM_?
- Method get_cell_history (Smartsheet API) works in Python file but doesn't work in exe file
- Smartsheet API not letting me save
- Updating users alternate email address
- Do I need to be an admin to generate an API access token on free Smartsheet gov?
- Add rows in smartsheets using python
- How to update one grid with information from another grid
- What's the most efficient way to get all attachments from any row in every sheet using Smartsheet API?
- How do I get all the rows in a Smartsheet by sending an API call using the requests package in python?
- Adding rows with smartsheet API in Google Apps Script
- Smartsheets Python API cell history from reports