Hi,
I had a similar case.
It ended up with the same idea you are writing about - a separate technical table for storing data from the REST API and next SELECT on this table and join the WEBCON tables with other data.
In my case, the data was updated once a day by global action
I also thought about the SDK custom data source, but the table was easier/faster ;)
Theoretically, webcon has the ability to enable filtering REST data source on the BPS side, but you can't even use business rules there, so you can't combine it with SQL query.
Maybe someone has another idea...
Hi,
you can make use of global business rules and form field values in a data source.
The attached screenshot is from a REST data source and the field is selected from "All form fields" . If the data source is executed, it takes the value of the field (table column) of the current instance. So the data source is no longer generic but specialized for this one process, but you can make use of these.
I don't know since when the "All form fields" option is available but I did not notice it before last year. :)
Best regards,
Daniel