How could I have two conditional queries in the same API Action?
I need to change the query in the same table and return to the same table with an optional filter in same API Action. I’m trying to do it but it just doesn’t work.
What are your conditions? Perhaps you can use a flow for this.
If condition 1 is met run first query, if second condition is met run second query. This is how I have done it. Currently I have 15 conditions in that flow and loads only the queries that match the condition.
Then you can use the same query, just conditionally enable the filter inside it.
Hello, thanks. I’m trying to use but it seems not working. Do you have any help available?
How can I use ?
What have you tried exactly?
Something like this :
IF $value =! null
execute QUERY1
ELSE
execute QUERY2
You said that two queries are identical and the only difference is a filter applied to one of them, is that correct?
If that’s the case you need only one query, with just a filter applied conditionally, not a whole new query …
How I can do this ?
I have used App Connect Flows. On this particular flow that I have running on page load, different server actions will run based on a value in the URL Parameters. I currently have about 15 different conditions to run three or four server actions instead of running all 40+ server actions on page load.
Hello Teodoro, Its works!
Thanks
1 Like