Parse / Display JSON data or render HTML stored in Glide?

[Nate_H]

I am currently using a Web Embed component to display a table of transactions from my accounting system on the details page of projects within my app.

Glide generates a URL that contains the ID of a project that is recognized by Netsuite, so it generates an HTML table with the transactions which then shows up in Glide. This works great and is pretty cool, but it’s wildly insecure.

I’m brainstorming alternatives here - using the Call API action, I could have the system return either a JSON with the transactions, or the HTML code, but I am not aware of a way to then display this data within Glide. Is there a way to either show the nested JSON data as a collection, like a data grid, or render HTML code that is stored in a column?

Maybe there’s another solution I’m not thinking of?

[Darren_Murphy]

@Nate_H

Is there a way to either show the nested JSON data as a collection, like a data grid, or render HTML code that is stored in a column?

Yeah, take a look at Bob’s Call API Tutorial. I’m pretty sure he covers that.

Call API Tutorial - Connect almost anything to Glide! (updated Aug. 21)

Hey Gliders! Glide apps are now exponentially more powerful! Learn how to call any API securely and return data directly within Glide…in SECONDS. No Make or Zapier needed! An introduction to API + JSON responses in Glide: This introductory video covers how to: find API endpoints that you can use in a Glide App create API endpoints using a Construct URL column call the API using the Call API action fetch and read the JSON response parse items within a JSON array onto their own row in Gli…

[Eric_Penn]

You could use the rich text component to display HTML