Store JSON in a Text field and then Display in RG

[sylvioavilla]

Hello,

I want to create a Data API endpoint to reduce the workload for my application when displaying data to a large number of people. Instead of performing a search for each item, I’d like to store the data as JSON, allowing users to view it in a Repeating Group (RG).

I’ve managed to create a JSON file, but I couldn’t find an option to do it on the backend. Sometimes, when attempting to generate it on the frontend, it crashes the application due to the file’s size. To address this, I came up with a solution (not sure if it’s the best one): I store the JSON in a text field and then try to retrieve this data and display it in an RG.

So far, I’ve successfully stored the JSON in the text field, but the API, which references the record, doesn’t recognize it as JSON. Is there a way to convert text to JSON and populate the RG? Alternatively, is there a plugin that allows me to create a JSON file on the backend?

Thank you.

[ed19]

Hey Sylvio!

If your only issue is needing to make an API call on the server, I made a post about it here:

Result Of Backend Workflow & Return Data From API fix

I’ve struggled with this for quite some time since there didn’t seem to be any obvious way to grab the result of a scheduled backend workflow on a page, so thought I’d post the solution here for anybody else that’s struggling with this issue. The trick here is in using the API Connector to trigger your own workflow, as opposed to using the Schedule API Workflow action: Create backend workflow for whatever your needs are Crucially as the last step in that workflow, add a Return Data From API …

Failing that, you should be able to query any API using the API connector. Setting the POST/GET request to type JSON should give you what you’re after.

[jared.gibb]

@sylvioavilla

far, I’ve successfully stored the JSON in the text field, but the API, which references the record, doesn’t recognize it as JSON. Is there a way to convert text to JSON and populate the RG? Alternatively, is there a plugin that allows me to

Yea. You need to build a plugin and pseudo data types. Feed the cells text into the plugin. have the plugin Json.parse() the text. The instance.publishState that to your pseudo type and voila!