Few questions about the product

[grzeho-woo]

Hello,
I’m in the process of selecting a workflow engine for my customer and I need some information. Could You please provide me with answers to the questions below?

1. Please provide me with several complex workflow examples containing mainly HTTP/REST, SQL, SSH tasks and iterations over data/objects, and data manipulation (not a bulk, <50 db rows / JSON objects).

2. How to handle data received from HTTP, SQL, SSH tasks without using scripts/code in SHELL/PYTHON/JAVA tasks, only using internal functions and/or tasks (or inline code)?

3. Is there a list of built-in functions/methods for data manipulation, e.g., JSON, XML with examples (I have found a few only for date/time manipulation)?

   • One of my use cases is to get data from HTTP/REST and put it into a DB (or vice versa).

4. Are there any (complex!) examples of conditions in a Switch task – e.g., to make decision based on an attribute of a JSON doc/object (again, without a need for parsing JSON in a shell), e.g., condition like this: ${HTTP_task.response}.key1 == “value1” does not seem to work (or the syntax is wrong?).

5. Are there Iterators to iterate over data like JSON objects, arrays, SQL result set etc.

   • Do / while / for loops with condition check, etc.

6. Environments (env variables) seems not to work as parameters in HTTP, SQL tasks – how should multiple environments be handled then (LAB/PROD)?

7. Are there Secret variables (e.g., credentials for a task – different users for different environments LAB/PROD.)? – provide examples.

   • masking secrets in logs

8. Is there a built-in/system sleep/wait block?

   • Until a certain timestamp.
   • For a certain duration.
   • For an external trigger/event.

9. Please describe how different retention times of different data is ensured.

10. Please describe how GDPR and other privacy regulations are supported/ensured in the solution.

11. In case Consent is the Legal Ground for processing the data in the solution, please describe how users can easily exercise their GDPR User Rights.

12. Describe how system upgrades are done.

13. How to deploy a custom task (preferably with zero downtime).

I would appreciate a quick response.

Best regards,
Grzegorz