Show/Hide Toolbars

Therefore Web API Programming Interface 1.0

REST URL (POST) https://tenant.thereforeonline.com/theservice/v0001/restun/GetQuerySpecification

SOAP Action (POST) http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/GetQuerySpecification

 

Returns query specification: list of valid operators and operands, formats for dates and numbers.

 

 

Input Message: http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/GetQuerySpecification

 

<Empty message>

 

Output Message: http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/GetQuerySpecificationResponse

 

Element Name

Element Type

Restrictions

Description

â–  parameters

 

 


â–¡ DateFormat

xs:string

nillable

Gets format string for date values in queries.

â–¡ NumberDecimalSeparator

xs:string

nillable

Gets decimal separator for numeric values in queries.

â–¡ ValidOperandMacros

 

nillable

Gets list of valid macros operands for queries.

≡ ValidOperandMacros

xs:string

list nillable


â–¡ ValidQueryOperators

 

nillable

Gets list of valid operators for queries.

â–¡ And

xs:string

nillable

Operator AND.

â–¡ Empty

xs:string

nillable

Operator EMPTY.

â–¡ GreaterThan

xs:string

nillable

Operator GREATER THAN.

â–¡ GreaterThanOrEqual

xs:string

nillable

Operator GREATER THAN OR EQUAL.

â–¡ LessThan

xs:string

nillable

Operator LESS THAN.

â–¡ LessThanOrEqual

xs:string

nillable

Operator LESS THAN OR EQUAL.

â–¡ Not

xs:string

nillable

Operator NOT.

â–¡ NotEmpty

xs:string

nillable

Operator NOT EMPTY.

â–¡ Or

xs:string

nillable

Operator OR.

â–¡ To

xs:string

nillable

Operator TO.

â–¡ Wildcard

xs:string

nillable

Wildcard.

â–¡ NumberThousandsSeparator

xs:string

nillable

Gets thousand separator for numeric values in queries.

â–¡ TimeFormat

xs:string

nillable

Gets format string for time values in queries.

 

 

 

Legend:

 

â– 

Not nillable element.

â–¡

Nillable element.

≡

List of elements.

Bold

Mandatory element.

 

 

© 2023 Therefore Corporation, all rights reserved.