Optimising Activities request via API

Hi, once per day we’re using the endpoint to import all open activities updated since the previous day. This process has been taking around 4 hours lately, so we decided to delve into this. We found out that a basic request for 500 records, https://api.pipedrive.com/v1/activities?user_id={user_id}&start=0&filter_id={filter_id}&limit=500&api_token={token}, is taking around 40 seconds.

Given that we have around 200000 activities after filtering, this explains the long import duration. However, it seems to us that importing 500 records should not take this long. Are we missing something? How could we optimise this process? Any ideas will be highly appreciated :slight_smile:

Thanks for the feedback. While we look into this, we believe that the following wiki might be useful

https://devcommunity.pipedrive.com/t/integrating-pipedrive-with-other-products/4956/6