List SDR contacts with data cross-referencing
Returns paginated list of unique contacts (grouped by session_id) with LEFT JOIN to Person and Sell tables for data enrichment. Includes aggregated metrics: totalContacts, activeContacts, conversionRate, totalMessages.
Returns paginated list of unique contacts (grouped by session_id) with LEFT JOIN to Person and Sell tables for data enrichment. Includes aggregated metrics: totalContacts, activeContacts, conversionRate, totalMessages.
In: header
Query Parameters
Page number
11 <= valueItems per page
201 <= value <= 100Search by partial phone number
Filter by activity status (active: last_interaction < 30 days)
"active" | "inactive" | "all"Filter by registered status (has Person record)
"true" | "false" | "all"Filter by start date (last_interaction >= dateFrom)
Filter by end date (last_interaction <= dateTo)
Filter by qualified status (has sales)
"all""true" | "false" | "all"Column to sort by
Sort order
"asc" | "desc"Filter by converted status (has sales) - deprecated, use qualified
"all""true" | "false" | "all"Response Body
application/json
curl -X GET "https://example.com/sdr/contacts"{
"data": [
[]
],
"total": 50,
"page": 1,
"limit": 20,
"hasMore": true,
"metrics": {
"totalContacts": 150,
"conversionRate": 0.34,
"totalMessages": 2340,
"sdrDisparos": 120,
"sdrConvertidos": 45,
"sdrTaxaConversao": 37.5
}
}List messages for a chat
Returns paginated list of WhatsApp messages from Evolution API for a specific instance and remote JID
Get client info by session ID
Returns client information by session ID with LEFT JOIN to Person and Sell tables. Includes phone extraction, status calculation, and sales aggregation. Returns fallback values when person not found.