Want all the lead data from Marketo using tMarketoInput in Excel file

One Star

Want all the lead data from Marketo using tMarketoInput in Excel file

Hi,
I am using tMarketoInput for extracting lead data from marketo.
I am able to connect with marketo using talend. But I am not getting all the data from leads into excel file as I am getting only four columns that are provided by the Talend.
I tried adding some fields in the schema but I am just getting the ID of that lead not all the data.

Can anybody help me to get data of all the columns?
Community Manager

Re: Want all the lead data from Marketo using tMarketoInput in Excel file

Hi
Which version are you using? Can you upload a screenshot of job?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Want all the lead data from Marketo using tMarketoInput in Excel file

Hi Shong,
Thanks for reply. I am using Talend MDM Studio (4.2.3.r67267).
One Star

Re: Want all the lead data from Marketo using tMarketoInput in Excel file

Hi all,
This is again a same typr of question. I am trying to pull Marketo Lead activities using tMarketoInput component and in general settings - I have given correct end point url which retrieves JSON with correct authentication to Marketo. I have modified the schema as per JSON file and still I am getting the following error
Starting job Marketocheck at 16:57 28/04/2015.
connecting to socket on port 3735
connected
Exception in component tMarketoInput_1
AxisFault
faultCode: {}Server.userException
faultSubcode:
faultString: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
faultActor:
faultNode:
faultDetail:
{}stackTrace:org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.marketo.www.mktows.MktowsApiSoapBindingStub.getLead(MktowsApiSoapBindingStub.java:1776)
at org.talend.marketo.Client.getLead(Client.java:108)
at firsttry.marketocheck_0_1.Marketocheck.tMarketoInput_1Process(Marketocheck.java:509)
at firsttry.marketocheck_0_1.Marketocheck.runJobInTOS(Marketocheck.java:927)
at firsttry.marketocheck_0_1.Marketocheck.main(Marketocheck.java:784)
{}hostname:Chn_DMI_L3
org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:701)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.marketo.www.mktows.MktowsApiSoapBindingStub.getLead(MktowsApiSoapBindingStub.java:1776)
at org.talend.marketo.Client.getLead(Client.java:108)
at firsttry.marketocheck_0_1.Marketocheck.tMarketoInput_1Process(Marketocheck.java:509)
at firsttry.marketocheck_0_1.Marketocheck.runJobInTOS(Marketocheck.java:927)
at firsttry.marketocheck_0_1.Marketocheck.main(Marketocheck.java:784)
Caused by: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
... 13 more
disconnected
Job Marketocheck ended at 16:57 28/04/2015.

please assist. I couldnt figure out what this error refers too "Content is not allowed in prolog"

regards
Rakz
One Star

Re: Want all the lead data from Marketo using tMarketoInput in Excel file

Attached try out for Marketo. I had fileoutputdelimited earlier though.
Please advice how to retrieve Lead activities from Marketo, thanks