2024 Aug 20 6:38 AM
Hi, I am learning Build Apps, have successfully integrated with an API, parsing the JSON and updated app variables to display on a page. The app variables structure include list of objects.
What i am struggling with is updating back end table with a list of objects. I can see examples of working via the front end for single record updates and creation, which make sense.
i am just wondering if anyone has any guidance on a bulk update of a backend tables. Where i am taking a list of objects app variable and then updating the table with multiple rows. My attempts seem to be failing.
2024 Aug 21 9:08 AM
Problem Solved, Just a follow on my learnings around this for anyone else starting out.
The approach I took to address complex structures via an API was to flatten some of the structures using the Javascript function, collapsing some of the embedded arrays into a string, this then allowed me to populate the table structure in visual cloud functions and also display them on pages. I am sure there are multiple ways to structure your data, this worked for me. Im also interested to hear if anyone has some guidance on working with data structures in Build Apps.