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)

This answer has been marked as the accepted answer
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
Hi Connor,
We believe you just need to hit "set data model".

- Run the GET call via Smartsheet (the connector step)
- On the right side of the page, the Output Data will have a button at the bottom called "Set Data Model"
- Click this button
- Now when you use the data picker to "drill down" into the response from the GET call, the data picker will have the exact structure of the response data
- You can then loop over it to your heart's content! - Mark Sayers Thu 9/26/24 11:12 AM