curl --request PUT \
--url https://api.getoneprofile.ai/tables/{table_id}/live-changes/ \
--header 'X-API-Key: <api-key>'import requests
url = "https://api.getoneprofile.ai/tables/{table_id}/live-changes/"
headers = {"X-API-Key": "<api-key>"}
response = requests.put(url, headers=headers)
print(response.text)const options = {method: 'PUT', headers: {'X-API-Key': '<api-key>'}};
fetch('https://api.getoneprofile.ai/tables/{table_id}/live-changes/', 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.getoneprofile.ai/tables/{table_id}/live-changes/",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PUT",
CURLOPT_HTTPHEADER => [
"X-API-Key: <api-key>"
],
]);
$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.getoneprofile.ai/tables/{table_id}/live-changes/"
req, _ := http.NewRequest("PUT", url, nil)
req.Header.Add("X-API-Key", "<api-key>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.put("https://api.getoneprofile.ai/tables/{table_id}/live-changes/")
.header("X-API-Key", "<api-key>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.getoneprofile.ai/tables/{table_id}/live-changes/")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Put.new(url)
request["X-API-Key"] = '<api-key>'
response = http.request(request)
puts response.read_body{
"endpoint": {
"authentication": "signed",
"created_at": "2023-11-07T05:31:56Z",
"delivered_last_24h": 123,
"delivered_total": 123,
"failed_last_24h": 123,
"failed_total": 123,
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"integration_type": "<string>",
"key_hint": "<string>",
"last_delivery_at": "2023-11-07T05:31:56Z",
"last_silence_notice_at": "2023-11-07T05:31:56Z",
"last_test_at": "2023-11-07T05:31:56Z",
"last_unsigned_surge_notice_at": "2023-11-07T05:31:56Z",
"mechanism_key": "<string>",
"old_key_expires_at": "2023-11-07T05:31:56Z",
"rejected_total": 123,
"revoked_at": "2023-11-07T05:31:56Z",
"status": "active",
"table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"subscription": {
"error": "refused",
"error_at": "2023-11-07T05:31:56Z",
"last_checked_at": "2023-11-07T05:31:56Z",
"status": "pending"
}
},
"integration_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"integration_type": "<string>",
"on": true,
"reconnect_needed": true,
"record_type": "<string>",
"source": {
"columns": [
{
"display_name": "<string>",
"name": "<string>",
"type": "string"
}
],
"customer_secrets": [
"signing_secret"
],
"display_name": "<string>",
"integration_type": "<string>",
"mechanism_key": "<string>",
"plan_note": "<string>",
"record_type": "<string>",
"setup_guide_section": "<string>",
"takes_identity_path": true,
"pastes_url": true,
"record_id_field": "id",
"subscribes": false
},
"table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"unavailable": "not_offered",
"url": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}Turn on a table's live changes
Have the app send the table its changes as they happen: a webhook URL whose records land in the table’s imported-record column and merge with the rows a refresh brings, through the table’s own connection. When the app is told about the URL by Oneprofile (source.pastes_url false) nothing else is needed; otherwise the answer shows the URL in full this once, to paste into the app (reveal shows it again). Turning on what is on changes nothing. Only a signed-in person sees a URL; for the AI Assistant it is left out and shown on the table’s Source panel.
curl --request PUT \
--url https://api.getoneprofile.ai/tables/{table_id}/live-changes/ \
--header 'X-API-Key: <api-key>'import requests
url = "https://api.getoneprofile.ai/tables/{table_id}/live-changes/"
headers = {"X-API-Key": "<api-key>"}
response = requests.put(url, headers=headers)
print(response.text)const options = {method: 'PUT', headers: {'X-API-Key': '<api-key>'}};
fetch('https://api.getoneprofile.ai/tables/{table_id}/live-changes/', 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.getoneprofile.ai/tables/{table_id}/live-changes/",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PUT",
CURLOPT_HTTPHEADER => [
"X-API-Key: <api-key>"
],
]);
$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.getoneprofile.ai/tables/{table_id}/live-changes/"
req, _ := http.NewRequest("PUT", url, nil)
req.Header.Add("X-API-Key", "<api-key>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.put("https://api.getoneprofile.ai/tables/{table_id}/live-changes/")
.header("X-API-Key", "<api-key>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.getoneprofile.ai/tables/{table_id}/live-changes/")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Put.new(url)
request["X-API-Key"] = '<api-key>'
response = http.request(request)
puts response.read_body{
"endpoint": {
"authentication": "signed",
"created_at": "2023-11-07T05:31:56Z",
"delivered_last_24h": 123,
"delivered_total": 123,
"failed_last_24h": 123,
"failed_total": 123,
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"integration_type": "<string>",
"key_hint": "<string>",
"last_delivery_at": "2023-11-07T05:31:56Z",
"last_silence_notice_at": "2023-11-07T05:31:56Z",
"last_test_at": "2023-11-07T05:31:56Z",
"last_unsigned_surge_notice_at": "2023-11-07T05:31:56Z",
"mechanism_key": "<string>",
"old_key_expires_at": "2023-11-07T05:31:56Z",
"rejected_total": 123,
"revoked_at": "2023-11-07T05:31:56Z",
"status": "active",
"table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"subscription": {
"error": "refused",
"error_at": "2023-11-07T05:31:56Z",
"last_checked_at": "2023-11-07T05:31:56Z",
"status": "pending"
}
},
"integration_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"integration_type": "<string>",
"on": true,
"reconnect_needed": true,
"record_type": "<string>",
"source": {
"columns": [
{
"display_name": "<string>",
"name": "<string>",
"type": "string"
}
],
"customer_secrets": [
"signing_secret"
],
"display_name": "<string>",
"integration_type": "<string>",
"mechanism_key": "<string>",
"plan_note": "<string>",
"record_type": "<string>",
"setup_guide_section": "<string>",
"takes_identity_path": true,
"pastes_url": true,
"record_id_field": "id",
"subscribes": false
},
"table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"unavailable": "not_offered",
"url": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}{
"detail": "<string>"
}Response
Successful Response
Live changes just turned on, with the URL to paste into the app when it needs one.
Why live changes can't be turned on: not_offered (the app sends no webhook for these records), rows_not_matched_by_id (rows are matched on another field than the app's record ID: change the import's identity_field to the source's record_id_field first). Null when they can be, or are on.
not_offered, rows_not_matched_by_id Was this page helpful?