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
Input Schema
TableJSON 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 |