Informatica ActiveVOS
- Informatica ActiveVOS 9.2.4.6
- All Products
<avosHost:read name="$default" objectType="contacts"> <avosHost:id>925cdc8b-f8e5-467e-ad1b-9270afb97b8f </avosHost:id> <avosHost:field>FirstName</avosHost:field> <avosHost:field>LastName</avosHost:field> <avosHost:field>AccountId2.Name</avosHost:field> </avosHost:read>
SELECT c.FirstName, c.BusinessPhone, a.Name FROM contacts c INNER JOIN accounts a on c.AccountId = a.AccountId WHERE c.ContactId = '925cdc8b-f8e5-467e-ad1b-9270afb97b8f'
<types1:readResponse id="925cdc8b-f8e5-467e-ad1b-9270afb97b8f" name="$default" objectType="contacts"> <types1:fieldValue name="FirstName">Mark</types1:fieldValue> <types1:fieldValue name="BusinessPhone">111-222-5555</types1:fieldValue> <types1:fieldValue displayName="true" name="LastName">Ford</types1:fieldValue> <types1:fieldValue name="AccountId2.Name">Acme Inc.</types1:fieldValue> </types1:readResponse>