API call to retrieve Leads/Contact from ProspectLists(Target List) which are linked after a certain date

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. 

Parents
  • There is no dedicated API call yet for that specific information.

    Perhaps you could define a custom collection definition on the ProspectList module to enable something like 
    .../rest/v10/ProspectLists/<id>/collection/leadlist

    But unfortunately the documentation for such a custom definition of a collection is still not available. Perhaps you can have a look on collection definitions in vardef files.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Reply
  • There is no dedicated API call yet for that specific information.

    Perhaps you could define a custom collection definition on the ProspectList module to enable something like 
    .../rest/v10/ProspectLists/<id>/collection/leadlist

    But unfortunately the documentation for such a custom definition of a collection is still not available. Perhaps you can have a look on collection definitions in vardef files.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Children
  • Hi Harald,
    Thank you for your quick response. Is there a table between Lead/Contact and ProspectLists? I'm looking for leads/Contacts linked to ProspectLists after a specific date. 
    My API calling this - /{ProspectLists }/{id}/{Link}/{leads} with filter date_modified >= Specific Date.

    This does not bring me leads that are linked to ProspectLists after a specific date if I add existing leads.
    It's working only if I add brand new leads to ProspectLists.