Skip to Content

SCPI - Convert XML to CSV from SuccessFactors CompoundEmployee Component

Hi,

We are busy implementing SuccessFactors. I need to create a custom integration flow via SCPI that retrieves the CompoundEmployee component from SuccessFactors and the converts it to a csv file that I am able to import to our on-premise to do some reconciliations on. I am still learning to create integration flows and not sure what the best way is to do this?

I have tried the XML To CSV Converter but cannot seem to get it working? Not sure if my Path to Source Element in XSD is correct? I read somewhere that that XML to CSV cannot to complex XML structures? Has any tried this before? What would be the best way to do this? Can a content modifier or another component be used?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 23, 2017 at 09:12 AM

    Hello Deon,

    XML to CSV Converter supports only one level ( one hierarchy level of XML).

    Basically if you want to convert Compound Employee Data to CSV then you must have Message Mapping and convert the Multi Hierarchy Compound Employee data to one level XML structure,may be something like below

    <EmployeeData>
    	<Record>
    		<person_id_external>P1</person_id_external>
    		<first_name>Sri</first_name>
    		<last_name>Bhat</last_name>
    		<Department>D1</Department>
    		<CostCenter>c1</CostCenter>
    		.
    		.
    		.
    		.
    		.
    		
    	</Record>
    <Record>
    		<person_id_external>P2</person_id_external>
    		<first_name>S</first_name>
    		<last_name>Bhat</last_name>
    		<Department>D1</Department>
    		<CostCenter>c2</CostCenter>
    		.
    		.
    		.
    		.
    		.
    		
    	</Record>
    </EmployeeData>

    And then use the XML to CSV converter and you have to build the target XSD manually for mapping.

    Also just to avoid lot of these manual activities,you can give a try on Integration Center option of SuccessFactors where it would be easy to generate the CSV ( if transformation required is very minimal )

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sriprasad,

      Just a last question. I managed to get hold of the Message Mapping component and select the CompoundEmployee as my source, but I am a bit unsure how to generate the xsd file for my target mapping?

      What do you suggested the best way is? Is there perhaps a way to get hold of the CompoundEmployee WSDL url directly that I can drag into a tool (like Postman) and then change it to look like the structure I want? I tried https://xxxxx/sfapi/v1/soap/CompoundEmployee.wsdl but get a message that I do not have authorization?

      Should I rather create a WSDL via Enterprise Services Builder? Not sure what the best approach would be?

      Thanks for all the assistance!

      Kind Regards

      Deon