GetAllTables | MapLarge

Table Versions User can View

The GetAllTables function returns an array of all table versions the user has permission to view. If the user belongs to more than one account, table versions from all accounts will be returned. The optional account parameter can be included to show only table versions for a specific account.

By default, table columns will be returned as a list of column names. Using the optional verbose parameter will return table columns as an array of objects.

GET/Remote/GetAllTables

REQUEST PARAMETERS

Parameter	Type	Description
mluser	string	Username - always in email form.
mltoken -or- mlpass	string	MapLarge generated auth token -or- the password for the mluser account.
account	string	If the parameter is included in the request, response will contain only table versions from this account.
verbose	boolean	Additional response values for table versions: acctcode, name, version. Table columns are returned as an array of objects. If verbose parameter is not included in the request, column names will be returned as a list.

EXAMPLE REQUEST

https://my.maplarge.com/Remote/GetAllTables?mluser=user@domain.com&mltoken=token

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

RETURNS

{
    "id": "0ba7b8b95607497e9c8941c7c63668be",
    "hash": null,
    "success": true,
    "isCached": false,
    "authorized": true,
    "errors": [],
    "timestamp": 1420568652,
    "data": null,
    "tables": [
        {
            "id": "8349/WorldCountries2011/634722587222141505",
            "isactive": true,
            "activeid": "634722587222141505",
            "created": "5/10/2012 2:58:42 PM",
            "publictable": false,
            "visibility": "PublicUnlisted",
            "inram": false,
            "columns": [
                {
                    "id": "test/testtableA5345/635561654609964665/WorldCountries2011",
                    "type": "Poly",
                    "created": "1/6/2015 6:24:21 PM"
                },
                {
                    "id": "test/testtableA5345/635561654609964665/FIPSCNTRY",
                    "type": "String",
                    "created": "1/6/2015 6:24:21 PM"
                },
                {
                    "id": "test/testtableA5345/635561654609964665/CNTRYNAME",
                    "type": "String",
                    "created": "1/6/2015 6:24:21 PM"
                }
            ]
        },
        {
            "id": "census/Counties/634540217037984323",
            "isactive": true,
            "activeid": "634540217037984323",
            "created": "10/12/2011 1:08:23 PM",
            "publictable": true,
            "visibility": "Public",
            "inram": false,
            "columns": [
                {
                    "id": "test/testtableA5345/635561654609964665/AREA",
                    "type": "Double",
                    "created": "1/6/2015 6:24:21 PM"
                },
                {
                    "id": "test/testtableA5345/635561654609964665/CO99D00",
                    "type": "Int32",
                    "created": "1/6/2015 6:24:21 PM"
                },
                {
                    "id": "test/testtableA5345/635561654609964665/Counties",
                    "type": "Poly",
                    "created": "1/6/2015 6:24:21 PM"
                },
                {
                    "id": "test/testtableA5345/635561654609964665/COUNTY",
                    "type": "Int32",
                    "created": "1/6/2015 6:24:21 PM"
                },
                {
                    "id": "test/testtableA5345/635561654609964665/LSAD",
                    "type": "Int32",
                    "created": "1/6/2015 6:24:21 PM"
                },
                {
                    "id": "test/testtableA5345/635561654609964665/LSADTRANS",
                    "type": "String",
                    "created": "1/6/2015 6:24:21 PM"
                },
                {
                    "id": "test/testtableA5345/635561654609964665/XY",
                    "type": "XY",
                    "created": "1/6/2015 6:24:21 PM"
                }
            ]
        }
    ]
}

ACTION SPECIFIC RESPONSE VALUES

Parameter	Type	Description
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: : 634539686979616719
Tables[].isactive	boolean	Table version is active: true or false.
Tables[].activeid	long	Table version: 634539686979616719
Tables[].created	datetime	Date and time when table version was created.
Tables[].visiblity	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[].names	string	Column name
Columns[].id	string	Long table name and column name: account/tablename/version/columnname
Columns[].type	string	Data type of column.
Columns[].rowcount	string	Number of rows in the table version.

Table Versions User can View

MAPPING PLATFORM FOR BIG DATA VISUALIZATION, ANALYTICS & PUBLISHING