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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。