topic Re: [resolved] How to extract leads from Marketo in Talend Studio

[resolved] How to extract leads from Marketo

Anonymous — Sat, 16 Nov 2024 10:11:21 GMT

I am using the REST API with the tMarketoInput component.
The connection are working fine.
Is there an example where I can get multiple leads at a time using getMultipleLeads operation. What happens if don't have the lead ID?.
I was expecting a behavior tSalesforceInput where I did not have to supply this.
Thanks
Ravi

Re: [resolved] How to extract leads from Marketo

Anonymous — Thu, 22 Dec 2016 07:17:08 GMT

Hi,
Due to Marketo recommends the REST API, have you tried to use tRESTClient with a JSON payload?
Best regards
Sabrina

Re: [resolved] How to extract leads from Marketo

Anonymous — Fri, 23 Dec 2016 04:17:38 GMT

Thanks for your quick response. Sorry for the newbie question. How do I specify the username password field in basic authentication type. (tRESTClient component)
Looking for the format.
Thanks
Ravi

Re: [resolved] How to extract leads from Marketo

Anonymous — Fri, 23 Dec 2016 09:23:41 GMT

Hi,
Could you please take a look at this component reference:TalendHelpCenter:tRESTClient?
Best regards
Sabrina

Re: [resolved] How to extract leads from Marketo

Anonymous — Fri, 23 Dec 2016 21:53:52 GMT

Thanks.I entered the password in double quotes (Q: per documentation it says I have to enter the password. No mention of user name and the syntax for user name and password). Thanks for all your help.
The tFileJSONouput file contains the following:
{"data":}
tSClientSetup.pdf_20161223-1353.pdf

Re: [resolved] How to extract leads from Marketo

Anonymous — Fri, 23 Dec 2016 22:37:59 GMT

See picture attached for the job.

Re: [resolved] How to extract leads from Marketo

Anonymous — Sun, 25 Dec 2016 23:26:05 GMT

Found the answer.It appears that I have to construct the URL for specific object I am interested.
For example to get multiple leads I have to enter the following URL:
""
See details of various API methods, here.
Then I entered the Access Token in the password field.
Then I had to three parameters to get the leads.
"acccess_token" -- value
"filterType" - "id"
"filterValues" --values separated by comma eg. "3,4,5"

Re: [resolved] How to extract leads from Marketo

Anonymous — Mon, 26 Dec 2016 03:28:17 GMT

Hi,
Can we condsider this topic as resolved?
Best regards
Sabrina

Re: [resolved] How to extract leads from Marketo

Anonymous — Mon, 26 Dec 2016 19:07:01 GMT

One last request.
I am using the tMarketo_Input component and taking LeadKeySelector Option with id as LeadKey Type.
Q: How do I enter the values for the id ( I get a pop up window, but won't allow me to enter value).
It is a required field.
Thanks
Ravi

Re: [resolved] How to extract leads from Marketo

Anonymous — Tue, 27 Dec 2016 08:13:05 GMT

Hi,
Could you please take a look at this related scenario: TalendHelpCenterata transmission between the Marketo database and an external system using REST API?
Best regards
Sabrina

Re: [resolved] How to extract leads from Marketo

Anonymous — Tue, 27 Dec 2016 22:28:11 GMT

Perfect.
For my POC I created tFixedInput component and connected to tMarketoInput component and entered the rows of tFixedInput manually.
Works like a charm!.
You can close the thread.
Thank you for your help and patience.
Ravi

Re: [resolved] How to extract leads from Marketo

Anonymous — Thu, 29 Dec 2016 04:00:08 GMT

Hi Ravi,
Great it can help. Feel free to let us know if there is any further help we can give.
Best regards
Sabrina