AnsweredAssumed Answered

Moving information from Marketo to a SQL Server

Question asked by akirkpatrick@apptio.com on Jul 12, 2018

I'm trying to move data from the Marketo Lead Activity table (using the REST API) to a MS SQL Server database but keep getting the following error

 

"Unable to create XML files from data, the document may not be well-formed xml ; Caused by: Unexpected character '{' (code 123) in prolog; expected '<' at [row,col {unknown-source}]: [1,1]"

 

I'm assuming this is due to Marketo using a JSON format and the SQL Server using XML but the Boomi documentation I could find says that Boomi does the format conversion automatically in the Map shape (which is where I'm getting errors) .... Json to XML script 

 

Has anyone been able to overcome this problem?

 

Thanks!

Outcomes