Overview
Configuration is provided for establishing connections with Teamwork service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Demonstration
Quick Start
In this task, we will show you step-by-step how to create a connection to Teamwork REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2. From drop-down menu Configuration select Teamwork. Set [site] to the desired site in the Server host parameter. Then click New in the Token File parameter to create a new token file.
Step 3: Provide Email and Password. Then press 'Log in' button.
Step 4: Save generated access token to file. Specify token protection password. Click OK.
Step 5. Click "Test Connection" to test your connection.
Congratulations! You have now established a connection to your Teamwork instance.
In this guide, we will show how to read data from the Teamwork service resource using the COZYROC REST Source component.
Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.
Step 3. Double click on the "REST Source" component and select Teamwork connection from the combo. Select from available Teamwork resources listed in the second combo below.
Optionally you can include extra parameters in the grid below if needed.
Step 4. Click on the "Columns tab" and select Teamwork resource columns you want to read.
Step 5. Click Preview to make sure all necessary resource columns are included.
Bravo! You have now learned how to read data from Teamwork service.
In this guide, we will show how to write data to the Teamwork service resource using the COZYROC REST Destination component.
Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open the "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.
Step 3. Double click on the "REST Destination" component and select Teamwork connection from the combo. Also, select resource action and Teamwork resource you want to work on.
Step 4. Click on the "Mapping" tab and map the input columns for the process you are configuring.
If you want to provide input for other resource composite objects, change the input above and map the columns.
Done. You have now learned how to write data into the Teamwork resource.
Configuration
Base URL address: https://[site].teamwork.com/projects/api/v3.
- OAuth 2
-
The authentication uses an authorized token.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
Documentation: https://apidocs.teamwork.com/docs/teamwork/99aa10e94733d-app-login-flow-for-teamwork.
-
Authorization:
- Token
-
The authentication uses a parameters-based authentication.
The authentication has the following user-defined parameters:
- Token: Required. Specify API token.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Basic {{=Base64.encode(connection.user.Token + ':abc')}}
Documentation: https://en.wikipedia.org/wiki/Basic_access_authentication.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/tags.json.
The result is extracted from:{{=response.tags}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/tags/get-projects-api-v3-tagsjson.
- [Read single] action
-
Endpoint URL address:
/tags/{{=parameters.id}}.json.
The result is extracted from:{{=[response.tag]}}.The action has the following user-defined parameters:
- id: Required. Specify tag id.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/tags/get-projects-api-v3-tags-idjson.
- [Create] action
-
Endpoint URL address:
/tags.json.The following request parameters will be automatically processed:
-
application/json:
{{={ tag:item } }}
Documentation: https://developer.teamwork.com/projects/api-v3/ref/tags/post-projects-api-v3-tagsjson.
-
application/json:
- [Update] action
-
Endpoint URL address:
/tags/{{=item.id}}.json.The following request parameters will be automatically processed:
-
application/json:
{{={ tag: item } }}
Documentation: https://developer.teamwork.com/projects/api-v3/ref/tags/patch-projects-api-v3-tags-idjson.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/tags/{{=item.id}}.json.Documentation: https://developer.teamwork.com/projects/api-v3/ref/tags/delete-projects-api-v3-tags-idjson.
- id
A key field. Data type: DT_I4
- color
Template: ShortText.
- projectId
Data type: DT_I4
- name
Template: ShortText.
- count
Data type: DT_I4
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/latestactivity.json.
The result is extracted from:{{=response.activities}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/activity/get-projects-api-v3-latestactivityjson.
- [Read project] action
-
Endpoint URL address:
/projects/{{=parameters.projectId}}/latestactivity.
The result is extracted from:{{=response.activities}}.The action has the following user-defined parameters:
- projectId: Required. Specify project identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/activity/get-projects-api-v3-projects-projectid-latestactivity.
The resource includes the fields from the ActivityT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/milestones.json.
The result is extracted from:{{=response.milestones}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/milestones/get-projects-api-v3-milestonesjson.
- [Read single] action
-
Endpoint URL address:
/milestones/{{=parameters.milestoneId}}.json.
The result is extracted from:{{=[response.milestone]}}.The action has the following user-defined parameters:
- milestoneId: Required. Specify milestone identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/milestones/get-projects-api-v3-milestones-idjson.
- [Read project] action
-
Endpoint URL address:
/projects/{{=parameters.projectId}}/milestones.json.
The result is extracted from:{{=response.milestones}}.The action has the following user-defined parameters:
- projectId: Required. Specify project identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/milestones/get-projects-api-v3-projects-projectid-milestonesjson.
The resource includes the fields from the MilestoneT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
people/metrics/performance.json.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- startDate: Required. Specify start date.
- endDate: Required. Specify end date.
- orderMode:
Documentation: https://developer.teamwork.com/projects/api-v3/ref/people/get-projects-api-v3-people-metrics-performancejson.
- name
Template: ShortText.
- value
Data type: DT_I4
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/statuses.json.
The result is extracted from:{{=response.statuses}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/people-status/get-projects-api-v3-statusesjson.
- [Read team] action
-
Endpoint URL address:
statuses/timeline.json.
The result is extracted from:{{=response.statuses}}.The action has the following user-defined parameters:
- teamId: Required. Specify team identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/people-status/get-projects-api-v3-statuses-timelinejson.
- id
Data type: DT_I4
- userId
Data type: DT_I4
- emoji
Template: ShortText.
- text
Template: ShortText.
- dateTime
Template: DateTime.
- ipAddress
Template: ShortText.
- dateLastUpdated
Template: DateTime.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/projects.json.
The result is extracted from:{{=response.projects}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/projects/get-projects-api-v3-projectsjson.
- id
A key field. Data type: DT_I4
- name
Template: ShortText.
- description
Template: ShortText.
- type
Template: ShortText.
- status
Template: ShortText.
- subStatus
Template: ShortText.
- companyId
Data type: DT_I4
- tagIds
Template: LongText. A composite field.
- startDate
Template: DateTime.
- endDate
Template: DateTime.
- categoryId
Template: ShortText.
- ownerId
Data type: DT_I4
- createdBy
Data type: DT_I4
- createdAt
Template: DateTime.
- updatedAt
Template: DateTime.
- defaultPrivacy
Template: ShortText.
- activePages
Field components:
- Contains the following components: billing, comments, files, links, messages, milestones, notebooks, riskRegister, tasks, time.
- directFileUploadsEnabled
Data type: DT_BOOL
- harvestTimersEnabled
Data type: DT_BOOL
- integrations
Field components:
- Contains the following components: oneDriveBusiness, sharepoint, xero.
- isOnBoardingProject
Data type: DT_BOOL
- isSampleProject
Data type: DT_BOOL
- logo
Template: ShortText.
- notifyEveryone
Data type: DT_BOOL
- overviewStartPage
Template: ShortText.
- privacyEnabled
Data type: DT_BOOL
- projectOwnerId
Data type: DT_I4
- replyByEmailEnabled
Data type: DT_BOOL
- showAnnouncement
Data type: DT_BOOL
- skipWeekends
Data type: DT_BOOL
- startPage
Template: ShortText.
- tasksStartPage
Template: ShortText.
- customFieldValueIds
Template: ShortText.
- value
Data type: DT_I8
- summary
The value is gathered from
/projects/{{=item.id}}/summary.jsonaddress. Field components:- Contains the following components: columns, events, health, milestones, risks, since, tasks, time, unread.
- updates
The gathered value is processed with
{{=connection.resourceManager['Project Update'].getData({ endpoint: 'project', parameters: ['projectId=' + item.id] })}}expression. Field components:- An array.
-
Uses template:
ProjectUpdateT.
- activities
The gathered value is processed with
{{=connection.resourceManager['Activity'].getData({ endpoint: 'project', parameters: ['projectId=' + item.id] })}}expression. Field components:- An array.
-
Uses template:
ActivityT.
- milestones
The gathered value is processed with
{{=connection.resourceManager['Milestone'].getData({ endpoint: 'project', parameters: ['projectId=' + item.id] })}}expression. Field components:- An array.
-
Uses template:
MilestoneT.
- risks
The gathered value is processed with
{{=connection.resourceManager['Risk'].getData({ endpoint: 'project', parameters: ['projectId=' + item.id] })}}expression. Field components:- An array.
-
Uses template:
RiskT.
- timeEntries
The gathered value is processed with
{{=connection.resourceManager['Time Entry'].getData({ endpoint: 'project', parameters: ['projectId=' + item.id] })}}expression. Field components:- An array.
-
Uses template:
TimeEntryT.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/projects/updates.json.
The result is extracted from:{{=response.projectUpdates}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/project-updates/get-projects-api-v3-projects-updatesjson.
- [Read project] action
-
Endpoint URL address:
/projects/{{=parameters.projectId}}/updates.json.
The result is extracted from:{{=response.projectUpdates}}.The action has the following user-defined parameters:
- projectId: Required. Specify project identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/project-updates/get-projects-api-v3-projects-projectids-updatesjson.
The resource includes the fields from the ProjectUpdateT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/risks.json.
The result is extracted from:{{=response.risks}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/risks/get-projects-api-v3-risksjson.
- [Read project] action
-
Endpoint URL address:
/projects/{{=parameters.projectId}}/risks.
The result is extracted from:{{=response.risks}}.The action has the following user-defined parameters:
- projectId: Required. Specify project identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/risks/get-projects-api-v3-projects-projectid-risks.
The resource includes the fields from the RiskT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/notebooks.json.
The result is extracted from:{{=response.notebooks}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/notebooks/get-projects-api-v3-notebooksjson.
- [Read single] action
-
Endpoint URL address:
/notebooks/{{=parameters.id}}.json.
The result is extracted from:{{=[response.notebook]}}.The action has the following user-defined parameters:
- id: Required. Specify notebook identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/notebooks/get-projects-api-v3-notebooks-idjson.
- [Create] action
-
Endpoint URL address:
/notebooks.json.The following request parameters will be automatically processed:
-
application/json:
{{= { notebook: item } }}
Documentation: https://developer.teamwork.com/projects/api-v3/ref/notebooks/post-projects-api-v3-notebooksjson.
-
application/json:
- [Update] action
-
Endpoint URL address:
notebooks/{{=item.id}}.json.The following request parameters will be automatically processed:
-
application/json:
{{={ notebook: item } }}
Documentation: https://developer.teamwork.com/projects/api-v3/ref/notebooks/patch-projects-api-v3-notebooks-idjson.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/notebooks/{{=item.id}}.json.Documentation: https://developer.teamwork.com/projects/api-v3/ref/notebooks/delete-projects-api-v3-notebooks-idjson.
- id
A key field. Data type: DT_I4
- name
Template: ShortText.
- description
Template: ShortText.
- contents
Template: ShortText.
- type
Template: ShortText.
- isPrivate
Data type: DT_BOOL
- locked
Data type: DT_BOOL
- lockdownId
Data type: DT_I4
- secureContent
Data type: DT_BOOL
- projectId
Data type: DT_I4
- createdByUserID
Data type: DT_I4
- updatedByUserID
Data type: DT_I4
- dateUpdated
Template: DateTime.
- dateCreated
Template: DateTime.
- deleted
Data type: DT_BOOL
- notebookVersionID
Data type: DT_I4
- notebookVersionCreatedDateTime
Template: DateTime.
- notebookVersionUpdatedDateTime
Template: DateTime.
- latestVersionNo
Data type: DT_I4
- commentsCount
Data type: DT_I4
- readCommentsCount
Data type: DT_I4
- commentFollowers
Field components:
-
Uses template:
LongText. - Contains the following components: userIds, companyIds, teamIds.
-
Uses template:
- changeFollowers
Field components:
-
Uses template:
ShortText. - Contains the following components: userIds, companyIds, teamIds.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/calendar/events.json.
The result is extracted from:{{=response.calendarEvents}}.The action has the following user-defined parameters:
- startDate: Required. Specify start date.
- endDate: Required. Specify end date.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/calendar-events/get-projects-api-v3-calendar-eventsjson.
- id
Data type: DT_I4
- additionalProperties
Template: ShortText.
- allDay
Data type: DT_BOOL
- attendeesCanEdit
Data type: DT_BOOL
- attendingUserIds
Template: LongText. A composite field.
- createdByUserId
Data type: DT_I4
- createdDateTime
Template: DateTime.
- currentUserAssociationType
Template: ShortText.
- dateDeleted
Template: DateTime.
- dateLastUpdated
Template: DateTime.
- deleted
Data type: DT_BOOL
- deletedByUserId
Data type: DT_I4
- description
Template: ShortText.
- endDate
Template: DateTime.
- location
Template: ShortText.
- monthlyRepeatType
Template: ShortText.
- ownerUserId
Data type: DT_I4
- privacyType
Template: ShortText.
- projectId
Data type: DT_I4
- projectUsersCanEdit
Data type: DT_BOOL
- sequenceId
Data type: DT_I4
- showAsBusy
Data type: DT_BOOL
- startDate
Template: DateTime.
- title
Template: ShortText.
- typeId
Data type: DT_I4
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/timers.json.
The result is extracted from:{{=response.timers}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/get-projects-api-v3-timersjson.
- [Read me] action
-
Endpoint URL address:
/me/timers.json.
The result is extracted from:{{=response.timers}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/get-projects-api-v3-me-timersjson.
- [Create] action
-
Endpoint URL address:
/me/timers.json.
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{= { timer: item } }}
Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/post-projects-api-v3-me-timersjson.
-
application/json:
- [Update] action
-
Endpoint URL address:
/me/timers/{{=item.id}}.json.Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/put-projects-api-v3-me-timers-idjson.
- [Delete] action
-
Endpoint URL address:
/me/timers/{{=item.id}}.json.Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/delete-projects-api-v3-me-timers-idjson.
- id
A key field. Data type: DT_I4
- billable
Data type: DT_BOOL
- createdAt
Template: DateTime.
- deleted
Data type: DT_BOOL
- deletedAt
Template: DateTime.
- description
Template: ShortText.
- duration
Data type: DT_I4
- intervals
Field components:
- An array.
- Contains the following components: duration, from, id, to.
- lastStartedAt
Template: DateTime.
- projectId
Data type: DT_I4
- running
Data type: DT_BOOL
- serverTime
Template: DateTime.
- taskId
Data type: DT_I4
- timeLogId
Data type: DT_I4
- timerLastIntervalEnd
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/time.json.
The result is extracted from:{{=response.timelogs}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/get-projects-api-v3-timejson.
- [Read allocation] action
-
Endpoint URL address:
/allocations/{{=parameters.allocationId}}/time.json.
The result is extracted from:{{=response.timelogs}}.The action has the following user-defined parameters:
- allocationId: Required. Specify allocation identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/get-projects-api-v3-allocations-allocationid-timejson.
- [Read project] action
-
Endpoint URL address:
projects/{{=parameters.projectId}}/time.json.
The result is extracted from:{{=response.timelogs}}.The action has the following user-defined parameters:
- projectId: Required. Specify project identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/get-projects-api-v3-projects-projectid-timejson.
The resource includes the fields from the TimeEntryT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/budgets.json.
The result is extracted from:{{=response.budgets}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/budgets/get-projects-api-v3-budgetsjson.
- [Read single] action
-
Endpoint URL address:
/budgets/{{=parameters.id}}.json.
The result is extracted from:{{=[response.budget]}}.The action has the following user-defined parameters:
- id: Required. Specify budget identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/budgets/get-projects-api-v3-budgets-idjson.
- [Create] action
-
Endpoint URL address:
/budgets/bulk/delete.json.Documentation: https://developer.teamwork.com/projects/api-v3/ref/budgets/post-projects-api-v3-budgetsjson.
- [Update] action
-
Endpoint URL address:
/budget/notifications/{{=item.id}}.json.The following request parameters will be automatically processed:
-
application/json:
{{= { notification: item} }}
Documentation: https://developer.teamwork.com/projects/api-v3/ref/budgets/patch-projects-api-v3-budgets-idjson.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/budget/notifications/{{=item.id}}.json.Documentation: https://developer.teamwork.com/projects/api-v3/ref/budgets/delete-projects-api-v3-budgets-idjson.
- id
A key field. Data type: DT_I4
- capacity
Data type: DT_I4
- capacityUsed
Data type: DT_I4
- completedByUserId
Data type: DT_I4
- createdByUserId
Data type: DT_I4
- currencyCode
Template: ShortText.
- dateCompleted
Template: DateTime.
- dateCreated
Template: DateTime.
- dateDeleted
Template: DateTime.
- dateUpdated
Template: DateTime.
- defaultRate
Data type: DT_R8
- deletedByUserId
Data type: DT_I4
- endDateTime
Template: DateTime.
- expenseType
Template: ShortText.
- isRepeating
Data type: DT_BOOL
- notificationIds
Template: LongText. A composite field.
- originatorBudgetId
Data type: DT_I4
- projectId
Data type: DT_I4
- repeatPeriod
Data type: DT_I4
- repeatUnit
Template: ShortText.
- repeatsRemaining
Data type: DT_I4
- sequenceNumber
Data type: DT_I4
- startDateTime
Template: DateTime.
- status
Template: ShortText.
- timelogType
Template: ShortText.
- type
Template: ShortText.
- updatedByUserId
Data type: DT_I4
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/customfields.json.
The result is extracted from:{{=response.customfields}}.Documentation: https://developer.teamwork.com/projects/api-v3/ref/custom-fields/get-projects-api-v3-customfieldsjson.
- [Read single] action
-
Endpoint URL address:
/customfields/{{=parameters.id}}.json.
The result is extracted from:{{=[response.customfield]}}.The action has the following user-defined parameters:
- id: Required. Please custom field identifier.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/custom-fields/get-projects-api-v3-customfields-idjson.
- [Create] action
-
Endpoint URL address:
/customfields.json.The following request parameters will be automatically processed:
-
application/json:
{{= { customfield: item } }}
Documentation: https://developer.teamwork.com/projects/api-v3/ref/custom-fields/post-projects-api-v3-customfieldsjson.
-
application/json:
- [Update] action
-
Endpoint URL address:
/customfields/{{=item.id}}.json.The following request parameters will be automatically processed:
-
application/json:
{{= {customfield: item } }}
Documentation: https://developer.teamwork.com/projects/api-v3/ref/custom-fields/patch-projects-api-v3-customfields-idjson.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/customfields/{{=item.id}}.json.Documentation: https://developer.teamwork.com/projects/api-v3/ref/custom-fields/delete-projects-api-v3-customfields-idjson.
- id
A key field. Data type: DT_I4
- createdAt
Template: DateTime.
- createdByUserId
Data type: DT_I4
- deleted
Data type: DT_BOOL
- deletedAt
Template: DateTime.
- deletedByUserId
Data type: DT_I4
- description
Template: ShortText.
- entity
Template: ShortText.
- isPrivate
Data type: DT_BOOL
- name
Template: ShortText.
- projectId
Data type: DT_I4
- required
Data type: DT_BOOL
- type
Template: ShortText.
- updatedAt
Template: DateTime.
- updatedByUserId
Data type: DT_I4
- visibilities
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/workload/planners.json.
The result is extracted from:{{=response.planners}}.The action has the following user-defined parameters:
- startDate: Required. Please specify the start date.
- endDate: Required. Please specify the end date.
Documentation: https://developer.teamwork.com/projects/api-v3/ref/workload/get-projects-api-v3-workload-plannersjson.
- userId
Data type: DT_I4
- capacities
The gathered value is processed with
{{=_.map(value, function(v, k) { return _.extend({ date: k }, item); })}}expression. Field components:- An array.
- Contains the following components: date, tasks, capacity, estimateMinutesTotal, lengthOfDayMinutes.
- [Read] action
-
The result is paginated.The following request parameters will be automatically processed:
-
page:
{{=parameters.iterator}} -
pageSize:
{{=parameters.batchSize}} -
_includeUserParameters:
{{=parameters}}
-
page:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The action uses PATCH method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.
- ShortText
Data type: DT_WSTR ( length 250 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Date
Data type: DT_DBDATE
- ProjectUpdateT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, color, createdAt, createdBy, deleted, deletedAt, deletedBy, health, likeFromUserIDs, projectId, reactions, text, updatedAt.
-
Uses template:
- ActivityT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, userId, projectId, companyId, activityType, dateTime, description, extraDescription, dueDate, forUserId, forUserName, isPrivate, itemId, itemLink, latestActivityType, link, lockdownId, publicInfo, type.
-
Uses template:
- MilestoneT
Field components:
-
Uses template:
DateTime. - Contains the following components: id, commentsCount, completed, completedOn, completerId, createdOn, creatorUserId, deadline, description, lastChangedOn, lockdownId, name, numCommentsRead, percentageComplete, private, projectId, reminder, responsiblePartyIds, status, tagIds, tasklistIds, userFollowingChanges, userFollowingComments.
-
Uses template:
- RiskT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, source, probability, probabilityValue, impact, impactValue, impactCost, impactSchedule, impactPerformance, createdOn, createdByUserId, lastChangedOn, lastChangedByUserId, result, mitigationPlan, status, projectId, deleted, canEdit.
-
Uses template:
- TimeEntryT
Field components:
-
Uses template:
DateTime. - Contains the following components: id, billable, dateCreated, dateDeleted, dateEdited, deleted, deletedByUserId, description, deskTicketId, editedByUserId, hasStartTime, invoiceNumber, loggedByUserId, minutes, projectBillingInvoiceId, projectId, taskId, taskIdPreMove, timeLogged, userId.
-
Uses template:
Knowledge Base
What's New
- New: Introduced connection.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.