Happy Business Starts Here

Data Query wrapper sync mode

0 Kudos

Data Query wrapper sync mode

Hi, we are receiving a lot of workflow notifications related to async task exhausted. We used DQ everywhere in the system because it is the only functionality in Zuora that enables us to do join and complex SQL queries. It also enables us to reduce task number. For online flows starting from notifications for example we should substitute DQ with a chaining of direct sync query/REST APIs and rearranging data using JSONata simulating all joins (to be honest sometimes we do not have a direct rest api to retrieve the same data) but in this way we have to mantain and fix two version of the same workflow a massive one using DQ and a non massive using sync API. What I am trying to suggest is: Creating a wrapper that receives in input a DQ and transforms in some way it in a sync call without changing our SQL query. In this case we can write our query once and we mantain/fix our logic once and we will have the possibility to have a workflow task/REST API that automatically switches to sync mode based on a dynamic selectable checkbox.
Thanks in advance
Pasquale