Date when existing record get linked with target list of Campaign

Thanks André.

But date_modified is prospect's modified date, not when it's get linked with prospect list, right?

Table prospect_lists_prospects is the relationship table between Prospect Lists and Prospects, so its date_modified field stores the date when that record (Prospect, Lead, Contact, Account) has been added into specified Prospect List.

Regards

You can get datetime using advance query

Query:

SELECT
p.name AS target_list,
c.name AS campaign_name,
pc.date_modified AS target_list_linked_campaign_datetime
FROM campaigns c
INNER JOIN prospect_list_campaigns pc ON (c.id = pc.campaign_id)
INNER JOIN prospect_lists p ON (p.id = pc.prospect_list_id)
WHERE
c.deleted = 0 AND
pc.deleted = 0 AND
p.deleted = 0

How to Make an API call to retrieve Leads from ProspectLists which are linked after a certain date?
I'm making an API call to ProspectLists with a filter added as date_modified >= Specific date-time, but this is filtering date_modified filed on leads table, not on  ProspectLists table.