Hierarchical Value Service API  future
api index

SingleScopeBatchRecord Object

since: 0.40
This object contains one or more column values for a single entry within a table. The entry does not specify its own dimension key and can only be used in a batch of records in a SingleScopeBatch.

Fields

start
0.40required
string
The start date and time that this record becomes effective.

The value must be a valid ISO 8601 string consisting of a fully specified date and an optional time component. If the time component is given, it must include values for hours, minutes, and seconds. A missing time component will be interpreted as midnight (00:00:00) on the given date. Time zones, sub-second precision, and durations in the ISO standard fields are not supported.

When omitted, the value defaults to the local date and time on the server receiving the request at the time the request is processed.

example value

2014-01-01T10:05:43
end
0.40required
string
The end date and time of this record. After this date and time, this value becomes invalid.

The value must be a valid ISO 8601 string consisting of a fully specified date and an optional time component. If the time component is given, it must include values for hours, minutes, and seconds. A missing time component will be interpreted as midnight (00:00:00) on the given date. Time zones, sub-second precision, and durations in the ISO standard fields are not supported.

When omitted, the value defaults to null, meaning the method lasts infinitely.

example value

2014-05-31T12:00:00
values
0.40required
array of Column
A list of typed data for defined columns in this table. The list is required when data is loaded into the table. If all columns are optional, an empty list must be provided; otherwise, the response will have http status 400 and an error message indicating that the values tag is missing. The order of the elements in the list is not significant. All required columns must exist in the list.
0.40 min length: 0
scale
0.40optional
ScaleStructure
An optional ScaleStructure describing the scale information used to scale values for the record. If the structure is not provided or the scale information is empty, the values will not be scaled during evaluation if scaling is requested by a formula.

Related API Objects

Example - Example Record

  {
    "start": "2014-04-14T10:05:43",
    "end": "2015-05-10T20:14:21",
    "values": [{
        "name": "Price",
        "value": "20",
        "type": "DECIMAL",
        "unit": "Each",
        "currency": "USD",
        "perQuantity" : 1
    }]
  }

Example - Example record with scale structure

  {
    "start": "2014-04-14T10:05:43",
    "end": "2015-05-10T20:14:21",
    "values": [{
        "name": "Price",
        "value": "20",
        "type": "DECIMAL",
        "unit": "Each",
        "currency": "USD",
        "perQuantity" : 1
    }],
    "scale": {
      "type": "QUANTITY",
      "offsetType": "NUMERIC",
      "calcType": "CUMULATIVE",
      "offsetCurrency": "USD",
      "scale":[
        { "threshold": 0, "offset": 0 },
        { "threshold": 10, "offset": -10 },
        { "threshold": 20, "offset": -20 }
      ]
    }
  }