This request deletes columns from the specified Data Manager table.
https://www.mapquestapi.com/datamanager/v2/drop-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 |
This is the complete name of the table. Table names for legacy users must be prefixed with mqap.[CLIENT_ID]_ Table names for new users must be prefixed with mqap.[APPLICATION_KEY]_
|
Yes |
columnNames String[] |
An array of column names to be removed from the specified table. | Yes |
POST
https://www.mapquestapi.com/datamanager/v2/drop-columns?key=KEY&inFormat=json
{
"clientId": "CLIENT_ID",
"password": "REGISTRY_PASSWORD",
"tableName": "mqap.TABLENAME",
"columnNames": [
{
"name": "NAME"
}
...
]
}
<datamanager>
<clientId>CLIENT_ID</clientId>
<password>REGISTRY_PASSWORD</password>
<tableName>TABLENAME</tableName>
<columnNames><name>NAME</name>...
</columnNames>
</datamanager>
{
"tableName": "mqap.TABLENAME",
"columns": [
{
"name": "...",
"type": "...",
"isPublic": "..."
}
]
}
<datamanager>
<tableName>mqap.TABLENAME</tableName>
<columns>
<column>
<name>...</name>
<type>...</type>
<isPublic>...</isPublic>
</column>
</columns>
</datamanager>