SOLVED

A list of supported filterTypes on the leads Rest API?

Go to solution
Highlighted
Anonymous
Not applicable

A list of supported filterTypes on the leads Rest API?

Is there a way to retrieve a list of the supported filterTypes on the leads API? I ran the describe.json on the model, and received all the fields on the Lead model, but when I try to use one of them in my query, for example, firstName, I get an error message that says "Lookup field 'firstName' not supported". Has anyone encountered this issue before, and is there a way to retrieve all the fields I'm able to use as lookup values? Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: A list of supported filterTypes on the leads Rest API?

4 REPLIES 4
Highlighted

Re: A list of supported filterTypes on the leads Rest API?

Hey Ja, according to developers.marketo.com: The fields and/or sets of fields indicated by the idField and dedupeFields of an object description will always be valid filterTypes for a query. 

If this isn't what you're experiencing, I would suggest reaching out to support.

Highlighted

Re: A list of supported filterTypes on the leads Rest API?

I did indeed encounter this the other day. If you find something, please share it here in the thread. I only tried briefly, but it seemed that only the standard fields of email and id were acceptable.

You may have noticed that a workaround seems to be to create a custom field, and to mirror the contents of the custom field with the standard field. There doesn't seem to be a restriction on using a custom field as a filterType.

Highlighted
Level 10 - Community Moderator

Re: A list of supported filterTypes on the leads Rest API?

Yeah, I've imagined this has to do with cardinality (at least with FN and LN). Although it wouldn't be the case for all databases, it's a good prediction that the number of records returned can be over the limit (1000) for common names in a locale.

If you use a custom field, it could have the same prob but it wouldn't be telegraphing the problem ahead of time.

Highlighted
Anonymous
Not applicable

Re: A list of supported filterTypes on the leads Rest API?