| Requires any of the roles: | Client, Admin, Partner |
| GET, POST | /scadmeta/tables/{TablesId}/data/{Id} | Gets table records |
|---|
<?php namespace dtos;
use DateTime;
use Exception;
use DateInterval;
use JsonSerializable;
use ServiceStack\{IReturn,IReturnVoid,IGet,IPost,IPut,IDelete,IPatch,IMeta,IHasSessionId,IHasBearerToken,IHasVersion};
use ServiceStack\{ICrud,ICreateDb,IUpdateDb,IPatchDb,IDeleteDb,ISaveDb,AuditBase,QueryDb,QueryDb2,QueryData,QueryData2,QueryResponse};
use ServiceStack\{ResponseStatus,ResponseError,EmptyResponse,IdResponse,ArrayList,KeyValuePair2,StringResponse,StringsResponse,Tuple2,Tuple3,ByteArray};
use ServiceStack\{JsonConverters,Returns,TypeContext};
class GetTableRecordsByIdResponse implements JsonSerializable
{
public function __construct(
/** @var ResponseStatus|null */
public ?ResponseStatus $ResponseStatus=null
) {
}
/** @throws Exception */
public function fromMap($o): void {
if (isset($o['ResponseStatus'])) $this->ResponseStatus = JsonConverters::from('ResponseStatus', $o['ResponseStatus']);
}
/** @throws Exception */
public function jsonSerialize(): mixed
{
$o = [];
if (isset($this->ResponseStatus)) $o['ResponseStatus'] = JsonConverters::to('ResponseStatus', $this->ResponseStatus);
return empty($o) ? new class(){} : $o;
}
}
class GetTableRecordsByIdRequest implements JsonSerializable
{
public function __construct(
/** @description Table id */
// @ApiMember(Description="Table id", IsRequired=true)
/** @var int */
public int $TablesId=0,
/** @description Primary Key */
// @ApiMember(Description="Primary Key", IsRequired=true)
/** @var int */
public int $Id=0,
/** @description Primary Key */
// @ApiMember(Description="Primary Key", IsRequired=true)
/** @var string */
public string $RowGuid='',
/** @description Filter list */
// @ApiMember(Description="Filter list")
/** @var array<string,Object>|null */
public ?array $FilterList=null
) {
}
/** @throws Exception */
public function fromMap($o): void {
if (isset($o['TablesId'])) $this->TablesId = $o['TablesId'];
if (isset($o['Id'])) $this->Id = $o['Id'];
if (isset($o['RowGuid'])) $this->RowGuid = $o['RowGuid'];
if (isset($o['FilterList'])) $this->FilterList = JsonConverters::from(JsonConverters::context('Dictionary',genericArgs:['string','Object']), $o['FilterList']);
}
/** @throws Exception */
public function jsonSerialize(): mixed
{
$o = [];
if (isset($this->TablesId)) $o['TablesId'] = $this->TablesId;
if (isset($this->Id)) $o['Id'] = $this->Id;
if (isset($this->RowGuid)) $o['RowGuid'] = $this->RowGuid;
if (isset($this->FilterList)) $o['FilterList'] = JsonConverters::to(JsonConverters::context('Dictionary',genericArgs:['string','Object']), $this->FilterList);
return empty($o) ? new class(){} : $o;
}
}
PHP GetTableRecordsByIdRequest DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=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"}}}