Update custom column values
curl --request PUT \
--url https://api.standardmetrics.io/v1/custom-columns/values/ \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
[
{
"company_slug": "<string>",
"company_id": "<string>",
"custom_column_id": "<string>",
"value": "<string>",
"selected_options": [
{
"option_id": "<string>",
"value": "<string>",
"color": "<string>"
}
]
}
]
'import requests
url = "https://api.standardmetrics.io/v1/custom-columns/values/"
payload = [
{
"company_slug": "<string>",
"company_id": "<string>",
"custom_column_id": "<string>",
"value": "<string>",
"selected_options": [
{
"option_id": "<string>",
"value": "<string>",
"color": "<string>"
}
]
}
]
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.put(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PUT',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify([
{
company_slug: '<string>',
company_id: '<string>',
custom_column_id: '<string>',
value: '<string>',
selected_options: [{option_id: '<string>', value: '<string>', color: '<string>'}]
}
])
};
fetch('https://api.standardmetrics.io/v1/custom-columns/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.standardmetrics.io/v1/custom-columns/values/",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PUT",
CURLOPT_POSTFIELDS => json_encode([
[
'company_slug' => '<string>',
'company_id' => '<string>',
'custom_column_id' => '<string>',
'value' => '<string>',
'selected_options' => [
[
'option_id' => '<string>',
'value' => '<string>',
'color' => '<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.standardmetrics.io/v1/custom-columns/values/"
payload := strings.NewReader("[\n {\n \"company_slug\": \"<string>\",\n \"company_id\": \"<string>\",\n \"custom_column_id\": \"<string>\",\n \"value\": \"<string>\",\n \"selected_options\": [\n {\n \"option_id\": \"<string>\",\n \"value\": \"<string>\",\n \"color\": \"<string>\"\n }\n ]\n }\n]")
req, _ := http.NewRequest("PUT", 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.put("https://api.standardmetrics.io/v1/custom-columns/values/")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("[\n {\n \"company_slug\": \"<string>\",\n \"company_id\": \"<string>\",\n \"custom_column_id\": \"<string>\",\n \"value\": \"<string>\",\n \"selected_options\": [\n {\n \"option_id\": \"<string>\",\n \"value\": \"<string>\",\n \"color\": \"<string>\"\n }\n ]\n }\n]")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.standardmetrics.io/v1/custom-columns/values/")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "[\n {\n \"company_slug\": \"<string>\",\n \"company_id\": \"<string>\",\n \"custom_column_id\": \"<string>\",\n \"value\": \"<string>\",\n \"selected_options\": [\n {\n \"option_id\": \"<string>\",\n \"value\": \"<string>\",\n \"color\": \"<string>\"\n }\n ]\n }\n]"
response = http.request(request)
puts response.read_body[
{
"company_slug": "<string>",
"company_id": "<string>",
"custom_column_id": "<string>",
"value": "<string>",
"selected_options": [
{
"option_id": "<string>",
"value": "<string>",
"color": "<string>"
}
]
}
]Custom Columns
Update custom column values
Update custom column values for companies. Fully replaces existing data for the specified company and column.
Permissions:
- User must be authenticated via OAuth.
- User must have access to the companies.
- User must have ADMIN or EDITOR role.
PUT
/
custom-columns
/
values
/
Update custom column values
curl --request PUT \
--url https://api.standardmetrics.io/v1/custom-columns/values/ \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
[
{
"company_slug": "<string>",
"company_id": "<string>",
"custom_column_id": "<string>",
"value": "<string>",
"selected_options": [
{
"option_id": "<string>",
"value": "<string>",
"color": "<string>"
}
]
}
]
'import requests
url = "https://api.standardmetrics.io/v1/custom-columns/values/"
payload = [
{
"company_slug": "<string>",
"company_id": "<string>",
"custom_column_id": "<string>",
"value": "<string>",
"selected_options": [
{
"option_id": "<string>",
"value": "<string>",
"color": "<string>"
}
]
}
]
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.put(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PUT',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify([
{
company_slug: '<string>',
company_id: '<string>',
custom_column_id: '<string>',
value: '<string>',
selected_options: [{option_id: '<string>', value: '<string>', color: '<string>'}]
}
])
};
fetch('https://api.standardmetrics.io/v1/custom-columns/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.standardmetrics.io/v1/custom-columns/values/",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PUT",
CURLOPT_POSTFIELDS => json_encode([
[
'company_slug' => '<string>',
'company_id' => '<string>',
'custom_column_id' => '<string>',
'value' => '<string>',
'selected_options' => [
[
'option_id' => '<string>',
'value' => '<string>',
'color' => '<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.standardmetrics.io/v1/custom-columns/values/"
payload := strings.NewReader("[\n {\n \"company_slug\": \"<string>\",\n \"company_id\": \"<string>\",\n \"custom_column_id\": \"<string>\",\n \"value\": \"<string>\",\n \"selected_options\": [\n {\n \"option_id\": \"<string>\",\n \"value\": \"<string>\",\n \"color\": \"<string>\"\n }\n ]\n }\n]")
req, _ := http.NewRequest("PUT", 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.put("https://api.standardmetrics.io/v1/custom-columns/values/")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("[\n {\n \"company_slug\": \"<string>\",\n \"company_id\": \"<string>\",\n \"custom_column_id\": \"<string>\",\n \"value\": \"<string>\",\n \"selected_options\": [\n {\n \"option_id\": \"<string>\",\n \"value\": \"<string>\",\n \"color\": \"<string>\"\n }\n ]\n }\n]")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.standardmetrics.io/v1/custom-columns/values/")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "[\n {\n \"company_slug\": \"<string>\",\n \"company_id\": \"<string>\",\n \"custom_column_id\": \"<string>\",\n \"value\": \"<string>\",\n \"selected_options\": [\n {\n \"option_id\": \"<string>\",\n \"value\": \"<string>\",\n \"color\": \"<string>\"\n }\n ]\n }\n]"
response = http.request(request)
puts response.read_body[
{
"company_slug": "<string>",
"company_id": "<string>",
"custom_column_id": "<string>",
"value": "<string>",
"selected_options": [
{
"option_id": "<string>",
"value": "<string>",
"color": "<string>"
}
]
}
]Authorizations
Your valid bearer token. All Auth tokens persist for all requests. Make sure to replace Client Credential Basic tokens with Bearer tokens after retrieving your bearer token. Go to the API Reference/Setup, User Guides/Initial Setup, or API Reference/Get API Access Token page to get your token.
Body
application/json
⌘I