XML Reference: Siebel Enterprise Application Integration > Sample XML for Siebel EAI Effective Dating Operations >
Sample XML for Link-Related Siebel EAI Effective Dating Operations
This topic provides sample input and output XML for link-related Siebel Enterprise Applications Integration (Siebel EAI) effective dating operations. It includes the following information:
NOTE: Bold text in the following code samples indicates syntax specific to Siebel EAI effective dating functionality.
Insert Link-Related Operations
The following code shows sample input and output XML for link-related INSERT operations. Input
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://example.com/asi/" xmlns:hous="http://www.example.com/xml/Household%20Interface">
<soapenv:Header/> <soapenv:Body>
<asi:SiebelHouseholdInsert_Input>
<asi:StatusObject/>
<hous:ListOfHouseholdInterface> <hous:Household operation="insert"> <hous:HouseholdName>Aaron12</hous:HouseholdName> <hous:HouseholdId>1-COQ1</hous:HouseholdId>
<hous:ListOfRelatedContact> <hous:RelatedContact EDStartDate="12/12/2011" EDEndDate=""> <ContactId>0V-19GBUM</ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2010" EDEndDate="12/11/2011"> <ContactId>0V-19GBUM</ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2003" EDEndDate="12/12/2004"> <ContactId>0V-18PLL2</ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2001" EDEndDate="12/12/2002"> <ContactId>0V-18PLL2</ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2005" EDEndDate="12/12/2006"> <ContactId>0V-18PMMD</ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2007" EDEndDate="12/12/2008"> <ContactId>1-AJ3J</ContactId> </hous:RelatedContact> </hous:ListOfRelatedContact>
</hous:Household> </hous:ListOfHouseholdInterface>
</asi:SiebelHouseholdInsert_Input>
</soapenv:Body> </soapenv:Envelope>
Output
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<ns:SiebelHouseholdInsert_Output xmlns:ns="http://example.com/asi/">
<ListOfHouseholdInterface xmlns="http://www.example.com/xml/Household%20Interface"> <Household operation="insert"> <HouseholdId>1-COQ1</HouseholdId> <IntegrationId/> </Household> </ListOfHouseholdInterface>
</ns:SiebelHouseholdInsert_Output>
</SOAP-ENV:Body> </SOAP-ENV:Envelope>
QueryByExample Link-Related Operations
The following code shows sample input and output XML for link-related QueryByExample operations. Input
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://example.com/asi/" xmlns:hous="http://www.example.com/xml/Household%20Interface">
<soapenv:Header/> <soapenv:Body>
<asi:SiebelHouseholdQueryByExample_Input>
<hous:ListOfHouseholdInterface> <hous:Household operation="?"> <hous:HouseholdId>1-COQ1</hous:HouseholdId> <hous:ListOfRelatedContact> <hous:RelatedContact EDStartDate="1/1/2000" EDEndDate=""> <hous:ContactId/> </hous:RelatedContact> </hous:ListOfRelatedContact> </hous:Household> </hous:ListOfHouseholdInterface>
</asi:SiebelHouseholdQueryByExample_Input>
</soapenv:Body> </soapenv:Envelope>
Output
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<ns:SiebelHouseholdQueryByExample_Output xmlns:ns="http://example.com/asi/">
<ListOfHouseholdInterface xmlns="http://www.example.com/xml/Household%20Interface">
<Household>
<Category/> <CurrencyCode>USD</CurrencyCode> <FaxNumber/> <HouseholdName>Aaron12</HouseholdName> <HouseholdId>1-COQ1</HouseholdId> <HouseholdSize/> <HouseholdWealth/> <Income/> <IntegrationId/> <PhoneNumber/> <Revenue/> <Segment/> <Status>Active</Status> <Type/> <ListOfRelatedContact>
<RelatedContact EDEndDate="12/12/2004" IsPrimaryMVG="N" EDStartDate="12/12/2003"> <ContactIntegrationId/> <FirstName>ANDREW</FirstName> <LastName>LAM</LastName> <MiddleName/> <PersonUId>0V-18PLL2</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>0V-18PLL2</ContactId> <DateEnteredHousehold>05/16/2012 05:18:50</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>0-R9NH</PrimaryOrganizationId> <Relationship/> </RelatedContact>
<RelatedContact EDEndDate="12/12/2001" IsPrimaryMVG="N" EDStartDate="12/12/2002"> <ContactIntegrationId/> <FirstName>ANDREW</FirstName> <LastName>LAM</LastName> <MiddleName/> <PersonUId>0V-18PLL2</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>0V-18PLL2</ContactId> <DateEnteredHousehold>05/16/2012 05:18:50< /DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>0-R9NH</PrimaryOrganizationId> <Relationship/> </RelatedContact>
<RelatedContact EDEndDate="" IsPrimaryMVG="Y" EDStartDate="12/12/2011"> <ContactIntegrationId/> <FirstName>VARUN</FirstName> <LastName>AJWANI</LastName> <MiddleName/> <PersonUId>0V-19GBUM</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>0V-19GBUM</ContactId> <DateEnteredHousehold>05/16/2012 05:18:50</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>0-R9NH</PrimaryOrganizationId> <Relationship/> </RelatedContact>
<RelatedContact EDEndDate="12/11/2010" IsPrimaryMVG="Y" EDStartDate="12/12/2010"> <ContactIntegrationId/> <FirstName>VARUN</FirstName> <LastName>AJWANI</LastName> <MiddleName/> <PersonUId>0V-19GBUM</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>0V-19GBUM</ContactId> <DateEnteredHousehold>05/16/2012 05:18:50</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>0-R9NH</PrimaryOrganizationId> <Relationship/> </RelatedContact>
<RelatedContact EDEndDate="12/12/2006" IsPrimaryMVG="N" EDStartDate="12/12/2005"> <ContactIntegrationId/> <FirstName>SARVI</FirstName> <LastName>ANANDAN</LastName> <MiddleName/> <PersonUId>0V-18PMMD</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>0V-18PMMD</ContactId> <DateEnteredHousehold>05/16/2012 05:18:50</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>0-R9NH</PrimaryOrganizationId> <Relationship/> </RelatedContact>
<RelatedContact EDEndDate="12/12/2008" IsPrimaryMVG="N" EDStartDate="12/12/2007"> <ContactIntegrationId/> <FirstName>Felix</FirstName> <LastName>Aaron</LastName> <MiddleName>Q</MiddleName> <PersonUId>1-AJ3J</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>1-AJ3J</ContactId> <DateEnteredHousehold>05/16/2012 05:18:50</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>88-14P0K</PrimaryOrganizationId> <Relationship/> </RelatedContact>
</ListOfRelatedContact>
<ListOfRelatedOrganization> <RelatedOrganization IsPrimaryMVG="Y"> <OrganizationName>Default Organization</OrganizationName> <OrganizationId>0-R9NH</OrganizationId> <OrganizationIntegrationId/> </RelatedOrganization> </ListOfRelatedOrganization>
<ListOfRelatedSalesRep> <RelatedSalesRep IsPrimaryMVG="Y"> <Position>Siebel Administrator</Position> <PositionDivision>Siebel Administration</PositionDivision> <PositionId>0-5220</PositionId> <PositionIntegrationId/> <Login>SADMIN</Login> </RelatedSalesRep> </ListOfRelatedSalesRep>
</Household>
</ListOfHouseholdInterface>
</ns:SiebelHouseholdQueryByExample_Output>
</SOAP-ENV:Body> </SOAP-ENV:Envelope>
QueryById Link-Related Operations
The following code shows sample input and output XML for link-related QueryById operations. Input
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://example.com/asi/">
<soapenv:Header/> <soapenv:Body>
<asi:SiebelHouseholdQueryById_Input> <asi:PrimaryRowId>88-30D3R</asi:PrimaryRowId> </asi:SiebelHouseholdQueryById_Input>
</soapenv:Body> </soapenv:Envelope>
Output
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<ns:SiebelHouseholdQueryById_Output xmlns:ns="http://example.com/asi/">
<ListOfHouseholdInterface xmlns="http://www.example.com/xml/Household%20Interface">
<Household>
<Category/> <CurrencyCode>USD</CurrencyCode> <FaxNumber/> <HouseholdName>Aul_HouseHold</HouseholdName> <HouseholdId>1-EKB3T1</HouseholdId> <HouseholdSize/> <HouseholdWealth/> <Income/> <IntegrationId/> <PhoneNumber/> <Revenue/> <Segment/> <Status>Active</Status> <Type/>
<ListOfRelatedContact> <RelatedContact EDEndDate="" IsPrimaryMVG="Y" EDStartDate="05/16/2012"> <ContactIntegrationId/> <FirstName>VARUN</FirstName> <LastName>AJWANI</LastName> <MiddleName/> <PersonUId>0V-19GBUM</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>0V-19GBUM</ContactId> <DateEnteredHousehold>01/01/1857 00:00:00</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>0-R9NH</PrimaryOrganizationId> <Relationship/> </RelatedContact>
<RelatedContact EDEndDate="" IsPrimaryMVG="N" EDStartDate="05/16/2012"> <ContactIntegrationId/> <FirstName>SARVI</FirstName> <LastName>ANANDAN</LastName> <MiddleName/> <PersonUId>0V-18PMMD</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>0V-18PMMD</ContactId> <DateEnteredHousehold>01/01/1857 00:00:00</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>0-R9NH</PrimaryOrganizationId> <Relationship/> </RelatedContact>
<RelatedContact EDEndDate="" IsPrimaryMVG="N" EDStartDate="05/16/2012"> <ContactIntegrationId/> <FirstName>Felix</FirstName> <LastName>Aaron</LastName> <MiddleName>Q</MiddleName> <PersonUId>1-AJ3J</PersonUId> <PersonalContact>N</PersonalContact> <ContactId>1-AJ3J</ContactId> <DateEnteredHousehold>01/01/1857 00:00:00</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>88-14P0K</PrimaryOrganizationId> <Relationship/> </RelatedContact>
</ListOfRelatedContact>
<ListOfRelatedOrganization> <RelatedOrganization IsPrimaryMVG="Y"> <OrganizationName>Default Organization</OrganizationName> <OrganizationId>0-R9NH</OrganizationId> <OrganizationIntegrationId/> </RelatedOrganization> </ListOfRelatedOrganization>
<ListOfRelatedSalesRep> <RelatedSalesRep IsPrimaryMVG="Y"> <Position>Siebel Administrator</Position> <PositionDivision>Siebel Administration</PositionDivision> <PositionId>0-5220</PositionId> <PositionIntegrationId/> <Login>SADMIN</Login> </RelatedSalesRep> </ListOfRelatedSalesRep>
</Household>
</ListOfHouseholdInterface>
</ns:SiebelHouseholdQueryById_Output>
</SOAP-ENV:Body> </SOAP-ENV:Envelope>
Update Link-Related Operations
The following code shows sample input and output XML for link-related UPDATE operations. Input
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://example.com/asi/" xmlns:hous="http://www.example.com/xml/Household%20Interface">
<soapenv:Header/> <soapenv:Body>
<asi:SiebelHouseholdUpdate_Input>
<asi:StatusObject/>
<hous:ListOfHouseholdInterface> <hous:Household operation="update"> <hous:EDListOfHouseholdName> <hous:HouseholdName>Aaron Household</hous:HouseholdName> </hous:EDListOfHouseholdName> <hous:HouseholdId>1-3W8</hous:HouseholdId> <hous:Type>Single</hous:Type> <hous:ListOfRelatedContact> <hous:RelatedContact EDStartDate="12/12/2011"> <hous:ContactId>1-D4U9</hous:ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2004" EDEndDate="12/12/2005"> <hous:ContactId>0V-18PLP2</hous:ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2002" EDEndDate="12/12/2004"> <hous:ContactId>0V-19GBUM</hous:ContactId> </hous:RelatedContact> </hous:ListOfRelatedContact> </hous:Household> </hous:ListOfHouseholdInterface>
</asi:SiebelHouseholdUpdate_Input>
</soapenv:Body> </soapenv:Envelope>
Output
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<ns:SiebelHouseholdUpdate_Output xmlns:ns="http://example.com/asi/">
<ListOfHouseholdInterface xmlns="http://www.example.com/xml/Household%20Interface"> <Household operation="update"> <HouseholdId>1-3W8</HouseholdId> <IntegrationId/> </Household> </ListOfHouseholdInterface>
</ns:SiebelHouseholdUpdate_Output>
</SOAP-ENV:Body> </SOAP-ENV:Envelope>
Upsert Link-Related Operations
The following code shows sample input and output XML for link-related UPSERT operations. Input
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://example.com/asi/" xmlns:hous="http://www.example.com/xml/Household%20Interface">
<soapenv:Header/>
<soapenv:Body>
<asi:SiebelHouseholdInsertOrUpdate_Input>
<asi:StatusObject/>
<hous:ListOfHouseholdInterface> <hous:Household> <hous:EDListOfHouseholdName> <hous:HouseholdName>A2</hous:HouseholdName> </hous:EDListOfHouseholdName> <hous:HouseholdId>2</hous:HouseholdId> <hous:ListOfRelatedContact> <hous:RelatedContact EDStartDate="12/12/2011"> <hous:ContactId>1-D4U9</hous:ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2004" EDEndDate="12/12/2005"> <hous:ContactId>0V-18PLP2</hous:ContactId> </hous:RelatedContact> <hous:RelatedContact EDStartDate="12/12/2002" EDEndDate="12/12/2004"> <hous:ContactId>0V-19GBUM</hous:ContactId> </hous:RelatedContact> </hous:ListOfRelatedContact>
</hous:Household>
</hous:ListOfHouseholdInterface>
</asi:SiebelHouseholdInsertOrUpdate_Input>
</soapenv:Body> </soapenv:Envelope>
Output
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<ns:SiebelHouseholdInsertOrUpdate_Output xmlns:ns="http://example.com/asi/">
<ListOfHouseholdInterface xmlns="http://www.example.com/xml/Household%20Interface"> <Household operation="insert"> <HouseholdId>2</HouseholdId> <IntegrationId/> </Household> </ListOfHouseholdInterface>
</ns:SiebelHouseholdInsertOrUpdate_Output>
</SOAP-ENV:Body> </SOAP-ENV:Envelope
Synchronize Link-Related Operations
The following code shows sample input and output XML for link-related SYNCH operations. Input
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://example.com/asi/" xmlns:hous="http://www.example.com/xml/Household%20Interface">
<soapenv:Header/> <soapenv:Body>
<asi:SiebelHouseholdSynchronize_Input>
<asi:StatusObject/>
<hous:ListOfHouseholdInterface> <hous:Household> <hous:EDListOfHouseholdName> <hous:HouseholdName>123</hous:HouseholdName> </hous:EDListOfHouseholdName> <hous:HouseholdId>296-5062875</hous:HouseholdId>
<hous:ListOfRelatedContact> <hous:RelatedContact EDStartDate="2/2/2010" EDEndDate="1/1/2011"> <hous:ContactId>04-LLSQ5</hous:ContactId> </hous:RelatedContact> </hous:ListOfRelatedContact> </hous:Household> </hous:ListOfHouseholdInterface>
</asi:SiebelHouseholdSynchronize_Input>
</soapenv:Body> </soapenv:Envelope>
Output
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<ns:SiebelHouseholdSynchronize_Output xmlns:ns="http://example.com.com/asi/">
<ListOfHouseholdInterface xmlns="http://www.example.com/xml/Household%20Interface"> <Household operation="update"> <HouseholdId>296-5062875</HouseholdId> <IntegrationId/> </Household> </ListOfHouseholdInterface>
</ns:SiebelHouseholdSynchronize_Output>
</SOAP-ENV:Body> </SOAP-ENV:Envelope>
Related Topics
About Siebel EAI Effective Dating Operations Sample XML for Field-Related Siebel EAI Effective Dating Operations
|