[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.