API: Export Data Values

Exporting data values using the Clear Impact Scorecard API.

Export Data Values

Parameters

  • id [int](Required) The unique Clear Impact Scorecard ID for the measure that data values are being retrieved for. You can find this ID by running an export on the list pages or on the edit view of an individual measure.
  • measureType [string](Required) Used to determine if the id is for an Indicator or a Performance Measure. May be "i" for Indicator or "p" for Performance Measure.

URL

https://api.resultsscorecard.com/api/datavalues/export

XML Input

<?xml version="1.0"?>
<Parameters>
<apiKey>eEIzvy0kCu017+D1VjjjI1f52Vmbm+VF2FvO</apiKey>
<siteCode>abc</siteCode>
<ID>555</ID>
<measureType>p</measureType>
</Parameters>

XML Output

<?xml version="1.0" encoding="UTF-8"?>
<DataValues xmlns:i="http://www.w3.org/2001/XMLSchema-instance" i:type="PMDataValues">
<values>
<DataValue>
<actualValue>97.000000</actualValue>
<endDate>2015-03-31T00:00:00</endDate>
<forecastValue i:nil="true" />
<startDate>2015-01-01T00:00:00</startDate>
<targetValue>85.000000</targetValue>
<timePeriod>Q1 2015</timePeriod>
</DataValue>
</values>
<perfmeasureID>555</perfmeasureID>
</DataValues>

JSON Input

{ 
"siteCode": "abc",
"apiKey": "eEIzvy0kCu017+D1VjjjI1f52Vmbm+VF2FvO",
"measureType": "p",
"ID": 555
}

JSON Output

{
"perfmeasureID": 555,
"values": [
{
"timePeriod": "Q1 2015",
"startDate": "2015-01-01T00:00:00",
"endDate": "2015-03-31T00:00:00",
"actualValue": 97,
"targetValue": 85,
"forecastValue": null
}
]
}