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

[Anonymous]

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. 

[Anonymous]

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.

[Anonymous]

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.

[Anonymous · Accepted solution]

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.

[Anonymous]

Thank you Travis!