Combining Data from Multiple APIs in SAP Build Apps

[king04aman]

Hi amazing SAP enthusiasts!

I hope you’re all having a great day! I’m diving into a project using SAP Build Apps and could really use your expertise on a particular challenge I’m facing.

I’m trying to display data in a single table that pulls from two different APIs. API1 gives me two of the fields I need, while API2 provides the other two. My goal is to combine these fields into one cohesive table.

If anyone has experience with this, I’d love to hear your tips or best practices! Are there specific functions or approaches within SAP Build Apps that can help me achieve this integration smoothly

Looking forward to your insights!

[Dan_Wroblewski · Accepted solution]

As I suggest to most people, I would create your own custom table -- not use the built-in table component. Building your own table is pretty easy and gives you COMPLETE control on how it works. If you need help with this let me know.

Once you have your own table, handling the data becomes trivial. Get data 1 and data 2, then use a formula to combine the them into a page variable. Then connect the page variable to the "Repeat with" of your table row. And if you need help with this part, let me know.

In the future there may be templates that makes it even simpler. See this Devtoberfest session:

[king04aman · Accepted solution]

Thank you for the suggestion! I appreciate the guidance on creating a custom table for complete control over the functionality.