The GetTableVersions function returns a list of all versions and associated meta data for a specific table.

GET/Remote/GetTableVersions

REQUEST PARAMETERS

ParameterTypeDescriptionRequired
mluser string Username - always in email form.
mltoken -or- mlpass string MapLarge generated auth token -or- the password for the mluser account.
shortTableId string Short table name: account/tablename

EXAMPLE REQUEST

https://my.maplarge.com/Remote/GetTableVersions?mluser=user@domain.com&mltoken=token&shortTableId=test/testtableA5345

*Either a token or password can be used in any request where authentication is required.

RETURNS

{
    "id": "74fa779691274244a4d5acbdd36215bf",
    "hash": null,
    "success": true,
    "isCached": false,
    "authorized": true,
    "errors": [],
    "timestamp": 1420568725,
    "data": null,
    "versions": [
        {
            "id": "test/testtableA5345/635561654951464560",
            "acctcode": "test",
            "name": "testtableA5345",
            "version": 635561654951464560,
            "description": null,
            "created": "1/6/2015 6:24:55 PM",
            "inram": false,
            "columns": [
                {
                    "id": "test/testtableA5345/635561654951464560/testtableA5345",
                    "type": "Poly"
                },
                {
                    "id": "test/testtableA5345/635561654951464560/CENTROIDLAT",
                    "type": "Double"
                },
                {
                    "id": "test/testtableA5345/635561654951464560/CENTROIDLNG",
                    "type": "Double"
                },
                {
                    "id": "test/testtableA5345/635561654951464560/age",
                    "type": "Int32"
                }
            ]
        }
    ]
}

ACTION SPECIFIC RESPONSE VALUES

ParameterTypeDescription
Tables[].id string Long table name: account/tablename/version
Tables[].acctcode string Account that owns the table version.
Tables[].name string Name of table
Tables[].version long Table version
Tables[].created datetime Date and time when table version was created.
Tables[].inram boolean Designates if table is currently in RAM: true or false
Tables[].columns JSON An array containing all of the columns in the table version. Each column has a column id and column type.
Columns[].id JSON Long column name: account/tablename/version/columnname
Columns[].type string Data type of column.