Issues with passing JSON values

Answers
-
@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" } ] }}
-
Pretty sure this is an issue with how the Power Automate Connector was built. It could definitely use an update…
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives