Skip to main content
Solved

How to Get the last added date for a list in API

  • September 18, 2024
  • 1 reply
  • 27 views

Forum|alt.badge.img

hi im using API to get the lists
the problem is that i need to know the last date that a profile filled the form
i can see this in the website on the "date added" column, though i can not export it
and when i use the API, i have created , updated and last_event_date attributes and these are not the same as date added, as they count any action (like consent) not just filling the form.
so i want a way or and attribute to get this data for our lists. is there a way to that ?

Best answer by ChristianPaget

Hi there, you can use Get List Profiles which will include a field “joined_group_at” that gives the timestamp that profile joined the list. If you include “joined_group_at” for the sort key in the API key, the first profile returned will be the most recently joined profile. Then, if you grab the “joined_group_at” field for the first profile, you will have the timestamp of the last time a profile was added to the list.

View original
Did this topic or the replies in the thread help you find an answer to your question?

1 reply

ChristianPaget
Klaviyo Employee
Forum|alt.badge.img
  • Klaviyo Employee
  • 5 replies
  • Answer
  • October 15, 2024

Hi there, you can use Get List Profiles which will include a field “joined_group_at” that gives the timestamp that profile joined the list. If you include “joined_group_at” for the sort key in the API key, the first profile returned will be the most recently joined profile. Then, if you grab the “joined_group_at” field for the first profile, you will have the timestamp of the last time a profile was added to the list.