|
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
| 
