Show/Hide Toolbars

Therefore Web API Programming Interface 1.0

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

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

 

Get technical information about the table to query in Therefore

 

 

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

 

Element Name

Element Type

Restrictions

Description

â–  parameters

 

 


â–  DataTypeNo

xs:int

mandatory

Number of the dataype the refernces table is defined

 

 

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

 

Element Name

Element Type

Restrictions

Description

â–  parameters

 

 


â–  FolderNo

xs:int

 

Gets the index column name

â–¡ IndexColumn

xs:string

nillable

Gets the index column name

â–¡ Name

xs:string

nillable

Gets the type name of the referenced table datatype

â–¡ TableName

xs:string

nillable

Gets the table name of the referenced table

â–  TypeGroup

xs:int

 

Gets the type group no of the referenced table

â–  TypeNo

xs:int

 

Gets the type no of the referenced table

â–¡ Columns

 

nillable

Gets the index column name

≡ WSRefTableColInfo

 

list nillable


â–¡ ColumnName

xs:string

nillable

Gets the name of the referenced column

â–  Length

xs:int

 

Gets the length of the referenced column

â–  Type

xs:int

 

Gets the type of the referenced column

 

 

 

Legend:

 

â– 

Not nillable element.

â–¡

Nillable element.

≡

List of elements.

Bold

Mandatory element.

 

 

© 2023 Therefore Corporation, all rights reserved.