C# · Track 7 · Tutorial 5 of 5
Read the consolidation entries, exchange rates and KPIs
Read what's behind the group's figures: the entries consolidation posted, the exchange rates it used, and the KPIs your group tracks.
1What the consolidation posted
Behind the group's figures are the entries consolidation makes: currency translation (cta), minority interests (nci), journal vouchers, adjustments, and intercompany. Each can be read for a month, and each answers for the group your company belongs to.
2Read one
Create ConsolidationEntries.cs. It reads one dataset and prints what came back:
ConsolidationEntries.cs
// ConsolidationEntries.cs - reads what the consolidation posted for September, one dataset at a time.
// dotnet run -- ConsolidationEntries cta
using System.Text.Json;
public static class ConsolidationEntries
{
public static async Task Run(string[] args)
{
var dataset = args.Length > 0 ? args[0] : "cta"; // cta, nci, journal-vouchers, adjustments or intercompany
var answer = await Brizo.Call("GET", $"/organisations/{Brizo.CompanyId}/consolidation/{dataset}?period=2026-09");
if (answer.Status != 200)
{
Console.WriteLine($"Refused ({answer.Status}): {answer.Body?["message"]}");
return;
}
Console.WriteLine($"{dataset} for {answer.Body!["group"]!["name"]}:");
Console.WriteLine(answer.Body.ToJsonString(new JsonSerializerOptions { WriteIndented = true }));
}
}dotnet run -- ConsolidationEntries ctaCheck
The dataset's name and your group, then the entries for September. What each holds depends on your group: a group with no foreign subsidiaries has no translation to show.
3Read exchange rates and KPIs
Create RatesKpis.cs. It reads September's closing USD to SGD rate, lists the KPIs your group defines, and reads the first:
RatesKpis.cs
// RatesKpis.cs - reads September's USD to SGD rate and one KPI.
public static class RatesKpis
{
public static async Task Run(string[] args)
{
var rate = await Brizo.Call("GET", $"/organisations/{Brizo.CompanyId}/exchange-rates?from=USD&to=SGD&period=2026-09&rate_type=closing");
if (rate.Status == 200)
{
Console.WriteLine($"1 USD = {rate.Body!["rate"]} SGD ({rate.Body["rate_type"]}, {rate.Body["period"]})");
}
else
{
Console.WriteLine($"No rate: {rate.Body?["message"]}");
}
var kpis = (await Brizo.Call("GET", "/kpis")).Body!["data"]!.AsArray();
Console.WriteLine($"KPIs the group defines: {string.Join(", ", kpis.Select(kpi => kpi!["name"]))}");
if (kpis.Count > 0)
{
var first = kpis[0]!["name"]!.ToString();
var value = (await Brizo.Call("GET", $"/organisations/{Brizo.CompanyId}/kpi-values?metric={Uri.EscapeDataString(first)}&period=2026-09")).Body!;
Console.WriteLine($"{first}, {value["period"]}: {value["this_month"]} this month, {value["this_month_ytd"]} year to date");
}
}
}4Run it
dotnet run -- RatesKpisCheck
The rate, with its type and month - or the reason there isn't one, if the group holds no rate for that pair and month. Then your group's KPI names, and the first one's figure for September.
5Good to know
rate_typeisaverage(the default) orclosing.- A KPI is read by the name
/kpisgives it. A name the group doesn't define answers404. - Each of these needs its own box on the credential: Consolidation (read), Exchange rates (read), KPIs (read).
Want more detail? See the documentation