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 datetime
import decimal
from marshmallow.fields import *
from servicestack import *
from typing import *
from dataclasses import dataclass, field
from dataclasses_json import dataclass_json, LetterCase, Undefined, config
from enum import Enum, IntEnum


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class GetTableRecordsByIdResponse:
    response_status: Optional[ResponseStatus] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class GetTableRecordsByIdRequest:
    # @ApiMember(Description="Table id", IsRequired=true)
    tables_id: int = 0
    """
    Table id
    """


    # @ApiMember(Description="Primary Key", IsRequired=true)
    id: int = 0
    """
    Primary Key
    """


    # @ApiMember(Description="Primary Key", IsRequired=true)
    row_guid: Optional[str] = None
    """
    Primary Key
    """


    # @ApiMember(Description="Filter list")
    filter_list: Optional[Dict[str, Object]] = None
    """
    Filter list
    """

Python GetTableRecordsByIdRequest DTOs

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

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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/json
Content-Type: application/json
Content-Length: length

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

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