PUT api/v2/dataservice/updaterows

Updates a collection of data rows in specified table with given the list of columns and values passed

Request Information

URI Parameters

None.

Body Parameters

The PcSafeData2 object containing entity collection to update.

Name	Type	Additional information
TransactionId	string	None.
PagingData	PagingData	None.
TableData	TableData	None.

Request Formats

application/json, text/json

Sample:

{
  "TransactionId": "sample string 1",
  "PagingData": {
    "PageSize": 1,
    "PageIndex": 2,
    "TotalRecords": 3,
    "TotalPages": 4,
    "Token": "sample string 5"
  },
  "TableData": {
    "TableName": "sample string 1",
    "FieldNames": [
      "sample string 1",
      "sample string 2"
    ],
    "Rows": [
      {
        "RefId": "sample string 1",
        "RowId": "sample string 2",
        "FieldValues": [
          "sample string 1",
          "sample string 2"
        ]
      },
      {
        "RefId": "sample string 1",
        "RowId": "sample string 2",
        "FieldValues": [
          "sample string 1",
          "sample string 2"
        ]
      }
    ]
  }
}

application/xml, text/xml

Sample:

<PcSafeData2 xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Paperclip.IOTA.WebApi.Model">
  <PagingData>
    <PageIndex>2</PageIndex>
    <PageSize>1</PageSize>
    <Token>sample string 5</Token>
    <TotalPages>4</TotalPages>
    <TotalRecords>3</TotalRecords>
  </PagingData>
  <TableData>
    <FieldNames xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:string>sample string 1</d3p1:string>
      <d3p1:string>sample string 2</d3p1:string>
    </FieldNames>
    <Rows>
      <SafeDataRow>
        <FieldValues xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:string>sample string 1</d5p1:string>
          <d5p1:string>sample string 2</d5p1:string>
        </FieldValues>
        <RefId>sample string 1</RefId>
        <RowId>sample string 2</RowId>
      </SafeDataRow>
      <SafeDataRow>
        <FieldValues xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:string>sample string 1</d5p1:string>
          <d5p1:string>sample string 2</d5p1:string>
        </FieldValues>
        <RefId>sample string 1</RefId>
        <RowId>sample string 2</RowId>
      </SafeDataRow>
    </Rows>
    <TableName>sample string 1</TableName>
  </TableData>
  <TransactionId>sample string 1</TransactionId>
</PcSafeData2>

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'JQueryMvcFormUrlEncodedFormatter' to write type 'PcSafeData2'.

Response Information

Resource Description

SafeDataAffected

Name	Description	Type	Additional information
TransactionId		string	None.
Rows		Collection of SafeDataAffectedEntry	None.

Response Formats

application/json, text/json

Sample:

{
  "TransactionId": "sample string 1",
  "Rows": [
    {
      "RefId": "sample string 1",
      "RowId": "sample string 2"
    },
    {
      "RefId": "sample string 1",
      "RowId": "sample string 2"
    }
  ]
}

application/xml, text/xml

Sample:

<SafeDataAffected xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Paperclip.IOTA.WebApi.Model">
  <Rows>
    <SafeDataAffectedEntry>
      <RefId>sample string 1</RefId>
      <RowId>sample string 2</RowId>
    </SafeDataAffectedEntry>
    <SafeDataAffectedEntry>
      <RefId>sample string 1</RefId>
      <RowId>sample string 2</RowId>
    </SafeDataAffectedEntry>
  </Rows>
  <TransactionId>sample string 1</TransactionId>
</SafeDataAffected>