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.

Tags iPaaS
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