Data Manager API

POST
Get Tables

This request returns a list of tables that belong to the API Key and ClientID that is making the request. If the includePublic parameter is set to true, all tables that have been marked as publicly available will be returned as well.

Resource URL

http://www.mapquestapi.com/datamanager/v2/get-tables

Resource Information

Response Formats JSON, XML
Authentication Yes (Requires Key)
Rate Limited Yes

Request Parameters

Request Parameter Description Required?
key
String
A unique key to authorize use of the API. Yes
inFormat
String
Specifies the format of the json/xml parameter. Must be one of the following, if supplied:
  • json
  • xml
Default = json
No
outFormat
String
Specifies the format of the response. Must be one of the following, if supplied:
  • json
  • xml
Default = json
No

Body Parameters

Name Description Required?
clientId
String

This is the ClientID associated with the API Key.

Yes
password
String
This is the registry password associated with the API Key. Yes
includePublic
Boolean
This parameter will return names and column information for tables that have been made public.
The default value is false.
No

Example Request

POST

http://www.mapquestapi.com/datamanager/v2/get-tables?key=KEY&inFormat=json&outFormat=json

Example Request Body

{
    "clientId": "CLIENT_ID",
    "password": "REGISTRY_PASSWORD",
    "includePublic": true
}
<datamanager>
    <clientId>CLIENT_ID</clientId>
    <password>REGISTRY_PASSWORD</password>
    <includePublic>true</includePublic>
</datamanager>

Example Response

"tables":[
  {
    "tableName": "...",
    "friendlyName": "...",
    "notes": "...",
    "owner": "...",
    "isPublic": "...",
    "totalRows": "...",
    "columns":[
      {
        "name": "...",
        "type": "...",
        "isPublic": "..."
      }
    ]
  }
]
<tables>
    <table>
        <tableName>...</tableName>
        <friendlyName>...</friendlyName>
        <notes>...</notes>
        <owner>...</owner>
        <isPublic>...</isPublic>
        <totalRows>...</totalRows>
        <columns>
            <column>
                <name>...</name>
                <type>...</type>
                <isPublic>...</isPublic>
            </column>
        </columns>
    </table>
</tables>