Variance Analysis APIs

The Variance Analysis APIs enable programmatic export of variance analysis data for a specific plan.

Exports are returned as CSV files and support optional parameters to control formatting, filtering, and output structure, making the data suitable for downstream analysis and visualization tools.

POST /planning/api/v1/plans/<planId>/varianceanalysis/export

Description

Exports variance analysis data for a specific plan. The export is returned as a CSV file based on the parameters supplied.

Request

POST https://app.apptio.com/planning/api/v1/plans/<planId>/varianceanalysis/export>

Note: Ensure the URL matches your region (e.g., app-eu.apptio.com, app-au.apptio.com). Use the plans GET api to get Plan Id of plan to export.

Parameters

Name	Allowed Values	Required	Description
departmentCode	<code> or blank	FALSE	The department code for which variance analysis data should be exported. Default: Leave blank to export data to All Departments.
basePercentage	ONE ONE_HUNDRED	FALSE	Format in which percentage has to be displayed. Default: ONE
characterEncoding	UTF_8 SHIFT_JIS	FALSE	Input file encoding Default: UTF_8
columnDelimiter	COMMA SEMICOLON TAB	FALSE	CSV delimiter Default: COMMA
dateFormat	Supported date formats: yyyy-MM-dd yyyy/MM/dd yyyy.MM.dd yy-MM-dd yy/MM/dd yy.MM.dd yy-M-d yy/M/d yy.M.d MM-dd-yyyy MM/dd/yyyy MM.dd.yyyy MM-dd-yy MM/dd/yy MM.dd.yy M-d-yyyy M/d/yyyy M.d.yyyy M-d-yy M/d/yy M.d.yy dd-MM-yyyy dd/MM/yyyy dd.MM.yyyy dd-MM-yy dd/MM/yy dd.MM.yy d-M-yy d/M/yy d.M.yy d-M-yyyy d/M/yyyy d.M.yyyy	FALSE	Format of date fields in the import file. Default: yyyy-MM-dd
decimalPrecision	ZERO ONE TWO THREE FOUR FIVE SIX SEVEN EIGHT	FALSE	Number of decimals applied to numeric values Default: EIGHT
decimalSymbol	PERIOD COMMA	FALSE	Decimal separator Default: PERIOD

Response

A downloadable CSV file containing the selected plan’s variance analysis details.

Errors

Code	Meaning
400	Bad Request
403	Unauthorized