# Records

This API allows users to create, retrieve, and manage records that are fully customizable and dynamically configured in the dashboard. Records can store various types of structured data, enabling flexible integrations and workflows tailored to specific business needs. 

## Create a new record in a table

> Create a new record in a table. Requires \`can\_edit\_data\` permission on the table.

```json
{"openapi":"3.0.1","info":{"title":"TransactionLink API","version":"v3"},"servers":[{"url":"https://api.transactionlink.io","description":"Production"}],"security":[{"organizationToken":[]},{"bearerAuthJWT":[]}],"components":{"securitySchemes":{"organizationToken":{"type":"apiKey","in":"header","name":"Authorization","description":"Organization API token (tot_) — preferred authentication method. Pass the token directly without Bearer prefix."},"bearerAuthJWT":{"type":"http","scheme":"bearer","bearerFormat":"JWT","description":"Legacy JWT Bearer token — deprecated in favor of organization tokens (tot_). Still supported for backwards compatibility."}},"schemas":{"CreateRecordRequest":{"title":"CreateRecordRequest","type":"object","properties":{"multiselect":{"type":"array","description":"Multi select field with options","nullable":true,"items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"date":{"type":"string","description":"Date field","nullable":true},"idField":{"type":"string","description":"Identifier field in UUID format","nullable":true},"number":{"type":"number","description":"Number field","nullable":true},"datetime":{"type":"string","description":"DateTime field","nullable":true},"array":{"type":"array","description":"Array field with arbitrary data","nullable":true,"items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"checkbox":{"type":"boolean","description":"Boolean field","nullable":true},"json":{"type":"object","description":"JSON field with arbitrary data","nullable":true},"assignee":{"type":"string","description":"Assigned user ID","nullable":true},"text":{"type":"string","description":"Text field","nullable":true},"integer":{"type":"number","description":"Integer field","nullable":true},"singleSelect":{"type":"string","description":"Select field option","nullable":true}}},"RecordDetailsResponse":{"title":"RecordDetailsResponse","required":["createdAt","id","updatedAt","version"],"type":"object","properties":{"date":{"type":"string","description":"Date field","nullable":true},"idField":{"type":"string","description":"Identifier field in UUID format","nullable":true},"integer":{"type":"number","description":"Integer field","nullable":true},"version":{"type":"number","description":"Record version"},"singleSelect":{"type":"object","properties":{"color":{"type":"string","description":"Single select defined color option","nullable":true},"value":{"type":"string","description":"Single select value","nullable":true}},"description":"Select field with options"},"multiselect":{"type":"array","description":"Multi select field with options","items":{"type":"object","properties":{"color":{"type":"string","description":"Multi select defined color option","nullable":true},"value":{"type":"string","description":"Multi select value","nullable":true}}}},"number":{"type":"number","description":"Number field","nullable":true},"createdAt":{"type":"string","description":"Creation timestamp"},"datetime":{"type":"string","description":"DateTime field","nullable":true},"array":{"type":"array","description":"Array field with arbitrary data","nullable":true,"items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"checkbox":{"type":"boolean","description":"Boolean field","nullable":true},"json":{"type":"object","description":"JSON field with arbitrary data","nullable":true},"assignee":{"type":"object","properties":{"lastName":{"type":"string","description":"Last name of the assignee","nullable":true},"firstName":{"type":"string","description":"First name of the assignee","nullable":true},"assignedAt":{"type":"string","description":"Timestamp when the user was assigned","nullable":true},"id":{"type":"string","description":"User ID of the assignee","nullable":true},"email":{"type":"string","description":"Email of the assignee","nullable":true}},"description":"Assignee field with user information"},"text":{"type":"string","description":"Text field","nullable":true},"id":{"type":"string","description":"Unique identifier of the record"},"updatedAt":{"type":"string","description":"Last update timestamp"}}},"ErrorResponse":{"required":["errors","fingerprint"],"type":"object","properties":{"fingerprint":{"type":"string","description":"Unique identifier for this error instance"},"errors":{"type":"array","description":"List of error details","items":{"required":["code","message"],"properties":{"code":{"type":"string","description":"Error code representing the type of error"},"message":{"type":"string","description":"Error message providing more details about the error"}}}}}}}},"paths":{"/tables/{tableId}/records":{"post":{"tags":["Records"],"summary":"Create a new record in a table","description":"Create a new record in a table. Requires `can_edit_data` permission on the table.","operationId":"create-record","parameters":[{"name":"tableId","in":"path","description":"Identifier of the table to create the record in","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Content-Type","in":"header","description":"Content type of the response","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Authorization","in":"header","description":"Organization token (`tot_`) — preferred method, or legacy Bearer JWT token. Pass the `tot_` token directly without Bearer prefix; use `Bearer <jwt>` for legacy JWT auth.","required":true,"style":"simple","explode":false,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json;charset=UTF-8":{"schema":{"$ref":"#/components/schemas/CreateRecordRequest"}}}},"responses":{"201":{"description":"201","headers":{"Content-Type":{"description":"Content type of the response","style":"simple","explode":false,"schema":{"type":"string"}}},"content":{"application/json;charset=UTF-8":{"schema":{"$ref":"#/components/schemas/RecordDetailsResponse"}}}},"400":{"description":"Bad Request – invalid request parameters","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"401":{"description":"Unauthorized – JWT token missing or invalid","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"403":{"description":"Forbidden – insufficient permissions","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"404":{"description":"Not Found – resource does not exist","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"500":{"description":"Internal Server Error – unexpected server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}}}}}
```

## Get a record by ID

> Get a record by ID. Requires \`can\_read\_data\` permission on the table.

```json
{"openapi":"3.0.1","info":{"title":"TransactionLink API","version":"v3"},"servers":[{"url":"https://api.transactionlink.io","description":"Production"}],"security":[{"organizationToken":[]},{"bearerAuthJWT":[]}],"components":{"securitySchemes":{"organizationToken":{"type":"apiKey","in":"header","name":"Authorization","description":"Organization API token (tot_) — preferred authentication method. Pass the token directly without Bearer prefix."},"bearerAuthJWT":{"type":"http","scheme":"bearer","bearerFormat":"JWT","description":"Legacy JWT Bearer token — deprecated in favor of organization tokens (tot_). Still supported for backwards compatibility."}},"schemas":{"RecordDetailsResponse":{"title":"RecordDetailsResponse","required":["createdAt","id","updatedAt","version"],"type":"object","properties":{"date":{"type":"string","description":"Date field","nullable":true},"idField":{"type":"string","description":"Identifier field in UUID format","nullable":true},"integer":{"type":"number","description":"Integer field","nullable":true},"version":{"type":"number","description":"Record version"},"singleSelect":{"type":"object","properties":{"color":{"type":"string","description":"Single select defined color option","nullable":true},"value":{"type":"string","description":"Single select value","nullable":true}},"description":"Select field with options"},"multiselect":{"type":"array","description":"Multi select field with options","items":{"type":"object","properties":{"color":{"type":"string","description":"Multi select defined color option","nullable":true},"value":{"type":"string","description":"Multi select value","nullable":true}}}},"number":{"type":"number","description":"Number field","nullable":true},"createdAt":{"type":"string","description":"Creation timestamp"},"datetime":{"type":"string","description":"DateTime field","nullable":true},"array":{"type":"array","description":"Array field with arbitrary data","nullable":true,"items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"checkbox":{"type":"boolean","description":"Boolean field","nullable":true},"json":{"type":"object","description":"JSON field with arbitrary data","nullable":true},"assignee":{"type":"object","properties":{"lastName":{"type":"string","description":"Last name of the assignee","nullable":true},"firstName":{"type":"string","description":"First name of the assignee","nullable":true},"assignedAt":{"type":"string","description":"Timestamp when the user was assigned","nullable":true},"id":{"type":"string","description":"User ID of the assignee","nullable":true},"email":{"type":"string","description":"Email of the assignee","nullable":true}},"description":"Assignee field with user information"},"text":{"type":"string","description":"Text field","nullable":true},"id":{"type":"string","description":"Unique identifier of the record"},"updatedAt":{"type":"string","description":"Last update timestamp"}}},"ErrorResponse":{"required":["errors","fingerprint"],"type":"object","properties":{"fingerprint":{"type":"string","description":"Unique identifier for this error instance"},"errors":{"type":"array","description":"List of error details","items":{"required":["code","message"],"properties":{"code":{"type":"string","description":"Error code representing the type of error"},"message":{"type":"string","description":"Error message providing more details about the error"}}}}}}}},"paths":{"/tables/{tableId}/records/{id}":{"get":{"tags":["Records"],"summary":"Get a record by ID","description":"Get a record by ID. Requires `can_read_data` permission on the table.","operationId":"get-record","parameters":[{"name":"tableId","in":"path","description":"Identifier of the table containing the record","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"id","in":"path","description":"Identifier of the record to retrieve","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Content-Type","in":"header","description":"Content type of the response","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Authorization","in":"header","description":"Organization token (`tot_`) — preferred method, or legacy Bearer JWT token. Pass the `tot_` token directly without Bearer prefix; use `Bearer <jwt>` for legacy JWT auth.","required":true,"style":"simple","explode":false,"schema":{"type":"string"}}],"responses":{"200":{"description":"200","headers":{"Content-Type":{"description":"Content type of the response","style":"simple","explode":false,"schema":{"type":"string"}}},"content":{"application/json;charset=UTF-8":{"schema":{"$ref":"#/components/schemas/RecordDetailsResponse"}}}},"400":{"description":"Bad Request – invalid request parameters","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"401":{"description":"Unauthorized – JWT token missing or invalid","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"403":{"description":"Forbidden – insufficient permissions","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"404":{"description":"Not Found – resource does not exist","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"500":{"description":"Internal Server Error – unexpected server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}}}}}
```

## Search records in a table

> Search records in a table. Requires \`can\_read\_data\` permission on the table.

```json
{"openapi":"3.0.1","info":{"title":"TransactionLink API","version":"v3"},"servers":[{"url":"https://api.transactionlink.io","description":"Production"}],"security":[{"organizationToken":[]},{"bearerAuthJWT":[]}],"components":{"securitySchemes":{"organizationToken":{"type":"apiKey","in":"header","name":"Authorization","description":"Organization API token (tot_) — preferred authentication method. Pass the token directly without Bearer prefix."},"bearerAuthJWT":{"type":"http","scheme":"bearer","bearerFormat":"JWT","description":"Legacy JWT Bearer token — deprecated in favor of organization tokens (tot_). Still supported for backwards compatibility."}},"schemas":{"SearchRecordsRequest":{"title":"SearchRecordsRequest","required":["pageNumber","pageSize"],"type":"object","properties":{"search":{"type":"object","properties":{"query":{"type":"string","description":"Search query string","nullable":true},"fields":{"type":"array","description":"List of field IDs to search in","nullable":true,"items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}}},"description":"Search criteria for quick search"},"view":{"type":"string","description":"Optional view ID to filter records","nullable":true},"pageNumber":{"type":"number","description":"Page number (0-based)"},"orderBy":{"type":"array","items":{"required":["direction","fieldId"],"type":"object","properties":{"direction":{"type":"string","description":"Order direction (ASC/DESC)"},"fieldId":{"type":"string","description":"Field ID to order by"}}}},"pageSize":{"type":"number","description":"Number of records per page"},"filters":{"required":["conjunction","groups"],"type":"object","properties":{"conjunction":{"type":"string","description":"Logical conjunction of filters, e.g. OR/AND"},"groups":{"type":"array","description":"Filter groups","items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"filters":{"type":"array","items":{"required":["fieldId","operator"],"type":"object","properties":{"type":{"type":"string","description":"Type of the value","nullable":true},"value":{"type":"object","description":"Value to compare","nullable":true},"operator":{"type":"string","description":"Operator for filtering, e.g. EQUALS"},"fieldId":{"type":"string","description":"ID of the field to filter"}}}}}}}},"SearchRecordsResponse":{"title":"SearchRecordsResponse","required":["content","empty","first","last","number","numberOfElements","size","totalElements","totalPages"],"type":"object","properties":{"number":{"type":"number","description":"The current page number"},"numberOfElements":{"type":"number","description":"Number of elements in the current page"},"size":{"type":"number","description":"The size of the page (repeated field)"},"last":{"type":"boolean","description":"Whether this is the last page"},"totalPages":{"type":"number","description":"Total number of pages"},"pageable":{"required":["offset","pageNumber","pageSize","paged","unpaged"],"type":"object","properties":{"paged":{"type":"boolean","description":"Whether the results are paged"},"pageNumber":{"type":"number","description":"Page number (0-based index)"},"offset":{"type":"number","description":"Offset of the first element on the page"},"pageSize":{"type":"number","description":"Size of the page"},"unpaged":{"type":"boolean","description":"Whether the results are unpaged"},"sort":{"required":["empty","sorted","unsorted"],"type":"object","properties":{"unsorted":{"type":"boolean","description":"Whether sorting has not been applied"},"sorted":{"type":"boolean","description":"Whether sorting has been applied"},"empty":{"type":"boolean","description":"Whether the sort is empty"}}}}},"sort":{"required":["empty","sorted","unsorted"],"type":"object","properties":{"unsorted":{"type":"boolean","description":"Whether the global sort has not been applied"},"sorted":{"type":"boolean","description":"Whether the global sort has been applied"},"empty":{"type":"boolean","description":"Whether the global sort is empty"}}},"first":{"type":"boolean","description":"Whether this is the first page"},"content":{"type":"array","description":"List of records in the current page","items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"empty":{"type":"boolean","description":"Whether the page is empty"},"totalElements":{"type":"number","description":"Total number of elements"}}},"ErrorResponse":{"required":["errors","fingerprint"],"type":"object","properties":{"fingerprint":{"type":"string","description":"Unique identifier for this error instance"},"errors":{"type":"array","description":"List of error details","items":{"required":["code","message"],"properties":{"code":{"type":"string","description":"Error code representing the type of error"},"message":{"type":"string","description":"Error message providing more details about the error"}}}}}}}},"paths":{"/tables/{tableId}/records/search":{"post":{"tags":["Records"],"summary":"Search records in a table","description":"Search records in a table. Requires `can_read_data` permission on the table.","operationId":"search-records","parameters":[{"name":"tableId","in":"path","description":"Identifier of the table to search records in","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Content-Type","in":"header","description":"Content type of the response","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Authorization","in":"header","description":"Organization token (`tot_`) — preferred method, or legacy Bearer JWT token. Pass the `tot_` token directly without Bearer prefix; use `Bearer <jwt>` for legacy JWT auth.","required":true,"style":"simple","explode":false,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json;charset=UTF-8":{"schema":{"$ref":"#/components/schemas/SearchRecordsRequest"}}}},"responses":{"200":{"description":"200","headers":{"Content-Type":{"description":"Content type of the response","style":"simple","explode":false,"schema":{"type":"string"}}},"content":{"application/json;charset=UTF-8":{"schema":{"$ref":"#/components/schemas/SearchRecordsResponse"}}}},"400":{"description":"Bad Request – invalid request parameters","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"401":{"description":"Unauthorized – JWT token missing or invalid","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"403":{"description":"Forbidden – insufficient permissions","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"404":{"description":"Not Found – resource does not exist","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"500":{"description":"Internal Server Error – unexpected server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}}}}}
```

## Delete a record by ID

> Delete a record by ID. Requires \`can\_edit\_data\` permission on the table.

```json
{"openapi":"3.0.1","info":{"title":"TransactionLink API","version":"v3"},"servers":[{"url":"https://api.transactionlink.io","description":"Production"}],"security":[{"organizationToken":[]},{"bearerAuthJWT":[]}],"components":{"securitySchemes":{"organizationToken":{"type":"apiKey","in":"header","name":"Authorization","description":"Organization API token (tot_) — preferred authentication method. Pass the token directly without Bearer prefix."},"bearerAuthJWT":{"type":"http","scheme":"bearer","bearerFormat":"JWT","description":"Legacy JWT Bearer token — deprecated in favor of organization tokens (tot_). Still supported for backwards compatibility."}},"schemas":{"ErrorResponse":{"required":["errors","fingerprint"],"type":"object","properties":{"fingerprint":{"type":"string","description":"Unique identifier for this error instance"},"errors":{"type":"array","description":"List of error details","items":{"required":["code","message"],"properties":{"code":{"type":"string","description":"Error code representing the type of error"},"message":{"type":"string","description":"Error message providing more details about the error"}}}}}}}},"paths":{"/tables/{tableId}/records/{id}":{"delete":{"tags":["Records"],"summary":"Delete a record by ID","description":"Delete a record by ID. Requires `can_edit_data` permission on the table.","operationId":"delete-record","parameters":[{"name":"tableId","in":"path","description":"Identifier of the table containing the record","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"id","in":"path","description":"Identifier of the record to delete","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Content-Type","in":"header","description":"Content type of the response","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Authorization","in":"header","description":"Organization token (`tot_`) — preferred method, or legacy Bearer JWT token. Pass the `tot_` token directly without Bearer prefix; use `Bearer <jwt>` for legacy JWT auth.","required":true,"style":"simple","explode":false,"schema":{"type":"string"}}],"responses":{"204":{"description":"204"},"400":{"description":"Bad Request – invalid request parameters","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"401":{"description":"Unauthorized – JWT token missing or invalid","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"403":{"description":"Forbidden – insufficient permissions","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"404":{"description":"Not Found – resource does not exist","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"500":{"description":"Internal Server Error – unexpected server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}}}}}
```

## Delete multiple records in batch

> Delete multiple records in batch. Requires \`can\_edit\_data\` permission on the table.

```json
{"openapi":"3.0.1","info":{"title":"TransactionLink API","version":"v3"},"servers":[{"url":"https://api.transactionlink.io","description":"Production"}],"security":[{"organizationToken":[]},{"bearerAuthJWT":[]}],"components":{"securitySchemes":{"organizationToken":{"type":"apiKey","in":"header","name":"Authorization","description":"Organization API token (tot_) — preferred authentication method. Pass the token directly without Bearer prefix."},"bearerAuthJWT":{"type":"http","scheme":"bearer","bearerFormat":"JWT","description":"Legacy JWT Bearer token — deprecated in favor of organization tokens (tot_). Still supported for backwards compatibility."}},"schemas":{"DeleteRecordsInBatchRequest":{"type":"array","description":"Array of record IDs to delete","items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"ErrorResponse":{"required":["errors","fingerprint"],"type":"object","properties":{"fingerprint":{"type":"string","description":"Unique identifier for this error instance"},"errors":{"type":"array","description":"List of error details","items":{"required":["code","message"],"properties":{"code":{"type":"string","description":"Error code representing the type of error"},"message":{"type":"string","description":"Error message providing more details about the error"}}}}}}}},"paths":{"/tables/{tableId}/records/delete-batch":{"post":{"tags":["Records"],"summary":"Delete multiple records in batch","description":"Delete multiple records in batch. Requires `can_edit_data` permission on the table.","operationId":"delete-records-in-batch","parameters":[{"name":"tableId","in":"path","description":"Identifier of the table containing the records","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Content-Type","in":"header","description":"Content type of the response","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Authorization","in":"header","description":"Organization token (`tot_`) — preferred method, or legacy Bearer JWT token. Pass the `tot_` token directly without Bearer prefix; use `Bearer <jwt>` for legacy JWT auth.","required":true,"style":"simple","explode":false,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json;charset=UTF-8":{"schema":{"$ref":"#/components/schemas/DeleteRecordsInBatchRequest"}}}},"responses":{"204":{"description":"204"},"400":{"description":"Bad Request – invalid request parameters","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"401":{"description":"Unauthorized – JWT token missing or invalid","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"403":{"description":"Forbidden – insufficient permissions","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"404":{"description":"Not Found – resource does not exist","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"500":{"description":"Internal Server Error – unexpected server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}}}}}
```

## Update an existing record by ID

> Update an existing record by ID. Requires \`can\_edit\_data\` permission on the table.

```json
{"openapi":"3.0.1","info":{"title":"TransactionLink API","version":"v3"},"servers":[{"url":"https://api.transactionlink.io","description":"Production"}],"security":[{"organizationToken":[]},{"bearerAuthJWT":[]}],"components":{"securitySchemes":{"organizationToken":{"type":"apiKey","in":"header","name":"Authorization","description":"Organization API token (tot_) — preferred authentication method. Pass the token directly without Bearer prefix."},"bearerAuthJWT":{"type":"http","scheme":"bearer","bearerFormat":"JWT","description":"Legacy JWT Bearer token — deprecated in favor of organization tokens (tot_). Still supported for backwards compatibility."}},"schemas":{"UpdateRecordRequest":{"title":"UpdateRecordRequest","type":"object","properties":{"multiselect":{"type":"array","description":"Multi select field with options","nullable":true,"items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"date":{"type":"string","description":"Date field","nullable":true},"idField":{"type":"string","description":"Identifier field in UUID format","nullable":true},"number":{"type":"number","description":"Number field","nullable":true},"datetime":{"type":"string","description":"DateTime field","nullable":true},"array":{"type":"array","description":"Array field with arbitrary data","nullable":true,"items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"checkbox":{"type":"boolean","description":"Boolean field","nullable":true},"json":{"type":"object","description":"JSON field with arbitrary data","nullable":true},"assignee":{"type":"string","description":"Assigned user ID","nullable":true},"text":{"type":"string","description":"Text field","nullable":true},"integer":{"type":"number","description":"Integer field","nullable":true},"singleSelect":{"type":"string","description":"Select field option","nullable":true}}},"RecordDetailsResponse":{"title":"RecordDetailsResponse","required":["createdAt","id","updatedAt","version"],"type":"object","properties":{"date":{"type":"string","description":"Date field","nullable":true},"idField":{"type":"string","description":"Identifier field in UUID format","nullable":true},"integer":{"type":"number","description":"Integer field","nullable":true},"version":{"type":"number","description":"Record version"},"singleSelect":{"type":"object","properties":{"color":{"type":"string","description":"Single select defined color option","nullable":true},"value":{"type":"string","description":"Single select value","nullable":true}},"description":"Select field with options"},"multiselect":{"type":"array","description":"Multi select field with options","items":{"type":"object","properties":{"color":{"type":"string","description":"Multi select defined color option","nullable":true},"value":{"type":"string","description":"Multi select value","nullable":true}}}},"number":{"type":"number","description":"Number field","nullable":true},"createdAt":{"type":"string","description":"Creation timestamp"},"datetime":{"type":"string","description":"DateTime field","nullable":true},"array":{"type":"array","description":"Array field with arbitrary data","nullable":true,"items":{"oneOf":[{"type":"object"},{"type":"boolean"},{"type":"string"},{"type":"number"}]}},"checkbox":{"type":"boolean","description":"Boolean field","nullable":true},"json":{"type":"object","description":"JSON field with arbitrary data","nullable":true},"assignee":{"type":"object","properties":{"lastName":{"type":"string","description":"Last name of the assignee","nullable":true},"firstName":{"type":"string","description":"First name of the assignee","nullable":true},"assignedAt":{"type":"string","description":"Timestamp when the user was assigned","nullable":true},"id":{"type":"string","description":"User ID of the assignee","nullable":true},"email":{"type":"string","description":"Email of the assignee","nullable":true}},"description":"Assignee field with user information"},"text":{"type":"string","description":"Text field","nullable":true},"id":{"type":"string","description":"Unique identifier of the record"},"updatedAt":{"type":"string","description":"Last update timestamp"}}},"ErrorResponse":{"required":["errors","fingerprint"],"type":"object","properties":{"fingerprint":{"type":"string","description":"Unique identifier for this error instance"},"errors":{"type":"array","description":"List of error details","items":{"required":["code","message"],"properties":{"code":{"type":"string","description":"Error code representing the type of error"},"message":{"type":"string","description":"Error message providing more details about the error"}}}}}}}},"paths":{"/tables/{tableId}/records/{id}":{"patch":{"tags":["Records"],"summary":"Update an existing record by ID","description":"Update an existing record by ID. Requires `can_edit_data` permission on the table.","operationId":"update-record","parameters":[{"name":"tableId","in":"path","description":"Identifier of the table containing the record","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"id","in":"path","description":"Identifier of the record to update","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Content-Type","in":"header","description":"Content type of the response","required":true,"style":"simple","explode":false,"schema":{"type":"string"}},{"name":"Authorization","in":"header","description":"Organization token (`tot_`) — preferred method, or legacy Bearer JWT token. Pass the `tot_` token directly without Bearer prefix; use `Bearer <jwt>` for legacy JWT auth.","required":true,"style":"simple","explode":false,"schema":{"type":"string"}}],"requestBody":{"content":{"application/json;charset=UTF-8":{"schema":{"$ref":"#/components/schemas/UpdateRecordRequest"}}}},"responses":{"200":{"description":"200","headers":{"Content-Type":{"description":"Content type of the response","style":"simple","explode":false,"schema":{"type":"string"}}},"content":{"application/json;charset=UTF-8":{"schema":{"$ref":"#/components/schemas/RecordDetailsResponse"}}}},"400":{"description":"Bad Request – invalid request parameters","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"401":{"description":"Unauthorized – JWT token missing or invalid","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"403":{"description":"Forbidden – insufficient permissions","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"404":{"description":"Not Found – resource does not exist","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}},"500":{"description":"Internal Server Error – unexpected server error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ErrorResponse"}}}}}}}}}
```

{% content-ref url="/pages/0Ibc7lh11DUQsBQm4XL1" %}
[Attachments](/docs/transactionlink-api/api-reference/records/attachments.md)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.transactionlink.io/docs/transactionlink-api/api-reference/records.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.