​REST Question - Get Multiple Leads by Filter - What Filter Types Supported? | Community
Skip to main content
A
Anonymous
February 24, 2015
Solved

​REST Question - Get Multiple Leads by Filter - What Filter Types Supported?

  • February 24, 2015
  • 4 replies
  • 2913 views
Hi all, 

My developer is attempting to use the "Get Multiple Leads by Filter Type" REST API (http://developers.marketo.com/documentation/rest/get-multiple-leads-by-filter-type) with a custom date field as a filter. 

Here is the call: 

curl 'https://[our_id].mktorest.com/rest/v1/leads.json?filterType=updated_date&filterValues="2015-02-23"&access_token=[our_token]'

Here is the response: 

{"requestId":"98f5#14bbd3fcf34","success":false,"errors":[{"code":"1011","message":"Lookup field 'updated_date' not supported"}]}

The error message doesn't give a lot of context. Is it that a date field is not a valid filter type for this call? 

What custom field types are supported? The docs are vague on this point. 

Thanks. 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
Hi Justin- You are correct, updated_date is not a supported filter to query the lead DB by.  You can retrieve leads that have changed using datetime with the Get Lead Changes REST API:  http://developers.marketo.com/documentation/rest/get-lead-changes/

This is the recommended approach to get leads and associated values that have been updated since a given time frame.

4 replies

A
Anonymous
February 26, 2015
Hi Justin

I'm interested in this issue and I tested seviral types.
Score: OK
Integer: OK
Float: Not supported
DateTime: Not supported

It seemed numeral is supported.
A
Anonymous
February 26, 2015
Takehiro, thanks a lot for responding. I believe our tests have shown the same. Additionally it appears Date - not supported String - ok It's unfortunate and I also wish this was better documented. What this means is I now need to use two Salesforce custom fields and two workflow rules to put a date into a string so we can query leads by date stamp! Ugh.
A
Anonymous
Accepted solution
March 2, 2015
Hi Justin- You are correct, updated_date is not a supported filter to query the lead DB by.  You can retrieve leads that have changed using datetime with the Get Lead Changes REST API:  http://developers.marketo.com/documentation/rest/get-lead-changes/

This is the recommended approach to get leads and associated values that have been updated since a given time frame.
A
Anonymous
March 2, 2015
Thank you Travis!
Terms & ConditionsAccessibility statement

Loading footer...