This request adds columns to the specified Data Manager table.
https://www.mapquestapi.com/datamanager/v2/add-columns
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 |
tableName String |
The name of the table | Yes |
name String |
The name of the column | Yes |
type String |
The type of the column. See get-column-types function to see a list of supported column types | Yes |
isPublic 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/add-columns?key=KEY&inFormat=json&outFormat=json
{
"clientId": "CLIENT_ID",
"password": "REGISTRY_PASSWORD",
"tableName": "mqap.TABLENAME",
"columns": [
{
"name": "NAME",
"type": "TYPE",
"isPublic": true
},
{
...
}
]
}
<datamanager>
<clientId>CLIENT_ID</clientId>
<password>REGISTRY_PASSWORD</password>
<tableName>TABLENAME</tableName>
<columns>
<column>
<name>NAME</name>
<type>TYPE</type>
<isPublic>true</isPublic>
</column>
...
</columns>
</datamanager>
{
"tableName": "mqap.[TABLENAME]",
"columns": [
{
"name": "...",
"type": "...",
"isPublic": "..."
}
]
}
<tableName>mqap.TABLENAME</tableName>
<columns>
<column>
<name>...</name>
<type>...</type>
<isPublic>...</isPublic>
</column>
</columns>