Bookshelf Home | Contents | Index | PDF     

XML Reference: Siebel Enterprise Application Integration > Sample XML for 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:

NOTE:  Bold text in the following code samples indicates syntax specific to Siebel EAI effective dating functionality.

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>

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>ASDQ-1264</HouseholdId>
<IntegrationId/>
</Household>
</ListOfHouseholdInterface>

</ns:SiebelHouseholdInsert_Output>

</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

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

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

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

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

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

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

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

Related Topics

About Siebel EAI Effective Dating Operations

Sample XML for Link-Related Siebel EAI Effective Dating Operations

    
XML Reference: Siebel Enterprise Application Integration Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.