SAP Builders Discussions
Join the discussion -- ask questions and discuss how you and fellow SAP Builders are using SAP Build, SAP Build Apps, SAP Build Process Automation, and SAP Build Work Zone.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Build Apps bulk updating backend tables with an Array or records

smckenna
Explorer
0 Kudos
233

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.

1 REPLY 1

smckenna
Explorer
0 Kudos
170

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.