Accessing Nested Values from JSON Objects
So I'm retrieving a JSON object with nested data via a GET call using the Smartsheets API. I'm able to retrieve the sheet's data, however I'm unable to find a way to access and parse through the data in IPAAS. For example, I can set a property equal to "GET rows", but from there I cannot access the cells within specific rows. The structure is as follows:
"rows": [
"rowID":
"cells": [
"columnID":
"value":
] ...
Optimally, I'd like to be able to access the variables nested inside "rows" and "cells" via a for each loop. If anyone has a solution, I'd greatly appreciate it! Thank you.
Asked by Connor Caddell
on Tue 5/14/24 3:36 PM
Last edited Tue 5/14/24 3:36 PM
Sign In to leave feedback or contribute an answer
Answer (1)
Mark Sayers
Tue 5/14/24 3:59 PM
Hello Connor,
What is the name of the flow you are attempting this in?
Sincerely,
Mark Sayers
Sr Support Consultant, CS
No feedback
Hi Mark,
The flow is titled "Link report to Smartsheets". It's currently unpublished though. - Connor Caddell Tue 5/14/24 4:29 PM
The flow is titled "Link report to Smartsheets". It's currently unpublished though. - Connor Caddell Tue 5/14/24 4:29 PM