Problem in extracting the XML extract

CloverDX Platform
1

Hi Everyone,

I need to extract the below XML. But I am unable to extract all the fields. Please help.

I need to extract the Bold Tags.

Appreciate your help.

Thanks,
Girish.

<soapenv:Envelope xmlns:soapenv=“http://schemas.xmlsoap.org/soap/envelope/” xmlns=“urn:enterprise.soap.sforce.com” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:sf=“urn:sobject.enterprise.soap.sforce.com”>
soapenv:Header


79
15000
API REQUESTS


</soapenv:Header>
soapenv:Body


true


sf:Id00kC000000iYkMOIA0</sf:Id>
<sf:Opportunity xsi:type=“sf:Opportunity”>
<sf:Id xsi:nil=“true”/>
<sf:Account xsi:type=“sf:Account”>
<sf:Id xsi:nil=“true”/>
sf:NameBusiness World</sf:Name>
</sf:Account>
sf:AccountId001C000001UBcYPIA1</sf:AccountId>
sf:Amount4000.0</sf:Amount>
sf:Campaign\_End\_Date\_\_c2018-08-31</sf:Campaign_End_Date__c>
sf:Campaign\_Start\_Date\_\_c2017-08-31</sf:Campaign_Start_Date__c>
sf:CloseDate2017-08-31</sf:CloseDate>
sf:NameGC_TEST11202017_1</sf:Name>
sf:StageNameQualification</sf:StageName>
</sf:Opportunity>
<sf:Product2 xsi:type=“sf:Product2”>
<sf:Id xsi:nil=“true”/>
sf:NameEcheck</sf:Name>
</sf:Product2>
sf:Quantity120.0</sf:Quantity>
sf:TotalPrice3000.0</sf:TotalPrice>
sf:UnitPrice25.0</sf:UnitPrice>



</soapenv:Body>
</soapenv:Envelope>

2

Hello Girish,
from the snippet of your XML, I would suggest using the XMLExtract component to generate the XSD schema and take advantage of its visual mapping feature. Moreover, I would recommend using the ‘Populate parent record’ functionality as the fundamental concept of your data extraction as it helps flatten the output data structure, thus reducing the number of output ports. More information about this concept can be found in our documentation (namely in the ‘XMLExtract Mapping Editor and XSD Schema’ part).
Attached is an example solution based on the provided input data. I have demonstrated 2 approaches one of which extracts the data in a flat structure while the other one sends the data to 2 different ports. If you have any additional questions, feel free to get back to us.
Best regards,

3

Thanks Vladimir Barton, this helped me alot.

4

@Girish: Seems like you’re working with Salesforce SOAP API, is there any reason why you’re not using WebServiceClient component (and WSDL for that matter) rather than XMLExtract?

Or you have a file downloaded and trying to process?