Historic Data

Historic Data (Data Collection)

Instructs the data logger to publish historic data records within a time range. This command only works with data tables that contain the MQTTPublishTable() CRBasic instruction. The data will be published in the same format as indicated in the table publish instruction. In the case of GeoJSON, the point coordinates used when re-publishing the data will be the latest values passed into the table publish instruction.

Subscribe <baseTopic>/cc/<deviceID>/historicData

Properties

  • "table": (string, Required) The table name to request historic data from.

  • "all": (string-“True”,”False”, optional) If "True", publishes all recorded data from the specified table. When this field is “True”, start and end are ignored and may be omitted.

  • "start": (string, optional) ISO 8601 formatted timestamp for the beginning of the data range (must be before end).

  • "end": (string, optional) ISO 8601 formatted timestamp for the end of the data range (must be after start).

  • "tranID": (optional) : Any

Example Command - All:

Subscribe cs/v2/cc/ABCD-EFGH-1234/historicData

{
    "table": "Deere4020Watch",
    "all": "true",
}

Example Command - Start and End Time:

Subscribe cs/v2/cc/ABCD-EFGH-1234/historicData

{
    "table": "Deere4020Watch",
    "start": "2025-09-29T08:11:00Z",
    "end": "2025-09-29T08:13:00Z"
}

Response Publish cs/v2/cr/ABCD-EFGH-1234/historicData/Deere4020Watch

{
    "type": "Feature",
    "geometry": {
        "type": "Point",
        "coordinates": [
        41.766533,
        -111.854909,
        4457
        ]
    },
    "properties": {
            "loggerID": "7GY3-DZYK-KBWF",
            "publish_ts": "2025-09-29T09:16:12.471Z",
            "observationNames": [
            "engine_rpm",
            "fuel_level",
            "pto_engaged",
            "location"
            ],
            "observations": {
            "2025-09-29T08:11:00Z": [
                1800,
                71.914,
                false,
                "North 40"
            ],
            "2025-09-29T08:12:00Z": [
                1800,
                71.79398,
                false,
                "North 40"
            ],
            "2025-09-29T08:13:00Z": [
                1800,
                71.67395,
                false,
                "North 40"
            ]
        }
    }
}