10Sample XML for Siebel EAI Effective Dating Operations
Sample XML for Siebel EAI Effective Dating Operations
This chapter provides sample XML for Siebel Enterprise Applications Integration (Siebel EAI) effective dating operations. It includes the following topics:
About Siebel EAI Effective Dating Operations
The Siebel Enterprise Applications Integration (Siebel EAI) effective dating framework allows access to effective dating data through various Siebel EAI communication mechanisms. You can use the typical query, insert, update, synch, and so on operations to manipulate effective dating enabled data. For more information about the Siebel effective dating feature, see Integration Platform Technologies: Siebel Enterprise Application Integration.
Related Topics
Sample XML for Field-Related Siebel EAI Effective Dating Operations
Sample XML for Link-Related Siebel EAI Effective Dating Operations
Sample XML for Field-Related Siebel EAI Effective Dating Operations
This topic provides sample input and output XML for field-related Siebel Enterprise Applications Integration (Siebel EAI) effective dating operations. It includes the following information:
Insert Field-Related Operations
The following code shows sample input and output XML for field-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> <hous:ListOfHouseholdInterface> <hous:Household> <hous:Category>Gold</hous:Category> <hous:CurrencyCode>USD</hous:CurrencyCode> <hous:EDListOfHouseholdName> <hous:HouseholdName EDStartDate="04/10/2012" EDEndDate="04/20/2012">Adam</hous:HouseholdName> <hous:HouseholdName>Becham</hous:HouseholdName> </hous:EDListOfHouseholdName> <hous:HouseholdId>ASDQ-1264</hous:HouseholdId> <hous:Income>47751</hous:Income> <hous:PhoneNumber>6504234234</hous:PhoneNumber> <hous:Segment>White Collar</hous:Segment> <hous:Status>Active</hous:Status> <hous:Type>Single</hous:Type> </hous:Household> </hous:ListOfHouseholdInterface> <asi:StatusObject>?</asi:StatusObject> </asi:SiebelHouseholdInsert_Input> </soapenv:Body> </soapenv:Envelope>
<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>ASDQ-1264</HouseholdId> <IntegrationId/> </Household> </ListOfHouseholdInterface> </ns:SiebelHouseholdInsert_Output> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
Query By Id Field-Related Operations
The following code shows sample input and output XML for field-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>1-EKCK</asi:PrimaryRowId> </asi:SiebelHouseholdQueryById_Input> </soapenv:Body> </soapenv:Envelope>
<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>Gold</Category> <CurrencyCode>USD</CurrencyCode> <FaxNumber/> <HouseholdId>1-EKCK</HouseholdId> <HouseholdWealth/> <Income/> <IntegrationId/> <PhoneNumber>6504234234</PhoneNumber> <Revenue>1500</Revenue> <Segment>White Collar</Segment> <Status>Active</Status> <Type>Single</Type> <ListOfRelatedContact> <RelatedContact IsPrimaryMVG="Y"> <ContactIntegrationId/> <MiddleName>B.</MiddleName> <PersonUId>1-D4U9</PersonUId> <PersonalContact>N</PersonalContact> <DateEnteredHousehold>11/12/2001 17:30:29</DateEnteredHousehold> <DateExitedHousehold/> <PrimaryOrganizationId>1-19T</PrimaryOrganizationId> <Relationship>Head</Relationship> <EDListOfFirstName> <FirstName EDEndDate="" EDStartDate="11/08/2001">John</FirstName> </EDListOfFirstName> <EDListOfLastName> <LastName EDEndDate="" EDStartDate="11/08/2001">Devine</LastName> </EDListOfLastName> </RelatedContact> </ListOfRelatedContact> <ListOfRelatedOrganization> <RelatedOrganization IsPrimaryMVG="Y"> <OrganizationName>Millennium Retail Finance Services RF ENU</ OrganizationName> <OrganizationId>1-19T</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> <EDListOfHouseholdName> <HouseholdName EDEndDate="" EDStartDate="11/12/2001">Devine - San Mateo </HouseholdName> </EDListOfHouseholdName> <EDListOfHouseholdSize> <HouseholdSize EDEndDate="" EDStartDate="11/12/2001">1</HouseholdSize> </EDListOfHouseholdSize> </Household> </ListOfHouseholdInterface> </ns:SiebelHouseholdQueryById_Output> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
Query By Example Field-Related Operations
The following code show sample input and output XML for field-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> <hous:EDListOfHouseholdName> <HouseholdName EDEndDate="04/20/2012" EDStartDate="04/10/2012"></HouseholdName> </hous:EDListOfHouseholdName> <HouseholdId>ASDQ-1264</HouseholdId> </hous:Household> </hous:ListOfHouseholdInterface> </asi:SiebelHouseholdQueryByExample_Input> </soapenv:Body> </soapenv:Envelope>
<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>Gold</Category> <CurrencyCode>USD</CurrencyCode> <FaxNumber/> <HouseholdId>ASDQ-1264</HouseholdId> <HouseholdWealth/> <Income>47751</Income> <IntegrationId/> <PhoneNumber>6504234234</PhoneNumber> <Revenue/> <Segment>White Collar</Segment> <Status>Active</Status> <Type>Single</Type> <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</Position Division> <PositionId>0-5220</PositionId> <PositionIntegrationId/> <Login>SADMIN</Login> RelatedSalesRep> </ListOfRelatedSalesRep> <EDListOfHouseholdName> <HouseholdName EDEndDate="04/20/2012" EDStartDate="04/10/2012">Adam</HouseholdName> </EDListOfHouseholdName> <EDListOfHouseholdSize> <HouseholdSize EDEndDate="04/19/2012"" EDStartDate="04/10/2012">5</HouseholdSize> <HouseholdSize EDEndDate="" EDStartDate="04/20/2012">7</HouseholdSize> </EDListOfHouseholdSize> </Household> </ListOfHouseholdInterface> </ns:SiebelHouseholdQueryByExample_Output> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
Delete Field-Related Operations
The following code shows sample input and output XML for field-related DELETE 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:SiebelHouseholdDelete_Input> <hous:ListOfHouseholdInterface> <hous:Household> <hous:EDListOfHouseholdName/> <HouseholdId>ASDQ-1264</HouseholdId> </hous:Household> </hous:ListOfHouseholdInterface> </asi:SiebelHouseholdDelete_Input> </soapenv:Body> </soapenv:Envelope>
<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:SiebelHouseholdDelete_Output xmlns:ns="http://example.com/asi/"> <ListOfHouseholdInterface xmlns="http://www.example.com/xml/ Household%20Interface"> <Household operation="delete"> <HouseholdId>ASDQ-1264</HouseholdId> <IntegrationId/> </Household> </ListOfHouseholdInterface> </ns:SiebelHouseholdDelete_Output> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
Synchronize Field-Related Operations
The following code shows sample input and output XML for field-related SYNCH operations.
Input
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://example.com/asi/" xmlns:acc="http://www.example.com/xml/ Account%20Interface"> <soapenv:Header/> <soapenv:Body> <asi:SiebelAccountSynchronize_Input> <acc:ListOfAccountInterface> <acc:Account> acc:AccountId>88-30A85</acc:AccountId> <acc:Name>TESTASDP</acc:Name> <acc:ListOfRelatedContact> <acc:RelatedContact> <acc:ContactId>88-30ARL</acc:ContactId> <acc:EDListOfFirstName> <acc:FirstName EDStartDate="04/01/2012" EDEndDate="">John</acc:FirstName> </acc:EDListOfFirstName> <acc:EDListOfLastName> <acc:LastName EDStartDate="04/01/2012" EDEndDate=""> Steven</acc:LastName> </acc:EDListOfLastName> </acc:RelatedContact> </acc:ListOfRelatedContact> </acc:Account> <acc:Account> <acc:AccountId>ASDQ_TY2</acc:AccountId> <acc:Name>TESTASDT</acc:Name> <acc:ListOfRelatedContact> <acc:RelatedContact> <acc:ContactId>ASDQ_TC2</acc:ContactId> <acc:EDListOfFirstName> <acc:FirstName EDStartDate="04/25/2012" EDEndDate="">Sam</acc:FirstName> </acc:EDListOfFirstName> <acc:EDListOfLastName> <acc:LastName EDStartDate="04/25/2012" EDEndDate="">Vincent</acc:LastName> </acc:EDListOfLastName> </acc:RelatedContact> </acc:ListOfRelatedContact> </acc:Account> </acc:ListOfAccountInterface> </asi:SiebelAccountSynchronize_Input> </soapenv:Body> </soapenv:Envelope>
<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:SiebelAccountSynchronize_Output xmlns:ns="http://example.com/asi/"> <ListOfAccountInterface xmlns="http://www.example.com/xml/ Account%20Interface"> <Account operation="update"> <AccountId>88-30A85</AccountId> <IntegrationId/> </Account> <Account operation="insert"> <AccountId>88-30GK4</AccountId> <IntegrationId/> </Account> </ListOfAccountInterface> </ns:SiebelAccountSynchronize_Output> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
Upsert Field-Related Operations
The following code shows sample input and output XML for field-related UPSERT operations.
Input
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:asi="http://example.com/asi/" xmlns:acc="http://www.example.com/xml/ Account%20Interface"> <soapenv:Header/> <soapenv:Body> <asi:SiebelAccountInsertOrUpdate_Input> <acc:ListOfAccountInterface> <acc:Account> <acc:AccountId>88-30A85</acc:AccountId> <acc:Name>TESTASDP</acc:Name> <acc:ListOfRelatedContact> <acc:RelatedContact> <acc:ContactId>88-30ARL</acc:ContactId> <acc:EDListOfFirstName> <acc:FirstName EDStartDate="04/01/2012" EDEndDate="">John</acc:FirstName> </acc:EDListOfFirstName> <acc:EDListOfLastName> <acc:LastName EDStartDate="04/01/2012" EDEndDate="">Steven</acc:LastName> </acc:EDListOfLastName> </acc:RelatedContact> </acc:ListOfRelatedContact> </acc:Account> <acc:Account> <acc:AccountId>ASDQ_TY4</acc:AccountId> <acc:Name>TESTASDY</acc:Name> <acc:ListOfRelatedContact> <acc:RelatedContact> <acc:ContactId>ASDQ_TC4</acc:ContactId> <acc:EDListOfFirstName> <acc:FirstName EDStartDate="04/25/2012" EDEndDate="">Louis</acc:FirstName> </acc:EDListOfFirstName> <acc:EDListOfLastName> <acc:LastName EDStartDate="04/25/2012" EDEndDate="">George</acc:LastName> </acc:EDListOfLastName> </acc:RelatedContact> </acc:ListOfRelatedContact> </acc:Account> </acc:ListOfAccountInterface> <!--Optional:--> <asi:StatusObject>?</asi:StatusObject> </asi:SiebelAccountInsertOrUpdate_Input> </soapenv:Body> </soapenv:Envelope>
<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:SiebelAccountInsertOrUpdate_Output xmlns:ns="http://example.com/asi/"> <ListOfAccountInterface xmlns="http://www.example.com/xml/ Account%20Interface"> <Account operation="update"> <AccountId>88-30A85</AccountId> <IntegrationId/> </Account> <Account operation="insert"> <AccountId>88-30HDZ</AccountId> <IntegrationId/> </Account> </ListOfAccountInterface> </ns:SiebelAccountInsertOrUpdate_Output> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
About Siebel EAI Effective Dating Operations
Sample XML for Link-Related 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:
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>
<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>
Query By Example 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>
<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>
Query By Id 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>
<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>
<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>
<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>
<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>
About Siebel EAI Effective Dating Operations
Sample XML for Field-Related Siebel EAI Effective Dating Operations