on 08-01-2018 7:39 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.