Show/Hide Toolbars

Therefore Web API Programming Interface 1.0

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:

 

â– 

Not nillable element.

â–¡

Nillable element.

≡

List of elements.

Bold

Mandatory element.

 

 

© 2023 Therefore Corporation, all rights reserved.