> ## Documentation Index > Fetch the complete documentation index at: https://docs.orbit.devotel.io/llms.txt > Use this file to discover all available pages before exploring further. # Get the BigQuery reverse-ETL config > Return the tenant's BigQuery reverse-ETL configuration — the destination project / dataset / table-prefix, which datasets are mirrored (contacts and cdp_events plus the opt-in messages, conversations, usage_events and call_logs deltas), the sync cadence, and the last run's status and per-table row counts. The stored service-account JSON is never returned in plaintext; `service_account_configured` reports only whether one is set. Owner / admin only. ## OpenAPI ````yaml /openapi.yaml get /api/v1/cdp/reverse-etl openapi: 3.1.0 info: title: Devotel CPaaS API description: Orbit by Devotel — Communications Platform as a Service API version: 1.0.0 contact: name: Devotel url: https://devotel.io email: support@devotel.io license: name: Proprietary servers: - url: https://api.orbit.devotel.io description: Production security: - Bearer: [] - ApiKey: [] tags: - name: Messages description: >- Send and manage messages across all channels (SMS, WhatsApp, RCS, Email, Viber, etc.) - name: Fax description: >- List and track fax (MMS/T.38) transmissions on Telnyx-backed fax numbers (sending flows through the Messaging API) - name: Agents description: AI agent creation, configuration, and execution - name: Voice description: Voice calls, IVR, conferencing, and SIP trunking - name: OnCall description: On-call rotations and escalation policy planning for incident alerting - name: Webhooks description: Webhook endpoint management and delivery logs - name: Numbers description: Phone number search, provisioning, and configuration - name: Brand Identity description: >- Unified cross-channel brand trust posture (10DLC, toll-free, WhatsApp, RCS, branded calling, number KYC) - name: Contacts description: Contact management, segmentation, and lifecycle tracking - name: Campaigns description: Marketing campaign orchestration and analytics - name: Flows description: Automation flow builder and execution engine - name: Templates description: Message template management and approval workflows - name: Settings description: Organization, channel, and user preference settings - name: Verify description: OTP generation and verification across channels - name: Push description: Push notification delivery via FCM and APNs - name: Integrations description: Third-party service connections and OAuth management - name: CDP description: >- Customer Data Platform — activation surface (CRM object sync, streaming destinations, ad-audience activation) - name: Files description: >- Server-to-server media upload, listing, retrieval, and deletion (signed-URL backed) - name: Commerce description: >- Omnichannel conversational-commerce — persistent cart + checkout state machine, channel-agnostic hosted pay-by-link, native WhatsApp checkout, and AP2-style agent payment mandates. - name: Sync description: >- Real-time shared-state primitive (Twilio Sync parity) — Documents, Maps, Lists, and ephemeral Streams, with change events relayed over the /api/v1/ws/sync WebSocket gateway - name: Risk description: >- Unified cross-channel Trust & Fraud risk scoring — fuses SMS-pumping, URL-reputation, Verify Fraud Guard, and Voice Biometrics signals into one composite verdict queryable before a send or a call. - name: Orby description: >- In-dashboard Orby operator assistant: streamed assistant turns, conversation threads, product knowledge-base search, and the tool-action approval gate. Available to signed-in operators only (dashboard session auth — API-key requests are rejected). paths: /api/v1/cdp/reverse-etl: get: tags: - CDP summary: Get the BigQuery reverse-ETL config description: >- Return the tenant's BigQuery reverse-ETL configuration — the destination project / dataset / table-prefix, which datasets are mirrored (contacts and cdp_events plus the opt-in messages, conversations, usage_events and call_logs deltas), the sync cadence, and the last run's status and per-table row counts. The stored service-account JSON is never returned in plaintext; `service_account_configured` reports only whether one is set. Owner / admin only. responses: '200': description: The tenant's current BigQuery reverse-ETL configuration. content: application/json: schema: type: object properties: data: $ref: '#/components/schemas/CdpReverseEtlConfig' meta: $ref: '#/components/schemas/ResponseMeta' components: schemas: CdpReverseEtlConfig: type: object description: >- Tenant BigQuery reverse-ETL configuration. The stored service-account JSON is never returned in plaintext — `service_account_configured` reports whether one is set. properties: enabled: type: boolean description: Whether the nightly reverse-ETL sync is active for this tenant. export_messages: type: boolean description: >- Opt-in — also mirror the `messages` delta to the destination dataset. export_conversations: type: boolean description: >- Opt-in — also mirror the `conversations` delta to the destination dataset. export_usage_events: type: boolean description: Opt-in — also mirror the rated-usage `usage_events` delta. export_call_logs: type: boolean description: Opt-in — also mirror the voice CDR `call_logs` delta. sync_interval_minutes: type: - 'null' - integer description: >- Configured sync cadence in minutes; null when on the default 23h nightly cadence. project_id: type: - 'null' - string description: Destination BigQuery project id. dataset_id: type: - 'null' - string description: Destination BigQuery dataset id. table_prefix: type: - 'null' - string description: Prefix applied to every destination table name. service_account_configured: type: boolean description: >- True when an encrypted service-account JSON is currently stored. The plaintext is never returned. field_mappings: type: - 'null' - object additionalProperties: true description: >- Per-table column exclusion / rename / computed map; null when every column is exported. last_run_at: type: - 'null' - string format: date-time description: >- ISO 8601 timestamp of the most recent sync run; null before the first run. last_run_status: type: - 'null' - string enum: - ok - failed - null description: Outcome of the most recent sync run. last_run_rows_contacts: type: - 'null' - integer description: Rows written to the contacts table on the last run. last_run_rows_events: type: - 'null' - integer description: Rows written to the cdp_events table on the last run. last_run_rows_messages: type: - 'null' - integer description: Rows written to the messages table on the last run. last_run_rows_conversations: type: - 'null' - integer description: Rows written to the conversations table on the last run. last_run_rows_usage_events: type: - 'null' - integer description: Rows written to the usage_events table on the last run. last_run_rows_call_logs: type: - 'null' - integer description: Rows written to the call_logs table on the last run. last_error: type: - 'null' - string description: >- Error message from the most recent failed run; null when the last run succeeded. last_error_at: type: - 'null' - string format: date-time description: ISO 8601 timestamp of the most recent failure. consecutive_failures: type: - 'null' - integer description: Count of consecutive failed runs; resets to 0 on a successful run. ResponseMeta: type: object required: - request_id - timestamp additionalProperties: false properties: request_id: type: string description: Unique request identifier (also returned as X-Request-Id header) timestamp: type: string format: date-time docs_url: type: string format: uri nullable: true securitySchemes: Bearer: type: http scheme: bearer bearerFormat: JWT description: Dashboard JWT token from Clerk ApiKey: type: apiKey name: X-API-Key in: header description: Server-to-server API key (dv_live_sk_*) ````