Warehouse Open Lot Extract RTR Example
Simple WRHSOPENLOTEXTRACT Run Task Request, Common Filter Only
<EagleML
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:type="RunTaskRequestSync"
eaglemlType="RunTaskRequest"
eaglemlVersion="2.0">
<header>
<messageId>CC59ADD40E1E069</messageId>
<sentBy>http://www.client.com</sentBy>
<sendTo>http://www.eagleinvsys.com/eagle_ml-2-0_default_cm_control_message</sendTo>
<replyTo>http://www.client.com/Eagle Control Messages</replyTo>
</header>
<taskIdentifier>
<correlationId>WRHSOPENLOTEXTRACT_2</correlationId>
<businessTaskId>WRHSOPENLOTEXTRACT_2</businessTaskId>
</taskIdentifier>
<taskTypeEnum>LOAD</taskTypeEnum>
<taskParameters>
<taskParameter>
<name>ActionType</name>
<dataType>S</dataType>
<value>EXTRACT</value>
</taskParameter>
<taskParameter>
<name>StreamName</name>
<dataType>S</dataType>
<value>eagle_ml-2-0_default_out_q</value>
</taskParameter>
<taskParameter>
<name>FeedType</name>
<dataType>S</dataType>
<value>WRHSOPENLOTEXTRACT</value>
</taskParameter>
<taskParameter>
<name>maxrows</name>
<dataType>S</dataType>
<value>100000</value>
</taskParameter>
</taskParameters>
</EagleML>
Typical WRHSOPENLOTBROKERROLLUPEXTRACT Run Task Request with an EntityId Filter, Effective Date Range Filter and a GroupBy Task Parameter
<EagleML
xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:type="RunTaskRequest"
eaglemlVersion="2-0"
xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd"
eaglemlType="RunTaskRequest">
<header>
<messageId>B612FI94HMMCQXBQ</messageId>
<sentBy>http://www.eagleinvsys.com</sentBy>
<sendTo>http://www.eagleinvsys.com</sendTo>
<creationTimestamp></creationTimestamp>
<expiryTimeStamp></expiryTimeStamp>
<expiryLoadFlag></expiryLoadFlag>
</header>
<taskIdentifier>
<processingSequenceNumber></processingSequenceNumber>
<correlationId>BT140962_part_both_011</correlationId>
<businessTaskId>BT140962_WHR_OLOT_ROLL_UP_EXTRACT_both_partitions</businessTaskId>
</taskIdentifier>
<taskTypeEnum>LOAD</taskTypeEnum>
<taskParameters>
<taskParameter>
<name>ActionType</name>
<dataType>S</dataType>
<value>EXTRACT</value>
</taskParameter>
<taskParameter>
<name>StreamName</name>
<dataType>S</dataType>
<value>eagle_ml-2-0_default_out_q</value>
</taskParameter>
<taskParameter>
<name>FeedType</name>
<dataType>S</dataType>
<value>WRHSOPENLOTBROKERROLLUPEXTRACT</value>
</taskParameter>
<taskParameter>
<name>fromeffectivedate</name>
<dataType>S</dataType>
<value>2016-08-16</value>
</taskParameter>
<taskParameter>
<name>fromeffectivedate</name>
<dataType>S</dataType>
<value>2016-09-16</value>
</taskParameter>
<taskParameter>
<name>entityselectiontype</name>
<dataType>S</dataType>
<value>EntityID</value>
</taskParameter>
<taskParameter>
<name>entityselectionvalue</name>
<dataType>S</dataType>
<value>BT764SP1,BT764SP2</value>
</taskParameter>
<taskParameter>
<name>ExcludeSecurityAlias</name>
<dataType>S</dataType>
<value>N</value>
</taskParameter>
<taskParameter>
<name>ExtractNamePattern</name>
<dataType>S</dataType>
<value>BT140962_ROLLUP_EXTRACT_part_both</value>
</taskParameter>
<taskParameter>
<name>GroupBy</name>
<dataType>S</dataType>
<value>POSITION.ENTITY_ID,POSITION.EFFECTIVE_DATE,LOT_LEVEL_POSITION.SECURITY_ALIAS,LOT_LEVEL_POSITION.BROKER_CODE,LOT_LEVEL_POSITION.CURRENCY</value>
</taskParameter>
<taskParameter>
<name>maxrows</name>
<dataType>S</dataType>
<value>10000</value>
</taskParameter>
<taskParameter>
<name>QueryProfileName</name>
<dataType>S</dataType>
<value>my_profile</value>
</taskParameter>
</taskParameters>
</EagleML>
RTR for a More Detailed Extract, Will Include Full Entity Properties Model
<EagleML
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:type="RunTaskRequestSync"
eaglemlVersion="2.0"
eaglemlType="RunTaskRequest">
<header>
<messageId>B33663B75403AA6</messageId>
<sentBy>http://www.client.com</sentBy>
<sendTo>http://www.eagleinvsys.com/eagle_ml-2-0_default_cm_control_message</sendTo>
<replyTo>http://www.client.com/Eagle Control Messages</replyTo>
</header>
<taskIdentifier>
<correlationId>WIKI_TEST001</correlationId>
<businessTaskId>WIKI_TEST001</businessTaskId>
</taskIdentifier>
<taskTypeEnum>LOAD</taskTypeEnum>
<taskParameters>
<taskParameter>
<name>ActionType</name>
<dataType>S</dataType>
<value>EXTRACT</value>
</taskParameter>
<taskParameter>
<name>StreamName</name>
<dataType>S</dataType>
<value>eagle_ml-2-0_default_out_q</value>
</taskParameter>
<taskParameter>
<name>FeedType</name>
<dataType>S</dataType>
<value>WRHSOPENLOTEXTRACT</value>
</taskParameter>
<taskParameter>
<name>IncludeExtendedDetails</name>
<dataType>S</dataType>
<value>ALL</value>
</taskParameter>
<taskParameter>
<name>maxrows</name>
<dataType>S</dataType>
<value>10</value>
</taskParameter>
</taskParameters>
</EagleML>