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
import java.math.*;
import java.util.*;
import java.io.InputStream;
import net.servicestack.client.*;

public class dtos
{

    public static class GetTableRecordsByIdRequest
    {
        /**
        * Table id
        */
        @ApiMember(Description="Table id", IsRequired=true)
        public Integer TablesId = null;

        /**
        * Primary Key
        */
        @ApiMember(Description="Primary Key", IsRequired=true)
        public Integer Id = null;

        /**
        * Primary Key
        */
        @ApiMember(Description="Primary Key", IsRequired=true)
        public UUID RowGuid = null;

        /**
        * Filter list
        */
        @ApiMember(Description="Filter list")
        public HashMap<String,Object> FilterList = null;
        
        public Integer getTablesId() { return TablesId; }
        public GetTableRecordsByIdRequest setTablesId(Integer value) { this.TablesId = value; return this; }
        public Integer getId() { return Id; }
        public GetTableRecordsByIdRequest setId(Integer value) { this.Id = value; return this; }
        public UUID getRowGuid() { return RowGuid; }
        public GetTableRecordsByIdRequest setRowGuid(UUID value) { this.RowGuid = value; return this; }
        public HashMap<String,Object> getFilterList() { return FilterList; }
        public GetTableRecordsByIdRequest setFilterList(HashMap<String,Object> value) { this.FilterList = value; return this; }
    }

    public static class GetTableRecordsByIdResponse
    {
        public ResponseStatus ResponseStatus = null;
        
        public ResponseStatus getResponseStatus() { return ResponseStatus; }
        public GetTableRecordsByIdResponse setResponseStatus(ResponseStatus value) { this.ResponseStatus = value; return this; }
    }

}

Java GetTableRecordsByIdRequest DTOs

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

HTTP + CSV

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: text/csv
Content-Type: text/csv
Content-Length: length

{"TablesId":0,"Id":0,"RowGuid":"00000000000000000000000000000000","FilterList":{"String":{}}}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}