- 12 Minutes to read
- Print
- DarkLight
- PDF
Export Leaf-Level Data (Scoped) (Master and Analytic Models)
- 12 Minutes to read
- Print
- DarkLight
- PDF
Export Leaf-Level Data (Scoped) (Master and Analytic Models)
This API allows you to export the leaf level data from a specified model in XMLand JSON format. Additionally, you can specify one or more filters to export specific data, and you can use attributes as filters.
POST /modeling/model/data/export HTTP/1.1
Content-Type: application/json or application/xml
Accept: application/json or application/xml
X-ACCESS-TOKEN: $ACCESS_TOKEN_GUID$
Request Payload Examples
Request Payload JSON- - example with Attribute and Operation Type
{
"model": "$ModelName",
"filters": [
{
"dimension": "$Dimension"/”$Attribute”,,
"filterType": "$FilterType",
"filterValues": [
"$value1",
"$value2"
]
}
],
"memberDisplay": "$MemberDisplay",
"suppressZeroes": "$SupressZerosFlag"
“operationType”: “operationType”
}
Request Payload JSON - example with Attribute
{
"model": "$ModelName",
"filters": [
{
"dimension": "$Dimension"/"$Attribute",
"filterType": "$FilterType",
"filterValues": [
"$value1",
"$value2"
]
}
],
"memberDisplay": "$MemberDisplay",
"suppressZeroes": "$SupressZerosFlag"
}
Request Payload XML - example with Attribute and Operation Type
<?xml version="1.0" encoding="UTF-8"?>
<payload>
<model>$ModelNamel</model>
<filters>
<filter>
<dimension>$Dimension/$Attribute</dimension>
<filter-type>$FilterType</filter-type>
<filter-value>$value1</filter-value>
<filter-value>$value2</filter-value>
</filter>
</filters>
<member-display>$MemberDisplay</member-display>
<suppress-zeroes>$SupressZerosFlag</suppress-zeroes>
<operation-type>AND</operation-type>
</payload>
Request Payload XML - Attribute Example
<?xml version="1.0" encoding="UTF-8"?>
<payload>
<model>$ModelNamel</model>
<filters>
<filter>
<dimension>$Dimension/$Attribute</dimension>
<filter-type>$FilterType</filter-type>
<filter-value>$value1</filter-value>
<filter-value>$value2</filter-value>
</filter>
</filters>
<member-display>$MemberDisplay</member-display>
<suppress-zeroes>$SupressZerosFlag</suppress-zeroes>
</payload>
Parameters
$ModelName: (type: string) Name of the model
$Dimension: (type: string) Name of the dimension
$Attribute: (type: string) Name of the attribute
$FilterType: (type: string) Dimension filter type, can be FixedMember or MemberAndBelow
$FilterValue: (type: string) Value of the filter
$MemberDisplay (type: string) Optional, can be either Code or Display Label, but defaults to Code
$SupressZerosFlag (type: boolean) Optional, can be either True or False, but defaults to True
$OperationType: (type: string) Operation Type, can be OR or AND, but default is OR - applicable among attribute filter values.
Payload Samples
Payload Sample JSON - example with Operation Type and Region Attribute
{
"model": "Financial Data",
"filters": [
{
"dimension": "Account",
"filterType": "MemberAndBelow",
"filterValues": [
"Expense"
]
},
{
"dimension": "BusinessCenter",
"filterType": "FixedMember",
"filterValues": [
"000"
]
},
{
"dimension": "Company",
"filterType": "FixedMember",
"filterValues": [
"2020 Host Spain",
"2020 HOST CND"
]
},
{
"dimension": "CostCenter",
"filterType": "FixedMember",
"filterValues": [
"1000"
]
},
{
"dimension": "Department",
"filterType": "FixedMember",
"filterValues": [
"Sales"
]
},
{
"dimension": "Geography",
"filterType": "FixedMember",
"filterValues": [
"000-0000"
]
},
{
"dimension": "Region_Attribute",
"filterType": "FixedMember",
"filterValues": [
"North America"
]
},
{
"dimension": "Region_Attribute",
"filterType": "FixedMember",
"filterValues": [
"South America"
]
}
],
"memberDisplay": "DisplayLabel",
"suppressZeroes": true,
“operationType”: “AND”
}
Response JSON - example with Operation Type and Region Attribute
[
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Dec-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "32.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jun-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "23.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Nov-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "31.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Oct-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "45.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "May-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "22.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Feb-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "35.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Aug-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "26.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jan-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "33.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jul-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "24.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Feb-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "18.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jul-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "41.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jun-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "40.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Sep-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "44.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Apr-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "20.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Aug-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "43.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Mar-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "19.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Oct-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "28.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Apr-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "37.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Mar-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "36.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Sep-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "27.0"
}
]
Payload Sample JSON - With Region Attribute
{
"model": "Financial Data",
"filters": [
{
"dimension": "Account",
"filterType": "MemberAndBelow",
"filterValues": [
"Expense"
]
},
{
"dimension": "BusinessCenter",
"filterType": "FixedMember",
"filterValues": [
"000"
]
},
{
"dimension": "Company",
"filterType": "FixedMember",
"filterValues": [
"2020 Host Spain",
"2020 HOST CND"
]
},
{
"dimension": "CostCenter",
"filterType": "FixedMember",
"filterValues": [
"1000"
]
},
{
"dimension": "Department",
"filterType": "FixedMember",
"filterValues": [
"Sales"
]
},
{
"dimension": "Geography",
"filterType": "FixedMember",
"filterValues": [
"000-0000"
]
},
{
"dimension": "Region_Attribute",
"filterType": "FixedMember",
"filterValues": [
"North America"
]
}
],
"memberDisplay": "DisplayLabel",
"suppressZeroes": true
}
Payload Sample XML - example with Attribute and Operation Type
[
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Dec-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "32.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jun-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "23.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Nov-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "31.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Oct-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "45.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "May-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "22.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Feb-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "35.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Aug-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "26.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jan-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "33.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jul-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "24.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Feb-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "18.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jul-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "41.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Jun-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "40.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Sep-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "44.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Apr-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "20.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Aug-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "43.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Mar-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "19.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Oct-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "28.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Apr-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "37.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Mar-16",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "36.0"
},
{
"BusinessCenter": "000",
"Company": "2020 Host Spain",
"CostCenter": "1000",
"ICSegment": "Default",
"ProductLine": "00",
"Reporting": "G/L Data (LC)",
"Time": "Sep-15",
"Account": "28 Expense",
"Department": "Sales",
"Geography": "000-0000 - Balance Sheet",
"Scenario": "Budget 2013",
"Amount": "27.0"
}
]
Payload Sample XML - With Attribute
<?xml version="1.0" encoding="UTF-8"?>
<payload>
<model>Financial Data</model>
<filters>
<filter>
<dimension>Account</dimension>
<filter-type>MemberAndBelow</filter-type>
<filter-value>Expense</filter-value>
</filter>
<filter>
<dimension>BusinessCenter</dimension>
<filter-type>FixedMember</filter-type>
<filter-value>000</filter-value>
</filter>
<filter>
<dimension>Company</dimension>
<filter-type>FixedMember</filter-type>
<filter-value>2020 Host Spain</filter-value>
<filter-value>2020 HOST CND</filter-value>
</filter>
<filter>
<dimension>CostCenter</dimension>
<filter-type>FixedMember</filter-type>
<filter-value>1000</filter-value>
</filter>
<filter>
<dimension>Department</dimension>
<filter-type>FixedMember</filter-type>
<filter-value>Sales</filter-value>
</filter>
<filter>
<dimension>Geography</dimension>
<filter-type>FixedMember</filter-type>
<filter-value>000-0000</filter-value>
</filter>
<filter>
<dimension>Region_Attribute</dimension>
<filter-type>FixedMember</filter-type>
<filter-value>North America</filter-value>
</filter>
</filters>
<member-display>DisplayLabel</member-display>
<suppress-zeroes>true</suppress-zeroes>
</payload>
XML Sample Response - example with Attribute and Operation Type
<?xml version="1.0" ?>
<records>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Dec-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>32.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Jun-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>23.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Nov-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>31.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Oct-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>45.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>May-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>22.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Feb-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>35.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Aug-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>26.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Jan-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>33.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Jul-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>24.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Feb-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>18.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Jul-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>41.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Jun-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>40.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Sep-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>44.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Apr-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>20.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Aug-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>43.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Mar-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>19.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Oct-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>28.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Apr-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>37.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Mar-16</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>36.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Sep-15</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>27.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Nov-14</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>14.0</Amount>
</record>
<record>
<BusinessCenter>000</BusinessCenter>
<Company>2020 Host Spain</Company>
<CostCenter>1000</CostCenter>
<ICSegment>Default</ICSegment>
<ProductLine>00</ProductLine>
<Reporting>G/L Data (LC)</Reporting>
<Time>Dec-14</Time>
<Account>28 Expense</Account>
<Department>Sales</Department>
<Geography>000-0000 - Balance Sheet</Geography>
<Scenario>Budget 2013</Scenario>
<Amount>15.0</Amount>
</record>
</records>
Success Response
HTTP/1.1 200/204 OK
Error Responses
Service Not Available (possibly due to maintenance)
HTTP/1.1 503 Service Unavailable
One or more HTTP headers were missing
HTTP/1.1 412 Precondition Failed
Unauthorized Access (access key lookup failed)
HTTP/1.1 401 Unauthorized
Invalid JSON/XML (bad request)
HTTP/1.1 400 Bad Request
Not Found (source model not found)
HTTP/1.1 404 Not Found