digitaluapi

<back to all web services

GetTableQueriesRequest

Requires Authentication
Requires any of the roles:Client, Admin, Partner
The following routes are available for this service:
GET/scadmeta/tables/{TablesId}/queriesGets table queries
Imports System
Imports System.IO
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports digitaluapi.ServiceModel
Imports digitaluapi.ServiceModel.Types

Namespace Global

    Namespace digitaluapi.ServiceModel

        Public Partial Class GetTableQueriesRequest
            '''<Summary>
            '''Table id
            '''</Summary>
            <ApiMember(Description:="Table id", IsRequired:=true)>
            Public Overridable Property TablesId As Integer

            '''<Summary>
            '''Parameter list
            '''</Summary>
            <ApiMember(Description:="Parameter list")>
            Public Overridable Property ParameterList As Dictionary(Of String, Object)

            '''<Summary>
            '''Filter list
            '''</Summary>
            <ApiMember(Description:="Filter list")>
            Public Overridable Property FilterList As Dictionary(Of String, Object)

            '''<Summary>
            '''Number of items to be returned per page
            '''</Summary>
            <ApiMember(Description:="Number of items to be returned per page")>
            Public Overridable Property Paging As Paging

            Public Overridable Property FromId As Integer
            '''<Summary>
            '''Drill down filter list
            '''</Summary>
            <ApiMember(Description:="Drill down filter list")>
            Public Overridable Property DrillDownFilterList As Dictionary(Of String, Object)

            '''<Summary>
            '''Global parameter list
            '''</Summary>
            <ApiMember(Description:="Global parameter list")>
            Public Overridable Property GlobalParamList As Dictionary(Of String, Object)

            '''<Summary>
            '''View id
            '''</Summary>
            <ApiMember(Description:="View id")>
            Public Overridable Property ViewId As Integer?

            '''<Summary>
            '''Whether or not to refresh the cache
            '''</Summary>
            <ApiMember(Description:="Whether or not to refresh the cache")>
            Public Overridable Property RefreshCache As Boolean
        End Class
    End Namespace

    Namespace digitaluapi.ServiceModel.Types

        Public Partial Class Paging
            Public Overridable Property PageNumber As Integer
            Public Overridable Property PageSize As Integer
        End Class
    End Namespace
End Namespace

VB.NET GetTableQueriesRequest 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.

GET /scadmeta/tables/{TablesId}/queries HTTP/1.1 
Host: duengageapi.uat.scadsoftware.com 
Accept: application/json

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

[{}]