curl --request POST \
--url https://api.statisfy.com/v1/integrations/pendo/queries \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"name": "<string>",
"query": "<string>",
"account_resolver": {
"column": "<string>",
"abbreviations": {},
"custom_field_key": "<string>",
"cutoff": 123,
"exclude_keywords": [
"<string>"
],
"field_to_parse": "<string>",
"value_transform": {
"regex_extract": "<string>",
"skip_if_contains": "<string>",
"skip_if_equals": "<string>",
"split_first_token": "<string>",
"strip_prefix": "<string>"
}
},
"custom_field_mappings": [
{
"key": "<string>",
"source_column": "<string>"
}
],
"custom_object_config": {
"external_id_column": "<string>",
"field_mappings": [
{
"field_label": "<string>",
"key": "<string>",
"source_column": "<string>"
}
],
"key": "<string>",
"name": "<string>"
},
"entity_type": "account",
"expected_version": 1,
"is_active": true,
"person_resolver": {
"email_column": "<string>",
"alias_domains": [
"<string>"
],
"create_missing_people": true,
"first_name_column": "<string>",
"last_name_column": "<string>",
"name_column": "<string>",
"tenant_domain": "<string>"
},
"product_usage_mappings": [
{
"metric_name": "<string>",
"source_column": "<string>",
"value_type": "int"
}
],
"transformers": [
{
"source_column": "<string>",
"steps": [
{
"mapping": {},
"delimiter": "<string>",
"keep_unmapped": true,
"type": "lookup"
}
],
"target_column": "<string>"
}
]
}
'import requests
url = "https://api.statisfy.com/v1/integrations/pendo/queries"
payload = {
"name": "<string>",
"query": "<string>",
"account_resolver": {
"column": "<string>",
"abbreviations": {},
"custom_field_key": "<string>",
"cutoff": 123,
"exclude_keywords": ["<string>"],
"field_to_parse": "<string>",
"value_transform": {
"regex_extract": "<string>",
"skip_if_contains": "<string>",
"skip_if_equals": "<string>",
"split_first_token": "<string>",
"strip_prefix": "<string>"
}
},
"custom_field_mappings": [
{
"key": "<string>",
"source_column": "<string>"
}
],
"custom_object_config": {
"external_id_column": "<string>",
"field_mappings": [
{
"field_label": "<string>",
"key": "<string>",
"source_column": "<string>"
}
],
"key": "<string>",
"name": "<string>"
},
"entity_type": "account",
"expected_version": 1,
"is_active": True,
"person_resolver": {
"email_column": "<string>",
"alias_domains": ["<string>"],
"create_missing_people": True,
"first_name_column": "<string>",
"last_name_column": "<string>",
"name_column": "<string>",
"tenant_domain": "<string>"
},
"product_usage_mappings": [
{
"metric_name": "<string>",
"source_column": "<string>",
"value_type": "int"
}
],
"transformers": [
{
"source_column": "<string>",
"steps": [
{
"mapping": {},
"delimiter": "<string>",
"keep_unmapped": True,
"type": "lookup"
}
],
"target_column": "<string>"
}
]
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
name: '<string>',
query: '<string>',
account_resolver: {
column: '<string>',
abbreviations: {},
custom_field_key: '<string>',
cutoff: 123,
exclude_keywords: ['<string>'],
field_to_parse: '<string>',
value_transform: {
regex_extract: '<string>',
skip_if_contains: '<string>',
skip_if_equals: '<string>',
split_first_token: '<string>',
strip_prefix: '<string>'
}
},
custom_field_mappings: [{key: '<string>', source_column: '<string>'}],
custom_object_config: {
external_id_column: '<string>',
field_mappings: [{field_label: '<string>', key: '<string>', source_column: '<string>'}],
key: '<string>',
name: '<string>'
},
entity_type: 'account',
expected_version: 1,
is_active: true,
person_resolver: {
email_column: '<string>',
alias_domains: ['<string>'],
create_missing_people: true,
first_name_column: '<string>',
last_name_column: '<string>',
name_column: '<string>',
tenant_domain: '<string>'
},
product_usage_mappings: [{metric_name: '<string>', source_column: '<string>', value_type: 'int'}],
transformers: [
{
source_column: '<string>',
steps: [{mapping: {}, delimiter: '<string>', keep_unmapped: true, type: 'lookup'}],
target_column: '<string>'
}
]
})
};
fetch('https://api.statisfy.com/v1/integrations/pendo/queries', 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.statisfy.com/v1/integrations/pendo/queries",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'name' => '<string>',
'query' => '<string>',
'account_resolver' => [
'column' => '<string>',
'abbreviations' => [
],
'custom_field_key' => '<string>',
'cutoff' => 123,
'exclude_keywords' => [
'<string>'
],
'field_to_parse' => '<string>',
'value_transform' => [
'regex_extract' => '<string>',
'skip_if_contains' => '<string>',
'skip_if_equals' => '<string>',
'split_first_token' => '<string>',
'strip_prefix' => '<string>'
]
],
'custom_field_mappings' => [
[
'key' => '<string>',
'source_column' => '<string>'
]
],
'custom_object_config' => [
'external_id_column' => '<string>',
'field_mappings' => [
[
'field_label' => '<string>',
'key' => '<string>',
'source_column' => '<string>'
]
],
'key' => '<string>',
'name' => '<string>'
],
'entity_type' => 'account',
'expected_version' => 1,
'is_active' => true,
'person_resolver' => [
'email_column' => '<string>',
'alias_domains' => [
'<string>'
],
'create_missing_people' => true,
'first_name_column' => '<string>',
'last_name_column' => '<string>',
'name_column' => '<string>',
'tenant_domain' => '<string>'
],
'product_usage_mappings' => [
[
'metric_name' => '<string>',
'source_column' => '<string>',
'value_type' => 'int'
]
],
'transformers' => [
[
'source_column' => '<string>',
'steps' => [
[
'mapping' => [
],
'delimiter' => '<string>',
'keep_unmapped' => true,
'type' => 'lookup'
]
],
'target_column' => '<string>'
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.statisfy.com/v1/integrations/pendo/queries"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"query\": \"<string>\",\n \"account_resolver\": {\n \"column\": \"<string>\",\n \"abbreviations\": {},\n \"custom_field_key\": \"<string>\",\n \"cutoff\": 123,\n \"exclude_keywords\": [\n \"<string>\"\n ],\n \"field_to_parse\": \"<string>\",\n \"value_transform\": {\n \"regex_extract\": \"<string>\",\n \"skip_if_contains\": \"<string>\",\n \"skip_if_equals\": \"<string>\",\n \"split_first_token\": \"<string>\",\n \"strip_prefix\": \"<string>\"\n }\n },\n \"custom_field_mappings\": [\n {\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"custom_object_config\": {\n \"external_id_column\": \"<string>\",\n \"field_mappings\": [\n {\n \"field_label\": \"<string>\",\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"key\": \"<string>\",\n \"name\": \"<string>\"\n },\n \"entity_type\": \"account\",\n \"expected_version\": 1,\n \"is_active\": true,\n \"person_resolver\": {\n \"email_column\": \"<string>\",\n \"alias_domains\": [\n \"<string>\"\n ],\n \"create_missing_people\": true,\n \"first_name_column\": \"<string>\",\n \"last_name_column\": \"<string>\",\n \"name_column\": \"<string>\",\n \"tenant_domain\": \"<string>\"\n },\n \"product_usage_mappings\": [\n {\n \"metric_name\": \"<string>\",\n \"source_column\": \"<string>\",\n \"value_type\": \"int\"\n }\n ],\n \"transformers\": [\n {\n \"source_column\": \"<string>\",\n \"steps\": [\n {\n \"mapping\": {},\n \"delimiter\": \"<string>\",\n \"keep_unmapped\": true,\n \"type\": \"lookup\"\n }\n ],\n \"target_column\": \"<string>\"\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.statisfy.com/v1/integrations/pendo/queries")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"query\": \"<string>\",\n \"account_resolver\": {\n \"column\": \"<string>\",\n \"abbreviations\": {},\n \"custom_field_key\": \"<string>\",\n \"cutoff\": 123,\n \"exclude_keywords\": [\n \"<string>\"\n ],\n \"field_to_parse\": \"<string>\",\n \"value_transform\": {\n \"regex_extract\": \"<string>\",\n \"skip_if_contains\": \"<string>\",\n \"skip_if_equals\": \"<string>\",\n \"split_first_token\": \"<string>\",\n \"strip_prefix\": \"<string>\"\n }\n },\n \"custom_field_mappings\": [\n {\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"custom_object_config\": {\n \"external_id_column\": \"<string>\",\n \"field_mappings\": [\n {\n \"field_label\": \"<string>\",\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"key\": \"<string>\",\n \"name\": \"<string>\"\n },\n \"entity_type\": \"account\",\n \"expected_version\": 1,\n \"is_active\": true,\n \"person_resolver\": {\n \"email_column\": \"<string>\",\n \"alias_domains\": [\n \"<string>\"\n ],\n \"create_missing_people\": true,\n \"first_name_column\": \"<string>\",\n \"last_name_column\": \"<string>\",\n \"name_column\": \"<string>\",\n \"tenant_domain\": \"<string>\"\n },\n \"product_usage_mappings\": [\n {\n \"metric_name\": \"<string>\",\n \"source_column\": \"<string>\",\n \"value_type\": \"int\"\n }\n ],\n \"transformers\": [\n {\n \"source_column\": \"<string>\",\n \"steps\": [\n {\n \"mapping\": {},\n \"delimiter\": \"<string>\",\n \"keep_unmapped\": true,\n \"type\": \"lookup\"\n }\n ],\n \"target_column\": \"<string>\"\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.statisfy.com/v1/integrations/pendo/queries")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"query\": \"<string>\",\n \"account_resolver\": {\n \"column\": \"<string>\",\n \"abbreviations\": {},\n \"custom_field_key\": \"<string>\",\n \"cutoff\": 123,\n \"exclude_keywords\": [\n \"<string>\"\n ],\n \"field_to_parse\": \"<string>\",\n \"value_transform\": {\n \"regex_extract\": \"<string>\",\n \"skip_if_contains\": \"<string>\",\n \"skip_if_equals\": \"<string>\",\n \"split_first_token\": \"<string>\",\n \"strip_prefix\": \"<string>\"\n }\n },\n \"custom_field_mappings\": [\n {\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"custom_object_config\": {\n \"external_id_column\": \"<string>\",\n \"field_mappings\": [\n {\n \"field_label\": \"<string>\",\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"key\": \"<string>\",\n \"name\": \"<string>\"\n },\n \"entity_type\": \"account\",\n \"expected_version\": 1,\n \"is_active\": true,\n \"person_resolver\": {\n \"email_column\": \"<string>\",\n \"alias_domains\": [\n \"<string>\"\n ],\n \"create_missing_people\": true,\n \"first_name_column\": \"<string>\",\n \"last_name_column\": \"<string>\",\n \"name_column\": \"<string>\",\n \"tenant_domain\": \"<string>\"\n },\n \"product_usage_mappings\": [\n {\n \"metric_name\": \"<string>\",\n \"source_column\": \"<string>\",\n \"value_type\": \"int\"\n }\n ],\n \"transformers\": [\n {\n \"source_column\": \"<string>\",\n \"steps\": [\n {\n \"mapping\": {},\n \"delimiter\": \"<string>\",\n \"keep_unmapped\": true,\n \"type\": \"lookup\"\n }\n ],\n \"target_column\": \"<string>\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"account_resolver": {},
"custom_field_mappings": [
{}
],
"custom_object_config": {},
"entity_type": "account",
"id": "<string>",
"is_active": true,
"name": "<string>",
"period": "HOURLY",
"person_resolver": {},
"product_usage_mappings": [
{}
],
"query": "<string>",
"query_type": "custom_field",
"transformers": [
{}
],
"version": 123
}Save a new Pendo query
Adds a query to the Pendo config (201). query is the Pendo aggregation JSON as text: check it first with POST /v1/integrations/pendo/query/validate. Every mapped field or metric must already exist: create them with /v1/fields and /v1/products first. A people query takes its internal domains from the workspace’s own when you leave them out. Saving locks each mapped field: the integration writes it, so it is read-only in the app. A save runs the app’s Pendo checks first, and a refusal is a 422 with the app’s text: a query that is not valid Pendo aggregation JSON, a query that uses while no account ID field is set, group_by_columns, order_by_columns or limit (they do not apply to Pendo), a survey ID with a character other than a letter, digit, - or _, a custom field match that is not a text custom field of accounts. A 409 means the config changed since you read it (or expected_version is not the live one): read it again.
curl --request POST \
--url https://api.statisfy.com/v1/integrations/pendo/queries \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"name": "<string>",
"query": "<string>",
"account_resolver": {
"column": "<string>",
"abbreviations": {},
"custom_field_key": "<string>",
"cutoff": 123,
"exclude_keywords": [
"<string>"
],
"field_to_parse": "<string>",
"value_transform": {
"regex_extract": "<string>",
"skip_if_contains": "<string>",
"skip_if_equals": "<string>",
"split_first_token": "<string>",
"strip_prefix": "<string>"
}
},
"custom_field_mappings": [
{
"key": "<string>",
"source_column": "<string>"
}
],
"custom_object_config": {
"external_id_column": "<string>",
"field_mappings": [
{
"field_label": "<string>",
"key": "<string>",
"source_column": "<string>"
}
],
"key": "<string>",
"name": "<string>"
},
"entity_type": "account",
"expected_version": 1,
"is_active": true,
"person_resolver": {
"email_column": "<string>",
"alias_domains": [
"<string>"
],
"create_missing_people": true,
"first_name_column": "<string>",
"last_name_column": "<string>",
"name_column": "<string>",
"tenant_domain": "<string>"
},
"product_usage_mappings": [
{
"metric_name": "<string>",
"source_column": "<string>",
"value_type": "int"
}
],
"transformers": [
{
"source_column": "<string>",
"steps": [
{
"mapping": {},
"delimiter": "<string>",
"keep_unmapped": true,
"type": "lookup"
}
],
"target_column": "<string>"
}
]
}
'import requests
url = "https://api.statisfy.com/v1/integrations/pendo/queries"
payload = {
"name": "<string>",
"query": "<string>",
"account_resolver": {
"column": "<string>",
"abbreviations": {},
"custom_field_key": "<string>",
"cutoff": 123,
"exclude_keywords": ["<string>"],
"field_to_parse": "<string>",
"value_transform": {
"regex_extract": "<string>",
"skip_if_contains": "<string>",
"skip_if_equals": "<string>",
"split_first_token": "<string>",
"strip_prefix": "<string>"
}
},
"custom_field_mappings": [
{
"key": "<string>",
"source_column": "<string>"
}
],
"custom_object_config": {
"external_id_column": "<string>",
"field_mappings": [
{
"field_label": "<string>",
"key": "<string>",
"source_column": "<string>"
}
],
"key": "<string>",
"name": "<string>"
},
"entity_type": "account",
"expected_version": 1,
"is_active": True,
"person_resolver": {
"email_column": "<string>",
"alias_domains": ["<string>"],
"create_missing_people": True,
"first_name_column": "<string>",
"last_name_column": "<string>",
"name_column": "<string>",
"tenant_domain": "<string>"
},
"product_usage_mappings": [
{
"metric_name": "<string>",
"source_column": "<string>",
"value_type": "int"
}
],
"transformers": [
{
"source_column": "<string>",
"steps": [
{
"mapping": {},
"delimiter": "<string>",
"keep_unmapped": True,
"type": "lookup"
}
],
"target_column": "<string>"
}
]
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
name: '<string>',
query: '<string>',
account_resolver: {
column: '<string>',
abbreviations: {},
custom_field_key: '<string>',
cutoff: 123,
exclude_keywords: ['<string>'],
field_to_parse: '<string>',
value_transform: {
regex_extract: '<string>',
skip_if_contains: '<string>',
skip_if_equals: '<string>',
split_first_token: '<string>',
strip_prefix: '<string>'
}
},
custom_field_mappings: [{key: '<string>', source_column: '<string>'}],
custom_object_config: {
external_id_column: '<string>',
field_mappings: [{field_label: '<string>', key: '<string>', source_column: '<string>'}],
key: '<string>',
name: '<string>'
},
entity_type: 'account',
expected_version: 1,
is_active: true,
person_resolver: {
email_column: '<string>',
alias_domains: ['<string>'],
create_missing_people: true,
first_name_column: '<string>',
last_name_column: '<string>',
name_column: '<string>',
tenant_domain: '<string>'
},
product_usage_mappings: [{metric_name: '<string>', source_column: '<string>', value_type: 'int'}],
transformers: [
{
source_column: '<string>',
steps: [{mapping: {}, delimiter: '<string>', keep_unmapped: true, type: 'lookup'}],
target_column: '<string>'
}
]
})
};
fetch('https://api.statisfy.com/v1/integrations/pendo/queries', 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.statisfy.com/v1/integrations/pendo/queries",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'name' => '<string>',
'query' => '<string>',
'account_resolver' => [
'column' => '<string>',
'abbreviations' => [
],
'custom_field_key' => '<string>',
'cutoff' => 123,
'exclude_keywords' => [
'<string>'
],
'field_to_parse' => '<string>',
'value_transform' => [
'regex_extract' => '<string>',
'skip_if_contains' => '<string>',
'skip_if_equals' => '<string>',
'split_first_token' => '<string>',
'strip_prefix' => '<string>'
]
],
'custom_field_mappings' => [
[
'key' => '<string>',
'source_column' => '<string>'
]
],
'custom_object_config' => [
'external_id_column' => '<string>',
'field_mappings' => [
[
'field_label' => '<string>',
'key' => '<string>',
'source_column' => '<string>'
]
],
'key' => '<string>',
'name' => '<string>'
],
'entity_type' => 'account',
'expected_version' => 1,
'is_active' => true,
'person_resolver' => [
'email_column' => '<string>',
'alias_domains' => [
'<string>'
],
'create_missing_people' => true,
'first_name_column' => '<string>',
'last_name_column' => '<string>',
'name_column' => '<string>',
'tenant_domain' => '<string>'
],
'product_usage_mappings' => [
[
'metric_name' => '<string>',
'source_column' => '<string>',
'value_type' => 'int'
]
],
'transformers' => [
[
'source_column' => '<string>',
'steps' => [
[
'mapping' => [
],
'delimiter' => '<string>',
'keep_unmapped' => true,
'type' => 'lookup'
]
],
'target_column' => '<string>'
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.statisfy.com/v1/integrations/pendo/queries"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"query\": \"<string>\",\n \"account_resolver\": {\n \"column\": \"<string>\",\n \"abbreviations\": {},\n \"custom_field_key\": \"<string>\",\n \"cutoff\": 123,\n \"exclude_keywords\": [\n \"<string>\"\n ],\n \"field_to_parse\": \"<string>\",\n \"value_transform\": {\n \"regex_extract\": \"<string>\",\n \"skip_if_contains\": \"<string>\",\n \"skip_if_equals\": \"<string>\",\n \"split_first_token\": \"<string>\",\n \"strip_prefix\": \"<string>\"\n }\n },\n \"custom_field_mappings\": [\n {\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"custom_object_config\": {\n \"external_id_column\": \"<string>\",\n \"field_mappings\": [\n {\n \"field_label\": \"<string>\",\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"key\": \"<string>\",\n \"name\": \"<string>\"\n },\n \"entity_type\": \"account\",\n \"expected_version\": 1,\n \"is_active\": true,\n \"person_resolver\": {\n \"email_column\": \"<string>\",\n \"alias_domains\": [\n \"<string>\"\n ],\n \"create_missing_people\": true,\n \"first_name_column\": \"<string>\",\n \"last_name_column\": \"<string>\",\n \"name_column\": \"<string>\",\n \"tenant_domain\": \"<string>\"\n },\n \"product_usage_mappings\": [\n {\n \"metric_name\": \"<string>\",\n \"source_column\": \"<string>\",\n \"value_type\": \"int\"\n }\n ],\n \"transformers\": [\n {\n \"source_column\": \"<string>\",\n \"steps\": [\n {\n \"mapping\": {},\n \"delimiter\": \"<string>\",\n \"keep_unmapped\": true,\n \"type\": \"lookup\"\n }\n ],\n \"target_column\": \"<string>\"\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.statisfy.com/v1/integrations/pendo/queries")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"query\": \"<string>\",\n \"account_resolver\": {\n \"column\": \"<string>\",\n \"abbreviations\": {},\n \"custom_field_key\": \"<string>\",\n \"cutoff\": 123,\n \"exclude_keywords\": [\n \"<string>\"\n ],\n \"field_to_parse\": \"<string>\",\n \"value_transform\": {\n \"regex_extract\": \"<string>\",\n \"skip_if_contains\": \"<string>\",\n \"skip_if_equals\": \"<string>\",\n \"split_first_token\": \"<string>\",\n \"strip_prefix\": \"<string>\"\n }\n },\n \"custom_field_mappings\": [\n {\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"custom_object_config\": {\n \"external_id_column\": \"<string>\",\n \"field_mappings\": [\n {\n \"field_label\": \"<string>\",\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"key\": \"<string>\",\n \"name\": \"<string>\"\n },\n \"entity_type\": \"account\",\n \"expected_version\": 1,\n \"is_active\": true,\n \"person_resolver\": {\n \"email_column\": \"<string>\",\n \"alias_domains\": [\n \"<string>\"\n ],\n \"create_missing_people\": true,\n \"first_name_column\": \"<string>\",\n \"last_name_column\": \"<string>\",\n \"name_column\": \"<string>\",\n \"tenant_domain\": \"<string>\"\n },\n \"product_usage_mappings\": [\n {\n \"metric_name\": \"<string>\",\n \"source_column\": \"<string>\",\n \"value_type\": \"int\"\n }\n ],\n \"transformers\": [\n {\n \"source_column\": \"<string>\",\n \"steps\": [\n {\n \"mapping\": {},\n \"delimiter\": \"<string>\",\n \"keep_unmapped\": true,\n \"type\": \"lookup\"\n }\n ],\n \"target_column\": \"<string>\"\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.statisfy.com/v1/integrations/pendo/queries")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"query\": \"<string>\",\n \"account_resolver\": {\n \"column\": \"<string>\",\n \"abbreviations\": {},\n \"custom_field_key\": \"<string>\",\n \"cutoff\": 123,\n \"exclude_keywords\": [\n \"<string>\"\n ],\n \"field_to_parse\": \"<string>\",\n \"value_transform\": {\n \"regex_extract\": \"<string>\",\n \"skip_if_contains\": \"<string>\",\n \"skip_if_equals\": \"<string>\",\n \"split_first_token\": \"<string>\",\n \"strip_prefix\": \"<string>\"\n }\n },\n \"custom_field_mappings\": [\n {\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"custom_object_config\": {\n \"external_id_column\": \"<string>\",\n \"field_mappings\": [\n {\n \"field_label\": \"<string>\",\n \"key\": \"<string>\",\n \"source_column\": \"<string>\"\n }\n ],\n \"key\": \"<string>\",\n \"name\": \"<string>\"\n },\n \"entity_type\": \"account\",\n \"expected_version\": 1,\n \"is_active\": true,\n \"person_resolver\": {\n \"email_column\": \"<string>\",\n \"alias_domains\": [\n \"<string>\"\n ],\n \"create_missing_people\": true,\n \"first_name_column\": \"<string>\",\n \"last_name_column\": \"<string>\",\n \"name_column\": \"<string>\",\n \"tenant_domain\": \"<string>\"\n },\n \"product_usage_mappings\": [\n {\n \"metric_name\": \"<string>\",\n \"source_column\": \"<string>\",\n \"value_type\": \"int\"\n }\n ],\n \"transformers\": [\n {\n \"source_column\": \"<string>\",\n \"steps\": [\n {\n \"mapping\": {},\n \"delimiter\": \"<string>\",\n \"keep_unmapped\": true,\n \"type\": \"lookup\"\n }\n ],\n \"target_column\": \"<string>\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"account_resolver": {},
"custom_field_mappings": [
{}
],
"custom_object_config": {},
"entity_type": "account",
"id": "<string>",
"is_active": true,
"name": "<string>",
"period": "HOURLY",
"person_resolver": {},
"product_usage_mappings": [
{}
],
"query": "<string>",
"query_type": "custom_field",
"transformers": [
{}
],
"version": 123
}Authorizations
An API key, sent as Authorization: Bearer stfy_live_…. See Authentication for how to get one and which scopes it needs.
Body
Response
Successful Response
A saved Pendo query as stored. Its resolver, mapping and transformer objects have the same shapes as in a SQL warehouse query.
Was this page helpful?