Export Contact from Marketing Cloud using CPI

[former_member606233]

Hello,

How can I export contacts from Marketing Cloud to SFTP (CSV File) using CPI.

I used The pre-installed package "SAP Marketing Cloud - Offline Sales Data Export" and I maked some changes on the artifact "Export Contacts Data". But I am facing some problems with the XSL"OData Receiver may not pass Xml message to XSLT Mapping. XSLT Mapping supports Xml input only." and the converter from xml to CSV (XSLT Mapping may not pass Xml message to XML To CSV Converter. XML To CSV Converter supports Xml input only.)

Attached a screenshot of the iflow.

Has anyone run into the same problem?

Thank you!

captureiflow.png

[former_member247020]

Hi,

Might be an error in the xsl script.

change template match="/" to template match="/Contacts/Contact"

That should work. also wasn't sure how the inbound message looks like.

Inbound message:

<Contacts> <Contact> <CreatedByUser>SAP_SYSTEM</CreatedByUser> <ContactOrigin>TEST</ContactOrigin> <ContactID>123456</ContactID> <FirstName>firstname</FirstName> <YY1_NUM_CIN_TVA_MPS>aaa</YY1_NUM_CIN_TVA_MPS> <BirthDate>bbb</BirthDate> <YY1_TELEPHONE_MPS>5551112222</YY1_TELEPHONE_MPS> <YY1_PROFESSION_MPST>ccc</YY1_PROFESSION_MPST> <YY1_VILLE_MPSF>ccc</YY1_VILLE_MPSF> <YY1_Type_Operation_MPS>ddd</YY1_Type_Operation_MPS> </Contact> </Contacts>

XSLT:

<?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" indent="yes"/> <xsl:template match="/Contacts/Contact"> <Contact> <ContactOrigin><xsl:value-of select="ContactOrigin" /></ContactOrigin> <ContactID><xsl:value-of select="ContactID" /></ContactID> <FirstName><xsl:value-of select="FirstName" /></FirstName> <YY1_NUM_CIN_TVA_MPS><xsl:value-of select="YY1_NUM_CIN_TVA_MPS" /></YY1_NUM_CIN_TVA_MPS> <BirthDate><xsl:value-of select="BirthDate" /></BirthDate> <YY1_TELEPHONE_MPS><xsl:value-of select="YY1_TELEPHONE_MPS" /></YY1_TELEPHONE_MPS> <YY1_PROFESSION_MPST><xsl:value-of select="YY1_PROFESSION_MPST" /></YY1_PROFESSION_MPST> <YY1_VILLE_MPSF><xsl:value-of select="YY1_VILLE_MPSF" /></YY1_VILLE_MPSF> <YY1_Type_Operation_MPS><xsl:value-of select="YY1_Type_Operation_MPS" /></YY1_Type_Operation_MPS> </Contact> </xsl:template> </xsl:stylesheet>

Output:

<Contact><ContactOrigin>TEST</ContactOrigin><ContactID>123456</ContactID><FirstName>firstname</FirstName><YY1_NUM_CIN_TVA_MPS>aaa</YY1_NUM_CIN_TVA_MPS><BirthDate>bbb</BirthDate><YY1_TELEPHONE_MPS>5551112222</YY1_TELEPHONE_MPS><YY1_PROFESSION_MPST>ccc</YY1_PROFESSION_MPST><YY1_VILLE_MPSF>ccc</YY1_VILLE_MPSF><YY1_Type_Operation_MPS>ddd</YY1_Type_Operation_MPS></Contact>