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
GetTableRecordsByIdRequest Parameters:
NameParameterData TypeRequiredDescription
TablesIdpathintYesTable id
IdpathintYesPrimary Key
RowGuidbodyGuidYesPrimary Key
FilterListbodyDictionary<string, Object>NoFilter list
GetTableRecordsByIdResponse Parameters:
NameParameterData TypeRequiredDescription
ResponseStatusformResponseStatusNo

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"}}}