Configure Smartsheet webhooks to trigger Field Nation work order creation when rows are added or updated.
Smartsheet webhooks are created via API (no UI). You can use Postman, curl, or custom scripts.
Endpoint:
POST https://api.smartsheet.com/2.0/webhooksHeaders:
Authorization: Bearer {your_access_token}
Content-Type: application/jsonBody:
{
"name": "Field Nation Integration",
"callbackUrl": "https://api.fieldnation.com/integrations/trigger/{YOUR_CLIENT_TOKEN}",
"scope": "sheet",
"scopeObjectId": {sheet_id},
"events": [
"row.added",
"row.updated"
],
"version": 1
}curl -X POST https://api.smartsheet.com/2.0/webhooks \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
-H "Content-Type: application/json" \
-d '{
"name": "Field Nation Integration",
"callbackUrl": "https://api.fieldnation.com/integrations/trigger/YOUR_CLIENT_TOKEN",
"scope": "sheet",
"scopeObjectId": 1234567890123456,
"events": ["row.added", "row.updated"],
"version": 1
}'After creation, enable it:
curl -X PUT https://api.smartsheet.com/2.0/webhooks/{webhook_id} \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
-H "Content-Type: application/json" \
-d '{"enabled": true}'Download Smartsheet Postman collection from Smartsheet API docs
access_token: Your access tokensheet_id: Your sheet IDcallback_url: Field Nation trigger URLUse "Create Webhook" request from collection
Use "Update Webhook" request with enabled: true
curl https://api.smartsheet.com/2.0/webhooks \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN"Look for your webhook with enabled: true and status: ENABLED
Check webhook status via API:
curl https://api.smartsheet.com/2.0/webhooks/{webhook_id} \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN"Verify work order created with correct data
Since Smartsheet webhooks fire on all changes, implement filtering:
Option 1: Add "Status" column
Only process rows where Status = "Ready for Field"Option 2: Add "Send to FN" checkbox
Only process rows where checkbox is checkedConfigure filtering in Field Nation Integration Broker (custom JSONNET).
Add checkbox column: "Synced to FN"
When work order created, Field Nation updates row:
Synced to FN = checkedIntegration Broker filters out rows where "Synced to FN" = checked.
curl https://api.smartsheet.com/2.0/webhooks \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN"curl https://api.smartsheet.com/2.0/webhooks/{webhook_id} \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN"curl -X PUT https://api.smartsheet.com/2.0/webhooks/{webhook_id} \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
-H "Content-Type: application/json" \
-d '{"enabled": false}'curl -X DELETE https://api.smartsheet.com/2.0/webhooks/{webhook_id} \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN"Last updated on