V8 API getting lead filter by email address

SuiteCRM Forum - English Language Developer Collaboration
#1

Hi, I tried to get a list of lead filter by email address.
I’ve tried
{{suitecrm.url}}/V8/module/Leads/

and it list all the leads with all attributes

then I try to filter by mobile number
{{suitecrm.url}}/V8/module/Leads/?filter[phone_mobile][eq]=01115265321
it works too.

then I try to filter by email
{{suitecrm.url}}/V8/module/Leads/?filter[email_address][eq]=example@example.com and it gave error 400, “detail”: “Filter field email_address in Lead module is not found”

{{suitecrm.url}}/V8/module/Leads/?filter[email1][eq]=example@example.com and it gave error 400,
“detail”: “Database failure. Please refer to suitecrm.log for details.”

May I know how to filter the lead with email address?
Thanks

#2

I think it’s lacking code to achieve that, there was a PR here

although I am not sure what the status is on that, maybe you can ask there