Request Tables
functionID = 18
Using this function you can fetch Tables in XML format out of the server.
You should send the following XML document to the server:
<softrulestcpframe>
<softrules>
<header>
<functionid>18</functionid>
<datasetid>1</datasetid>
<configid>2700</configid>
<inadapter>AFD</inadapter>
<outadapter>AFD</outadapter>
<parameters>
<parameter>
<name>ConfigID</name>
<value>2700</value>
</parameter>
<parameter>
<name>TableID</name>
<value>13</value>
</parameter>
</parameters>
</header>
</softrules>
</softrulestcpframe>
This contains 2 parameters: ConfigID and TableID. The ConfigID holds the ID of the Local Configuration and Table ID holds the ID of the Table requested.
Send this to the SoftRules® Server using the following command:
string TableXml = SendXML(<xml>, TCPPort);
This will be the response:
<?xml version="1.0" encoding="utf-8"?>
<Table>
<ID>13</ID>
<DisplayIndex>13</DisplayIndex>
<Include>False</Include>
<IncludeFileName/>
<Description>VE: Afsluitprovisie</Description>
<Hash/>
<Locked>False</Locked>
<Versions>
<Version>
<VersionID>1</VersionID>
<IndexElement>*_ENTITEI</IndexElement>
<IndexElementAttributes/>
<RoundToNearest>False</RoundToNearest>
<RoundToHighest>False</RoundToHighest>
<RoundToLowest>False</RoundToLowest>
<Interpolate>False</Interpolate>
<Extrapolate>False</Extrapolate>
<Contains>False</Contains>
<NumberOfRows>3</NumberOfRows>
<MatchFoundElementname/>
<MatchFoundElementAttributes/>
<Columns>
<Column>
<ID>0</ID>
<Expression>
<Conditions/>
<StartValue>True</StartValue>
<Description/>
</Expression>
<ElementName/>
<AltPath/>
<Disable>False</Disable>
<WriteTextValueText>False</WriteTextValueText>
<Attributes/>
<RangeTo>False</RangeTo>
<Values>
<Value>DA</Value>
<Value>DJ</Value>
<Value>OD</Value>
</Values>
</Column>
<Column>
<ID>0</ID>
<Expression>
<Conditions/>
<StartValue>True</StartValue>
<Description/>
</Expression>
<ElementName>*_VMAPRC</ElementName>
<AltPath/>
<Disable>False</Disable>
<WriteTextValueText>False</WriteTextValueText>
<Attributes/>
<RangeTo>False</RangeTo>
<Values>
<Value>0</Value>
<Value>0</Value>
<Value>0</Value>
</Values>
</Column>
<Column>
<ID>0</ID>
<Expression>
<Conditions>
<Condition>
<LogOperator>AND</LogOperator>
<Operator>EQUAL</Operator>
<LeftOperand>
<Value>*_ENTITEI</Value>
<Attributes/>
<AltPath>..</AltPath>
<ValueType>ELEMENTNAME</ValueType>
</LeftOperand>
<RightOperand>
<Value>PP</Value>
<Attributes/>
<AltPath/>
<ValueType>CONSTANT</ValueType>
</RightOperand>
</Condition>
<Condition>
<LogOperator>AND</LogOperator>
<Operator>EQUAL</Operator>
<LeftOperand>
<Value>PP_BRANCHE</Value>
<Attributes/>
<AltPath>..</AltPath>
<ValueType>ELEMENTNAME</ValueType>
</LeftOperand>
<RightOperand>
<Value>060</Value>
<Attributes/>
<AltPath/>
<ValueType>CONSTANT</ValueType>
</RightOperand>
</Condition>
<Condition>
<LogOperator>AND</LogOperator>
<Operator>EQUAL</Operator>
<LeftOperand>
<Value>PP_CDUUMND</Value>
<Attributes/>
<AltPath>..</AltPath>
<ValueType>ELEMENTNAME</ValueType>
</LeftOperand>
<RightOperand>
<Value>60</Value>
<Attributes/>
<AltPath/>
<ValueType>CONSTANT</ValueType>
</RightOperand>
</Condition>
</Conditions>
<StartValue>True</StartValue>
<Description/>
</Expression>
<ElementName>*_VMAPRC</ElementName>
<AltPath/>
<Disable>False</Disable>
<WriteTextValueText>False</WriteTextValueText>
<Attributes/>
<RangeTo>False</RangeTo>
<Values>
<Value>35</Value>
<Value>35</Value>
<Value/>
</Values>
</Column>
<Column>
<ID>0</ID>
<Expression>
<Conditions>
<Condition>
<LogOperator>AND</LogOperator>
<Operator>EQUAL</Operator>
<LeftOperand>
<Value>*_ENTITEI</Value>
<Attributes/>
<AltPath/>
<ValueType>ELEMENTNAME</ValueType>
</LeftOperand>
<RightOperand>
<Value>PP</Value>
<Attributes/>
<AltPath/>
<ValueType>CONSTANT</ValueType>
</RightOperand>
</Condition>
<Condition>
<LogOperator>AND</LogOperator>
<Operator>EQUAL</Operator>
<LeftOperand>
<Value>*_CDUUMND</Value>
<Attributes/>
<AltPath/>
<ValueType>ELEMENTNAME</ValueType>
</LeftOperand>
<RightOperand>
<Value>60</Value>
<Attributes/>
<AltPath/>
<ValueType>CONSTANT</ValueType>
</RightOperand>
</Condition>
<Condition>
<LogOperator>AND</LogOperator>
<Operator>EQUAL</Operator>
<LeftOperand>
<Value>*_BRANCHE</Value>
<Attributes/>
<AltPath/>
<ValueType>ELEMENTNAME</ValueType>
</LeftOperand>
<RightOperand>
<Value>010</Value>
<Attributes/>
<AltPath/>
<ValueType>CONSTANT</ValueType>
</RightOperand>
</Condition>
</Conditions>
<StartValue>True</StartValue>
<Description/>
</Expression>
<ElementName>*_VMAPRC</ElementName>
<AltPath/>
<Disable>False</Disable>
<WriteTextValueText>False</WriteTextValueText>
<Attributes/>
<RangeTo>False</RangeTo>
<Values>
<Value/>
<Value/>
<Value>35</Value>
</Values>
</Column>
</Columns>
<IndexElementAltPath/>
<MatchElementAltPath/>
<RepeatType>SimpleType</RepeatType>
<DefaultRow>False</DefaultRow>
<DateChanged>0</DateChanged>
</Version>
</Versions>
</Table>
