Unable to Extract the fields from the XML String

CloverDX Platform
1

Hi Team,

Please help me in extracting the XML fields from the below payload.

2

Hello Girish,

Could you please elaborate more on what exactly you are trying to accomplish? Based on the payload sent you are using the XMLExtract to process information from a Salesforce SOAP API, and everything looks in order. Are you getting an error of sorts when extracting the data? Also is there a reason why you are not using the WebServiceClient component or do you have the file download beforehand?

3

Hi Pedro Vazquez Rosario,

I had the XML file in hand. I want to extract the fields like firstname,lastname,email etc.

Thanks,
Girish.

4

Like I mentioned prior you can use the XMLExtract to extract the fields you mentioned. You can follow the same steps as described in the following forum post:

https://forum.cloveretl.com/viewtopic.php?f=5&t=7541&p=13089#p13095

5

Hi,

I still unable to get all the fields. Please help.

6

Hi,

It would be helpful if you could please post the structure of the XML you are trying to extract, without any sensitive data of course.

Thank You,

7

Please find the XML

<ws:Worker_Sync xmlns:ws=“urn:com.workday/workersync” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>
ws:Header
ws:Version25.0</ws:Version>
ws:Prior\_Entry\_Time2018-02-28T12:25:34.000-08:00</ws:Prior_Entry_Time>
ws:Current\_Entry\_Time2018-03-01T13:27:19.841-08:00</ws:Current_Entry_Time>
ws:Prior\_Effective\_Time2018-02-28T00:00:00.000-08:00</ws:Prior_Effective_Time>
ws:Current\_Effective\_Time2018-03-01T00:00:00.000-08:00</ws:Current_Effective_Time>
ws:Full\_Filefalse</ws:Full_File>
ws:Document\_Retention\_Policy30</ws:Document_Retention_Policy>
ws:Worker\_Count1</ws:Worker_Count>
</ws:Header>
ws:Worker
ws:Summary
ws:Employee\_ID800810</ws:Employee_ID>
ws:NameGaryy Song</ws:Name>
</ws:Summary>
ws:Eligibilitytrue</ws:Eligibility>
ws:Personal
ws:Name\_Data
<ws:First_Name ws:PriorValue=“Gary”>Garyy</ws:First_Name>
ws:Last\_NameSong</ws:Last_Name>
</ws:Name_Data>
ws:Email\_Data
ws:Email\_TypeWORK</ws:Email_Type>
ws:Email\_Is\_Publictrue</ws:Email_Is_Public>
ws:Is\_Primarytrue</ws:Is_Primary>
ws:Email\_Addressgary.song@instacart.com</ws:Email_Address>
</ws:Email_Data>
</ws:Personal>
ws:Status
ws:Activetrue</ws:Active>
ws:Hire\_Date2018-02-05</ws:Hire_Date>
ws:Original\_Hire\_Date2018-02-05</ws:Original_Hire_Date>
ws:Terminatedfalse</ws:Terminated>
ws:Rehirefalse</ws:Rehire>
</ws:Status>
ws:Position
ws:OperationNONE</ws:Operation>
ws:Effective\_Date2018-02-05</ws:Effective_Date>
ws:Worker\_TypeRegular</ws:Worker_Type>
ws:Position\_Time\_TypeFull time</ws:Position_Time_Type>
ws:Organization\_Data
ws:OperationNONE</ws:Operation>
ws:OrganizationINSTA-US-01</ws:Organization>
ws:Organization\_TypeCompany</ws:Organization_Type>
</ws:Organization_Data>
ws:Organization\_Data
ws:OperationNONE</ws:Operation>
ws:Organization6800</ws:Organization>
ws:Organization\_TypeCost_Center</ws:Organization_Type>
</ws:Organization_Data>
ws:Job\_ProfileEN02E</ws:Job_Profile>
ws:Management\_Level5</ws:Management_Level>
ws:Supervisor
ws:OperationNONE</ws:Operation>
ws:Supervisor\_ID800009</ws:Supervisor_ID>
ws:Supervisor\_NameBrandon Leonardo</ws:Supervisor_Name>
</ws:Supervisor>
</ws:Position>
ws:Additional\_Information
ws:Management\_Level\_TextIndividual Contributor</ws:Management_Level_Text>
ws:Job\_Profile\_TextSoftware Engineer</ws:Job_Profile_Text>
ws:LocationSan Francisco</ws:Location>
ws:Company\_TextMaplebear dba Instacart</ws:Company_Text>
ws:Cost\_Center\_TextEngineering</ws:Cost_Center_Text>
</ws:Additional_Information>
</ws:Worker>
</ws:Worker_Sync>

8

Hi,

It appears that you still had some difficulties with the mapping, in cases like this its important to use the Populate parent record. A good tip is using the root element of the data you need to extract for example in your case it would be Worker and then use Populate parent record for all the other element mappings.

I have attached the solution to the XML you sent me

Example.zip