priority is a number that corresponds to the Priorities available in the ClickUp UI.
1 is Urgent
2 is High
3 is Normal
4 is Low
time_estimate must be in milliseconds.
parent must be an existing task. If provided, it will make the new task a subtask of that parent. Parent must not be a subtask itself, and must be part of the list you selected.
Array properties can be passed to ClickUp by returning the data as either a comma delimited string or an array in your SQL query. For example, tags.
Hightouch will override array. For example, if you have ['tag 1, tag 2']
tags set in a task and we run a sync with values ['tag 1', 'tag 3']. After
the sync, the tags value will be ['tag 1', 'tag 3'].
Reference properties are fields that would require internal IDs as values. However, Hightouch also will you to match rows by meaningful properties, for example, email for users.
Reference fields like assignees that allow multiple values will behave like
arrays.