Use a JSON output in a RG or a Table

Need help
1

Hi fellow Bubblers,

I am developing an app where I use a toolbox expression to do some calculations on the front end using a JS code snippet. The expression gives me an output as a JSON that looks like this.

{
  "userId": "1711409---------",
  "isRepeatingCustomer": "no",
  "financials": [
    {
      "year": 2024,
      "startingBalance": "0.00",
      "thisYearContribution": "120000.00",
      "thisYearWithdrawals": "0.00",
      "thisYearInterest": "5538.19",
      "endingBalance": "125538.19"
    }
  ]
}

As you can see this is a list of financials for each of my users.

My question is how do I make this into a format where I can use it in a repeating group or in a table?

P.S. I am aware that I can use my JS as a server-side action and get it onto the front end via an API call. But I am a little concerned about the WU and thought to do the calculations on the front end.

2

You will need to use one of the multiple json plugin available

1 Like
3

@Jici Thanks for replying. So a plugin like this?

Actually, I was looking if there is any solution like @lottemint.md suggested here but that works on frontend instead of using a server-side action.

4

No. There’s JSON plugin that work client side to display in RG using JSON key.