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

Getting error in deal_product table #125

Open jensbohse opened 1 year ago

jensbohse commented 1 year ago

Since Sunday we get the following error when importing with Stitch Data. Does anyone have the same problem?

Also when I create a new destination and source with Pipedrive the same error occurs. There even new tables are created. We urgently need updated data and the Stitchdata support simply does not answer.

image
akmnko commented 1 year ago

We're experiencing the same problem, also starting Sunday January 19th. Exactly the same scenario with deal_product not working correctly.

jensbohse commented 1 year ago

Hey @akmnko,

We have found a solution. Pipedrive has completely deleted all deleted products on January 19, this also meant that the deleted products could no longer be accessed as usual. Unfortunately, we had to go through all the deals where these deleted products are still present, after that everything worked again.

Gabrieldlramos commented 1 year ago

Hey @akmnko we are having the same issue with the Deal table we are receiving a similar messagem, amd @jensbohse

deal: data does not match {'type': ['object', 'null'], 'properties': {'title': {'type': 'string'}}} : data does not match {'type': 'object', 'properties': {'person_id': {'type': ['integer', 'null']}, 'user_id': {'type': 'integer'}, 'pinned_to_lead_flag': {'type': ['string', 'null']}, 'update_time': {'type': ['string', 'null'], 'format': 'date-time'}, 'last_update_user_id': {'type': ['integer', 'null']}, 'pinned_to_organization_flag': {'type': ['boolean', 'null']}, 'id': {'type': 'integer'}, 'deal': {'type': ['object', 'null'], 'properties': {'title': {'type': 'string'}}}, 'person': {'type': ['object', 'null'], 'required': ['name'], 'properties': {'name': {'type': 'string'}}}, 'content': {'type': ['string', 'null']}, 'pinned_to_person_flag': {'type': ['boolean', 'null']}, 'active_flag': {'type': ['boolean', 'null']}, 'deal_id': {'type': ['integer', 'null']}, 'add_time': {'type': ['string', 'null'], 'format': 'date-time'}, 'lead_id': {'type': ['string', 'null']}, 'user': {'type': 'object', 'properties': {'is_you': {'type': 'boolean'}, 'icon_url': {'type': ['string', 'null']}, 'email': {'type': ['string', 'null']}, 'name': {'type': ['string', 'null']}}}, 'organization': {'type': ['object', 'null'], 'properties': {'name': {'type': 'string'}}}, 'pinned_to_deal_flag': {'type': ['boolean', 'null']}, 'org_id': {'type': ['integer', 'null']}}}

Do you think undeleting deals could have the same effect? or seeing if any of the deals have a deleted product, Kind regards