JavaScript APIWeb Services APIGeocoder API
  1. Tables
  2. GetTableInformation
Information about a Table Version

The GetTableInformation function returns all metadata and columns for a table version.

GET/Remote/GetTableInformation

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.
longTableId string Long table name: account/tablename/version

EXAMPLE REQUEST

https://my.maplarge.com/Remote/GetTableInformation?mluser=user@domain.com&mltoken=token&longTableId=test/testtableA5345/635561654380250838

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

RETURNS 

{ 
"id": "38aaa4ba2fb44d79b89569aca001af09",
    "hash": null,
    "success": true,
    "isCached": false,
    "authorized": true,
    "errors": [],
    "timestamp": 1420568654,
    "data": null,
    "table": {
        "id": "test/testtableA5345/635561654380250838",
        "acctcode": "test",
        "name": "testtableA5345",
        "version": 635561654380250900,
        "description": null,
        "created": "1/6/2015 6:23:58 PM",
        "visibility": "PublicUnlisted",
        "isactive": true,
        "inram": false,
        "columns": [
            {
                "id": "test/testtableA5345/635561654380250838/testtableA5345",
                "type": "Poly",
                "created": "1/6/2015 6:23:59 PM"
            },
            {
                "id": "test/testtableA5345/635561654380250838/CENTROIDLAT",
                "type": "Double",
                "created": "1/6/2015 6:23:59 PM"
            },
            {
                "id": "test/testtableA5345/635561654380250838/diversityindex",
                "type": "Double",
                "created": "1/6/2015 6:23:59 PM"
            },
            {
                "id": "test/testtableA5345/635561654380250838/statename",
                "type": "String",
                "created": "1/6/2015 6:23:59 PM"
            },
            {
                "id": "test/testtableA5345/635561654380250838/tract",
                "type": "Int32",
                "created": "1/6/2015 6:23:59 PM"
            },
            {
                "id": "test/testtableA5345/635561654380250838/XY",
                "type": "XY",
                "created": "1/6/2015 6:23:59 PM"
            },
            {
                "id": "test/testtableA5345/635561654380250838/year",
                "type": "Int32",
                "created": "1/6/2015 6:23:59 PM"
            }
        ]
    }
}

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[].longTableId string Long table name: account/tablename/version
Tables[].version long Table version: 634539686979616719
Tables[].description string Description of table
Tables[].created datetime Date and time when table version was created.
Tables[].visibility string Visibility of table: Public, PublicUnlisted, or Private.
Tables[].inram boolean Table is currently in RAM: true or false
Tables[].columns JSON An array containing all of the columns in the table version.
Columns[].id string Long table name and column name: account/tablename/version/columnname
Columns[].type string Data type of column.
MAPPING PLATFORM FOR BIG DATA VISUALIZATION, ANALYTICS & PUBLISHING
Request More Info