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	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: