I know that it’s possible to join 1 or more database tables with innerjoin etc, but is this also possible with a database table and the data from an API call? If so, how?
That would be amazing but I don’t think it is currently possible in Wappler directly
You can do it in a server action, like this:
- Do you query without output
- Execute the API action also with output off
- Loop either trough the query or api output and for each record use one or more setValue to create a new record that you output
Yes, that’s why I said directly but while that would be a type of solution, to be able to treat an API connection like a table and perform real joins would be incredibly powerful