Therefore Web API Programming Interface 1.0

GetReferencedTableInfo

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	optional	Gets the index column name
□ IndexColumn	xs:string	optional nillable	Gets the index column name
□ Name	xs:string	optional nillable	Gets the type name of the referenced table datatype
□ TableName	xs:string	optional nillable	Gets the table name of the referenced table
■ TypeGroup	xs:int	optional	Gets the type group no of the referenced table
■ TypeNo	xs:int	optional	Gets the type no of the referenced table
□ Columns		optional nillable	Gets the index column name
≡ WSRefTableColInfo		optional unbounded nillable
□ ColumnName	xs:string	optional nillable	Gets the name of the referenced column
■ Length	xs:int	optional	Gets the length of the referenced column
■ Type	xs:int	optional	Gets the type of the referenced column

Legend:

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