One level of the work order explorer: the groups below where the reader has got to, with each group's work order counts.

curl --request POST \
  --url https://app.assetinfinity.ai/api/rpc/work_order_drilldown \
  --header 'Content-Type: application/json' \
  --data '
{
  "p_by": "<string>",
  "p_filter": "<string>",
  "p_from": "<string>",
  "p_to": "<string>"
}
'

import requests

url = "https://app.assetinfinity.ai/api/rpc/work_order_drilldown"

payload = {
    "p_by": "<string>",
    "p_filter": "<string>",
    "p_from": "<string>",
    "p_to": "<string>"
}
headers = {"Content-Type": "application/json"}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {'Content-Type': 'application/json'},
  body: JSON.stringify({p_by: '<string>', p_filter: '<string>', p_from: '<string>', p_to: '<string>'})
};

fetch('https://app.assetinfinity.ai/api/rpc/work_order_drilldown', 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://app.assetinfinity.ai/api/rpc/work_order_drilldown",
  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([
    'p_by' => '<string>',
    'p_filter' => '<string>',
    'p_from' => '<string>',
    'p_to' => '<string>'
  ]),
  CURLOPT_HTTPHEADER => [
    "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://app.assetinfinity.ai/api/rpc/work_order_drilldown"

	payload := strings.NewReader("{\n  \"p_by\": \"<string>\",\n  \"p_filter\": \"<string>\",\n  \"p_from\": \"<string>\",\n  \"p_to\": \"<string>\"\n}")

	req, _ := http.NewRequest("POST", url, payload)

	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://app.assetinfinity.ai/api/rpc/work_order_drilldown")
  .header("Content-Type", "application/json")
  .body("{\n  \"p_by\": \"<string>\",\n  \"p_filter\": \"<string>\",\n  \"p_from\": \"<string>\",\n  \"p_to\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://app.assetinfinity.ai/api/rpc/work_order_drilldown")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n  \"p_by\": \"<string>\",\n  \"p_filter\": \"<string>\",\n  \"p_from\": \"<string>\",\n  \"p_to\": \"<string>\"\n}"

response = http.request(request)
puts response.read_body

Reports

One level of the work order explorer: the groups below where the reader has got to, with each group's work order counts.

One level of the work order explorer: the groups below where the reader has got to, with each group’s work order counts.

p_by is the view the explorer opened in. SITE goes from sites to the locations inside each, a level at a time; TEAM from teams to each team’s lead assignees; PRIORITY from priorities to sites; TYPE from work order types to the types under them. p_filter is the path walked so far, in the keys api.work_order_drilldown_rows takes, and decides the level; a path that has reached the work orders themselves returns no rows. Each row’s filter is that path with the row’s own key added, to pass back for the next level or to list its work orders, and can_drill is false where the next level is the work orders. A location or type with work recorded against itself as well as below it has its own row, with is_self true. A group with no value (no team, no location) has a null group_id. SLA met and breached are the resolution clock; response met and breached are the response clock. by_priority is the count per priority in rank order. Counts are of the work orders the caller can already see.

POST

rpc

work_order_drilldown

One level of the work order explorer: the groups below where the reader has got to, with each group's work order counts.

curl --request POST \
  --url https://app.assetinfinity.ai/api/rpc/work_order_drilldown \
  --header 'Content-Type: application/json' \
  --data '
{
  "p_by": "<string>",
  "p_filter": "<string>",
  "p_from": "<string>",
  "p_to": "<string>"
}
'

import requests

url = "https://app.assetinfinity.ai/api/rpc/work_order_drilldown"

payload = {
    "p_by": "<string>",
    "p_filter": "<string>",
    "p_from": "<string>",
    "p_to": "<string>"
}
headers = {"Content-Type": "application/json"}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {'Content-Type': 'application/json'},
  body: JSON.stringify({p_by: '<string>', p_filter: '<string>', p_from: '<string>', p_to: '<string>'})
};

fetch('https://app.assetinfinity.ai/api/rpc/work_order_drilldown', 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://app.assetinfinity.ai/api/rpc/work_order_drilldown",
  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([
    'p_by' => '<string>',
    'p_filter' => '<string>',
    'p_from' => '<string>',
    'p_to' => '<string>'
  ]),
  CURLOPT_HTTPHEADER => [
    "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://app.assetinfinity.ai/api/rpc/work_order_drilldown"

	payload := strings.NewReader("{\n  \"p_by\": \"<string>\",\n  \"p_filter\": \"<string>\",\n  \"p_from\": \"<string>\",\n  \"p_to\": \"<string>\"\n}")

	req, _ := http.NewRequest("POST", url, payload)

	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://app.assetinfinity.ai/api/rpc/work_order_drilldown")
  .header("Content-Type", "application/json")
  .body("{\n  \"p_by\": \"<string>\",\n  \"p_filter\": \"<string>\",\n  \"p_from\": \"<string>\",\n  \"p_to\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://app.assetinfinity.ai/api/rpc/work_order_drilldown")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n  \"p_by\": \"<string>\",\n  \"p_filter\": \"<string>\",\n  \"p_from\": \"<string>\",\n  \"p_to\": \"<string>\"\n}"

response = http.request(request)
puts response.read_body

Headers

Prefer

enum<string>

Preference

Available options:

params=single-object

Body

One level of the work order explorer: the groups below where the reader has got to, with each group's work order counts.

p_by is the view the explorer opened in. SITE goes from sites to the locations inside each, a level at a time; TEAM from teams to each team's lead assignees; PRIORITY from priorities to sites; TYPE from work order types to the types under them. p_filter is the path walked so far, in the keys api.work_order_drilldown_rows takes, and decides the level; a path that has reached the work orders themselves returns no rows. Each row's filter is that path with the row's own key added, to pass back for the next level or to list its work orders, and can_drill is false where the next level is the work orders. A location or type with work recorded against itself as well as below it has its own row, with is_self true. A group with no value (no team, no location) has a null group_id. SLA met and breached are the resolution clock; response met and breached are the response clock. by_priority is the count per priority in rank order. Counts are of the work orders the caller can already see.

p_by

string<text>

required

p_filter

string<jsonb>

p_from

string<timestamp with time zone>

p_to

string<timestamp with time zone>

Response

200