cancel
Showing results for 
Search instead for 
Did you mean: 

SF to SFTP in CSV format using CPI

0 Kudos

I have a requirement here where I am supposed to query data from SuccessFactors and send it to an SFTP server in a CSV file. I have set up the XML to CSV converter and I am getting a warning message as: "SuccessFactors may not pass XML message to XML To CSV Converter. XML To CSV Converter supports XML input only." Leading this, I get a blank CSV in the SFTP as my output after deploying the iflow. Any idea how may I proceed on this further? I am I using the incorrect converter?

Accepted Solutions (0)

Answers (1)

Answers (1)

Sriprasadsbhat
Active Contributor

Hello Rishab,

Please find the below details.

1) "SuccessFactors may not pass XML message to XML To CSV Converter. XML To CSV Converter supports XML input only." Its just a warning and you can ignore.

2) Currently XML to CSV supports only one hierarchy of XML,you may not able to convert whole Compound Employee XML to CSV.Before you pass the XML to converter you need to normalize so that it will have one parent node and reoccurring child node.

<Root>
	<Record>
		<Field1>F11</Field1>
		<Field2>F22</Field2>
	</Record>
	<Record>
		<Field1>F12</Field1>
		<Field2>F23</Field2>
	</Record>
	.
	.
	.
	.
	.
	.
	.
	.
	.
</Root>

Regards,

Sriprasad Shivaram Bhat

0 Kudos

Thanks for your reply Sriprasad.

I will ignore the warning.

Could you please suggest some options on how do we normalize?

Moreover, I am confused a bit about the structure of the reply that I get from SuccessFactors after the request-reply step. Is it XML or Json?

Sriprasadsbhat
Active Contributor

If you are querying Successfactors Compound Employee you will get XML message and after request reply add message mapping with source XSD ( compound employee schema ) and normalized target schema ( like above shown sample XML ),map all the required field ( similar SAP PI message mapping )

Regards,

Sriprasad Shivaram Bhat