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</ns5
artyId>
<ns5artyNumber>1010001200127</ns5
artyNumber>
<ns5artyName>Jane Does</ns5
artyName>
<ns5artyType>PERSON</ns5
artyType>
<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</ns5
rigSystemReference>
<ns5ICCode xsi:nil="true"/>
<ns5:JgzzFiscalCode xsi:nil="true"/>
<ns5ersonFirstName>Jane</ns5
ersonFirstName>
<ns5ersonPreNameAdjunct xsi:nil="true"/>
<ns5ersonLastName>Does</ns5
ersonLastName>
<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</ns5
tatus>
<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</ns5
referredFunctionalCurrency>
<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</ns5
artyUniqueName>
<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</ns6
artySiteId>
<ns6artyId>300000002374605</ns6
artyId>
<ns6:LocationId>1010001200127</ns6:LocationId>
<ns6:LastUpdateDate>2017-11-04T03:33:18.264Z</ns6:LastUpdateDate>
<ns6artySiteNumber>1010001200127</ns6
artySiteNumber>
<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</ns6
rigSystemReference>
<ns6tartDateActive>2017-10-31</ns6
tartDateActive>
<ns6:EndDateActive>4712-12-31</ns6:EndDateActive>
<ns6:Mailstop xsi:nil="true"/>
<ns6:IdentifyingAddressFlag>true</ns6:IdentifyingAddressFlag>
<ns6:Language>US</ns6:Language>
<ns6tatus>A</ns6
tatus>
<ns6artySiteName>Home Address1</ns6
artySiteName>
<ns6:Addressee xsi:nil="true"/>
<ns6bjectVersionNumber>1</ns6
bjectVersionNumber>
<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</ns6
verallPrimaryFlag>
<ns6artySiteUse>
<ns6artySiteUseId>300000002374607</ns6
artySiteUseId>
<ns6:BeginDate>2017-10-31</ns6:BeginDate>
<ns6:Comments>Home Address1</ns6:Comments>
<ns6:EndDate>4712-12-31</ns6:EndDate>
<ns6artySiteId>300000002374606</ns6
artySiteId>
<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</ns6
iteUseType>
<ns6rimaryPerType>Y</ns6
rimaryPerType>
<ns6tatus>A</ns6
tatus>
<ns6bjectVersionNumber>1</ns6
bjectVersionNumber>
<ns6:CreatedByModule>HZ_WS</ns6:CreatedByModule>
</ns6artySiteUse>
</ns5artySite>
<ns5ersonProfile xmlns:ns4="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/person/">
<ns5ersonProfileId>300000002374605</ns5
ersonProfileId>
<ns5artyId>300000002374605</ns5
artyId>
<ns5ersonName>Jane Does</ns5
ersonName>
<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</ns5
ersonFirstName>
<ns5ersonMiddleName xsi:nil="true"/>
<ns5ersonLastName>Does</ns5
ersonLastName>
<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</ns5
tatus>
<ns5:CreatedByModule>HZ_WS</ns5:CreatedByModule>
<ns5eceasedFlag>false</ns5
eceasedFlag>
<ns5:Comments xsi:nil="true"/>
<ns5ersonLastNamePrefix xsi:nil="true"/>
<ns5ersonSecondLastName xsi:nil="true"/>
<ns5referredFunctionalCurrency>AED</ns5
referredFunctionalCurrency>
<ns5rigSystem>XSTORE</ns5
rigSystem>
<ns5rigSystemReference>Per1010001200127</ns5
rigSystemReference>
<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</ns5
uffixOverriddenFlag>
<ns5:UniqueNameSuffix xsi:nil="true"/>
<ns5:CorpCurrencyCode>USD</ns5:CorpCurrencyCode>
<ns5:CurcyConvRateType>Corporate</ns5:CurcyConvRateType>
<ns5:CurrencyCode>USD</ns5:CurrencyCode>
<ns5artyNumber>1010001200127</ns5
artyNumber>
<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</ns5
rimaryAddressLine1>
<ns5rimaryAddressLine2 xsi:nil="true"/>
<ns5rimaryAddressLine3 xsi:nil="true"/>
<ns5rimaryAddressLine4 xsi:nil="true"/>
<ns5:Alias xsi:nil="true"/>
<ns5rimaryAddressCity>Aurora</ns5
rimaryAddressCity>
<ns5rimaryAddressCountry>US</ns5
rimaryAddressCountry>
<ns5rimaryAddressCounty xsi:nil="true"/>
<ns5rimaryEmailAddress xsi:nil="true"/>
<ns5rimaryFormattedAddress>54332 Main St,AURORA,</ns5
rimaryFormattedAddress>
<ns5rimaryFormattedPhoneNumber xsi:nil="true"/>
<ns5rimaryLanguage xsi:nil="true"/>
<ns5artyUniqueName>Jane Does</ns5
artyUniqueName>
<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</ns5
oNotCallFlag>
<ns5oNotContactFlag>false</ns5
oNotContactFlag>
<ns5oNotEmailFlag>false</ns5
oNotEmailFlag>
<ns5oNotMailFlag>false</ns5
oNotMailFlag>
<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</ns6
artyUsgAssignmentId>
<ns6artyId>300000002374605</ns6
artyId>
<ns6artyUsageCode>SALES_ACCOUNT</ns6
artyUsageCode>
<ns6:EffectiveStartDate>2017-10-31</ns6:EffectiveStartDate>
<ns6:EffectiveEndDate>4712-12-31</ns6:EffectiveEndDate>
<ns6tatusFlag>true</ns6
tatusFlag>
<ns6:Comments xsi:nil="true"/>
<ns6wnerTableName>HZ_PARTIES</ns6
wnerTableName>
<ns6wnerTableId>1010001200127</ns6
wnerTableId>
<ns6:CreatedByModule>HZ_WS</ns6:CreatedByModule>
<ns6bjectVersionNumber>1</ns6
bjectVersionNumber>
<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>
Solved! Go to 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
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
It worked!!
Thank you