Adding a row via API using cURL adds blank row

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

Find more posts tagged with

API and Developers

Accepted answers

ser72

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

All comments

Georgie

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

RGS

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.

ser72

I didn't end up using this but it was something like:

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.