InsertRow in Smartheet

(2) Share

Report

Posted on by UnspeakablePirate

Hi,

How do I use Smartsheet connector to Insert Row in specific Sheet?

Documentation is quite poor and don't know how to pass values properly. Code that I use is below. How do I fix it to make to make it work?

Smartsheet.InsertRow(
    "192045464213123";
    {
        [
            {
                "columnId": 4266183311445892,
                "value": "TEST",
                "displayValue": "TEST"
            }
        ]
    }
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

BostonSailor 154 on at

Like (0)

Report

Your "Row Post" object (the second argument in the Insert Row call) needs to be well-formed JSON. Try something like this:

Smartsheet.InsertRow(
"SheetID", // The ID of your Smartsheet
{
"cells": [
{
"columnId": "ColumnID1", // The ID of the column
"value": "Value1" // The value to insert
},
{
"columnId": "ColumnID2",
"value": "Value2"
}
// Add more columns as needed
]
}
)

Was this reply helpful? Yes No
CU22080829-0 2 on at

Like (0)

Report
@BostonSailor
Unfortunatelly this doesn't work. I've got few messages:

"Unexpected characters. The formula contains the 'cells' symbol where the 'Ident' symbol is expected."

"Unexpected characters. The formula contains the 'cells' symbol where the 'Colon' symbol is expected."

"Expected colon. A colon (:) was expected at this point in the formula."

"Unexpected characters. The formula contains the 'Colon' symbol where the 'CurlyClose' symbol is expected."

"Unexpected characters. The formula contains the 'Colon' symbol where the 'ParenClose' symbol is expected."

"Unexpected characters. The symbols are used in the formula in an unexpected way."

Code that I used:

Smartsheet.InsertRow(

"1920494682634852";

{

"cells": [

{

"columnId": "4266183311448892";

"value": "Test"

}

]

}

)

Was this reply helpful? Yes No