Find Query filter column for Email in V2 version

API Q&A
1

Hi Team,

We are looking to use Query filter for Email using V2.
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

2

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)

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?

3

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”,

        "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**
4

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.