SCPI - Convert XML to CSV from SuccessFactors CompoundEmployee Component

[Deon_van_Zyl]

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?

[Sriprasadsbhat · Accepted solution]

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

[Deon_van_Zyl · Accepted solution]

Hi Sriprasad,

Thanks for your answer. I would prefer doing this via SCPI. I looked briefly at the Integration Centre in SuccessFactors and I would have to create a lot different Integrations with a lot of separate files, where with SCPI I should be able to split them into different files or combine some of the date into 1 files, all within 1 integration flow?

Just to confirm, I should be able to connect more than one mapping to a single SuccessFactors target/connection? If I for instance want to split for instance a component with multiple entries per employee (like dependants/family members) into a separate file.

I would also in the future like to run the reconciliation with delta's for which I think SCPI would be better suited.

Let me know what your thoughts are.

Kind Regards

Deon

[Sriprasadsbhat · Accepted solution]

Hello Deon,

Yes its possible with one iflow and looking at above requirement its better to go with SCPI.

Regards,

Sriprasad Shivaram Bhat

[Deon_van_Zyl · Accepted solution]

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