Issues with passing JSON values

System

This discussion was created from comments split from: Point me in the right direction - Troubleshooting API.

John Sauber

@Tim Starkey @Lindsay Whitbread

I'm currently struggling with passing JSON values, cast as integers, decimals, numbers, etc. to Smartsheet cells using the Power Automate tool. Even when input parameters are clean and cast, the connector doesn't pass the actual value, but an apostrophe-leading string.

INPUT:
{ "sheetId": "2104897646317444", "row/Primary Column": "1", "row/Invited": "2", "row/Coming": 1}

OUTPUT:

{ "message": "SUCCESS", "resultCode": 0, "version": 17, "result": { "id": 5518528902565764, "sheetId": 2104897646317444, "rowNumber": 1, "expanded": true, "locked": false, "lockedForUser": false, "createdAt": "2024-12-11T20:34:22Z", "modifiedAt": "2024-12-11T20:34:22Z", "cells": [ { "columnId": 4611568601091972, "displayValue": "1", "value": "1" }, { "columnId": 2359768787406724, "displayValue": "2", "value": "2" }, { "columnId": 6863368414777220, "displayValue": "1", "value": "1" } ] }}

Leibel S

@John Sauber

Pretty sure this is an issue with how the Power Automate Connector was built. It could definitely use an update…