Merge data coming from the DB and API to display in a bootstrap table

Hello dear Wappler superstars !

I’m integrating a “ping” service.

The following informations are coming from our mysql DB :

  • user_id
  • probe_id
  • probe_url

Then we use a loop to retrieve additional informations from the “ping” api with probe_id as a parameter :

  • probe_uptime
  • probe_status

The goal is to display a table like this :

My problem is that I can’t figure out a way to merge the data coming from the DB, with the one from the API (either in app connect or in server connect).

I’m surely missing the obvious.

Thank you very much for your help ! :slight_smile:

EDIT : OK, found it finally, combining repeat + value output.
I’d be interested though if someone has a solution to retrieve the API values asynchronously through App Connect… as this Server Connect method will likely halt at some point with too many rows to query against the API.

That’s already possible using the Server Connect Array List component:

This topic was automatically closed after 2 days. New replies are no longer allowed.