API Reference

curl -X POST "{{base_url}}/external/v1/auth/login" \
  -H "Content-Type: application/json" \
  -d '{"client_id": "{{client_id}}", "client_secret": "{{client_secret}}"}'

{
    "access_token": "pvx_at_9c1f…",
    "token_type": "Bearer",
    "expires_in": 3600,
    "scope": "entries:read entries:write",
    "refresh_token": "pvx_rt_47d2…"
}

curl -X POST "{{base_url}}/external/v1/auth/token" \
  -H "Content-Type: application/json" \
  -d '{"grant_type": "refresh_token", "refresh_token": "{{refresh_token}}", "client_id": "{{client_id}}", "client_secret": "{{client_secret}}"}'

{
    "access_token": "pvx_at_5be0…",
    "token_type": "Bearer",
    "expires_in": 3600,
    "scope": "entries:read entries:write",
    "refresh_token": "pvx_rt_a812…"
}

curl -X GET "{{base_url}}/external/v1/me" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "client": {
        "name": "Acme Logistics",
        "client_id": "ext.acme-logistics.1a2b3c4d"
    },
    "credential": {
        "name": "Production server",
        "expires_at": null
    },
    "permissions": [
        {
            "permission": "entries:read",
            "smarttables": [
                {
                    "id": 61,
                    "name": "Dispatch Log"
                }
            ]
        },
        {
            "permission": "entries:write",
            "smarttables": [
                {
                    "id": 61,
                    "name": "Dispatch Log"
                }
            ]
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/reference/postman?base_url=https%3A%2F%2Fyour-host%2Fpersivapps%2Fservice" \
  -H "Authorization: Bearer {{access_token}}"

(a file: application/json)

curl -X GET "{{base_url}}/external/v1/reference/pdf?base_url=https%3A%2F%2Fyour-host%2Fpersivapps%2Fservice" \
  -H "Authorization: Bearer {{access_token}}"

(a file: application/pdf)

curl -X GET "{{base_url}}/external/v1/smarttables/61/entries?page=1&page_size=100&updated_after=2026-10-01T00%3A00%3A00Z&sort=updated_at&dir=asc" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "entries": [
        {
            "smarttable_id": 61,
            "smarttable_data_id": 189862,
            "smarttable_data_entry_id": 195569,
            "observation_number": 1,
            "values": {
                "1": "Truck MH12AB1234",
                "3": 12.5,
                "8": "Arrived"
            },
            "is_submitted": false,
            "is_deleted": false,
            "created_at": "2026-10-12T09:41:07.512Z",
            "updated_at": "2026-10-12T09:41:07.512Z",
            "created_by": "Acme Logistics (integration)"
        }
    ],
    "page": 1,
    "page_size": 100,
    "total_count": 1,
    "total_pages": 1
}

curl -X GET "{{base_url}}/external/v1/smarttables/data/189862" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "row": {
        "smarttable_id": 61,
        "smarttable_data_id": 189862,
        "smarttable_data_entry_id": 195569,
        "observation_number": 1,
        "values": {
            "1": "Truck MH12AB1234",
            "3": 12.5,
            "8": "Arrived"
        },
        "is_submitted": false,
        "is_deleted": false,
        "created_at": "2026-10-12T09:41:07.512Z",
        "updated_at": "2026-10-12T09:41:07.512Z",
        "created_by": "Acme Logistics (integration)"
    }
}

curl -X GET "{{base_url}}/external/v1/entries/195569" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "smarttable_data_entry_id": 195569,
    "observations": [
        {
            "smarttable_id": 61,
            "smarttable_data_id": 189862,
            "smarttable_data_entry_id": 195569,
            "observation_number": 1,
            "values": {
                "1": "Truck MH12AB1234",
                "3": 12.5,
                "8": "Arrived"
            },
            "is_submitted": false,
            "is_deleted": false,
            "created_at": "2026-10-12T09:41:07.512Z",
            "updated_at": "2026-10-12T09:41:07.512Z",
            "created_by": "Acme Logistics (integration)"
        }
    ]
}

curl -X DELETE "{{base_url}}/external/v1/smarttables/data/189862" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Deleted",
    "smarttable_data_id": 189862
}

curl -X POST "{{base_url}}/external/v1/smarttables/data/189862/restore" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Restored",
    "smarttable_data_id": 189862
}

curl -X DELETE "{{base_url}}/external/v1/smarttables/data/189862/permanent" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Deleted permanently",
    "smarttable_data_id": 189862
}

curl -X POST "{{base_url}}/external/v1/smarttables/data/189862/unsubmit" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Unsubmitted",
    "smarttable_data_id": 189862
}

curl -X POST "{{base_url}}/external/v1/smarttables/data/189862/release-lock" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Edit lock released",
    "smarttable_data_id": 189862
}

curl -X POST "{{base_url}}/external/v1/smarttables/data/save" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"smarttable_id": 61, "smarttable_values": {"1": "Truck MH12AB1234", "3": 12.5, "8": "Arrived"}, "is_submit": false, "client_op_id": "acme-dispatch-000123"}'

{
    "status": "success",
    "message": "Saved",
    "duplicate": false,
    "smarttable_id": 61,
    "smarttable_data_id": 189862,
    "smarttable_data_entry_id": 195569,
    "observation_number": 1
}

curl -X PUT "{{base_url}}/external/v1/smarttables/data/189862/update" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"smarttable_values": {"8": "Unloaded"}, "cleared_fields": ["3"]}'

{
    "status": "success",
    "message": "Updated",
    "smarttable_id": 61,
    "smarttable_data_id": 189862,
    "smarttable_data_entry_id": 195569,
    "observation_number": 1
}

curl -X POST "{{base_url}}/external/v1/bulk/delete" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"smarttable_data_ids": [189862, 189863, 999999]}'

{
    "status": "success",
    "deleted": [
        189862,
        189863
    ],
    "failed": [
        {
            "id": 999999,
            "error": "Not found"
        }
    ]
}

curl -X POST "{{base_url}}/external/v1/bulk/restore" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"smarttable_data_ids": [189862, 189863]}'

{
    "status": "success",
    "restored": [
        189862,
        189863
    ],
    "failed": []
}

curl -X POST "{{base_url}}/external/v1/bulk/delete-permanently" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"smarttable_data_ids": [189862]}'

{
    "status": "success",
    "deleted": [
        189862
    ],
    "failed": []
}

curl -X POST "{{base_url}}/external/v1/bulk/update-version" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"smarttable_data_ids": [189862], "update": "both"}'

{
    "status": "success",
    "updated": [
        {
            "id": 189862,
            "entry_version_id": 412,
            "display_version_id": 233
        }
    ],
    "failed": []
}

curl -X POST "{{base_url}}/external/v1/smarttables/64/bulk-upload" \
  -H "Authorization: Bearer {{access_token}}" \
  -F "file=@vehicles.xlsx"

{
    "status": "success",
    "smarttable_id": 64,
    "message": "Bulk upload completed",
    "total_rows": 120,
    "added": 118,
    "failed": 2,
    "errors": [
        "Row 14: Vehicle number is required",
        "Row 87: duplicate Vehicle number"
    ]
}

curl -X GET "{{base_url}}/external/v1/smarttables/data/189862/attestation" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "attestation": {
        "smarttable_data_id": 189862,
        "attested": true,
        "attested_by": {
            "user_id": 431,
            "name": "Acme Logistics (integration)"
        },
        "esign": {
            "status": null,
            "transaction_id": null
        }
    }
}

curl -X POST "{{base_url}}/external/v1/smarttables/data/189862/attestation" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"image": "iVBORw0KGgoAAAANSUhEUgAA..."}'

{
    "status": "success",
    "attestation": {
        "smarttable_data_id": 189862,
        "attested": true,
        "attested_by": {
            "user_id": 431,
            "name": "Acme Logistics (integration)"
        },
        "esign": {
            "status": null,
            "transaction_id": null
        }
    }
}

curl -X DELETE "{{base_url}}/external/v1/smarttables/data/189862/attestation" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "attestation": {
        "smarttable_data_id": 189862,
        "attested": false,
        "attested_by": null,
        "esign": {
            "status": null,
            "transaction_id": null
        }
    }
}

curl -X GET "{{base_url}}/external/v1/smarttables/data/189862/attachments" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_data_id": 189862,
    "attachments": {
        "6": [
            {
                "filename": "0001_3f9a1c2b7d4e_weighbridge-slip.pdf",
                "path": "smarttables/data/189862/attachments/6/0001_3f9a1c2b7d4e_weighbridge-slip.pdf"
            }
        ]
    }
}

curl -X GET "{{base_url}}/external/v1/smarttables/data/189862/attachments/6/0001_3f9a1c2b7d4e_weighbridge-slip.pdf" \
  -H "Authorization: Bearer {{access_token}}"

(a file: application/octet-stream)

curl -X POST "{{base_url}}/external/v1/smarttables/data/189862/attachments/6" \
  -H "Authorization: Bearer {{access_token}}" \
  -F "files=@weighbridge-slip.pdf"

{
    "status": "success",
    "smarttable_data_id": 189862,
    "field_id": "6",
    "files": [
        "0001_3f9a1c2b7d4e_weighbridge-slip.pdf"
    ]
}

curl -X DELETE "{{base_url}}/external/v1/smarttables/data/189862/attachments/6/0001_3f9a1c2b7d4e_weighbridge-slip.pdf" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Removed",
    "smarttable_data_id": 189862,
    "field_id": "6",
    "filename": "0001_3f9a1c2b7d4e_weighbridge-slip.pdf"
}

curl -X GET "{{base_url}}/external/v1/smarttables/data/189862/comments" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_data_id": 189862,
    "comments": [
        {
            "text": "Weighbridge slip attached.",
            "author": "Asha Patel",
            "at": "2026-10-12T10:02:11Z",
            "kind": "comment",
            "attachments": []
        }
    ]
}

curl -X POST "{{base_url}}/external/v1/smarttables/data/189862/comments" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"text": "Unloaded at gate 3."}'

{
    "status": "success",
    "message": "Comment added",
    "smarttable_data_id": 189862
}

curl -X GET "{{base_url}}/external/v1/entries/195569/approval" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_data_entry_id": 195569,
    "approval_enabled": true,
    "approval": {
        "approval_workflow_enabled": true,
        "interleaved": false,
        "total_steps": 2,
        "current_step": 2,
        "current_entry_step": null,
        "steps_done": 1,
        "steps_pending": 1,
        "is_fully_approved": false,
        "is_rejected": false,
        "is_published": false,
        "published_at": null,
        "waiting_for_approval": true,
        "approved_at": null,
        "steps": [
            {
                "step": 1,
                "label": "Step 1",
                "mode": "any",
                "approvers": [
                    12,
                    15
                ],
                "approvers_list": [
                    {
                        "name": "Asha Patel"
                    },
                    {
                        "name": "Vikram Rao"
                    }
                ],
                "status": "approved",
                "approved_by": [
                    {
                        "name": "Asha Patel"
                    }
                ],
                "pending_approvers": [],
                "comment": "Looks fine"
            }
        ],
        "publish_notification_users": [],
        "email_publish_notification_users": [],
        "publish_email_settings": {
            "subject": "",
            "body": ""
        }
    }
}

curl -X GET "{{base_url}}/external/v1/entries/195569/approval/history" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_data_entry_id": 195569,
    "rounds": []
}

curl -X POST "{{base_url}}/external/v1/bulk/pdf" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"smarttable_data_entry_ids": [195569, 195570], "include_attachments": false}'

(a file: application/zip)

curl -X GET "{{base_url}}/external/v1/entries/195569/pdf?include_attachments=false" \
  -H "Authorization: Bearer {{access_token}}"

(a file: application/pdf)

curl -X GET "{{base_url}}/external/v1/smarttables" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttables": [
        {
            "smarttable_id": 61,
            "name": "Dispatch Log",
            "is_approved": true,
            "is_relational": false,
            "observation_count": 1,
            "version": 4
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/smarttables/61" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable": {
        "smarttable_id": 61,
        "name": "Dispatch Log",
        "is_approved": true,
        "is_relational": false,
        "observation_count": 1,
        "version": 4,
        "fields": [
            {
                "id": 1,
                "name": "Truck number",
                "ui_smarttable_element": "text",
                "optional": false,
                "hide": false,
                "isDisabled": false,
                "show_in_entries_list": true,
                "accordion": "Vehicle",
                "smarttable_section": "Dispatch",
                "row": "",
                "table": false,
                "table_no": "",
                "auto_increment": false,
                "min_value_allowed": "",
                "max_value_allowed": "",
                "acceptance_criteria": "",
                "allowed_data": "",
                "properties": "",
                "hide_for_observation_number": "",
                "autofill_from_observation1": false,
                "attachment": "",
                "attachment_max_count": "",
                "remarks": false,
                "default": ""
            }
        ]
    }
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/versions" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "versions": [
        {
            "version": 4,
            "approved": true,
            "source": "sharepoint",
            "created_at": "2026-10-01T08:00:00Z",
            "field_count": 12
        }
    ]
}

curl -X POST "{{base_url}}/external/v1/smarttables" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"name": "Dispatch Log", "is_relational": false, "observation_count": 1, "fields": [{"name": "Truck number", "ui_smarttable_element": "text"}, {"name": "Weight (t)", "ui_smarttable_element": "number", "optional": true}]}'

{
    "status": "success",
    "smarttable_id": 88,
    "name": "Dispatch Log",
    "message": "Created; it is usable once approved in the app"
}

curl -X PUT "{{base_url}}/external/v1/smarttables/61/schema" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"fields": [{"id": 1, "name": "Truck number", "ui_smarttable_element": "text"}, {"name": "Driver phone", "ui_smarttable_element": "text", "optional": true}]}'

{
    "status": "success",
    "smarttable_id": 61,
    "version": 5,
    "message": "Saved; a new version may need approval in the app"
}

curl -X DELETE "{{base_url}}/external/v1/smarttables/61" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Deleted",
    "smarttable_id": 61
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/display?version=3" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "display": {
        "version": 3,
        "approved": true,
        "created_at": "2026-09-20T07:30:00Z",
        "layout": {
            "cells": [
                {
                    "address": "B2",
                    "row": 1,
                    "column": 1,
                    "value": "<pa_1>",
                    "font": {
                        "bold": true,
                        "name": "Calibri",
                        "size": 11
                    },
                    "column_width": 18,
                    "row_height": 15
                }
            ]
        }
    }
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/display/versions" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "versions": [
        {
            "version": 3,
            "approved": true,
            "created_at": "2026-09-20T07:30:00Z"
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/source" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "source": "sharepoint",
    "url": "https://contoso.sharepoint.com/sites/ops/Shared%20Documents/dispatch.xlsx",
    "sync_locked": false
}

curl -X POST "{{base_url}}/external/v1/smarttables/61/sync" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "source": "sharepoint",
    "versions_updated": true,
    "entry_version": 5,
    "display_version": 3
}

curl -X POST "{{base_url}}/external/v1/smarttables/from-source" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"name": "Vehicle Master", "sharepoint_url": "https://contoso.sharepoint.com/sites/ops/Shared%20Documents/vehicles.xlsx", "is_relational": true}'

{
    "status": "success",
    "smarttable_id": 89,
    "name": "Vehicle Master",
    "message": "Created; it is usable once approved in the app"
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/settings" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "settings": {
        "observation_count": 1,
        "submit_button_label": "Submit",
        "show_observation_number": false,
        "show_min_max_values": true,
        "is_autosave_enabled": true,
        "autosave_enabled_by_default": false,
        "enable_attestation": false,
        "require_submitter_signature": false,
        "enable_notification_comments": false,
        "enable_notes": false,
        "enable_entry_access_control": false,
        "autosave_interval": 60,
        "freeze_columns_fields": [
            1
        ],
        "filter_fields": [
            8
        ],
        "pdf_filename_fields": [
            1
        ],
        "primary_field_id": null,
        "entries_page_size": 100,
        "show_entries": "all",
        "show_entries_attribute_id": null,
        "submit_admin_users": [],
        "unsubmit_admin_users": [],
        "attest_users": [],
        "submit_notification_users": [],
        "offline_enabled": false,
        "compress_attachments": true
    }
}

curl -X PATCH "{{base_url}}/external/v1/smarttables/61/settings" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"submit_button_label": "Send", "autosave_interval": 30}'

{
    "status": "success",
    "smarttable_id": 61,
    "version": 7,
    "settings": {
        "observation_count": 1,
        "submit_button_label": "Send",
        "show_observation_number": false,
        "show_min_max_values": true,
        "is_autosave_enabled": true,
        "autosave_enabled_by_default": false,
        "enable_attestation": false,
        "require_submitter_signature": false,
        "enable_notification_comments": false,
        "enable_notes": false,
        "enable_entry_access_control": false,
        "autosave_interval": 30,
        "freeze_columns_fields": [
            1
        ],
        "filter_fields": [
            8
        ],
        "pdf_filename_fields": [
            1
        ],
        "primary_field_id": null,
        "entries_page_size": 100,
        "show_entries": "all",
        "show_entries_attribute_id": null,
        "submit_admin_users": [],
        "unsubmit_admin_users": [],
        "attest_users": [],
        "submit_notification_users": [],
        "offline_enabled": false,
        "compress_attachments": true
    }
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/approval-workflow" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "approval_workflow": {
        "enabled": true,
        "interleaved": false,
        "step0": {
            "enabled": false,
            "notify_on_later_steps": false,
            "deadline_days": 0
        },
        "steps": [
            {
                "step": 1,
                "mode": "any",
                "approvers": [
                    12,
                    15
                ],
                "notify_on_later_steps": false,
                "deadline_days": 2
            }
        ],
        "on_publish": {
            "notify_users": [],
            "email_users": [
                30
            ],
            "email": {
                "subject": "Approved",
                "body": "Please find the PDF attached.",
                "signature": ""
            }
        }
    }
}

curl -X PUT "{{base_url}}/external/v1/smarttables/61/approval-workflow" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"enabled": true, "steps": [{"mode": "any", "approvers": [12, 15], "deadline_days": 2}, {"mode": "all", "approvers": [20]}]}'

{
    "status": "success",
    "smarttable_id": 61,
    "version": 6,
    "approval_workflow": {
        "enabled": true,
        "interleaved": false,
        "step0": {
            "enabled": false,
            "notify_on_later_steps": false,
            "deadline_days": 0
        },
        "steps": [
            {
                "step": 1,
                "mode": "any",
                "approvers": [
                    12,
                    15
                ],
                "notify_on_later_steps": false,
                "deadline_days": 2
            }
        ],
        "on_publish": {
            "notify_users": [],
            "email_users": [
                30
            ],
            "email": {
                "subject": "Approved",
                "body": "Please find the PDF attached.",
                "signature": ""
            }
        }
    }
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/steps" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "steps": [
        {
            "step_number": 1,
            "step_name": "Gate in",
            "sheet_step_name": "Gate in",
            "field_count": 6,
            "assignees": {
                "users": [
                    12
                ]
            },
            "resolved_users": [
                {
                    "id": 12,
                    "name": "Asha Patel"
                }
            ],
            "show_to_later_steps": false
        }
    ]
}

curl -X PUT "{{base_url}}/external/v1/smarttables/61/steps" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"steps": [{"step_number": 1, "assignees": {"users": [12]}}]}'

{
    "status": "success",
    "smarttable_id": 61,
    "steps": [
        {
            "step_number": 1,
            "step_name": "Gate in",
            "sheet_step_name": "Gate in",
            "field_count": 6,
            "assignees": {
                "users": [
                    12
                ]
            },
            "resolved_users": [
                {
                    "id": 12,
                    "name": "Asha Patel"
                }
            ],
            "show_to_later_steps": false
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/access" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "access": [
        {
            "user_id": 12,
            "name": "Asha Patel",
            "username": "asha.patel",
            "role": "admin",
            "is_api_client": false
        }
    ]
}

curl -X POST "{{base_url}}/external/v1/smarttables/61/access" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"user_ids": [12, 15], "role": "user"}'

{
    "status": "success",
    "smarttable_id": 61,
    "granted": [
        15
    ],
    "already_had_access": [
        12
    ],
    "role": "user"
}

curl -X PUT "{{base_url}}/external/v1/smarttables/61/access/15" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"role": "viewer"}'

{
    "status": "success",
    "smarttable_id": 61,
    "user_id": 15,
    "role": "viewer"
}

curl -X DELETE "{{base_url}}/external/v1/smarttables/61/access/15" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Access removed",
    "smarttable_id": 61,
    "user_id": 15
}

curl -X GET "{{base_url}}/external/v1/access/users?search=asha" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "users": [
        {
            "user_id": 12,
            "name": "Asha Patel",
            "username": "asha.patel"
        }
    ],
    "page": 1,
    "page_size": 100,
    "total_count": 1
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/entry-access" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "feature_enabled_on_server": true,
    "enabled": true,
    "rules": {
        "view": {
            "match_creator_attribute": "5"
        },
        "edit": {
            "creator_only": true
        },
        "admin": []
    },
    "show_entries": "all"
}

curl -X PUT "{{base_url}}/external/v1/smarttables/61/entry-access" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"enabled": true, "rules": {"view": {"match_creator_attribute": "5"}, "edit": {"creator_only": true, "users": [12]}}}'

{
    "status": "success",
    "smarttable_id": 61,
    "feature_enabled_on_server": true,
    "enabled": true,
    "rules": {
        "view": {
            "match_creator_attribute": "5"
        },
        "edit": {
            "creator_only": true,
            "users": [
                12
            ]
        },
        "admin": []
    },
    "show_entries": "all"
}

curl -X PATCH "{{base_url}}/external/v1/smarttables/data/189862/access" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"view": {"users": [12]}, "edit": null}'

{
    "status": "success",
    "smarttable_data_id": 189862,
    "access": {
        "view": {
            "users": [
                12
            ]
        }
    }
}

curl -X GET "{{base_url}}/external/v1/folders" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "folders": [
        {
            "folder_id": 7,
            "name": "Dispatch",
            "smarttable_ids": [
                61,
                62
            ],
            "shared_with": [
                {
                    "user_id": 12,
                    "name": "Asha Patel"
                }
            ]
        }
    ]
}

curl -X POST "{{base_url}}/external/v1/folders" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"name": "Dispatch"}'

{
    "status": "success",
    "folder": {
        "folder_id": 7,
        "name": "Dispatch",
        "smarttable_ids": [],
        "shared_with": []
    }
}

curl -X PATCH "{{base_url}}/external/v1/folders/7" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"name": "Dispatch (North)"}'

{
    "status": "success",
    "folder": {
        "folder_id": 7,
        "name": "Dispatch (North)",
        "smarttable_ids": [
            61,
            62
        ],
        "shared_with": [
            {
                "user_id": 12,
                "name": "Asha Patel"
            }
        ]
    }
}

curl -X PUT "{{base_url}}/external/v1/folders/7/smarttables" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"smarttable_ids": [61, 62]}'

{
    "status": "success",
    "folder": {
        "folder_id": 7,
        "name": "Dispatch",
        "smarttable_ids": [
            61,
            62
        ],
        "shared_with": [
            {
                "user_id": 12,
                "name": "Asha Patel"
            }
        ]
    }
}

curl -X DELETE "{{base_url}}/external/v1/folders/7" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "message": "Deleted",
    "folder_id": 7
}

curl -X POST "{{base_url}}/external/v1/folders/7/share" \
  -H "Authorization: Bearer {{access_token}}" \
  -H "Content-Type: application/json" \
  -d '{"user_ids": [12]}'

{
    "status": "success",
    "folder": {
        "folder_id": 7,
        "name": "Dispatch",
        "smarttable_ids": [
            61,
            62
        ],
        "shared_with": [
            {
                "user_id": 12,
                "name": "Asha Patel"
            }
        ]
    }
}

curl -X DELETE "{{base_url}}/external/v1/folders/7/share/12" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "folder": {
        "folder_id": 7,
        "name": "Dispatch",
        "smarttable_ids": [
            61,
            62
        ],
        "shared_with": []
    }
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/history" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "history": [
        {
            "event": "ENTRY_VERSION_CREATED",
            "action": "ENTRY_VERSION_CREATED",
            "timestamp": "2026-10-01 13:30:00",
            "performed_by": "Asha Patel",
            "details": {
                "version": 5,
                "approved": 1
            }
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/smarttables/61/settings-log" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_id": 61,
    "changes": [
        {
            "id": 85235,
            "event": "SMART_TABLE_SETTINGS_UPDATED",
            "timestamp": "2026-10-02 11:42:00",
            "user_name": "Asha Patel",
            "details": {
                "autosave_interval": "30",
                "submit_button_label": "Send"
            }
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/smarttables/data/189862/history" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "smarttable_data_id": 189862,
    "history": [
        {
            "event": "SMART_TABLE_DATA_SAVED",
            "timestamp": "2026-10-12 15:11:07",
            "performed_by": "Acme Logistics (integration)",
            "details": []
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/users?search=asha&active=1" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "users": [
        {
            "user_id": 12,
            "name": "Asha Patel",
            "username": "asha.patel",
            "email": "asha.patel@example.com",
            "role": "User",
            "active": true,
            "mfa_enabled": false,
            "attributes": [
                {
                    "attribute_id": 5,
                    "name": "Department",
                    "value": "Logistics"
                }
            ],
            "created_at": "2026-03-02T05:10:00Z",
            "updated_at": "2026-09-28T11:02:43Z"
        }
    ],
    "page": 1,
    "page_size": 100,
    "total_count": 1,
    "total_pages": 1
}

curl -X GET "{{base_url}}/external/v1/users/12" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "user": {
        "user_id": 12,
        "name": "Asha Patel",
        "username": "asha.patel",
        "email": "asha.patel@example.com",
        "role": "User",
        "active": true,
        "mfa_enabled": false,
        "attributes": [
            {
                "attribute_id": 5,
                "name": "Department",
                "value": "Logistics"
            }
        ],
        "created_at": "2026-03-02T05:10:00Z",
        "updated_at": "2026-09-28T11:02:43Z"
    }
}

curl -X GET "{{base_url}}/external/v1/users/12/smarttables" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "user_id": 12,
    "smarttables": [
        {
            "smarttable_id": 61,
            "name": "Dispatch Log",
            "role": "admin"
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/roles" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "roles": [
        {
            "role_id": 3,
            "name": "User"
        }
    ]
}

curl -X GET "{{base_url}}/external/v1/user-attributes" \
  -H "Authorization: Bearer {{access_token}}"

{
    "status": "success",
    "attributes": [
        {
            "attribute_id": 5,
            "name": "Department",
            "type": "TEXT_INPUT",
            "default_value": null,
            "is_filter": true
        }
    ]
}