Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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
Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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"

View solution in original post

11 Replies
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

See picture attached for the job.
0683p000009MCjJ.png
Anonymous
Not applicable
Author

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"
Anonymous
Not applicable
Author

Hi,
Can we condsider this topic as resolved?
Best regards
Sabrina
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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