A list of supported filterTypes on the leads Rest API? | Community
Skip to main content
A
Anonymous
January 31, 2017
Solved

A list of supported filterTypes on the leads Rest API?

  • January 31, 2017
  • 3 replies
  • 5126 views

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.

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 Ja Shia​

I was looking for filter types in current API docs

http://developers.marketo.com/rest-api/lead-database/leads/#query

3 replies

Dory_Viscoglio
Dory_Viscoglio
Level 10
January 31, 2017

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.

Nicholas_Manojl
Nicholas_Manojl
Level 8
February 1, 2017

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.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    February 1, 2017

    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.

    A
    Anonymous
    Accepted solution
    February 1, 2017

    Hi Ja Shia​

    I was looking for filter types in current API docs

    http://developers.marketo.com/rest-api/lead-database/leads/#query

      Terms & ConditionsAccessibility statement

      Loading footer...