Therefore Web API Programming Interface 1.0

QueryDependentFieldsDirect

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

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

Search Therefore database table for content

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

Element Name	Element Type	Restrictions	Description
■ parameters
■ DataTypeNo	xs:int	mandatory	The datatype to query for information
□ maxRows	xs:int	optional nillable	Maximum number of rows to return
□ queryConditions		mandatory nillable	The query conditions for different columns to search
≡ WSQueryDependentFieldsDirectCondition		optional unbounded nillable
□ ColName	xs:string	optional nillable	Sets the column name to query
■ ColumnType	xs:int	optional	Sets the type of the column to query
□ Condition	xs:string	optional nillable	Sets the query condition
□ selectColumns		mandatory nillable	The columns to select from the datatype table
≡ SelectColumn	xs:string	optional unbounded nillable

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

Element Name	Element Type	Restrictions	Description
■ parameters
□ QueryResult		optional nillable	Gets the query result.
□ Columns		optional nillable	Gets the query result rows.
≡ string	xs:string	optional unbounded nillable
□ ResultRows		optional nillable	Gets the query result rows.
≡ WSDependentFieldsQueryResultRow		optional unbounded nillable
□ FieldValues		optional nillable	List of index values presented as a string list.
≡ IndexValue	xs:string	optional unbounded nillable
■ AllRowsReturned	xs:boolean	optional	indicate if all rows were returned or the maximum hitcount was exceeded

Legend:

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