digitaluapi

<back to all web services

GetTableRecordsByIdRequest

Requires Authentication
Requires any of the roles:Client, Admin, Partner
The following routes are available for this service:
GET, POST/scadmeta/tables/{TablesId}/data/{Id}Gets table records
using System;
using System.IO;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using ServiceStack;
using ServiceStack.DataAnnotations;
using digitaluapi.ServiceModel;

namespace digitaluapi.ServiceModel
{
    public partial class GetTableRecordsByIdRequest
    {
        ///<summary>
        ///Table id
        ///</summary>
        [ApiMember(Description="Table id", IsRequired=true)]
        public virtual int TablesId { get; set; }

        ///<summary>
        ///Primary Key
        ///</summary>
        [ApiMember(Description="Primary Key", IsRequired=true)]
        public virtual int Id { get; set; }

        ///<summary>
        ///Primary Key
        ///</summary>
        [ApiMember(Description="Primary Key", IsRequired=true)]
        public virtual Guid RowGuid { get; set; }

        ///<summary>
        ///Filter list
        ///</summary>
        [ApiMember(Description="Filter list")]
        public virtual Dictionary<string, Object> FilterList { get; set; }
    }

    public partial class GetTableRecordsByIdResponse
    {
        public virtual ResponseStatus ResponseStatus { get; set; }
    }

}

C# GetTableRecordsByIdRequest DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /scadmeta/tables/{TablesId}/data/{Id} HTTP/1.1 
Host: duengageapi.uat.scadsoftware.com 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<GetTableRecordsByIdRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/digitaluapi.ServiceModel">
  <FilterList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </FilterList>
  <Id>0</Id>
  <RowGuid>00000000-0000-0000-0000-000000000000</RowGuid>
  <TablesId>0</TablesId>
</GetTableRecordsByIdRequest>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<GetTableRecordsByIdResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/digitaluapi.ServiceModel">
  <ResponseStatus xmlns:d2p1="http://schemas.servicestack.net/types">
    <d2p1:ErrorCode>String</d2p1:ErrorCode>
    <d2p1:Message>String</d2p1:Message>
    <d2p1:StackTrace>String</d2p1:StackTrace>
    <d2p1:Errors>
      <d2p1:ResponseError>
        <d2p1:ErrorCode>String</d2p1:ErrorCode>
        <d2p1:FieldName>String</d2p1:FieldName>
        <d2p1:Message>String</d2p1:Message>
        <d2p1:Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </d2p1:Meta>
      </d2p1:ResponseError>
    </d2p1:Errors>
    <d2p1:Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </d2p1:Meta>
  </ResponseStatus>
</GetTableRecordsByIdResponse>