{"id":3739,"date":"2023-08-31T07:58:10","date_gmt":"2023-08-31T06:58:10","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&p=3739"},"modified":"2024-04-25T07:44:34","modified_gmt":"2024-04-25T06:44:34","slug":"add-row","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/api\/methods\/data-tables\/add-row\/","title":{"rendered":"Add row"},"content":{"rendered":"\n

DataTablesAddRow collection allows adding new rows to Data Tables using HTTP POST method. It is possible to add a single row or multiple rows with one request.<\/p>\n\n\n\n

<\/a><\/a>Request data format<\/strong><\/h3>\n\n\n\n
Parameter<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
ApiKey<\/td>string<\/td>Your API key, required for authentication. Required.<\/td><\/tr>
TableName<\/td>string<\/td>Name of Data Table. Required.<\/td><\/tr>
Data<\/td>complex<\/td>Object containing row data. Used to add a single row to Data Table. Required, unless you are using MultiData to add multiple rows instead.<\/td><\/tr>
MultiData<\/td>complex<\/td>Collection of Row elements. Used to add multiple rows to Data Table. Required, unless you are using Data to add a single row instead.\u00a0This option is deprecated – please use\u00a0Add multiple rows method<\/a>.<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Data element children:<\/p>\n\n\n\n

Parameter<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
Columns<\/td>complex<\/td>Collection of Column elements.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Column element children:<\/p>\n\n\n\n

Parameter<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
Name<\/td>string<\/td>Column name. Required.<\/td><\/tr>
Value<\/td>string<\/td>Field value. Required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

To add multiple rows, use MultiData element instead of Data element (this option is deprecated – please use <\/strong>Add multiple rows method<\/strong><\/a>)<\/strong>:<\/p>\n\n\n\n

Element\/attribute<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
MultiData<\/td>complex<\/td>Collection of Row elements that have the same structure as Data element in request adding a single row.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Examples<\/strong><\/h3>\n\n\n\n

Request (adding single row):<\/p>\n\n\n\n

<\/path><\/path><\/svg><\/span>
POST https:\/\/api.esv2.com\/v2\/Api\/DataTablesAddRow\/ HTTP\/1.1<\/span><\/span>\nAccept-Encoding: gzip,deflate<\/span><\/span>\nUser-Agent: Jakarta Commons-HttpClient\/3.1<\/span><\/span>\nHost: api.esv2.com<\/span><\/span>\nContent-Length: 269<\/span><\/span>\n<\/span>\n<<\/span>ApiRequest<\/span> <\/span>xmlns<\/span>:<\/span>xsi<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/span>"<\/span> <\/span>xmlns<\/span>:<\/span>xs<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema<\/span>"<\/span>><\/span><\/span>\n  <\/span><<\/span>ApiKey<\/span>><\/span>test_api_key1<\/span><\/<\/span>ApiKey<\/span>><\/span><\/span>\n  <\/span><<\/span>TableName<\/span>><\/span>Table1<\/span><\/<\/span>TableName<\/span>><\/span><\/span>\n  <\/span><<\/span>Data<\/span>><\/span><\/span>\n    <\/span><<\/span>Columns<\/span>><\/span><\/span>\n      <\/span><<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Name<\/span>><\/span>Column1<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n        <\/span><<\/span>Value<\/span>><\/span>Value1<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n      <\/span><<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Name<\/span>><\/span>Column2<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n        <\/span><<\/span>Value<\/span>><\/span>2<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n      <\/span><<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Name<\/span>><\/span>Column3<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n        <\/span><<\/span>Value<\/span>><\/span>2013-01-01 01:00:00 PM<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n      <\/span><<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Name<\/span>><\/span>Column4<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n        <\/span><<\/span>Value<\/span>><\/span>4.66<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n      <\/span><<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Name<\/span>><\/span>Column5<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n        <\/span><<\/span>Value<\/span>><\/span>True<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n    <\/span><\/<\/span>Columns<\/span>><\/span><\/span>\n  <\/span><\/<\/span>Data<\/span>><\/span><\/span>\n<\/<\/span>ApiRequest<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Request (adding multiple rows) this option is deprecated – please use <\/strong>Add multiple rows method<\/strong><\/a><\/strong><\/a>:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
POST https:\/\/api.esv2.com\/v2\/Api\/DataTablesAddRow\/ HTTP\/1.1<\/span><\/span>\nAccept-Encoding: gzip,deflate<\/span><\/span>\nUser-Agent: Jakarta Commons-HttpClient\/3.1<\/span><\/span>\nHost: api.esv2.com<\/span><\/span>\nContent-Length: 269<\/span><\/span>\n<\/span>\n<<\/span>ApiRequest<\/span> <\/span>xmlns<\/span>:<\/span>xsi<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/span>"<\/span> <\/span>xmlns<\/span>:<\/span>xs<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema<\/span>"<\/span>><\/span><\/span>\n  <\/span><<\/span>ApiKey<\/span>><\/span>test_api_key1<\/span><\/<\/span>ApiKey<\/span>><\/span><\/span>\n  <\/span><<\/span>TableName<\/span>><\/span>Table1<\/span><\/<\/span>TableName<\/span>><\/span><\/span>\n  <\/span><<\/span>MultiData<\/span>><\/span><\/span>\n    <\/span><<\/span>Row<\/span>><\/span><\/span>\n      <\/span><<\/span>Columns<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column1<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>Value1<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column2<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>2<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column3<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>2013-01-01 01:00:00 PM<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column4<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>4.66<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column5<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>True<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Columns<\/span>><\/span><\/span>\n    <\/span><\/<\/span>Row<\/span>><\/span><\/span>\n    <\/span><<\/span>Row<\/span>><\/span><\/span>\n      <\/span><<\/span>Columns<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column1<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>Value2<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column2<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>3<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column3<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>2013-01-01 01:00:00 PM<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column4<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>4.66<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Column<\/span>><\/span><\/span>\n          <\/span><<\/span>Name<\/span>><\/span>Column5<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n          <\/span><<\/span>Value<\/span>><\/span>True<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n        <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Columns<\/span>><\/span><\/span>\n    <\/span><\/<\/span>Row<\/span>><\/span><\/span>\n  <\/span><\/<\/span>MultiData<\/span>><\/span><\/span>\n<\/<\/span>ApiRequest<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
OK response:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
HTTP\/1.1 201 Created<\/span><\/span>\nCache-Control: private<\/span><\/span>\nServer: Microsoft-IIS\/7.5<\/span><\/span>\nX-AspNetMvc-Version: 1.0<\/span><\/span>\nX-AspNet-Version: 2.0.50727<\/span><\/span>\nX-Powered-By: ASP.NET<\/span><\/span>\nDate: Wed, 28 Oct 2009 15:35:17 GMT<\/span><\/span>\nContent-Length: 0<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Error response:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
HTTP\/1.1 400 Bad Request<\/span><\/span>\nCache-Control: private<\/span><\/span>\nContent-Type: text\/xml; charset=utf-8<\/span><\/span>\nServer: Microsoft-IIS\/7.5<\/span><\/span>\nX-AspNetMvc-Version: 1.0<\/span><\/span>\nX-AspNet-Version: 2.0.50727<\/span><\/span>\nX-Powered-By: ASP.NET<\/span><\/span>\nDate: Wed, 28 Oct 2009 11:32:07 GMT<\/span><\/span>\nContent-Length: 239<\/span><\/span>\n<\/span>\n<<\/span>ApiResponse<\/span> <\/span>xmlns<\/span>:<\/span>xsi<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/span>"<\/span> <\/span>xmlns<\/span>:<\/span>xsd<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema<\/span>"<\/span>><\/span><\/span>\n   <\/span><<\/span>ErrorMessage<\/span>><\/span><\/span>\n      <\/span><<\/span>Code<\/span>><\/span>400<\/span><\/<\/span>Code<\/span>><\/span><\/span>\n      <\/span><<\/span>Message<\/span>><\/span>Row with specified criteria already exists<\/span><\/<\/span>Message<\/span>><\/span><\/span>\n   <\/span><\/<\/span>ErrorMessage<\/span>><\/span><\/span>\n<\/<\/span>ApiResponse<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Request (inserting NULL value into column):<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
POST https:\/\/api.esv2.com\/v2\/Api\/DataTablesAddRow\/ HTTP\/1.1<\/span><\/span>\nAccept-Encoding: gzip,deflate<\/span><\/span>\nUser-Agent: Jakarta Commons-HttpClient\/3.1<\/span><\/span>\nHost: api.esv2.com<\/span><\/span>\nContent-Length: 187<\/span><\/span>\n<\/span>\n<<\/span>ApiRequest<\/span> <\/span>xmlns<\/span>:<\/span>xsi<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/span>"<\/span> <\/span>xmlns<\/span>:<\/span>xs<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema<\/span>"<\/span>><\/span><\/span>\n  <\/span><<\/span>ApiKey<\/span>><\/span>test_api_key1<\/span><\/<\/span>ApiKey<\/span>><\/span><\/span>\n  <\/span><<\/span>TableName<\/span>><\/span>Table1<\/span><\/<\/span>TableName<\/span>><\/span><\/span>\n  <\/span><<\/span>Data<\/span>><\/span><\/span>\n    <\/span><<\/span>Columns<\/span>><\/span><\/span>\n      <\/span><<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Name<\/span>><\/span>NotNullColumn<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n        <\/span><<\/span>Value<\/span>><\/span>some value<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n      <\/span><<\/span>Column<\/span>><\/span><\/span>\n        <\/span><<\/span>Name<\/span>><\/span>NullableColumn<\/span><\/<\/span>Name<\/span>><\/span><\/span>\n        <\/span><<\/span>Value<\/span> <\/span>xsi<\/span>:<\/span>nil<\/span>=<\/span>"<\/span>true<\/span>"<\/span>\/><\/span><\/span>\n      <\/span><\/<\/span>Column<\/span>><\/span><\/span>\n    <\/span><\/<\/span>Columns<\/span>><\/span><\/span>\n  <\/span><\/<\/span>Data<\/span>><\/span><\/span>\n<\/<\/span>ApiRequest<\/span>><\/span><\/span><\/code><\/pre><\/div>\n","protected":false},"author":5,"featured_media":0,"parent":3729,"menu_order":268,"template":"","format":"standard","emp-category":[],"class_list":["post-3739","es","type-es","status-publish","format-standard","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es"}],"about":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/types\/es"}],"author":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":4,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3739\/revisions"}],"predecessor-version":[{"id":10428,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3739\/revisions\/10428"}],"up":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3729"}],"wp:attachment":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/media?parent=3739"}],"wp:term":[{"taxonomy":"emp-category","embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/emp-category?post=3739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}