{"id":3745,"date":"2023-08-31T08:09:24","date_gmt":"2023-08-31T07:09:24","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&p=3745"},"modified":"2024-03-19T13:24:34","modified_gmt":"2024-03-19T12:24:34","slug":"update-multiple-rows","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/api\/methods\/data-tables\/update-multiple-rows\/","title":{"rendered":"Update multiple rows"},"content":{"rendered":"\n

DataTablesUpdateMultipleRows allows updating existing rows using HTTP POST method. It is possible to update multiple rows in one data table in one request by specifying row unique identifier (PK, primary key) for each row.<\/p>\n\n\n\n

<\/a><\/a>Request data format<\/strong><\/h3>\n\n\n\n

ApiRequest element children:<\/p>\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 rows data. Required.<\/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 row elements. Required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

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

Parameter<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
PrimaryKeyColumns<\/td>complex<\/td>Collection of Column elements. Contains unique identifier (PK, primary key) of the row that is supposed to be updated. This is an equivalent of SQL “WHERE” directive. Required. <\/td><\/tr>
Columns<\/td>complex<\/td>Collection of Column elements. Contains information only about columns that are supposed to be updated and their new values. This is an equivalent of SQL “SET” directive. Required. <\/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>
Column<\/td>string<\/td>Column name. Required.<\/td><\/tr>
Value<\/td>string<\/td>Field value. Required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

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

Request:<\/p>\n\n\n\n

<\/path><\/path><\/svg><\/span>
POST https:\/\/api.esv2.com\/v2\/Api\/DataTablesUpdateMultipleRows\/ HTTP\/1.1<\/span><\/span>\n<\/span>\n<<\/span>ApiRequest<\/span> <\/span>xmlns<\/span>:<\/span>xs<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema<\/span>"<\/span> <\/span>xmlns<\/span>:<\/span>xsi<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/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>Row<\/span>><\/span><\/span>\n      <\/span><<\/span>PrimaryKeyColumns<\/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>PrimaryKeyColumns<\/span>><\/span><\/span>\n      <\/span><<\/span>Columns<\/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>PrimaryKeyColumns<\/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>PrimaryKeyColumns<\/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>Value5<\/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>5<\/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>Data<\/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 204 No Content<\/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>\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>Messages<\/span>><\/span><\/span>\n   <\/span><<\/span>Message<\/span> <\/span>for<\/span>=<\/span>"<\/span>Row 1<\/span>"<\/span>><\/span>Row with specified criteria already exists.<\/span><\/<\/span>Message<\/span>><\/span><\/span>\n   <\/span><<\/span>Message<\/span> <\/span>for<\/span>=<\/span>"<\/span>Row 2<\/span>"<\/span>><\/span>Request does not contain required columns.<\/span><\/<\/span>Message<\/span>><\/span><\/span>\n   <\/span><<\/span>Message<\/span> <\/span>for<\/span>=<\/span>"<\/span>Row 3<\/span>"<\/span>><\/span>No row matching specified criteria was found.<\/span><\/<\/span>Message<\/span>><\/span><\/span>\n   <\/span><<\/span>Message<\/span> <\/span>for<\/span>=<\/span>"<\/span>Row 4<\/span>"<\/span>><\/span>Validation error, field type:Number value:test<\/span><\/<\/span>Message<\/span>><\/span><\/span>\n  <\/span><\/<\/span>Messages<\/span>><\/span><\/span>\n <\/span><\/<\/span>ErrorMessage<\/span>><\/span><\/span>\n<\/<\/span>ApiResponse<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Please note that the error response contains information about errors in specific rows (identified by the index number of a row, starting from 1). If there were rows that were not reported here as an error it means that those rows were successfully updated in data tables.<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":3729,"menu_order":265,"template":"","format":"standard","emp-category":[],"class_list":["post-3745","es","type-es","status-publish","format-standard","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3745","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":2,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3745\/revisions"}],"predecessor-version":[{"id":8851,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3745\/revisions\/8851"}],"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=3745"}],"wp:term":[{"taxonomy":"emp-category","embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/emp-category?post=3745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}