Query automatic cost allocation results by tag

1 min

GET

https://app.amberflo.io/business-unit/focus-allocation/automatic/query

Queries FOCUS cost amounts allocated to business units through automatic allocation rules based on resource tags and metadata. Analyzes current allocation status showing which FOCUS values are assigned and which remain unallocated.

Required parameters:

columns: Minimum set of FOCUS columns to include in allocation analysis

Optional parameters:

tagName: Specific FOCUS tag name to analyze for business unit allocations

Returns allocation analysis with assigned values mapped to business units and unassigned values available for rule configuration. Includes metadata about cost amounts, row counts, and tag value relationships for allocation management.

Query Parameters

tagNamestring
Description
FOCUS tag name to analyze for automatic allocation status. Filters allocation analysis to specific tag key used for business unit cost assignment.
columnsstring[]required
Description
Minimum set of FOCUS column names to include in allocation analysis. Additional columns referenced by automatic rules are automatically included.

Responses

200Successful request

business_unit.details.AutoAllocatedFocusValuesResponse.out
Description
Response showing FOCUS value allocation status for automatic cost assignment. Separates values already assigned to business units from unassigned values requiring attention.
- tagNamestring
  Description
  FOCUS tag name being analyzed for automatic allocation rules. Represents the column key used for cost assignment and business unit mapping.
- columnsstring[]
  Description
  Array of FOCUS column names included in the allocation analysis. Contains minimum requested columns plus any additional columns referenced by automatic rules.
- assignedValuesbusiness_unit.details.AutoAllocatedFocusValuesResponse.AssignedValueMetadata.out[]
  Description
  FOCUS values already assigned to business units through automatic allocation rules. Each entry includes value metadata and business unit assignment details.
  - valuestring[]
    Description
    Array of FOCUS column values representing resource attributes assigned to business unit through automatic allocation rules.
  - rowCountinteger<int64>
    Description
    Number of cost records associated with this assigned value combination. Indicates allocation coverage for business unit tracking.
  - totalBilledCostnumber
    Description
    Total cost amount allocated to business unit for this value combination. Represents financial impact of automatic allocation rules.
  - tagValuestring
    Description
    Specific tag value used for cost assignment to business unit. Corresponds to FOCUS tag used in allocation logic.
- unassignedValuesfocus.query.ColumnValueMetadata.out[]
  Description
  FOCUS values not yet assigned to any business unit. Available for manual assignment or additional automatic rule configuration.
  - valuestring[]
    Description
    Ordered list of column values forming distinct tuple combination for queried FOCUS column names with null values represented as null elements in array
  - rowCountinteger<int64>
    Description
    Total number of records in FOCUS dataset matching this specific column value combination for occurrence frequency analysis
  - totalBilledCostnumber
    Description
    Sum of all billed costs for records matching this column value combination rounded to two decimal places for cost impact analysis

curl

curl --request GET \
     --url 'https://app.amberflo.io/business-unit/focus-allocation/automatic/query?columns=array' \
     --header 'accept: application/json'

javascript

var myHeaders = new Headers();
myHeaders.append("accept", "application/json");
myHeaders.append("content-type", "application/json");

var requestOptions = {
   method: 'GET',
   headers: myHeaders,
   redirect: 'follow'
};

fetch("https://app.amberflo.io/business-unit/focus-allocation/automatic/query?columns=array", requestOptions)
   .then(response => response.text())
   .then(result => console.log(result))
   .catch(error => console.log('error', error));

ruby

require "uri"
require "json"
require "net/http"

url = URI("https://app.amberflo.io/business-unit/focus-allocation/automatic/query?columns=array")

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

request = Net::HTTP::Get.new(url)
request["accept"] = "application/json"
request["content-type"] = "application/json"

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

python

import requests
import json

url = "https://app.amberflo.io/business-unit/focus-allocation/automatic/query?columns=array"

payload = {}
headers = {
   'accept': 'application/json',
   'content-type': 'application/json'
}

response = requests.request("GET", url, headers=headers, data=payload)

print(response.text)

200

// Successful request
{
  "tagName": "",
  "columns": [
    ""
  ],
  "assignedValues": [
    {
      "value": [
        ""
      ],
      "rowCount": "",
      "totalBilledCost": 0,
      "tagValue": ""
    }
  ],
  "unassignedValues": [
    {
      "value": [
        ""
      ],
      "rowCount": "",
      "totalBilledCost": 0
    }
  ]
}