Add a filter to a canvas, on a field from filtera…
curl --request POST \
--url https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters \
--header 'Content-Type: application/json' \
--header 'authorization: <api-key>' \
--data '
{
"field": "<string>",
"apiKey": "<string>",
"organizationId": "<string>",
"connectionId": "<string>",
"displayName": "<string>",
"fieldKeys": [
"<string>"
],
"itemIds": [
"<string>"
],
"selectedValue": "<string>",
"sort_order": 0,
"dataModelVersion": 123
}
'import requests
url = "https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters"
payload = {
"field": "<string>",
"apiKey": "<string>",
"organizationId": "<string>",
"connectionId": "<string>",
"displayName": "<string>",
"fieldKeys": ["<string>"],
"itemIds": ["<string>"],
"selectedValue": "<string>",
"sort_order": 0,
"dataModelVersion": 123
}
headers = {
"authorization": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {authorization: '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
field: '<string>',
apiKey: '<string>',
organizationId: '<string>',
connectionId: '<string>',
displayName: '<string>',
fieldKeys: ['<string>'],
itemIds: ['<string>'],
selectedValue: '<string>',
sort_order: 0,
dataModelVersion: 123
})
};
fetch('https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters', 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.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters",
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([
'field' => '<string>',
'apiKey' => '<string>',
'organizationId' => '<string>',
'connectionId' => '<string>',
'displayName' => '<string>',
'fieldKeys' => [
'<string>'
],
'itemIds' => [
'<string>'
],
'selectedValue' => '<string>',
'sort_order' => 0,
'dataModelVersion' => 123
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"authorization: <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"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters"
payload := strings.NewReader("{\n \"field\": \"<string>\",\n \"apiKey\": \"<string>\",\n \"organizationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"displayName\": \"<string>\",\n \"fieldKeys\": [\n \"<string>\"\n ],\n \"itemIds\": [\n \"<string>\"\n ],\n \"selectedValue\": \"<string>\",\n \"sort_order\": 0,\n \"dataModelVersion\": 123\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("authorization", "<api-key>")
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.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters")
.header("authorization", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"field\": \"<string>\",\n \"apiKey\": \"<string>\",\n \"organizationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"displayName\": \"<string>\",\n \"fieldKeys\": [\n \"<string>\"\n ],\n \"itemIds\": [\n \"<string>\"\n ],\n \"selectedValue\": \"<string>\",\n \"sort_order\": 0,\n \"dataModelVersion\": 123\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"field\": \"<string>\",\n \"apiKey\": \"<string>\",\n \"organizationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"displayName\": \"<string>\",\n \"fieldKeys\": [\n \"<string>\"\n ],\n \"itemIds\": [\n \"<string>\"\n ],\n \"selectedValue\": \"<string>\",\n \"sort_order\": 0,\n \"dataModelVersion\": 123\n}"
response = http.request(request)
puts response.read_body{
"status": "success",
"data": {
"filter": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"canvas_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"filter_config": {
"filterType": "Input",
"filterSubType": "Input Equals",
"filterRestrictions": null,
"displayName": "<string>",
"layout": {
"i": "<string>",
"x": 123,
"y": 123,
"w": 123,
"h": 123,
"minW": 123,
"maxW": 123,
"minH": 123,
"maxH": 123,
"moved": true,
"static": true,
"isDraggable": true,
"isResizable": true,
"resizeHandles": [
"s"
],
"isBounded": true
},
"filterTargets": [
{
"type": "Before logic",
"columns": [
{
"type": "string",
"columnName": "<string>",
"columnMetadata": "<string>",
"columnSummary": {
"values": [
"<unknown>"
],
"isExhaustive": true
}
}
],
"chartId": "<string>",
"targetTable": "<string>",
"targetColumn": "<string>"
}
],
"controlKey": "<string>",
"globalFilterColumns": [
"<string>"
],
"selectedValue": "<string>",
"fieldKey": "<string>",
"fieldRef": {
"kind": "raw",
"table": "<string>",
"column": "<string>",
"columnType": "string"
},
"itemIds": [
"<string>"
],
"fieldKeys": [
"<string>"
],
"tileColumns": {},
"customFilterId": "<string>",
"filtersEveryTable": true
},
"sort_order": 0,
"created_at": "<unknown>",
"updated_at": "<unknown>"
}
}
}{
"status": "error",
"error": {
"message": "<string>",
"code": "<string>",
"details": {}
}
}Canvases
Add Canvas Filter
Add a filter to a canvas, on a field from filterable-fields
POST
/
v2
/
api
/
projects
/
{projectId}
/
workspaces
/
{workspaceId}
/
canvases
/
{canvasId}
/
filters
Add a filter to a canvas, on a field from filtera…
curl --request POST \
--url https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters \
--header 'Content-Type: application/json' \
--header 'authorization: <api-key>' \
--data '
{
"field": "<string>",
"apiKey": "<string>",
"organizationId": "<string>",
"connectionId": "<string>",
"displayName": "<string>",
"fieldKeys": [
"<string>"
],
"itemIds": [
"<string>"
],
"selectedValue": "<string>",
"sort_order": 0,
"dataModelVersion": 123
}
'import requests
url = "https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters"
payload = {
"field": "<string>",
"apiKey": "<string>",
"organizationId": "<string>",
"connectionId": "<string>",
"displayName": "<string>",
"fieldKeys": ["<string>"],
"itemIds": ["<string>"],
"selectedValue": "<string>",
"sort_order": 0,
"dataModelVersion": 123
}
headers = {
"authorization": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {authorization: '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
field: '<string>',
apiKey: '<string>',
organizationId: '<string>',
connectionId: '<string>',
displayName: '<string>',
fieldKeys: ['<string>'],
itemIds: ['<string>'],
selectedValue: '<string>',
sort_order: 0,
dataModelVersion: 123
})
};
fetch('https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters', 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.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters",
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([
'field' => '<string>',
'apiKey' => '<string>',
'organizationId' => '<string>',
'connectionId' => '<string>',
'displayName' => '<string>',
'fieldKeys' => [
'<string>'
],
'itemIds' => [
'<string>'
],
'selectedValue' => '<string>',
'sort_order' => 0,
'dataModelVersion' => 123
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"authorization: <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"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters"
payload := strings.NewReader("{\n \"field\": \"<string>\",\n \"apiKey\": \"<string>\",\n \"organizationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"displayName\": \"<string>\",\n \"fieldKeys\": [\n \"<string>\"\n ],\n \"itemIds\": [\n \"<string>\"\n ],\n \"selectedValue\": \"<string>\",\n \"sort_order\": 0,\n \"dataModelVersion\": 123\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("authorization", "<api-key>")
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.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters")
.header("authorization", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"field\": \"<string>\",\n \"apiKey\": \"<string>\",\n \"organizationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"displayName\": \"<string>\",\n \"fieldKeys\": [\n \"<string>\"\n ],\n \"itemIds\": [\n \"<string>\"\n ],\n \"selectedValue\": \"<string>\",\n \"sort_order\": 0,\n \"dataModelVersion\": 123\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.upsolve.ai/v2/api/projects/{projectId}/workspaces/{workspaceId}/canvases/{canvasId}/filters")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"field\": \"<string>\",\n \"apiKey\": \"<string>\",\n \"organizationId\": \"<string>\",\n \"connectionId\": \"<string>\",\n \"displayName\": \"<string>\",\n \"fieldKeys\": [\n \"<string>\"\n ],\n \"itemIds\": [\n \"<string>\"\n ],\n \"selectedValue\": \"<string>\",\n \"sort_order\": 0,\n \"dataModelVersion\": 123\n}"
response = http.request(request)
puts response.read_body{
"status": "success",
"data": {
"filter": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"canvas_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"filter_config": {
"filterType": "Input",
"filterSubType": "Input Equals",
"filterRestrictions": null,
"displayName": "<string>",
"layout": {
"i": "<string>",
"x": 123,
"y": 123,
"w": 123,
"h": 123,
"minW": 123,
"maxW": 123,
"minH": 123,
"maxH": 123,
"moved": true,
"static": true,
"isDraggable": true,
"isResizable": true,
"resizeHandles": [
"s"
],
"isBounded": true
},
"filterTargets": [
{
"type": "Before logic",
"columns": [
{
"type": "string",
"columnName": "<string>",
"columnMetadata": "<string>",
"columnSummary": {
"values": [
"<unknown>"
],
"isExhaustive": true
}
}
],
"chartId": "<string>",
"targetTable": "<string>",
"targetColumn": "<string>"
}
],
"controlKey": "<string>",
"globalFilterColumns": [
"<string>"
],
"selectedValue": "<string>",
"fieldKey": "<string>",
"fieldRef": {
"kind": "raw",
"table": "<string>",
"column": "<string>",
"columnType": "string"
},
"itemIds": [
"<string>"
],
"fieldKeys": [
"<string>"
],
"tileColumns": {},
"customFilterId": "<string>",
"filtersEveryTable": true
},
"sort_order": 0,
"created_at": "<unknown>",
"updated_at": "<unknown>"
}
}
}{
"status": "error",
"error": {
"message": "<string>",
"code": "<string>",
"details": {}
}
}Path Parameters
Body
application/json
POST /v2/api/projects/:projectId/workspaces/:workspaceId/canvases/:canvasId/filters Request body
filterSubType
Option 1 · enum<string>Option 2 · enum<string>Option 3 · enum<string>Option 4 · enum<string>
required
Operator, from the filterType's own list (e.g. 'Select Multi', 'Number Greater than', 'Date Range'). Null for Toggle.
Available options:
Input Equals, Input Starts with, Input Ends with, Input Contains Tables picked under one column name, each a raw:<table>.<column> key from a field's tableChoices, all of one type: each chart is filtered on every one of these tables it reads, or not at all, and a chart that reads none of them is not filtered (even one showing a column of the name). field must be the first of them.
Minimum array length:
1Was this page helpful?