Use this Odata endpoint to retrieve information from the Anaplan Financial Consolidation server’s client schema table.

Specify the relevant parameters in a GET request to retrieve consolidated financial data such as: balance sheets, profit and loss, cash flow data, and other financial metrics. 

This connection makes it easier to retrieve data and update integrated apps. This helps make operations more efficient and financial information more accurate.

Method and endpoint

GET

/odata/{clienttablename}?{filterparameter}

Parameters

ParameterTypeDescriptionRequired
{clienttablename}StringThe name of the client schema table in your Financial Consolidation tenant.Yes
{filterparameter}FilterSee Query parameters.No

Curl example

curl -L -X GET 'https://fluenceapi-prod.fluence.app/api/v2305.1/odata/Consolidation?$filter=startswith(Date,’2024’)' \

-H 'TENANT: CustomerTenant' \

-H 'X_API_TOKEN: 73ca5973-ce3e-4cc6-b2d4-b09a99770ccf'

Response

[

    {

        "Account_Name": "1110",

        "Audit_Name": "Source GL",

        "CostCenter_Name": "No CostCenter",

        "Currency_Name": "USD",

        "DataView_Name": "Conversion",

        "Date_Name": "2024 Dec",

        "Entity_Name": "220",

        "Intercompany_Name": "No Entity",

        "Movement_Name": "Closing",

        "Product_Name": "No product",

        "Scenario_Name": "Actual",

        "Amount": 75443.48,

        "Text": "",

        "Periodic_Amount": 0.0

    }

]

Note:  More results were returned but were removed for brevity.