get_attachment_metadata
Returns metadata for files stored in an Attachment-type field of a Caspio table. Returns PK_ID (the table record's internal ID), FileName, FileType, Size, DateCreated, and DateUpdated. Use the optional WHERE clause to filter to specific records. A table record can have multiple Attachment-type fields.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| where | No | Optional WHERE clause to filter records. Supports Microsoft SQL Server syntax. Examples: 'PK_ID=42'; 'Status=N'Active'' | |
| tableId | Yes | Table Id (obtained from discover_tables, e.g. 'd99357') -- the table's name has no meaning for API calls; only the Id can be used here. | |
| attachmentFieldName | Yes | The name of the Attachment-type field in the table |