Is there any field which stores the date when existing record get linked with target list of Campaign
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.
You can get datetime using advance query
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)
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.