Creating and updating tasks from your database

After Connecting to a database, you can setup Data Sync when creating a new workflow or via the Data tab.

Choose the database you’ve just connected and write your query that fetches records that should become a task.

Optionally add a variation of your fetch all records query to fetch a single record. We’ve supply the variable {{id}} to represent your primary key.

Query must return results

In order for us to analyze the results of your query, it must return at least one result.

Using a separate query for updates

If you want to use a different query to keep your tasks in Sync, select Use a separate query for subsequent updates and input your query.

Mapping columns to fields

Press continue and we will now run your query. When it’s completed you will have to confirm the columns to field mapping. You will have the choice of selecting an existing field or creating a new one.

Sync Settings

Below you will have the option to configure how often the data sync will query your database.