(...) Hi, while we can create business rule s which act similar to table valued / scalar functions, we can't pass the columns/data to them. The inner business rule s are executed before the outer SQL command is executed. This comes in really handy in a lot of cases but also has it's limitation and will require creating repetitive code. I would suggest the following: Create a new "type" "SQL function" Prop (...)
(...) ents in BPS based on data retrieved from another system. I already have an endpoint that returns the required data. To achieve this, I planned to use a global action (cyclical). First, I created a business rule that fetches the data using a REST API. Then, I wrote an SQL query that utilized this business rule to retrieve the data. However, when testing it, I keep encountering the following error: WebC (...)