[resolved] How to extract leads from Marketo

One Star

[resolved] How to extract leads from Marketo

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

Accepted Solutions
One Star

Re: [resolved] How to extract leads from Marketo

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"

All Replies
Moderator

Re: [resolved] How to extract leads from Marketo

Hi,
Due to Marketo recommends the REST API, have you tried to use tRESTClient with a JSON payload?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] How to extract leads from Marketo

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
Moderator

Re: [resolved] How to extract leads from Marketo

Hi,
Could you please take a look at this component reference:TalendHelpCenter:tRESTClient?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] How to extract leads from Marketo

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
One Star

Re: [resolved] How to extract leads from Marketo

See picture attached for the job.
One Star

Re: [resolved] How to extract leads from Marketo

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"
Moderator

Re: [resolved] How to extract leads from Marketo

Hi,
Can we condsider this topic as resolved?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] How to extract leads from Marketo

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
Moderator

Re: [resolved] How to extract leads from Marketo

Hi,
Could you please take a look at this related scenario:TalendHelpCenterSmiley Very Happyata transmission between the Marketo database and an external system using REST API?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] How to extract leads from Marketo

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
Moderator

Re: [resolved] How to extract leads from Marketo

Hi Ravi,
Great it can help. Feel free to let us know if there is any further help we can give.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch