Your program asks DotSIP to call a patient. When the patient answers, DotSIP posts the route. Your server finds that patient in your database and returns a recording plus gather. Digit 1 confirms the row. DotSIP does not store the patient.
1. Records in DotSIP
- Open API. Create a key, listen on 127.0.0.1, port 9090, turn it on, and copy the secret before you hide it.
- Under SIP accounts, turn on Outgoing (OUT) for the trunk that places the call. Its transfer URI template must contain {extension}. With no sip_account in the JSON, DotSIP uses the first enabled outgoing account.
- Under SIP phones, user 101. Set its outbound route to a route whose URL is http://127.0.0.1:9099/route. If that route is missing, an outbound originate is not placed.
- Put confirm.wav in data/media. Mono PCM16, 8000, 16000, or 24000 Hz. The words are “Press 1 to confirm the appointment.”
2. Your database
CREATE TABLE patients (
phone TEXT PRIMARY KEY,
name TEXT NOT NULL,
confirmed INTEGER NOT NULL
);
INSERT INTO patients(phone, name, confirmed) VALUES ('+421901234567', 'Eva Kovac', 0);
CREATE TABLE pending (call_id TEXT PRIMARY KEY, phone TEXT NOT NULL);
3. Place the call
This request is from your program to the API-key port, not to port 9080.
POST /v1/calls/originate HTTP/1.1
Host: 127.0.0.1:9090
Authorization: Bearer dsk_the-copied-secret
Content-Type: application/json
{"to":"+421901234567","extension":"101","behavior":"outbound"}
HTTP 201 returns { "ok": true, "call_id": "..." }. After the patient answers, DotSIP POSTs the extension’s outbound route. direction is outbound. caller.number is 101. dialed is to.
4. The route server
It loads the patient by dialed and stores that phone under call_id in pending. The plan plays the file, then waits for 1. The digit is not in the local map, so DotSIP posts dotsip.dtmf to /confirmed and waits. The server loads the phone for that call_id, sets confirmed to 1, and returns hangup. On that digit callback, caller.number is the number that was rung, not the extension. Keep the patient on call_id.
<?php
$db = new PDO("sqlite:" . __DIR__ . "/operator.sqlite");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec("CREATE TABLE IF NOT EXISTS patients (phone TEXT PRIMARY KEY, name TEXT NOT NULL, confirmed INTEGER NOT NULL)");
$db->exec("CREATE TABLE IF NOT EXISTS pending (call_id TEXT PRIMARY KEY, phone TEXT NOT NULL)");
$db->exec("INSERT OR IGNORE INTO patients(phone, name, confirmed) VALUES ('+421901234567', 'Eva Kovac', 0)");
$body = json_decode(file_get_contents("php://input"), true);
header("Content-Type: application/json");
$format = is_array($body) && isset($body["format"]) ? $body["format"] : "";
if ($format === "dotsip.route") {
$dialed = isset($body["dialed"]) ? (string) $body["dialed"] : "";
$name = $db->query("SELECT name FROM patients WHERE phone = " . $db->quote($dialed))->fetchColumn();
if (!$name) {
echo json_encode(array("commands" => array(array("do" => "hangup"))));
return;
}
$save = $db->prepare("INSERT OR REPLACE INTO pending(call_id, phone) VALUES (?, ?)");
$save->execute(array(isset($body["call_id"]) ? $body["call_id"] : "", $dialed));
echo json_encode(array(
"format" => "dotsip.route-result",
"format_version" => 2,
"commands" => array(
array("do" => "play", "media" => "confirm.wav", "barge_in" => false),
array("do" => "gather", "max_digits" => 1, "timeout_ms" => 10000,
"callback_url" => "http://127.0.0.1:9099/confirmed", "wait" => true,
"digits" => array("timeout" => array(array("do" => "hangup")))),
),
));
return;
}
if ($format === "dotsip.dtmf") {
if ((isset($body["digits"]) ? $body["digits"] : "") === "1") {
$call = isset($body["call_id"]) ? $body["call_id"] : "";
$phone = $db->query("SELECT phone FROM pending WHERE call_id = " . $db->quote($call))->fetchColumn();
if ($phone) {
$stmt = $db->prepare("UPDATE patients SET confirmed = 1 WHERE phone = ?");
$stmt->execute(array($phone));
}
}
echo json_encode(array("commands" => array(array("do" => "hangup"))));
return;
}
http_response_code(400);
echo json_encode(array("error" => "bad request"));
import sqlite3
from flask import Flask, request, jsonify
app = Flask(__name__)
con = sqlite3.connect("operator.sqlite", check_same_thread=False)
con.execute("CREATE TABLE IF NOT EXISTS patients (phone TEXT PRIMARY KEY, name TEXT NOT NULL, confirmed INTEGER NOT NULL)")
con.execute("CREATE TABLE IF NOT EXISTS pending (call_id TEXT PRIMARY KEY, phone TEXT NOT NULL)")
con.execute("INSERT OR IGNORE INTO patients(phone, name, confirmed) VALUES ('+421901234567', 'Eva Kovac', 0)")
con.commit()
@app.post("/route")
def route():
body = request.get_json(silent=True) or {}
if body.get("format") != "dotsip.route":
return jsonify({"error": "bad request"}), 400
row = con.execute("SELECT name FROM patients WHERE phone = ?", (str(body.get("dialed") or ""),)).fetchone()
if not row:
return jsonify({"commands": [{"do": "hangup"}]})
con.execute("INSERT OR REPLACE INTO pending(call_id, phone) VALUES (?, ?)", (str(body.get("call_id") or ""), str(body.get("dialed") or "")))
con.commit()
return jsonify({
"format": "dotsip.route-result", "format_version": 2,
"commands": [
{"do": "play", "media": "confirm.wav", "barge_in": False},
{"do": "gather", "max_digits": 1, "timeout_ms": 10000,
"callback_url": "http://127.0.0.1:9099/confirmed", "wait": True,
"digits": {"timeout": [{"do": "hangup"}]}},
],
})
@app.post("/confirmed")
def confirmed():
body = request.get_json(silent=True) or {}
if body.get("format") != "dotsip.dtmf":
return jsonify({"error": "bad request"}), 400
if body.get("digits") == "1":
found = con.execute("SELECT phone FROM pending WHERE call_id = ?", (str(body.get("call_id") or ""),)).fetchone()
if found:
con.execute("UPDATE patients SET confirmed = 1 WHERE phone = ?", (found[0],))
con.commit()
return jsonify({"commands": [{"do": "hangup"}]})
const http = require("http");
const { DatabaseSync } = require("node:sqlite");
const db = new DatabaseSync("operator.sqlite");
db.exec("CREATE TABLE IF NOT EXISTS patients (phone TEXT PRIMARY KEY, name TEXT NOT NULL, confirmed INTEGER NOT NULL)");
db.exec("CREATE TABLE IF NOT EXISTS pending (call_id TEXT PRIMARY KEY, phone TEXT NOT NULL)");
db.exec("INSERT OR IGNORE INTO patients(phone, name, confirmed) VALUES ('+421901234567', 'Eva Kovac', 0)");
const patient = db.prepare("SELECT name FROM patients WHERE phone = ?");
const save = db.prepare("INSERT OR REPLACE INTO pending(call_id, phone) VALUES (?, ?)");
const pending = db.prepare("SELECT phone FROM pending WHERE call_id = ?");
const confirm = db.prepare("UPDATE patients SET confirmed = 1 WHERE phone = ?");
function send(res, code, payload) {
res.writeHead(code, { "Content-Type": "application/json" });
res.end(JSON.stringify(payload));
}
http.createServer((req, res) => {
let raw = "";
req.on("data", (c) => { raw += c; });
req.on("end", () => {
let body = {};
try { body = JSON.parse(raw || "{}"); } catch (e) { body = {}; }
if (req.url === "/route" && body.format === "dotsip.route") {
const dialed = String(body.dialed || "");
if (!patient.get(dialed)) { send(res, 200, { commands: [{ do: "hangup" }] }); return; }
save.run(String(body.call_id || ""), dialed);
send(res, 200, { format: "dotsip.route-result", format_version: 2, commands: [
{ do: "play", media: "confirm.wav", barge_in: false },
{ do: "gather", max_digits: 1, timeout_ms: 10000, callback_url: "http://127.0.0.1:9099/confirmed", wait: true, digits: { timeout: [{ do: "hangup" }] } }
]});
return;
}
if (req.url === "/confirmed" && body.format === "dotsip.dtmf") {
if (body.digits === "1") {
const row = pending.get(String(body.call_id || ""));
if (row) confirm.run(row.phone);
}
send(res, 200, { commands: [{ do: "hangup" }] });
return;
}
send(res, 400, { error: "bad request" });
});
}).listen(9099);
After the patient presses 1, patients.confirmed is 1 for the phone stored in pending for that call_id. DotSIP does not write that column. behavior none with no route does not send the route POST.