SSIS Components for Xero

Build 24.0.9062

Time

Query, insert, update and delete time entries for a Xero project.

Table-Specific Information

Creating Time

A Time must be created with a ProjectId, TaskId, UserId, Date and Duration. An optional description may also be provided:

INSERT INTO Time (ProjectId, TaskId, UserId, Date, Duration, Description) VALUES ('1de78bad-5a81-4cb8-ab53-5a1a3bc73b29', 'd15810a1-9324-4765-a357-80d160a0b87c', '312b124b-f33f-4cfe-a831-20eb290610d6', '2019-10-01', 250, 'Paved northwest section')

Updating Time

Once a Time has been created, its UserId, Date, Duration or Description may be updated:

UPDATE Time SET Date = '2019-11-01', Duration = 350 WHERE Id = '1de78bad-5a81-4cb8-ab53-5a1a3bc73b29/cb53829a-31ca-4760-a2a7-5a2a46e67cfb'

Deleting Time

Time may also be deleted by specifying their Id:

DELETE FROM Time WHERE Id = '1de78bad-5a81-4cb8-ab53-5a1a3bc73b29/cb53829a-31ca-4760-a2a7-5a2a46e67cfb'

Columns

Name Type ReadOnly Description
Id [KEY] String False

A unique combination of the project and time entry identifiers

TimeEntryId String True

The unique Xero identifier of the time entry.

UserId String False

The ID of the user who logged the time entry

ProjectId String False

The ID of the project the task belongs to

TaskId String False

The ID of the task the time is logged for

Date Date False

The day the time was logged for

DateEntered Datetime True

When the time entry was created

Duration Int False

When the time entry was created

Description String False

The description of the time entry

Status String True

One of ACTIVE, LOCKED or INVOICED

TenantId String False

The ID of the tenant to query instead of the connection tenant

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062