Get Column Values
curl --request GET \
--url https://api.revenuebase.ai/v2/contact/columns/{column}/values \
--header 'X-Key: <api-key>'import requests
url = "https://api.revenuebase.ai/v2/contact/columns/{column}/values"
headers = {"X-Key": "<api-key>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {'X-Key': '<api-key>'}};
fetch('https://api.revenuebase.ai/v2/contact/columns/{column}/values', 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.revenuebase.ai/v2/contact/columns/{column}/values",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"X-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.revenuebase.ai/v2/contact/columns/{column}/values"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("X-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.get("https://api.revenuebase.ai/v2/contact/columns/{column}/values")
.header("X-Key", "<api-key>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.revenuebase.ai/v2/contact/columns/{column}/values")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["X-Key"] = '<api-key>'
response = http.request(request)
puts response.read_body{
"column": "COUNTRY_CODE_PER",
"values": [
"AD",
"AE",
"AF",
"AG",
"AI"
],
"truncated": true,
"limit": 5,
"multiselect": true
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>",
"input": "<unknown>",
"ctx": {}
}
]
}Contact Endpoints
Column Values
Get or search the options for one enumerable contact field.
GET
/
columns
/
{column}
/
values
Get Column Values
curl --request GET \
--url https://api.revenuebase.ai/v2/contact/columns/{column}/values \
--header 'X-Key: <api-key>'import requests
url = "https://api.revenuebase.ai/v2/contact/columns/{column}/values"
headers = {"X-Key": "<api-key>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {'X-Key': '<api-key>'}};
fetch('https://api.revenuebase.ai/v2/contact/columns/{column}/values', 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.revenuebase.ai/v2/contact/columns/{column}/values",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"X-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.revenuebase.ai/v2/contact/columns/{column}/values"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("X-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.get("https://api.revenuebase.ai/v2/contact/columns/{column}/values")
.header("X-Key", "<api-key>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.revenuebase.ai/v2/contact/columns/{column}/values")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["X-Key"] = '<api-key>'
response = http.request(request)
puts response.read_body{
"column": "COUNTRY_CODE_PER",
"values": [
"AD",
"AE",
"AF",
"AG",
"AI"
],
"truncated": true,
"limit": 5,
"multiselect": true
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>",
"input": "<unknown>",
"ctx": {}
}
]
}Credits and plans
PAYG is Pay-as-you-go. AYCE is All-you-can-eat.| Usage | PAYG | AYCE |
|---|---|---|
| Vocabulary lookup | Free 0 credits | Free 0 credits |
When to use Column Values
Populate one filter picker or search its bounded vocabulary. Choose a field marked as enumerable in Columns.Example
SetREVENUEBASE_API_KEY to your API key.
curl --request GET 'https://api.revenuebase.ai/v2/contact/columns/COUNTRY_CODE_PER/values?limit=5' \
--header "X-Key: $REVENUEBASE_API_KEY"
{
"column": "COUNTRY_CODE_PER",
"values": [
"AD",
"AE",
"AF",
"AG",
"AI"
],
"truncated": true,
"limit": 5,
"multiselect": true
}
Read the result
| Field or input | Meaning |
|---|---|
column | Canonical name of the requested field. |
values | Returned field values; use them in eq or in conditions. |
truncated | True means more options exist than were returned. |
limit | Applied vocabulary cap. Omit it to use the field’s valueLimit; a requested value is clamped to that cap. |
search | Optional query parameter narrowing the returned options. |
multiselect | Whether the field supports a multiselect picker. |
Errors and limits
An unknown field returns 404. Open-ended fields, such as JOB_TITLE_PER or COMPANY_NAME_ORG, return 422 COLUMN_NOT_ENUMERABLE; filter these fields with contains instead. This endpoint has no page cursor. A truncated list is not the full vocabulary. For all available picker values at once, request Columns with include=values. Contact and company routes share the default 10 requests per second per user. Wait for the reset time or Retry-After when rate limited; coordinate requests across your workers and API keys.Next steps
Use the values in a filter, then Count or View the audience.Authorizations
Path Parameters
An enumerable field name from the column catalog.
Query Parameters
Optional text to narrow the returned vocabulary.
Maximum options to return, clamped to the field’s valueLimit. Omit to use that cap.
Response
Successful Response
The response is of type Response Get Column Values V1 Columns Column Values Get · object.
Was this page helpful?
