条目添加
Add Row 条目添加
DataTablesAddRow采用 HTTP POST 方式可以更新Data table中的现有条目. 它支持一次请求更新一个单一条目.
请求数据格式
ApiRequest子元素:
| 参数 | 类型 | 描述 |
|---|---|---|
| ApiKey | string | 你的 API key, 用于身份验证. 必填 |
| TableName | string | 数据表格名称. 必填. |
| Data | complex | 对象包含行值. 用于向数据表格添加一行. 必填, 除非指定添加多行. |
| MultiData | complex | 行元素集合. 用于向数据表格添加多行. 必填, 除非指定添加一行. This option is deprecated – please use Add multiple rows method. |
Data子元素:
| 参数 | 类型 | 描述 |
|---|---|---|
| Columns | complex | 列元素集合. |
Column子元素:
| 参数 | 类型 | 描述 |
|---|---|---|
| Name | string | 列名称. 必填. |
| Value | string | 值. 必填. |
To add multiple rows, use MultiData element instead of Data element (这个方式已过时 – 请使用 Add multiple rows method):
| 元素/属性 | 类型 | 描述 |
|---|---|---|
| MultiData | complex | Collection of Row elements that have the same structure as Data element in request adding a single row. |
示例:
请求 (添加一行):
| POST https://api.esv2.com/v2/Api/DataTablesAddRow/ HTTP/1.1
Accept-Encoding: gzip,deflate
User-Agent: Jakarta Commons-HttpClient/3.1
Host: api.esv2.com
Content-Length: 269
<ApiRequest xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xs=”http://www.w3.org/2001/XMLSchema”>
<ApiKey>test_api_key1</ApiKey>
<TableName>Table1</TableName>
<Data>
<Columns>
<Column>
<Name>Column1</Name>
<Value>Value1</Value>
</Column>
<Column>
<Name>Column2</Name>
<Value>2</Value>
</Column>
<Column>
<Name>Column3</Name>
<Value>2013-01-01 01:00:00 PM</Value>
</Column>
<Column>
<Name>Column4</Name>
<Value>4.66</Value>
</Column>
<Column>
<Name>Column5</Name>
<Value>True</Value>
</Column>
</Columns>
</Data>
</ApiRequest>
|
|
POST https://api.esv2.com/v2/Api/DataTablesAddRow/ HTTP/1.1
Accept-Encoding: gzip,deflate
User-Agent: Jakarta Commons-HttpClient/3.1
Host: api.esv2.com
Content-Length: 269
<ApiRequest xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xs=”http://www.w3.org/2001/XMLSchema”>
<ApiKey>test_api_key1</ApiKey>
<TableName>Table1</TableName>
<MultiData>
<Row>
<Columns>
<Column>
<Name>Column1</Name>
<Value>Value1</Value>
</Column>
<Column>
<Name>Column2</Name>
<Value>2</Value>
</Column>
<Column>
<Name>Column3</Name>
<Value>2013-01-01 01:00:00 PM</Value>
</Column>
<Column>
<Name>Column4</Name>
<Value>4.66</Value>
</Column>
<Column>
<Name>Column5</Name>
<Value>True</Value>
</Column>
</Columns>
</Row>
<Row>
<Columns>
<Column>
<Name>Column1</Name>
<Value>Value2</Value>
</Column>
<Column>
<Name>Column2</Name>
<Value>3</Value>
</Column>
<Column>
<Name>Column3</Name>
<Value>2013-01-01 01:00:00 PM</Value>
</Column>
<Column>
<Name>Column4</Name>
<Value>4.66</Value>
</Column>
<Column>
<Name>Column5</Name>
<Value>True</Value>
</Column>
</Columns>
</Row>
</MultiData>
</ApiRequest>
|
OK应答:
| HTTP/1.1 201 Created
Cache-Control: private
Server: Microsoft-IIS/7.5
X-AspNetMvc-Version: 1.0
X-AspNet-Version: 2.0.50727
X-Powered-By: ASP.NET
Date: Wed, 28 Oct 2009 15:35:17 GMT
Content-Length: 0 |
错误应答:
|
HTTP/1.1 400 Bad Request
Cache-Control: private
Content-Type: text/xml; charset=utf-8
Server: Microsoft-IIS/7.5
X-AspNetMvc-Version: 1.0
X-AspNet-Version: 2.0.50727
X-Powered-By: ASP.NET
Date: Wed, 28 Oct 2009 11:32:07 GMT
Content-Length: 239
<ApiResponse xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema”>
<ErrorMessage>
<Code>400</Code>
<Message>Row with specified criteria already exists</Message>
</ErrorMessage>
</ApiResponse>
|
请求 (向列插入NULL值):
|
POST https://api.esv2.com/v2/Api/DataTablesAddRow/ HTTP/1.1
Accept-Encoding: gzip,deflate
User-Agent: Jakarta Commons-HttpClient/3.1
Host: api.esv2.com
Content-Length: 187
<ApiRequest xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xs=”http://www.w3.org/2001/XMLSchema”>
<ApiKey>test_api_key1</ApiKey>
<TableName>Table1</TableName>
<Data>
<Columns>
<Column>
<Name>NotNullColumn</Name>
<Value>some value</Value>
</Column>
<Column>
<Name>NullableColumn</Name>
<Value xsi:nil=”true”/>
</Column>
</Columns>
</Data>
</ApiRequest>
|