AnsweredAssumed Answered

importToList: quoting commas

Question asked by 944305f82a3d29af645a1f0dd997d502eecbf9e5 on Jul 15, 2014
Latest reply on Jul 24, 2014 by 3c0ec00d91a60fe9c285cd3be9d891e2bbeb178e
The importToList (SOAP API) documentation says and shows an example indicating that the lead data to be imported is in the form of comma-separated fields, like this:

<stringItem>Awesomesauce,Developer,Code Slinger,Marketo,dawesomesauce@marketo.com</stringItem>

I assume there must be some quoting convention in effect (to handle a field whose data itself contains a comma), but I didn't have any luck uncovering that convention. How do we ensure that a stray comma in a data field is accurately handled as field content rather than as a field separator?

Outcomes