digitaluapi

<back to all web services

MetaQueriesAdd

Requires Authentication
Requires any of the roles:Client, Admin, Partner
The following routes are available for this service:
POST/scadmeta/meta_queries
import java.math.*;
import java.util.*;
import java.io.InputStream;
import net.servicestack.client.*;

public class dtos
{

    @DataContract
    public static class MetaQueriesAdd
    {
        @DataMember(Order=1)
        public Integer Id = null;

        @DataMember(Order=2)
        public Short DbTechnologiesId = null;

        @DataMember(Order=3)
        public String Description = null;

        @DataMember(Order=4)
        public String CommandText = null;

        @DataMember(Order=5)
        public Short CommandTypesId = null;

        @DataMember(Order=6)
        public Boolean CacheResult = null;

        @DataMember(Order=7)
        public Integer CachetimeInSeconds = null;

        @DataMember(Order=8)
        public Integer QueryTypesId = null;

        @DataMember(Order=9)
        public Short DbTechnologyTemplatesId = null;

        @DataMember(Order=10)
        public Date LastModifiedDate = null;

        @DataMember(Order=11)
        public UUID RowVersionGuid = null;

        @DataMember(Order=12)
        public Boolean IsEnabled = null;

        @DataMember(Order=13)
        public Short ConnectionsId = null;
        
        public Integer getId() { return Id; }
        public MetaQueriesAdd setId(Integer value) { this.Id = value; return this; }
        public Short getDbTechnologiesId() { return DbTechnologiesId; }
        public MetaQueriesAdd setDbTechnologiesId(Short value) { this.DbTechnologiesId = value; return this; }
        public String getDescription() { return Description; }
        public MetaQueriesAdd setDescription(String value) { this.Description = value; return this; }
        public String getCommandText() { return CommandText; }
        public MetaQueriesAdd setCommandText(String value) { this.CommandText = value; return this; }
        public Short getCommandTypesId() { return CommandTypesId; }
        public MetaQueriesAdd setCommandTypesId(Short value) { this.CommandTypesId = value; return this; }
        public Boolean isCacheResult() { return CacheResult; }
        public MetaQueriesAdd setCacheResult(Boolean value) { this.CacheResult = value; return this; }
        public Integer getCachetimeInSeconds() { return CachetimeInSeconds; }
        public MetaQueriesAdd setCachetimeInSeconds(Integer value) { this.CachetimeInSeconds = value; return this; }
        public Integer getQueryTypesId() { return QueryTypesId; }
        public MetaQueriesAdd setQueryTypesId(Integer value) { this.QueryTypesId = value; return this; }
        public Short getDbTechnologyTemplatesId() { return DbTechnologyTemplatesId; }
        public MetaQueriesAdd setDbTechnologyTemplatesId(Short value) { this.DbTechnologyTemplatesId = value; return this; }
        public Date getLastModifiedDate() { return LastModifiedDate; }
        public MetaQueriesAdd setLastModifiedDate(Date value) { this.LastModifiedDate = value; return this; }
        public UUID getRowVersionGuid() { return RowVersionGuid; }
        public MetaQueriesAdd setRowVersionGuid(UUID value) { this.RowVersionGuid = value; return this; }
        public Boolean getIsEnabled() { return IsEnabled; }
        public MetaQueriesAdd setIsEnabled(Boolean value) { this.IsEnabled = value; return this; }
        public Short getConnectionsId() { return ConnectionsId; }
        public MetaQueriesAdd setConnectionsId(Short value) { this.ConnectionsId = value; return this; }
    }

    public static class MetaQueriesAddResponse
    {
        @DataMember(Order=1)
        public Integer Id = null;

        @DataMember(Order=2)
        public Short DbTechnologiesId = null;

        @DataMember(Order=3)
        public String Description = null;

        @DataMember(Order=4)
        public String CommandText = null;

        @DataMember(Order=5)
        public Short CommandTypesId = null;

        @DataMember(Order=6)
        public Boolean CacheResult = null;

        @DataMember(Order=7)
        public Integer CachetimeInSeconds = null;

        @DataMember(Order=8)
        public Integer QueryTypesId = null;

        @DataMember(Order=9)
        public Short DbTechnologyTemplatesId = null;

        @DataMember(Order=10)
        public Date LastModifiedDate = null;

        @DataMember(Order=11)
        public UUID RowVersionGuid = null;

        @DataMember(Order=12)
        public Boolean IsEnabled = null;

        @DataMember(Order=13)
        public Short ConnectionsId = null;

        @DataMember(Order=15)
        public ResponseStatus ResponseStatus = null;
        
        public Integer getId() { return Id; }
        public MetaQueriesAddResponse setId(Integer value) { this.Id = value; return this; }
        public Short getDbTechnologiesId() { return DbTechnologiesId; }
        public MetaQueriesAddResponse setDbTechnologiesId(Short value) { this.DbTechnologiesId = value; return this; }
        public String getDescription() { return Description; }
        public MetaQueriesAddResponse setDescription(String value) { this.Description = value; return this; }
        public String getCommandText() { return CommandText; }
        public MetaQueriesAddResponse setCommandText(String value) { this.CommandText = value; return this; }
        public Short getCommandTypesId() { return CommandTypesId; }
        public MetaQueriesAddResponse setCommandTypesId(Short value) { this.CommandTypesId = value; return this; }
        public Boolean isCacheResult() { return CacheResult; }
        public MetaQueriesAddResponse setCacheResult(Boolean value) { this.CacheResult = value; return this; }
        public Integer getCachetimeInSeconds() { return CachetimeInSeconds; }
        public MetaQueriesAddResponse setCachetimeInSeconds(Integer value) { this.CachetimeInSeconds = value; return this; }
        public Integer getQueryTypesId() { return QueryTypesId; }
        public MetaQueriesAddResponse setQueryTypesId(Integer value) { this.QueryTypesId = value; return this; }
        public Short getDbTechnologyTemplatesId() { return DbTechnologyTemplatesId; }
        public MetaQueriesAddResponse setDbTechnologyTemplatesId(Short value) { this.DbTechnologyTemplatesId = value; return this; }
        public Date getLastModifiedDate() { return LastModifiedDate; }
        public MetaQueriesAddResponse setLastModifiedDate(Date value) { this.LastModifiedDate = value; return this; }
        public UUID getRowVersionGuid() { return RowVersionGuid; }
        public MetaQueriesAddResponse setRowVersionGuid(UUID value) { this.RowVersionGuid = value; return this; }
        public Boolean getIsEnabled() { return IsEnabled; }
        public MetaQueriesAddResponse setIsEnabled(Boolean value) { this.IsEnabled = value; return this; }
        public Short getConnectionsId() { return ConnectionsId; }
        public MetaQueriesAddResponse setConnectionsId(Short value) { this.ConnectionsId = value; return this; }
        public ResponseStatus getResponseStatus() { return ResponseStatus; }
        public MetaQueriesAddResponse setResponseStatus(ResponseStatus value) { this.ResponseStatus = value; return this; }
    }

}

Java MetaQueriesAdd DTOs

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/meta_queries HTTP/1.1 
Host: duengageapi.uat.scadsoftware.com 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"Id":0,"DbTechnologiesId":0,"Description":"String","CommandText":"String","CommandTypesId":0,"CacheResult":false,"CachetimeInSeconds":0,"QueryTypesId":0,"DbTechnologyTemplatesId":0,"LastModifiedDate":"0001-01-01T00:00:00.0000000","RowVersionGuid":"00000000000000000000000000000000","IsEnabled":false,"ConnectionsId":0}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Id":0,"DbTechnologiesId":0,"Description":"String","CommandText":"String","CommandTypesId":0,"CacheResult":false,"CachetimeInSeconds":0,"QueryTypesId":0,"DbTechnologyTemplatesId":0,"LastModifiedDate":"0001-01-01T00:00:00.0000000","RowVersionGuid":"00000000000000000000000000000000","IsEnabled":false,"ConnectionsId":0,"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}