How do i search for a contact by email address using the new v8 API?

💬 General Discussion
1

Hi,

I’ve just started using the new v8 API and I can successfully get an access token and get a contact using filter by first name;

{url}/api/v8/modules/Contacts?filter[Contacts.first_name]=[[li]]tes%

And it works :slight_smile:

But I’m trying to lookup by email. I know that the emails are stored on a separate table so I’ve trying to access it through the API using;

{url}//api/v8/modules/EmailAddresses?filter[EmailAddresses.email_address]=[[li]]tes%

But the result is empty?

Does anyone have any thoughts as to where I’m going wrong?

2

looking into in more i have a 500 error.

Does anyone know how to get an email address object? im trying /api/v8/modules/EmailAddresses/359a0abc-c96e-be93-5710-5b7173cfc811 but it returns.

"errors": [
        {
            "id": "1",
            "links": {
                "about": null
            },
            "status": 500,
            "code": 8025,
            "title": "JSON API Error",
            "detail": "Api Version: 8",
            "source": {
                "pointer": null,
                "parameter": null
            },
            "meta": {
                "about": "Exception",
                "class": "SuiteCRM\\API\\v8\\Exception\\ApiException",
                "code": 8025,
                "langMessage": null
            }
        },
1 Like
3

I know I’m kinda late, but maybe it still helps someone:
This is an example that works for me: http://{{ip_address}}/legacy/Api/V8/module/Contacts?filter[email1][like]=test@test.com

4

Thank you for sharing your solution. Definitely, it will help others in the future.

5

For future reference, I have a tutorial here whith a bunch of examples including fetching by email: