ProjectAttachments
Returns binary file and text-document attachments of projects. Specify ProjectId to query one project, or omit it to source project IDs from Projects and query each project.
View-Specific Information
Select
If ProjectId is omitted, the connector can source project Ids from Projects and query each project.
The connector uses the Claude Compliance API to process WHERE clause conditions built with the following column and operator server-side. The rest of the filter, including sorting, grouping, and offsets, is processed client-side within the connector.
- ProjectId supports the following operator: =.
- LIMIT
SELECT Id, Filename, MimeType, SizeBytes, Type FROM ProjectAttachments WHERE ProjectId = 'claude_proj_123' LIMIT 100;
Columns
| Name | Type | Description |
| Id [KEY] | String | The identifier of the attached file or project document. |
| ProjectId | String | The Id of the project. Filterable with =. Obtain it from Projects.Id to query one project; when omitted, the provider queries each project. The provider copies the SQL criterion into each row because the API response does not repeat the parent project Id. |
| CreatedAt | Datetime | The creation timestamp of the attachment. |
| Filename | String | The display name of the attachment. |
| Md5 | String | The lowercase MD5 of a project_file attachment, when recorded. |
| MimeType | String | The MIME type of the attachment. |
| SizeBytes | Long | The size in bytes of a project_file attachment, when recorded. |
| Type | String | The attachment discriminator: project_file or project_doc. |
| UpdatedAt | Datetime | The last-modified timestamp of a project_doc attachment; currently reserved and normally null. |