Skip to main content

Hi all — I’m not a developer, I’m a sales guy (apologies) - so that should be the problem right there.  Anyway, I can’t loop in our dev team due to strategic constraints, and I’m trying to build a simple reporting workflow using the Front API.

Goal:
Generate a report that lists:

  • Conversation ID

  • Shared inbox name(s)

  • Tags
    Grouped by Month and Year, based on when the conversation first arrived (i.e. was created).

I'd like to use this for historical reporting — so I need to pull conversations created in previous months, like March 2025, February 2025, etc.

From what I understand, this means:

  • Using the /conversations endpoint

  • Possibly filtering or grouping by created_at

But I’m running into issues — even when I try filtering with something like created:kYYYY-MM-DD TO YYYY-MM-DD] (or manually filtering the created_at values after retrieval), I only return conversations with today’s date, nothing from prior days or weeks.

Key question:
👉 What’s the best way to reliably retrieve conversations created within a specific timeframe (including past months) for reporting?

Any tips, simple examples, or clarification would be so appreciated 🙏 Thank you!

Hi Jonny!

In this case, I’d recommend using the Search Conversations endpoint—it's designed for exactly this kind of use case. This endpoint lets you filter conversations using a query string, so you’ll get back only the data that’s relevant to your search. The query can be used to search for things like conversations that have messages that were created before or after a specific date. You can learn more about our query string syntax here. 


Hope this helps, and let me know if you have any questions!

Thanks for taking the time to share that info, Andy.  I’ll give that a whirl.

cheers

Reply


Terms & ConditionsCookie settings