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

Anonymous — Sat, 16 Nov 2024 12:35:10 GMT

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?

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

Anonymous — Sat, 05 Nov 2011 02:24:03 GMT

Hi
Which version are you using? Can you upload a screenshot of job?
Best regards
Shong

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

Anonymous — Mon, 07 Nov 2011 06:44:06 GMT

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

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

Anonymous — Tue, 28 Apr 2015 12:46:34 GMT

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

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

Anonymous — Tue, 28 Apr 2015 12:54:25 GMT

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

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

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

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

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

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

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