Fetch XML field

[Padmini]

Hi ,

Can u anyone help me on the below issue..

I am trying to fetch XML field partysiteId and partyID fields using tExtractXMLField component for the below mentioned XML, but nothing works and please find attached screenshot for the Xpath loop and query i have set.

<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
<env:Header>
<wsa:Action>http://xmlns.oracle.com/apps/crmCommon/salesParties/salesPartiesService//SalesPartyService/createPer...>
<wsa:MessageID>urn:uuid:f0ee78a7-fbc0-4813-9a21-1605a2874d40</wsa:MessageID>
</env:Header>
<env:Body>
<ns0:createPersonPartyResponse xmlns:ns0="http://xmlns.oracle.com/apps/crmCommon/salesParties/salesPartiesService/types/">
<ns1:result xmlns:ns1="http://xmlns.oracle.com/apps/crmCommon/salesParties/salesPartiesService/types/" xmlns:ns14="http://xmlns.oracle.com/apps/cdm/foundation/parties/groupService/" xmlns:ns3="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns5="http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/" xmlns:ns6="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/" xmlns:ns8="http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/" xmlns:ns11="http://xmlns.oracle.com/apps/cdm/foundation/parties/relationshipService/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns5ersonResult">
<ns5:Value>
<ns5artyId>300000002374605</ns5artyId>
<ns5artyNumber>1010001200127</ns5artyNumber>
<ns5artyName>Jane Does</ns5artyName>
<ns5artyType>PERSON</ns5artyType>
<ns5:ValidatedFlag xsi:nil="true"/>
<ns5:LastUpdatedBy>rahul@ps-ipl.com</ns5:LastUpdatedBy>
<ns5:LastUpdateLogin>5D20E1D8F1D03324E053D07E6D0AD5A1</ns5:LastUpdateLogin>
<ns5:CreationDate>2017-11-04T03:33:18.0Z</ns5:CreationDate>
<ns5:RequestId xsi:nil="true"/>
<ns5:LastUpdateDate>2017-11-04T03:33:18.347Z</ns5:LastUpdateDate>
<ns5:CreatedBy>rahul@ps-ipl.com</ns5:CreatedBy>
<ns5rigSystemReference>Per1010001200127</ns5rigSystemReference>
<ns5ICCode xsi:nil="true"/>
<ns5:JgzzFiscalCode xsi:nil="true"/>
<ns5ersonFirstName>Jane</ns5ersonFirstName>
<ns5ersonPreNameAdjunct xsi:nil="true"/>
<ns5ersonLastName>Does</ns5ersonLastName>
<ns5ersonMiddleName xsi:nil="true"/>
<ns5ersonTitle xsi:nil="true"/>
<ns5ersonNameSuffix xsi:nil="true"/>
<ns5ersonPreviousLastName xsi:nil="true"/>
<ns5ersonAcademicTitle xsi:nil="true"/>
<ns5:Country>US</ns5:Country>
<ns5:Address2 xsi:nil="true"/>
<ns5:Address1>54332 Main St</ns5:Address1>
<ns5:Address4 xsi:nil="true"/>
<ns5:Address3 xsi:nil="true"/>
<ns5ostalCode xsi:nil="true"/>
<ns5:City>Aurora</ns5:City>
<ns5rovince xsi:nil="true"/>
<ns5tate xsi:nil="true"/>
<ns5:County xsi:nil="true"/>
<ns5tatus>A</ns5tatus>
<ns5:URL xsi:nil="true"/>
<ns5ICCodeType xsi:nil="true"/>
<ns5:EmailAddress xsi:nil="true"/>
<ns5:GSAIndicatorFlag xsi:nil="true"/>
<ns5:LanguageName xsi:nil="true"/>
<ns5:MissionStatement xsi:nil="true"/>
<ns5:CategoryCode xsi:nil="true"/>
<ns5:ThirdPartyFlag xsi:nil="true"/>
<ns5alutation xsi:nil="true"/>
<ns5:CreatedByModule>HZ_WS</ns5:CreatedByModule>
<ns5:CertReasonCode xsi:nil="true"/>
<ns5:CertificationLevel xsi:nil="true"/>
<ns5rimaryPhonePurpose xsi:nil="true"/>
<ns5rimaryPhoneContactPTId xsi:nil="true"/>
<ns5rimaryPhoneCountryCode xsi:nil="true"/>
<ns5rimaryPhoneLineType xsi:nil="true"/>
<ns5rimaryPhoneNumber xsi:nil="true"/>
<ns5rimaryPhoneAreaCode xsi:nil="true"/>
<ns5referredContactMethod xsi:nil="true"/>
<ns5rimaryPhoneExtension xsi:nil="true"/>
<ns5:IdenAddrLocationId>1010001200127</ns5:IdenAddrLocationId>
<ns5rimaryEmailContactPTId xsi:nil="true"/>
<ns5:IdenAddrPartySiteId>300000002374606</ns5:IdenAddrPartySiteId>
<ns5ersonLastNamePrefix xsi:nil="true"/>
<ns5rimaryURLContactPTId xsi:nil="true"/>
<ns5referredName xsi:nil="true"/>
<ns5ersonSecondLastName xsi:nil="true"/>
<ns5referredNameId xsi:nil="true"/>
<ns5referredContactPersonId xsi:nil="true"/>
<ns5:InternalFlag xsi:nil="true"/>
<ns5referredFunctionalCurrency>AED</ns5referredFunctionalCurrency>
<ns5:Gender xsi:nil="true"/>
<ns5:MaritalStatus xsi:nil="true"/>
<ns5:Comments xsi:nil="true"/>
<ns5ateOfBirth xsi:nil="true"/>
<ns5:UserGUID xsi:nil="true"/>
<ns5artyUniqueName>Jane Does</ns5artyUniqueName>
<ns5ourceSystem xsi:nil="true"/>
<ns5ourceSystemReferenceValue xsi:nil="true"/>
<ns5ourceSystemUpdateDate xsi:nil="true"/>
<ns5artySite xmlns:ns10="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/partySite/">
<ns6artySiteId>300000002374606</ns6artySiteId>
<ns6artyId>300000002374605</ns6artyId>
<ns6:LocationId>1010001200127</ns6:LocationId>
<ns6:LastUpdateDate>2017-11-04T03:33:18.264Z</ns6:LastUpdateDate>
<ns6artySiteNumber>1010001200127</ns6artySiteNumber>
<ns6:LastUpdatedBy>rahul@ps-ipl.com</ns6:LastUpdatedBy>
<ns6:CreationDate>2017-11-04T03:33:18.012Z</ns6:CreationDate>
<ns6:CreatedBy>rahul@ps-ipl.com</ns6:CreatedBy>
<ns6:LastUpdateLogin>5D20E1D8F1D03324E053D07E6D0AD5A1</ns6:LastUpdateLogin>
<ns6:RequestId xsi:nil="true"/>
<ns6rigSystemReference>Loc1010001200127</ns6rigSystemReference>
<ns6tartDateActive>2017-10-31</ns6tartDateActive>
<ns6:EndDateActive>4712-12-31</ns6:EndDateActive>
<ns6:Mailstop xsi:nil="true"/>
<ns6:IdentifyingAddressFlag>true</ns6:IdentifyingAddressFlag>
<ns6:Language>US</ns6:Language>
<ns6tatus>A</ns6tatus>
<ns6artySiteName>Home Address1</ns6artySiteName>
<ns6:Addressee xsi:nil="true"/>
<ns6bjectVersionNumber>1</ns6bjectVersionNumber>
<ns6:CreatedByModule>HZ_WS</ns6:CreatedByModule>
<ns6:GlobalLocationNumber xsi:nil="true"/>
<ns6UNSNumberC xsi:nil="true"/>
<ns6:Comments xsi:nil="true"/>
<ns6artySiteType xsi:nil="true"/>
<ns6artyNameDba xsi:nil="true"/>
<ns6artyNameDivision xsi:nil="true"/>
<ns6artyNameLegal xsi:nil="true"/>
<ns6:RelationshipId xsi:nil="true"/>
<ns6artyUsageCode xsi:nil="true"/>
<ns6verallPrimaryFlag>true</ns6verallPrimaryFlag>
<ns6artySiteUse>
<ns6artySiteUseId>300000002374607</ns6artySiteUseId>
<ns6:BeginDate>2017-10-31</ns6:BeginDate>
<ns6:Comments>Home Address1</ns6:Comments>
<ns6:EndDate>4712-12-31</ns6:EndDate>
<ns6artySiteId>300000002374606</ns6artySiteId>
<ns6:LastUpdateDate>2017-11-04T03:33:18.141Z</ns6:LastUpdateDate>
<ns6:RequestId xsi:nil="true"/>
<ns6:LastUpdatedBy>rahul@ps-ipl.com</ns6:LastUpdatedBy>
<ns6:CreationDate>2017-11-04T03:33:18.027Z</ns6:CreationDate>
<ns6:CreatedBy>rahul@ps-ipl.com</ns6:CreatedBy>
<ns6:LastUpdateLogin>5D20E1D8F1D03324E053D07E6D0AD5A1</ns6:LastUpdateLogin>
<ns6:IntegrationKey>x</ns6:IntegrationKey>
<ns6iteUseType>BILL_TO</ns6iteUseType>
<ns6rimaryPerType>Y</ns6rimaryPerType>
<ns6tatus>A</ns6tatus>
<ns6bjectVersionNumber>1</ns6bjectVersionNumber>
<ns6:CreatedByModule>HZ_WS</ns6:CreatedByModule>
</ns6artySiteUse>
</ns5artySite>
<ns5ersonProfile xmlns:ns4="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/person/">
<ns5ersonProfileId>300000002374605</ns5ersonProfileId>
<ns5artyId>300000002374605</ns5artyId>
<ns5ersonName>Jane Does</ns5ersonName>
<ns5:LastUpdateDate>2017-11-04T03:33:18.353Z</ns5:LastUpdateDate>
<ns5:LastUpdatedBy>rahul@ps-ipl.com</ns5:LastUpdatedBy>
<ns5:CreationDate>2017-11-04T03:33:18.057Z</ns5:CreationDate>
<ns5:CreatedBy>rahul@ps-ipl.com</ns5:CreatedBy>
<ns5:LastUpdateLogin>5D20E1D8F1D03324E053D07E6D0AD5A1</ns5:LastUpdateLogin>
<ns5:RequestId xsi:nil="true"/>
<ns5ersonPreNameAdjunct xsi:nil="true"/>
<ns5ersonFirstName>Jane</ns5ersonFirstName>
<ns5ersonMiddleName xsi:nil="true"/>
<ns5ersonLastName>Does</ns5ersonLastName>
<ns5ersonNameSuffix xsi:nil="true"/>
<ns5ersonTitle xsi:nil="true"/>
<ns5ersonAcademicTitle xsi:nil="true"/>
<ns5ersonPreviousLastName xsi:nil="true"/>
<ns5ersonInitials xsi:nil="true"/>
<ns5:JgzzFiscalCode xsi:nil="true"/>
<ns5ateOfBirth xsi:nil="true"/>
<ns5laceOfBirth xsi:nil="true"/>
<ns5ateOfDeath xsi:nil="true"/>
<ns5:Gender xsi:nil="true"/>
<ns5eclaredEthnicity xsi:nil="true"/>
<ns5:MaritalStatus xsi:nil="true"/>
<ns5:MaritalStatusEffectiveDate xsi:nil="true"/>
<ns5ersonalIncomeAmount xsi:nil="true"/>
<ns5:RentOwnInd xsi:nil="true"/>
<ns5:LastKnownGPS xsi:nil="true"/>
<ns5:EffectiveStartDate>2017-11-04</ns5:EffectiveStartDate>
<ns5:EffectiveEndDate>4712-12-31</ns5:EffectiveEndDate>
<ns5:InternalFlag xsi:nil="true"/>
<ns5tatus>A</ns5tatus>
<ns5:CreatedByModule>HZ_WS</ns5:CreatedByModule>
<ns5eceasedFlag>false</ns5eceasedFlag>
<ns5:Comments xsi:nil="true"/>
<ns5ersonLastNamePrefix xsi:nil="true"/>
<ns5ersonSecondLastName xsi:nil="true"/>
<ns5referredFunctionalCurrency>AED</ns5referredFunctionalCurrency>
<ns5rigSystem>XSTORE</ns5rigSystem>
<ns5rigSystemReference>Per1010001200127</ns5rigSystemReference>
<ns5:EffectiveSequence>1</ns5:EffectiveSequence>
<ns5:HeadOfHouseholdFlag xsi:nil="true"/>
<ns5:HouseholdIncomeAmount xsi:nil="true"/>
<ns5:HouseholdSize xsi:nil="true"/>
<ns5:EffectiveLatestChange>Y</ns5:EffectiveLatestChange>
<ns5uffixOverriddenFlag>false</ns5uffixOverriddenFlag>
<ns5:UniqueNameSuffix xsi:nil="true"/>
<ns5:CorpCurrencyCode>USD</ns5:CorpCurrencyCode>
<ns5:CurcyConvRateType>Corporate</ns5:CurcyConvRateType>
<ns5:CurrencyCode>USD</ns5:CurrencyCode>
<ns5artyNumber>1010001200127</ns5artyNumber>
<ns5alutation xsi:nil="true"/>
<ns5:CertReasonCode xsi:nil="true"/>
<ns5:CertificationLevel xsi:nil="true"/>
<ns5referredContactMethod xsi:nil="true"/>
<ns5referredContactPersonId xsi:nil="true"/>
<ns5rimaryAddressLine1>54332 Main St</ns5rimaryAddressLine1>
<ns5rimaryAddressLine2 xsi:nil="true"/>
<ns5rimaryAddressLine3 xsi:nil="true"/>
<ns5rimaryAddressLine4 xsi:nil="true"/>
<ns5:Alias xsi:nil="true"/>
<ns5rimaryAddressCity>Aurora</ns5rimaryAddressCity>
<ns5rimaryAddressCountry>US</ns5rimaryAddressCountry>
<ns5rimaryAddressCounty xsi:nil="true"/>
<ns5rimaryEmailAddress xsi:nil="true"/>
<ns5rimaryFormattedAddress>54332 Main St,AURORA,</ns5rimaryFormattedAddress>
<ns5rimaryFormattedPhoneNumber xsi:nil="true"/>
<ns5rimaryLanguage xsi:nil="true"/>
<ns5artyUniqueName>Jane Does</ns5artyUniqueName>
<ns5rimaryAddressPostalCode xsi:nil="true"/>
<ns5referredContactEmail xsi:nil="true"/>
<ns5referredContactName xsi:nil="true"/>
<ns5referredContactPhone xsi:nil="true"/>
<ns5referredContactURL xsi:nil="true"/>
<ns5referredName xsi:nil="true"/>
<ns5referredNameId xsi:nil="true"/>
<ns5rimaryEmailId xsi:nil="true"/>
<ns5rimaryPhoneAreaCode xsi:nil="true"/>
<ns5rimaryPhoneId xsi:nil="true"/>
<ns5rimaryPhoneCountryCode xsi:nil="true"/>
<ns5rimaryPhoneExtension xsi:nil="true"/>
<ns5rimaryPhoneLineType xsi:nil="true"/>
<ns5rimaryPhoneNumber xsi:nil="true"/>
<ns5rimaryPhonePurpose xsi:nil="true"/>
<ns5rimaryWebId xsi:nil="true"/>
<ns5ronunciation xsi:nil="true"/>
<ns5rimaryAddressProvince xsi:nil="true"/>
<ns5rimaryAddressState xsi:nil="true"/>
<ns5rimaryURL xsi:nil="true"/>
<ns5:ValidatedFlag xsi:nil="true"/>
<ns5rimaryAddressLatitude xsi:nil="true"/>
<ns5rimaryAddressLongitude xsi:nil="true"/>
<ns5rimaryAddressLocationId/>
<ns5:FavoriteContactFlag>false</ns5:FavoriteContactFlag>
<ns5istance xsi:nil="true"/>
<ns5alesAffinityCode xsi:nil="true"/>
<ns5alesBuyingRoleCode xsi:nil="true"/>
<ns5epartmentCode xsi:nil="true"/>
<ns5epartment xsi:nil="true"/>
<ns5:JobTitleCode xsi:nil="true"/>
<ns5:JobTitle xsi:nil="true"/>
<ns5oNotCallFlag>false</ns5oNotCallFlag>
<ns5oNotContactFlag>false</ns5oNotContactFlag>
<ns5oNotEmailFlag>false</ns5oNotEmailFlag>
<ns5oNotMailFlag>false</ns5oNotMailFlag>
<ns5:LastContactDate xsi:nil="true"/>
<ns5rimaryCustomerId xsi:nil="true"/>
<ns5rimaryCustomerRelationshipId xsi:nil="true"/>
<ns5rimaryCustomerName/>
<ns5:LastSourceUpdateDate>2017-11-04T03:33:18.0Z</ns5:LastSourceUpdateDate>
<ns5:LastUpdateSourceSystem>UNKNOWN</ns5:LastUpdateSourceSystem>
<ns5ataCloudStatus xsi:nil="true"/>
<ns5:LastEnrichmentDate xsi:nil="true"/>
</ns5ersonProfile>
<ns5artyUsageAssignment>
<ns6artyUsgAssignmentId>300000002374608</ns6artyUsgAssignmentId>
<ns6artyId>300000002374605</ns6artyId>
<ns6artyUsageCode>SALES_ACCOUNT</ns6artyUsageCode>
<ns6:EffectiveStartDate>2017-10-31</ns6:EffectiveStartDate>
<ns6:EffectiveEndDate>4712-12-31</ns6:EffectiveEndDate>
<ns6tatusFlag>true</ns6tatusFlag>
<ns6:Comments xsi:nil="true"/>
<ns6wnerTableName>HZ_PARTIES</ns6wnerTableName>
<ns6wnerTableId>1010001200127</ns6wnerTableId>
<ns6:CreatedByModule>HZ_WS</ns6:CreatedByModule>
<ns6bjectVersionNumber>1</ns6bjectVersionNumber>
<ns6:CreatedBy>rahul@ps-ipl.com</ns6:CreatedBy>
<ns6:CreationDate>2017-11-04T03:33:18.07Z</ns6:CreationDate>
<ns6:LastUpdateLogin>5D20E1D8F1D03324E053D07E6D0AD5A1</ns6:LastUpdateLogin>
<ns6:LastUpdateDate>2017-11-04T03:33:18.165Z</ns6:LastUpdateDate>
<ns6:LastUpdatedBy>rahul@ps-ipl.com</ns6:LastUpdatedBy>
<ns6:RequestId xsi:nil="true"/>
</ns5artyUsageAssignment>
</ns5:Value>
</ns1:result>
</ns0:createPersonPartyResponse>
</env:Body>
</env:Envelope>

[rhall_2_0 · Accepted solution]

I suspect that you are struggling with the namespaces. Simply go to the Advanced component tab for the tExtractXMLField and select "Ignore the namespaces". Check out the documentation below to see how to use the component. The XPaths below are guessed. Unfortunately your XML is really badly formatted in the post. Try posting it again using a Code Block. 

Loop Expression = "/"

XPath for PartySiteId = "./Body/createPersonPartyResponse/result/Value/PartySiteId"

XPath for PartyId = "./Body/createPersonPartyResponse/result/Value/PartyId"

Take a look at the tExtractXMLField documentation below...

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/Pc9RZi6IiWw1Kb~Jf0bE0Q

[rhall_2_0 · Accepted solution]

I suspect that you are struggling with the namespaces. Simply go to the Advanced component tab for the tExtractXMLField and select "Ignore the namespaces". Check out the documentation below to see how to use the component. The XPaths below are guessed. Unfortunately your XML is really badly formatted in the post. Try posting it again using a Code Block. 

Loop Expression = "/"

XPath for PartySiteId = "./Body/createPersonPartyResponse/result/Value/PartySiteId"

XPath for PartyId = "./Body/createPersonPartyResponse/result/Value/PartyId"

Take a look at the tExtractXMLField documentation below...

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/Pc9RZi6IiWw1Kb~Jf0bE0Q

[rhall_2_0]

Did this resolve your question? If so can you set it to resolved so that others can benefit from this?

[Padmini]

It worked!!

Thank you