Tasks
Retrieves a list of all tasks.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True | ||
| Title | String | False | ||
| Description | String | False | ||
| Type | String | False |
The allowed values are Call, Email, Fax, Letter, Appointment, Other. | |
| UserId | Integer | False |
Users.Id | |
| FunnelId | Integer | True | ||
| JGraphId | Integer | True | ||
| ContactId | Integer | False |
Contacts.Id | |
| ContactEmail | String | True | ||
| ContactFirstName | String | True | ||
| IsCompleted | Boolean | False | ||
| CompletionDate | Datetime | True | ||
| ContactLastName | String | True | ||
| CreationDate | Datetime | True | ||
| DueDate | Datetime | False | ||
| ModificationDate | Datetime | True | ||
| Priority | Integer | False | ||
| RemindTime | Integer | False | ||
| Url | String | False |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| HasDueDate | Boolean |