Therefore Web API Programming Interface 1.0

GetQuerySpecification

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

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

Element Name	Element Type	Restrictions	Description
■ parameters
□ DateFormat	xs:string	optional nillable	Gets format string for date time values returned by queries.
□ NumberDecimalSeparator	xs:string	optional nillable	Gets format string for decimal values returned by queries.
□ ValidOperandMacros		optional nillable	Gets list of valid macros operands for queries.
≡ ValidOperandMacros	xs:string	optional unbounded nillable
□ ValidQueryOperators		optional nillable	Gets list of valid operators for queries.
□ And	xs:string	optional nillable	Operator AND.
□ Empty	xs:string	optional nillable	Operator EMPTY.
□ GreaterThan	xs:string	optional nillable	Operator GREATER THAN.
□ GreaterThanOrEqual	xs:string	optional nillable	Operator GREATER THAN OR EQUAL.
□ LessThan	xs:string	optional nillable	Operator LESS THAN.
□ LessThanOrEqual	xs:string	optional nillable	Operator LESS THAN OR EQUAL.
□ Not	xs:string	optional nillable	Operator NOT.
□ NotEmpty	xs:string	optional nillable	Operator NOT EMPTY.
□ Or	xs:string	optional nillable	Operator OR.
□ To	xs:string	optional nillable	Operator TO.
□ Wildcard	xs:string	optional nillable	Wildcard.

Legend:

■	Not nillable element.
□	Nillable element.
≡	Unbounded element (List of elements).
Normal	Optional element.
Bold	Mandatory element.