generate_and_update_signed_url
Generate a signed URL for a private bucket file and update it along with expiration timestamp in a database table.
Instructions
Generate a signed URL for a private bucket file and update the URL in a DB media table
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"bucket": "<bucket>",
"path": "<path>",
"table": "<table>",
"id_value": "<id_value>"
},
"name": "generate_and_update_signed_url"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bucket | Yes | Bucket name (e.g. prd_medias, pry_medias) | |
| path | Yes | File path in the bucket (e.g. aqc/aqc-105/250gr.jpeg) | |
| expires_in | No | Expiry in seconds (default: 1 year = 31536000) | |
| table | Yes | Table to update (e.g. prd_medias, pry_medias, brd_medias) | |
| id_column | No | Primary key column name (default: id) | id |
| id_value | Yes | Value of the primary key to match | |
| url_column | No | Column for signed URL (default: signed_url) | signed_url |
| expires_at_column | No | Column for expiration timestamp (default: signed_url_expires_at) | signed_url_expires_at |