Getting Data from Switchboard

Last updated: March 12, 2026

There are several mechanisms available for getting data out of the switchboard system. This article will describe them and help you decide which ones to use to meet your needs.

Feature

Data freshness

Example use-cases

Additional documentation

API

Live

  • Automated loading of new numbers into Switchboard from another system

  • Accessing live data about broadcasts

  • Triggering exports with customized formats

API documentation

SQL Mirror

Up to an hour delayed

  • Analysis of messaging performance over time

  • Ad-hoc data analysis

SQL Mirror documentation

Exports

Live at time of export

  • Bulk transferring phone numbers between systems

Export information

Webhooks

Live

  • Application that needs to take automatic action based on individual datapoints

Reach out to support@oneswitchboard.com for more info

API

Switchboard has an API that you can use to retrieve data out of Switchboard, as well as load in new phones and emails into Switchboard. The full documentation is available here. The API is ideal if you need live data or if you have a different technical system that you want to integrate with ours. It is rate limited though, so it's not optimal for bulk data exports. You can set up an API key for your organization at https://oneswitchboard.com/organization/settings?tab=api.

SQL Mirror

Each organization can be set up with a SQL Mirror in BigQuery. The SQL mirror is a set of tables containing organization data. You can read more about the specific data available here, and learn more about how to get onboarded here. The data in the SQL mirror is updated hourly, so it's not useful for applications that need live data, but it is a great mechanism for exporting and examining bulk data.

Exports

Throughout our product, there are several places you can export data as a CSV. This includes things like contacts, messages, opt-outs, invoices, and many more. You can see your previous exports at https://oneswitchboard.com/exports. Exports contain live data from the time of export, but cannot be scheduled directly within the platform. You can use the API to create exports, for example you can export all your email addresses, if you want them created on a schedule. Different export jobs have different API endpoints.

Webhooks

We support outgoing webhooks for certain limited data. Please reach out to support@oneswitchboard.com if you're interested in learning more.