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.
https://www.mapquestapi.com/datamanager/v2/get-tables
Response Formats | JSON, XML |
---|---|
Authentication | Yes (Requires Key) |
Rate Limited | Yes |
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
|
No |
outFormat String |
Specifies the format of the response. Must be one of the following, if supplied:
json
|
No |
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 |
POST
https://www.mapquestapi.com/datamanager/v2/get-tables?key=KEY&inFormat=json&outFormat=json
{
"clientId": "CLIENT_ID",
"password": "REGISTRY_PASSWORD",
"includePublic": true
}
<datamanager>
<clientId>CLIENT_ID</clientId>
<password>REGISTRY_PASSWORD</password>
<includePublic>true</includePublic>
</datamanager>
"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>