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
}
]
}