Adding a row via API using cURL adds blank row
![ser72](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi all:
I'm attempting to add a child row to a sheet using the API and cURL. It took some time but finally, taking information from chatgpt and other sources, I was able to get a row added as a child in the proper place. However, the row is blank and not taking the values I am setting.
curl -X POST https://api.smartsheet.com/2.0/sheets/3571298173144964/rows -H "Authorization: Bearer <TOKEN> " -H "Content-Type: application/json" -d "{\"parentId\":525015721938820,\"rows\": [{ \"cells\": [ {\"columnId\": 4063440565129092, \"Value\": \"Child\"}]}]}"
is setting a child row to the parent as expected, but all cells are blank.
Any ideas what is wrong with the value set?
Thanks
Answers
-
Hi @ser72,
I noticed that you opened a Support ticket about this, and I can see that’s now resolved. Would you be able to post the solution here to help other members reviewing this thread?
Thanks,
Georgie
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I am having the same problem and have not found a solution. @ser72 did you figure this out?
Edit: Disregard, I found I was using the 'rows' in my json which you dont need when adding a new row. Just the cells element.
-
I didn't end up using this but it was something like:
curl -X POST https://api.smartsheet.com/2.0/sheets/3571298173144964/rows -H "Authorization: Bearer <TOKEN> " -H "Content-Type: application/json" -d "{"parentId":525015721938820: [{ "cells": [ {"columnId": 4063440565129092, "Value": "Child"}]}]}"
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives