# Find Query filter column for Email in V2 version
**URL:** https://integration.keap.com/t/find-query-filter-column-for-email-in-v2-version/94012
**Category:** API Q&A
**Tags:** api
**Created:** [April 9, 2026, 9:04am UTC](https://integration.keap.com/t/find-query-filter-column-for-email-in-v2-version/94012 "2026-04-09T09:04:58Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Harish\_Sreekantaradh](https://integration.keap.com/u/Harish_Sreekantaradh)
#### Post date: [April 9, 2026, 9:04am UTC](https://integration.keap.com/t/find-query-filter-column-for-email-in-v2-version/94012/1 "2026-04-09T09:04:59Z")
Hi Team,
We are looking to use Query filter for Email using V2.
[https://api.infusionsoft.com/crm/rest/v2/emails](https://api.infusionsoft.com/crm/rest/v2/emails) we see below columns has the Query parameter filter
- (String) start\_created\_time
- (String) end\_created\_time
Which is column are we supposed to consider in this case. I donot see the column names in Email. Please suggest
---
### Author:  [@OmarAlmonte](https://integration.keap.com/u/OmarAlmonte)
#### Post date: [April 9, 2026, 1:25pm UTC](https://integration.keap.com/t/find-query-filter-column-for-email-in-v2-version/94012/2 "2026-04-09T13:25:32Z")
Hi Harish,
For List Emails (V2), you can use the `filter` parameter with the `==` operator (encoded as `%3D%3D`). The available fields are:
- `contact_id` → filter by contact ID
- `email` → filter by email address
- `start_created_time` → emails created on/after this timestamp
- `end_created_time` → emails created on/before this timestamp
Example (filter by email address)
```auto
curl -X GET "https://api.infusionsoft.com/crm/rest/v2/emails?filter=email%3D%3Dtest@example.com" \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
-H "Content-Type: application/json"
```
Could you confirm which field you want to search by exactly?
---
### Author:  [@Harish\_Sreekantaradh](https://integration.keap.com/u/Harish_Sreekantaradh)
#### Post date: [April 9, 2026, 1:40pm UTC](https://integration.keap.com/t/find-query-filter-column-for-email-in-v2-version/94012/3 "2026-04-09T13:40:04Z")
Hi Almonte,
we are using **Service Account Keys and in emails section below are the columns available. Which one to consider for** `start_created_time` and `end_created_time`
“sent\_to\_address”: “[test@gmail.com](mailto:test@gmail.com)”,
```
"sent_to_cc_address_list": \[\],
"sent_to_bcc_address_list": \[\],
"sent_from_address": "noreply@keap.app",
"sent_from_reply_address": **null** ,
"sent_time": "2026-04-08T23:10:04Z",
"received_time": **null** ,
"opened_time": **null** ,
"clicked_time": **null** ,
"original_provider_id": **null** ,
"original_provider": "UNKNOWN",
"provider_source_id": **null** ,
"plain_content": **null** ,
"html_content": **null** ,
"sent_to_cc_addresses": "",
"sent_to_bcc_addresses": "",
"sent_date": "2026-04-08T23:10:04Z",
"received_date": **null** ,
"opened_date": **null** ,
"click_date": **null**
```
---
### Author:  [@OmarAlmonte](https://integration.keap.com/u/OmarAlmonte)
#### Post date: [April 9, 2026, 2:27pm UTC](https://integration.keap.com/t/find-query-filter-column-for-email-in-v2-version/94012/4 "2026-04-09T14:27:55Z")
Both `start_created_time` and `end_created_time` filter on the `sent_time` field (which is the same value you see returned as sent\_date in the response). So when you use those filters, the API will return emails whose `sent_time` falls within the range you specify.