singer-io / tap-pipedrive

A Singer.io tap for extracting data from the Pipedrive API
GNU Affero General Public License v3.0
13 stars 34 forks source link

Deleted product from deal is not updated to replicated data #110

Open LianaJarkkoRanta opened 2 years ago

LianaJarkkoRanta commented 2 years ago

We use Pipedrive connector via Stitchdata to replicate data from Pipedrive to Google BigQuery. Connector has generally worked well but now we noticed that Pipedrive deal products data is not replicated correctly.

There is one annoying bug that if we delete a product from Pipedrive deal --> information is updated to Pipedrive API but connector cannot update the information also to Google BigQuery. Deleted product will stay forever in BigQuery database eventhough that is not valid anymore in data that connector is replicating. All the other changes (added, modified, hidden) related to deal products are updating normally.

jensbohse commented 2 years ago

Hey! I have the same problem and am already considering using another importer.... Unfortunately, it is so difficult to make a forecasting and our sales are then also not correct, if before the signing still products are changed. Have you found a solution?

danpermun commented 1 year ago

Hello ! I am having the same problem with Stitchdata, but in my scenario my destination is AWS Redshift. Any solution ?