Export Leaf-Level Data (Scoped) (Master and Analytic Models)
  • 12 Minutes to read
  • Dark
    Light
  • PDF

Export Leaf-Level Data (Scoped) (Master and Analytic Models)

  • Dark
    Light
  • PDF

Article summary

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

  1. $ModelName: (type: string) Name of the model

  2. $Dimension: (type: string) Name of the dimension

  3. $Attribute: (type: string) Name of the attribute

  4. $FilterType: (type: string) Dimension filter type, can be FixedMember or MemberAndBelow

  5. $FilterValue: (type: string) Value of the filter

  6. $MemberDisplay (type: string) Optional, can be either Code or Display Label, but defaults to Code

  7. $SupressZerosFlag (type: boolean) Optional, can be either True or False, but defaults to True

  8. $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


Was this article helpful?