digitaluapi

<back to all web services

GetTableRecordsRequest

import 'package:servicestack/servicestack.dart';
import 'dart:collection';

class Filter implements IConvertible
{
    String? Column;
    String? Operator;
    dynamic? Value;
    String? FromVariable;
    dynamic? ToValue;
    String? ToVariable;

    Filter({this.Column,this.Operator,this.Value,this.FromVariable,this.ToValue,this.ToVariable});
    Filter.fromJson(Map<String, dynamic> json) { fromMap(json); }

    fromMap(Map<String, dynamic> json) {
        Column = json['Column'];
        Operator = json['Operator'];
        Value = JsonConverters.fromJson(json['Value'],'dynamic',context!);
        FromVariable = json['FromVariable'];
        ToValue = JsonConverters.fromJson(json['ToValue'],'dynamic',context!);
        ToVariable = json['ToVariable'];
        return this;
    }

    Map<String, dynamic> toJson() => {
        'Column': Column,
        'Operator': Operator,
        'Value': JsonConverters.toJson(Value,'dynamic',context!),
        'FromVariable': FromVariable,
        'ToValue': JsonConverters.toJson(ToValue,'dynamic',context!),
        'ToVariable': ToVariable
    };

    getTypeName() => "Filter";
    TypeContext? context = _ctx;
}

class Paging implements IConvertible
{
    int? PageNumber;
    int? PageSize;

    Paging({this.PageNumber,this.PageSize});
    Paging.fromJson(Map<String, dynamic> json) { fromMap(json); }

    fromMap(Map<String, dynamic> json) {
        PageNumber = json['PageNumber'];
        PageSize = json['PageSize'];
        return this;
    }

    Map<String, dynamic> toJson() => {
        'PageNumber': PageNumber,
        'PageSize': PageSize
    };

    getTypeName() => "Paging";
    TypeContext? context = _ctx;
}

class GetTableRecordsRequest implements IConvertible
{
    /**
    * Table id
    */
    // @ApiMember(Description="Table id", IsRequired=true)
    int? TablesId;

    /**
    * Query id
    */
    // @ApiMember(Description="Query id")
    int? QueryId;

    /**
    * Parameter list
    */
    // @ApiMember(Description="Parameter list")
    Map<String,dynamic?>? ParameterList;

    /**
    * Filter list
    */
    // @ApiMember(Description="Filter list")
    Map<String,dynamic?>? FilterList;

    List<Filter>? Filter;
    /**
    * Number of items to be returned per page
    */
    // @ApiMember(Description="Number of items to be returned per page")
    Paging? Paging;

    /**
    * Drill down filter list
    */
    // @ApiMember(Description="Drill down filter list")
    Map<String,dynamic?>? DrillDownFilterList;

    /**
    * Global parameter list
    */
    // @ApiMember(Description="Global parameter list")
    Map<String,dynamic?>? GlobalParamList;

    /**
    * View id
    */
    // @ApiMember(Description="View id")
    int? ViewId;

    /**
    * Whether or not to refresh the cache
    */
    // @ApiMember(Description="Whether or not to refresh the cache")
    bool? RefreshCache;

    GetTableRecordsRequest({this.TablesId,this.QueryId,this.ParameterList,this.FilterList,this.Filter,this.Paging,this.DrillDownFilterList,this.GlobalParamList,this.ViewId,this.RefreshCache});
    GetTableRecordsRequest.fromJson(Map<String, dynamic> json) { fromMap(json); }

    fromMap(Map<String, dynamic> json) {
        TablesId = json['TablesId'];
        QueryId = json['QueryId'];
        ParameterList = JsonConverters.fromJson(json['ParameterList'],'Map<String,dynamic?>',context!);
        FilterList = JsonConverters.fromJson(json['FilterList'],'Map<String,dynamic?>',context!);
        Filter = JsonConverters.fromJson(json['Filter'],'List<Filter>',context!);
        Paging = JsonConverters.fromJson(json['Paging'],'Paging',context!);
        DrillDownFilterList = JsonConverters.fromJson(json['DrillDownFilterList'],'Map<String,dynamic?>',context!);
        GlobalParamList = JsonConverters.fromJson(json['GlobalParamList'],'Map<String,dynamic?>',context!);
        ViewId = json['ViewId'];
        RefreshCache = json['RefreshCache'];
        return this;
    }

    Map<String, dynamic> toJson() => {
        'TablesId': TablesId,
        'QueryId': QueryId,
        'ParameterList': JsonConverters.toJson(ParameterList,'Map<String,dynamic?>',context!),
        'FilterList': JsonConverters.toJson(FilterList,'Map<String,dynamic?>',context!),
        'Filter': JsonConverters.toJson(Filter,'List<Filter>',context!),
        'Paging': JsonConverters.toJson(Paging,'Paging',context!),
        'DrillDownFilterList': JsonConverters.toJson(DrillDownFilterList,'Map<String,dynamic?>',context!),
        'GlobalParamList': JsonConverters.toJson(GlobalParamList,'Map<String,dynamic?>',context!),
        'ViewId': ViewId,
        'RefreshCache': RefreshCache
    };

    getTypeName() => "GetTableRecordsRequest";
    TypeContext? context = _ctx;
}

TypeContext _ctx = TypeContext(library: 'duengageapi.uat.scadsoftware.com', types: <String, TypeInfo> {
    'Filter': TypeInfo(TypeOf.Class, create:() => Filter()),
    'Paging': TypeInfo(TypeOf.Class, create:() => Paging()),
    'GetTableRecordsRequest': TypeInfo(TypeOf.Class, create:() => GetTableRecordsRequest()),
    'Map<String,dynamic?>': TypeInfo(TypeOf.Class, create:() => Map<String,dynamic?>()),
    'List<Filter>': TypeInfo(TypeOf.Class, create:() => <Filter>[]),
});

Dart GetTableRecordsRequest DTOs

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

<GetTableRecordsRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/digitaluapi.ServiceModel">
  <DrillDownFilterList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </DrillDownFilterList>
  <Filter xmlns:d2p1="http://schemas.datacontract.org/2004/07/digitaluapi.ServiceModel.Types">
    <d2p1:Filter>
      <d2p1:Column>String</d2p1:Column>
      <d2p1:FromVariable>String</d2p1:FromVariable>
      <d2p1:Operator>String</d2p1:Operator>
      <d2p1:ToValue />
      <d2p1:ToVariable>String</d2p1:ToVariable>
      <d2p1:Value />
    </d2p1:Filter>
  </Filter>
  <FilterList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </FilterList>
  <GlobalParamList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </GlobalParamList>
  <Paging xmlns:d2p1="http://schemas.datacontract.org/2004/07/digitaluapi.ServiceModel.Types">
    <d2p1:PageNumber>0</d2p1:PageNumber>
    <d2p1:PageSize>0</d2p1:PageSize>
  </Paging>
  <ParameterList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </ParameterList>
  <QueryId>0</QueryId>
  <RefreshCache>false</RefreshCache>
  <TablesId>0</TablesId>
  <ViewId>0</ViewId>
</GetTableRecordsRequest>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<ArrayOfanyType xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
  <anyType />
</ArrayOfanyType>