curl --request GET \
--url https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exportsimport requests
url = "https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports"
response = requests.get(url)
print(response.text)const options = {method: 'GET'};
fetch('https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports"
req, _ := http.NewRequest("GET", url, nil)
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
response = http.request(request)
puts response.read_body{
"data": {
"destinations": [
{
"destination": "bigquery",
"profile_export_capability": "native",
"capability_reason": "BigQuery is the reference reverse-ETL destination — the exporter lands the contacts entity including the materialised traits column, so profile traits propagate as first-class data.",
"configured": true,
"enabled": true,
"traits": [
{
"trait_id": "ctrait_orders30d",
"name": "orders_30d",
"description": "Orders in the last 30 days",
"status": "active",
"syncable": true,
"block_reason": null
}
]
},
{
"destination": "databricks",
"profile_export_capability": "organic",
"capability_reason": "Databricks takes the same contacts + events export but has no dedicated profile pipeline — profile traits are reachable downstream via SQL over the exported data.",
"configured": true,
"enabled": true,
"traits": [
{
"trait_id": "ctrait_orders30d",
"name": "orders_30d",
"description": "Orders in the last 30 days",
"status": "active",
"syncable": false,
"block_reason": "traits_via_exported_data"
}
]
},
{
"destination": "clickhouse",
"profile_export_capability": null,
"capability_reason": null,
"configured": false,
"enabled": false,
"traits": [
{
"trait_id": "ctrait_orders30d",
"name": "orders_30d",
"description": "Orders in the last 30 days",
"status": "active",
"syncable": false,
"block_reason": "destination_not_configured"
}
]
}
],
"summary": {
"configured": 2,
"native": 1,
"syncable_traits": 1
}
},
"meta": {
"request_id": "req_01J8Z9K3P4Q5R6S7T8U9V0W1X2",
"timestamp": "2026-08-27T12:00:00.000Z"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "RATE_LIMITED",
"message": "<string>",
"status": 429,
"retry_after": 2
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}Reverse-ETL profile export destinations
Returns one row per reverse-ETL warehouse destination (BigQuery, Snowflake, Redshift, Postgres, Databricks, ClickHouse), each resolving to a profile-export capability tier — native (profile traits propagate as first-class data for this destination kind), organic (profile data is reachable via SQL over the exported contacts/events data), or null when the destination is not configured — joined against the tenant’s computed-trait catalog so every destination row carries the per-trait propagation verdict (syncable / blocked reason). Pure read projection over organizations.settings.reverse_etl_* + computed_traits; no new storage, no secret material returned. Owner / admin / developer only.
curl --request GET \
--url https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exportsimport requests
url = "https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports"
response = requests.get(url)
print(response.text)const options = {method: 'GET'};
fetch('https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports"
req, _ := http.NewRequest("GET", url, nil)
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.orbit.devotel.io/api/v1/cdp/reverse-etl/profile-exports")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
response = http.request(request)
puts response.read_body{
"data": {
"destinations": [
{
"destination": "bigquery",
"profile_export_capability": "native",
"capability_reason": "BigQuery is the reference reverse-ETL destination — the exporter lands the contacts entity including the materialised traits column, so profile traits propagate as first-class data.",
"configured": true,
"enabled": true,
"traits": [
{
"trait_id": "ctrait_orders30d",
"name": "orders_30d",
"description": "Orders in the last 30 days",
"status": "active",
"syncable": true,
"block_reason": null
}
]
},
{
"destination": "databricks",
"profile_export_capability": "organic",
"capability_reason": "Databricks takes the same contacts + events export but has no dedicated profile pipeline — profile traits are reachable downstream via SQL over the exported data.",
"configured": true,
"enabled": true,
"traits": [
{
"trait_id": "ctrait_orders30d",
"name": "orders_30d",
"description": "Orders in the last 30 days",
"status": "active",
"syncable": false,
"block_reason": "traits_via_exported_data"
}
]
},
{
"destination": "clickhouse",
"profile_export_capability": null,
"capability_reason": null,
"configured": false,
"enabled": false,
"traits": [
{
"trait_id": "ctrait_orders30d",
"name": "orders_30d",
"description": "Orders in the last 30 days",
"status": "active",
"syncable": false,
"block_reason": "destination_not_configured"
}
]
}
],
"summary": {
"configured": 2,
"native": 1,
"syncable_traits": 1
}
},
"meta": {
"request_id": "req_01J8Z9K3P4Q5R6S7T8U9V0W1X2",
"timestamp": "2026-08-27T12:00:00.000Z"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "RATE_LIMITED",
"message": "<string>",
"status": 429,
"retry_after": 2
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}{
"error": {
"code": "<string>",
"message": "<string>",
"status": 123,
"details": {}
},
"meta": {
"request_id": "<string>",
"timestamp": "2023-11-07T05:31:56Z",
"docs_url": "<string>"
}
}Response
The profile-exports view: one destination row per reverse-ETL destination with its capability tier and the per-trait propagation verdict, plus a configured/native/syncable summary.
The profile-exports view: one destination row per reverse-ETL destination with its capability tier and the per-trait propagation verdict, plus a configured/native/syncable summary.