updateReview
Idempotent
Update an existing review by ID to change its status (accept, decline, pending) or correct text fields. Ideal for moderation and typo fixes.
Instructions
Update a review - Update an existing review record by ID. Fields omitted are untouched. Writes live data.
Use when: moderating - change review_status (0=Pending -> 2=Accepted to publish, 3=Declined to reject, 4=Waiting for Admin). Also used for admin corrections of typos in review text.
Required: review_id.
Enums: review_status: 0=Pending, 2=Accepted, 3=Declined, 4=Waiting for Admin.
See also: createReview (add new), deleteReview (remove permanently).
Returns: { status: "success", message: {...updatedRecord} } - the full updated record after changes applied.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| review_id | Yes | ||
| review_name | No | ||
| review_title | No | ||
| review_description | No | ||
| rating_overall | No | ||
| recommend | No | ||
| review_status | No | Review status (integer): - `0` = Pending (awaiting moderation) - `2` = Accepted (visible on profile) - `3` = Declined (rejected, not public) - `4` = Waiting for Admin (member pre-accepted, needs admin sign-off) Value `1` is NOT documented. BD does NOT reject it - stores `"1"` verbatim with undefined render behavior. Stick to documented values. Normal flow: `0` -> `2` (accepted) or `0` -> `3` (declined). | |
| _clear_fields | No | Column names to clear to empty string. Available on every `update*` operation. Works on base columns AND EAV/`users_meta` rows (rows preserved with `value=""`). To actually clear a field you MUST use this parameter — sending the field with `""` alone is a no-op (BD drops empty values). To remove a `users_meta` row entirely, use `deleteUserMeta`. See **Rule: Clearing fields**. Example: `_clear_fields: ["h2", "hero_link_url"]`. |