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	nillable	Maximum number of rows to return
□ queryConditions		mandatory nillable	The query conditions for different columns to search
≡ WSQueryDependentFieldsDirectCondition		list nillable
□ ColName	xs:string	nillable	Sets the column name to query
■ ColumnType	xs:int		Sets the type of the column to query
□ Condition	xs:string	nillable	Sets the query condition
□ selectColumns		mandatory nillable	The columns to select from the datatype table
≡ SelectColumn	xs:string	list nillable
■ FormNo	xs:int	mandatory	The eForm no in which context the datatype should be searched

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

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

Legend: