SSIS Components for Basecamp

Build 23.0.8839

Attachments

Retrieve Attachments on Basecamp.

Columns

Name Type References Description
Id [KEY] String The Id of the attachment.
Key String The key of the attachment.
Name String The name of the attachment.
ByteSize Int The size of the attachment in bytes.
CreatedAt Datetime The date when the attachment was created.
UpdatedAt Datetime The date when the attachment was last updated.
Url String The Url of the attachment.
AppUrl String The AppUrl of the attachment.
ThumbnailUrl String The Thumbnail Url of the attachment.
Private Boolean Indicates if the attachemtn is private.
Trashed Boolean Indicates if the attachment is trashed.
Tags String The tags of the attachment.
CreatorId String The Id of the attachment creator.
CreatorName String The name of the attachment creator.
CreatorAvatarUrl String The avatar url of the attachment creator.
CreatorFullsizeAvatarUrl String The url of the full sized avatar of the attachment creator.
AttachableId String The Id of the attachable.
AttachableType String The type of the attachable.
AttachableUrl String The Url of the attachable.
AttachableAppUrl String The AppUrl of the attachable.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ProjectId String The id of the project

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