search

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

Error Pipedrive Extraction #61

Open warwintryborn opened 5 years ago

warwintryborn commented 5 years ago

Hi, I am having problem with data extraction from Pipedrive on Stitch. The error appears is "Errors during transform". This error occurred since Aug-22.

May you help me? Below is Raw extratcion logs:

2019-09-05 14:43:58,926Z main - INFO Running tap-pipedrive version 1.0.4 and target-stitch version 1.8.1 2019-09-05 14:43:59,047Z main - INFO Starting tap to discover schemas: tap-env/bin/tap-pipedrive --config /tmp/tap_discover_config.json --discover 2019-09-05 14:43:59,218Z tap - INFO Starting discover 2019-09-05 14:43:59,925Z tap - INFO Finished discover 2019-09-05 14:43:59,950Z main - INFO Tap exited normally. 2019-09-05 14:43:59,952Z main - INFO Saving list of discovered streams 2019-09-05 14:43:59,969Z main - INFO Saving structure of stream currency 2019-09-05 14:43:59,997Z main - INFO Saving structure of stream activity_types 2019-09-05 14:44:00,014Z main - INFO Saving structure of stream stages 2019-09-05 14:44:00,472Z main - INFO Saving structure of stream filters 2019-09-05 14:44:00,627Z main - INFO Saving structure of stream pipelines 2019-09-05 14:44:00,775Z main - INFO Saving structure of stream notes 2019-09-05 14:44:01,135Z main - INFO Saving structure of stream users 2019-09-05 14:44:01,194Z main - INFO Saving structure of stream activities 2019-09-05 14:44:01,308Z main - INFO Saving structure of stream deals 2019-09-05 14:44:01,530Z main - INFO Saving structure of stream files 2019-09-05 14:44:01,583Z main - INFO Saving structure of stream organizations 2019-09-05 14:44:01,723Z main - INFO Saving structure of stream persons 2019-09-05 14:44:01,988Z main - INFO Saving structure of stream products 2019-09-05 14:44:02,270Z main - INFO Saving structure of stream delete_log 2019-09-05 14:44:02,532Z main - INFO Saving structure of stream dealflow 2019-09-05 14:44:02,622Z main - INFO Saving structure of stream deal_products 2019-09-05 14:44:02,762Z main - INFO Getting list of selected properties 2019-09-05 14:44:03,084Z main - INFO Starting tap: tap-env/bin/tap-pipedrive --config /tmp/tap_config.json --properties /tmp/properties.json --catalog /tmp/catalog.json --state /tmp/tap_state.json 2019-09-05 14:44:03,086Z main - INFO Starting target: target-env/bin/target-stitch --config /tmp/target_config.json 2019-09-05 14:44:03,272Z tap - INFO Skipping stream currency as resuming from deals 2019-09-05 14:44:03,272Z tap - INFO Skipping stream activity_types as resuming from deals 2019-09-05 14:44:03,272Z tap - INFO Skipping stream stages as resuming from deals 2019-09-05 14:44:03,272Z tap - INFO Skipping stream filters as resuming from deals 2019-09-05 14:44:03,273Z tap - INFO Skipping stream pipelines as resuming from deals 2019-09-05 14:44:03,273Z tap - INFO Skipping stream notes as resuming from deals 2019-09-05 14:44:03,273Z tap - INFO Skipping stream users as resuming from deals 2019-09-05 14:44:03,273Z tap - INFO Skipping stream activities as resuming from deals 2019-09-05 14:44:03,273Z tap - INFO Resuming from deals 2019-09-05 14:44:03,393Z target - INFO Using Stitch import URL https://api.stitchdata.com/v2/import/batch 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.activities.update_time = "2019-08-20T21:30:14+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.activity_types.update_time = "2019-07-17T13:54:29+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.dealflow.log_time = "2019-08-20T18:26:24.284354+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.deals.update_time = "2019-08-20T20:26:36+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.files.update_time = "2019-08-20T20:19:04+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.filters.update_time = "2019-08-19T14:25:48+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.notes.update_time = "2019-08-20T21:51:32+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.organizations.update_time = "2019-08-20T20:26:36+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.persons.update_time = "2019-08-20T20:26:36+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.pipelines.update_time = "2019-06-07T22:19:44+00:00" 2019-09-05 14:44:03,394Z main - INFO State update: adding bookmarks.products.update_time = "2019-07-03T14:49:41+00:00" 2019-09-05 14:44:03,395Z main - INFO State update: adding bookmarks.stages.update_time = "2019-08-06T20:26:28+00:00" 2019-09-05 14:44:03,395Z main - INFO State update: adding currently_syncing = "deals" 2019-09-05 14:44:03,629Z tap - INFO HTTP request to "deals" endpoint took 0.260s, returned status code 200 2019-09-05 14:44:03,743Z tap - WARNING year is out of range, (0000-00-00 00:00:00) 2019-09-05 14:44:03,745Z tap - WARNING Removed 15 paths during transforms: 2019-09-05 14:44:03,745Z tap - 2959b6cf42b057ccb00516ccfead4e4d2b2103d0 2019-09-05 14:44:03,745Z tap - 758706bcae449ad3a1a4284d0ed948485ab3f493 2019-09-05 14:44:03,745Z tap - 7866911bdb49ba8ce2d6f15cc1a82de6f150a890 2019-09-05 14:44:03,745Z tap - 7b616bbf2165239959dc171d56a5f24bb250f9ca 2019-09-05 14:44:03,745Z tap - 883562f9aa3cc5b57965cddb0ac25f7192a4ba40 2019-09-05 14:44:03,745Z tap - a691cae5c929fbb89310537063d6d94f719a0628 2019-09-05 14:44:03,745Z tap - a863255148d9dd52cda44afd39d9c9ad6366cb20 2019-09-05 14:44:03,745Z tap - aba3b830c7182f46bc48887725f13549bc53591e 2019-09-05 14:44:03,745Z tap - bac1f7da1572ffb203d4952c1d20b5dd18b7ed35 2019-09-05 14:44:03,745Z tap - cf029c16c837c08896473078a887c82fdd5eb7fd 2019-09-05 14:44:03,746Z tap - d0dcd82449a2a614970ffc2271b0d65a326b9070 2019-09-05 14:44:03,746Z tap - ddc7f2156b24cb5f2eb4dea19f4c11a9d3370c95 2019-09-05 14:44:03,746Z tap - e359700ae6ab944b9dc402eb1b34ab05db462d02 2019-09-05 14:44:03,746Z tap - fad73eb539ff739c9d40880dbd534f1629472a25 2019-09-05 14:44:03,746Z tap - label 2019-09-05 14:44:03,746Z tap - WARNING Removed paths list: ['2959b6cf42b057ccb00516ccfead4e4d2b2103d0', '758706bcae449ad3a1a4284d0ed948485ab3f493', '7866911bdb49ba8ce2d6f15cc1a82de6f150a890', '7b616bbf2165239959dc171d56a5f24bb250f9ca', '883562f9aa3cc5b57965cddb0ac25f7192a4ba40', 'a691cae5c929fbb89310537063d6d94f719a0628', 'a863255148d9dd52cda44afd39d9c9ad6366cb20', 'aba3b830c7182f46bc48887725f13549bc53591e', 'bac1f7da1572ffb203d4952c1d20b5dd18b7ed35', 'cf029c16c837c08896473078a887c82fdd5eb7fd', 'd0dcd82449a2a614970ffc2271b0d65a326b9070', 'ddc7f2156b24cb5f2eb4dea19f4c11a9d3370c95', 'e359700ae6ab944b9dc402eb1b34ab05db462d02', 'fad73eb539ff739c9d40880dbd534f1629472a25', 'label'] 2019-09-05 14:44:03,746Z tap - INFO replicated 76 records from "deals" endpoint 2019-09-05 14:44:03,746Z tap - CRITICAL Errors during transform 2019-09-05 14:44:03,746Z tap - first_won_time: 0000-00-00 00:00:00 does not match {'format': 'date-time', 'type': ['string', 'null']} 2019-09-05 14:44:03,746Z tap - : {'7f6a4c86fcc21a0f5001b7dd997566ff709d79a7': '263', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_street_number': None, 'value': 1767.34, 'participants_count': 0, 'bac1f7da1572ffb203d4952c1d20b5dd18b7ed35': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_sublocality': None, 'stage_id': 123, 'expected_close_date': None, 'person_hidden': False, 'next_activity_time': None, '25ba250a3d4443dafcd0b59d5b8501bfad3a1d4c': '266', '567fc60ff309cb97fe7c570bd37ec12d880a14dc': None, 'org_name': 'BMW - Contrato', 'person_name': None, 'active': False, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_route': None, 'd0dcd82449a2a614970ffc2271b0d65a326b9070': None, '6dcc8245a6fb963676af5a24f79a02d0afa446f7': None, 'last_outgoing_mail_time': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_1': 'Santa Catarina', 'files_count': 0, 'lost_time': None, 'org_id': 11973, 'title': 'MANUTEN��O DOS SISTEMAS DE AUTOMA��O E/OU SEGURAN�A ELETR�NICA PREDIAL C�D - B1T NR', '560be1591f5c3eeb982f1a43f73c8cc6f9dd7f19': 'C05385004000582', 'e359700ae6ab944b9dc402eb1b34ab05db462d02': None, 'followers_count': 0, 'first_won_time': '0000-00-00 00:00:00', '7866911bdb49ba8ce2d6f15cc1a82de6f150a890': None, 'next_activity_note': None, '2959b6cf42b057ccb00516ccfead4e4d2b2103d0': None, 'close_time': '2019-08-21 13:40:53', 'owner_name': 'Amanda Domingues', '883562f9aa3cc5b57965cddb0ac25f7192a4ba40': None, 'next_activity_duration': None, '8736987144ca5adee8900ddd592604cafb766d68': None, '758706bcae449ad3a1a4284d0ed948485ab3f493': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_country': 'Brasil', 'fad73eb539ff739c9d40880dbd534f1629472a25': None, 'org_hidden': False, 'next_activity_date': None, 'b8fa89a2aacc21ea4f1d9bd4b226d74f551cde11': None, '7d10345f7b8bfad8fd59c68b2ddcf75f8df2d055': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_postal_code': None, 'deleted': True, 'a863255148d9dd52cda44afd39d9c9ad6366cb20': None, 'next_activity_id': None, 'last_activity_id': None, '58fe86f2ba1f6716ef7cf31d5c87dcc4c0b933a1': None, 'stage_order_nr': 9, 'weighted_value_currency': 'BRL', 'email_messages_count': 0, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_formatted_address': 'Joinville - SC, Brasil', 'done_activities_count': 0, 'update_time': '2019-08-21 13:40:53', 'stage_change_time': None, 'ad75ae6ce334d1383bee83dbac8fd39f853f04a6': '472-2', 'eeac3647750d674f47668a0060ab1713a830348d': None, 'ddc7f2156b24cb5f2eb4dea19f4c11a9d3370c95': None, 'next_activity_subject': None, 'status': 'deleted', 'probability': None, 'id': 12935, 'cc_email': 'evertical2+deal12935@pipedrivemail.com', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_locality': None, 'creator_user_id': 5759137, '59a7351d0b0ccbf6e67e38cbde07749117805ed4': 'JOINVILLE', 'aba3b830c7182f46bc48887725f13549bc53591e': None, '9d3b5db9aff7903b7a353715b14be92d3aa6d999': '180', 'cf029c16c837c08896473078a887c82fdd5eb7fd': None, 'add_time': '2019-08-20 21:39:09', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_2': 'Joinville', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_subpremise': None, 'last_incoming_mail_time': None, '9ac4d6226280789c1acf887648b4eaa168640b08': '1970-01-01', 'label': None, 'ede292fd3271572a8ee43bf066faa6368da5bdec': None, 'next_activity_type': None, 'won_time': None, 'products_count': 0, 'currency': 'BRL', '7b616bbf2165239959dc171d56a5f24bb250f9ca': None, 'person_id': None, 'rotten_time': None, '6ff4e1c32b8d100a63acc58b50efed41740d015a': None, '63011ec62a4f8528719fcd2e485578b374df13d0': None, '651685a82af190fa79db57f79421a05c6cbaeeed': None, '4130f450addd36c0f71f8b4513a8ce61eca6084c': 'BMW JOINVILLE', '17c31746c32222b6ee130ed07fd22d2630c8b375': None, 'undone_activities_count': 0, 'activities_count': 0, 'weighted_value': 1590.61, 'c309f97b01c3c91810bc057b96b5a2a6809fee4b': '2027-01-06', 'pipeline_id': 1, 'fed79da883be601b7dcfe8dd00bd8c3b6ac07e71': None, 'user_id': 5759137, 'reference_activities_count': 0, 'a691cae5c929fbb89310537063d6d94f719a0628': None, 'visible_to': '1', 'last_activity_date': None, 'formatted_weighted_value': 'R$\xa01.590,61', 'formatted_value': 'R$\xa01.767,34', 'lost_reason': None, 'notes_count': 0} does not match {'properties': {'59a7351d0b0ccbf6e67e38cbde07749117805ed4_street_number': {'type': ['string', 'null']}, 'value': {'type': ['number', 'null']}, 'participants_count': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_sublocality': {'type': ['string', 'null']}, 'pipeline': {'type': ['string', 'null']}, 'stage_id': {'type': ['integer', 'null']}, 'expected_close_date': {'type': ['string', 'null']}, 'person_hidden': {'type': ['boolean', 'null']}, 'next_activity_time': {'type': ['string', 'null']}, '25ba250a3d4443dafcd0b59d5b8501bfad3a1d4c': {'type': ['string', 'null']}, '567fc60ff309cb97fe7c570bd37ec12d880a14dc': {'type': ['string', 'null']}, 'org_name': {'type': ['string', 'null']}, 'person_name': {'type': ['string', 'null']}, 'active': {'type': ['boolean', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_route': {'type': ['string', 'null']}, '6dcc8245a6fb963676af5a24f79a02d0afa446f7': {'type': ['string', 'null']}, 'last_outgoing_mail_time': {'format': 'date-time', 'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_1': {'type': ['string', 'null']}, 'lost_time': {'format': 'date-time', 'type': ['string', 'null']}, 'files_count': {'type': ['integer', 'null']}, '7f6a4c86fcc21a0f5001b7dd997566ff709d79a7': {'type': ['string', 'null']}, 'title': {'type': ['string', 'null']}, '560be1591f5c3eeb982f1a43f73c8cc6f9dd7f19': {'type': ['string', 'null']}, 'followers_count': {'type': ['integer', 'null']}, 'first_won_time': {'format': 'date-time', 'type': ['string', 'null']}, 'close_time': {'format': 'date-time', 'type': ['string', 'null']}, 'owner_name': {'type': ['string', 'null']}, 'next_activity_duration': {'type': ['string', 'null']}, '8736987144ca5adee8900ddd592604cafb766d68': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_country': {'type': ['string', 'null']}, 'org_id': {'type': ['integer', 'null']}, 'c309f97b01c3c91810bc057b96b5a2a6809fee4b': {'type': ['string', 'null']}, 'next_activity_date': {'type': ['string', 'null']}, 'b8fa89a2aacc21ea4f1d9bd4b226d74f551cde11': {'type': ['string', 'null']}, '7d10345f7b8bfad8fd59c68b2ddcf75f8df2d055': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_postal_code': {'type': ['string', 'null']}, 'deleted': {'type': ['boolean', 'null']}, 'next_activity_id': {'type': ['integer', 'null']}, 'last_activity_id': {'type': ['integer', 'null']}, '58fe86f2ba1f6716ef7cf31d5c87dcc4c0b933a1': {'type': ['string', 'null']}, 'stage_order_nr': {'type': ['integer', 'null']}, 'weighted_value_currency': {'type': ['string', 'null']}, 'email_messages_count': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_formatted_address': {'type': ['string', 'null']}, 'done_activities_count': {'type': ['integer', 'null']}, 'update_time': {'format': 'date-time', 'type': ['string', 'null']}, 'stage_change_time': {'format': 'date-time', 'type': ['string', 'null']}, 'ad75ae6ce334d1383bee83dbac8fd39f853f04a6': {'type': ['string', 'null']}, 'eeac3647750d674f47668a0060ab1713a830348d': {'type': ['string', 'null']}, 'next_activity_subject': {'type': ['string', 'null']}, 'status': {'type': ['string', 'null']}, 'probability': {'type': ['number', 'null']}, 'id': {'type': 'integer'}, 'cc_email': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_locality': {'type': ['string', 'null']}, 'creator_user_id': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4': {'type': ['string', 'null']}, '9d3b5db9aff7903b7a353715b14be92d3aa6d999': {'type': ['string', 'null']}, 'add_time': {'format': 'date-time', 'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_2': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_subpremise': {'type': ['string', 'null']}, 'last_incoming_mail_time': {'format': 'date-time', 'type': ['string', 'null']}, '9ac4d6226280789c1acf887648b4eaa168640b08': {'type': ['string', 'null']}, 'next_activity_note': {'type': ['string', 'null']}, 'ede292fd3271572a8ee43bf066faa6368da5bdec': {'type': ['string', 'null']}, 'next_activity_type': {'type': ['string', 'null']}, 'won_time': {'format': 'date-time', 'type': ['string', 'null']}, 'products_count': {'type': ['integer', 'null']}, 'currency': {'type': ['string', 'null']}, 'person_id': {'type': ['integer', 'null']}, 'rotten_time': {'format': 'date-time', 'type': ['string', 'null']}, '6ff4e1c32b8d100a63acc58b50efed41740d015a': {'type': ['string', 'null']}, '63011ec62a4f8528719fcd2e485578b374df13d0': {'type': ['string', 'null']}, '651685a82af190fa79db57f79421a05c6cbaeeed': {'type': ['string', 'null']}, '4130f450addd36c0f71f8b4513a8ce61eca6084c': {'type': ['string', 'null']}, '17c31746c32222b6ee130ed07fd22d2630c8b375': {'type': ['string', 'null']}, 'undone_activities_count': {'type': ['integer', 'null']}, 'activities_count': {'type': ['integer', 'null']}, 'weighted_value': {'type': ['number', 'null']}, 'org_hidden': {'type': ['boolean', 'null']}, 'pipeline_id': {'type': ['integer', 'null']}, 'fed79da883be601b7dcfe8dd00bd8c3b6ac07e71': {'type': ['string', 'null']}, 'user_id': {'type': ['integer', 'null']}, 'reference_activities_count': {'type': ['integer', 'null']}, 'visible_to': {'type': ['string', 'null']}, 'last_activity_date': {'type': ['string', 'null']}, 'formatted_weighted_value': {'type': ['string', 'null']}, 'formatted_value': {'type': ['string', 'null']}, 'lost_reason': {'type': ['string', 'null']}, 'notes_count': {'type': ['integer', 'null']}}, 'type': 'object'} 2019-09-05 14:44:03,746Z tap - 2019-09-05 14:44:03,746Z tap - 2019-09-05 14:44:03,747Z tap - Errors during transform: [first_won_time: 0000-00-00 00:00:00 does not match {'format': 'date-time', 'type': ['string', 'null']}, : {'7f6a4c86fcc21a0f5001b7dd997566ff709d79a7': '263', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_street_number': None, 'value': 1767.34, 'participants_count': 0, 'bac1f7da1572ffb203d4952c1d20b5dd18b7ed35': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_sublocality': None, 'stage_id': 123, 'expected_close_date': None, 'person_hidden': False, 'next_activity_time': None, '25ba250a3d4443dafcd0b59d5b8501bfad3a1d4c': '266', '567fc60ff309cb97fe7c570bd37ec12d880a14dc': None, 'org_name': 'BMW - Contrato', 'person_name': None, 'active': False, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_route': None, 'd0dcd82449a2a614970ffc2271b0d65a326b9070': None, '6dcc8245a6fb963676af5a24f79a02d0afa446f7': None, 'last_outgoing_mail_time': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_1': 'Santa Catarina', 'files_count': 0, 'lost_time': None, 'org_id': 11973, 'title': 'MANUTEN��O DOS SISTEMAS DE AUTOMA��O E/OU SEGURAN�A ELETR�NICA PREDIAL C�D - B1T NR', '560be1591f5c3eeb982f1a43f73c8cc6f9dd7f19': 'C05385004000582', 'e359700ae6ab944b9dc402eb1b34ab05db462d02': None, 'followers_count': 0, 'first_won_time': '0000-00-00 00:00:00', '7866911bdb49ba8ce2d6f15cc1a82de6f150a890': None, 'next_activity_note': None, '2959b6cf42b057ccb00516ccfead4e4d2b2103d0': None, 'close_time': '2019-08-21 13:40:53', 'owner_name': 'Amanda Domingues', '883562f9aa3cc5b57965cddb0ac25f7192a4ba40': None, 'next_activity_duration': None, '8736987144ca5adee8900ddd592604cafb766d68': None, '758706bcae449ad3a1a4284d0ed948485ab3f493': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_country': 'Brasil', 'fad73eb539ff739c9d40880dbd534f1629472a25': None, 'org_hidden': False, 'next_activity_date': None, 'b8fa89a2aacc21ea4f1d9bd4b226d74f551cde11': None, '7d10345f7b8bfad8fd59c68b2ddcf75f8df2d055': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_postal_code': None, 'deleted': True, 'a863255148d9dd52cda44afd39d9c9ad6366cb20': None, 'next_activity_id': None, 'last_activity_id': None, '58fe86f2ba1f6716ef7cf31d5c87dcc4c0b933a1': None, 'stage_order_nr': 9, 'weighted_value_currency': 'BRL', 'email_messages_count': 0, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_formatted_address': 'Joinville - SC, Brasil', 'done_activities_count': 0, 'update_time': '2019-08-21 13:40:53', 'stage_change_time': None, 'ad75ae6ce334d1383bee83dbac8fd39f853f04a6': '472-2', 'eeac3647750d674f47668a0060ab1713a830348d': None, 'ddc7f2156b24cb5f2eb4dea19f4c11a9d3370c95': None, 'next_activity_subject': None, 'status': 'deleted', 'probability': None, 'id': 12935, 'cc_email': 'evertical2+deal12935@pipedrivemail.com', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_locality': None, 'creator_user_id': 5759137, '59a7351d0b0ccbf6e67e38cbde07749117805ed4': 'JOINVILLE', 'aba3b830c7182f46bc48887725f13549bc53591e': None, '9d3b5db9aff7903b7a353715b14be92d3aa6d999': '180', 'cf029c16c837c08896473078a887c82fdd5eb7fd': None, 'add_time': '2019-08-20 21:39:09', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_2': 'Joinville', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_subpremise': None, 'last_incoming_mail_time': None, '9ac4d6226280789c1acf887648b4eaa168640b08': '1970-01-01', 'label': None, 'ede292fd3271572a8ee43bf066faa6368da5bdec': None, 'next_activity_type': None, 'won_time': None, 'products_count': 0, 'currency': 'BRL', '7b616bbf2165239959dc171d56a5f24bb250f9ca': None, 'person_id': None, 'rotten_time': None, '6ff4e1c32b8d100a63acc58b50efed41740d015a': None, '63011ec62a4f8528719fcd2e485578b374df13d0': None, '651685a82af190fa79db57f79421a05c6cbaeeed': None, '4130f450addd36c0f71f8b4513a8ce61eca6084c': 'BMW JOINVILLE', '17c31746c32222b6ee130ed07fd22d2630c8b375': None, 'undone_activities_count': 0, 'activities_count': 0, 'weighted_value': 1590.61, 'c309f97b01c3c91810bc057b96b5a2a6809fee4b': '2027-01-06', 'pipeline_id': 1, 'fed79da883be601b7dcfe8dd00bd8c3b6ac07e71': None, 'user_id': 5759137, 'reference_activities_count': 0, 'a691cae5c929fbb89310537063d6d94f719a0628': None, 'visible_to': '1', 'last_activity_date': None, 'formatted_weighted_value': 'R$\xa01.590,61', 'formatted_value': 'R$\xa01.767,34', 'lost_reason': None, 'notes_count': 0} does not match {'properties': {'59a7351d0b0ccbf6e67e38cbde07749117805ed4_street_number': {'type': ['string', 'null']}, 'value': {'type': ['number', 'null']}, 'participants_count': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_sublocality': {'type': ['string', 'null']}, 'pipeline': {'type': ['string', 'null']}, 'stage_id': {'type': ['integer', 'null']}, 'expected_close_date': {'type': ['string', 'null']}, 'person_hidden': {'type': ['boolean', 'null']}, 'next_activity_time': {'type': ['string', 'null']}, '25ba250a3d4443dafcd0b59d5b8501bfad3a1d4c': {'type': ['string', 'null']}, '567fc60ff309cb97fe7c570bd37ec12d880a14dc': {'type': ['string', 'null']}, 'org_name': {'type': ['string', 'null']}, 'person_name': {'type': ['string', 'null']}, 'active': {'type': ['boolean', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_route': {'type': ['string', 'null']}, '6dcc8245a6fb963676af5a24f79a02d0afa446f7': {'type': ['string', 'null']}, 'last_outgoing_mail_time': {'format': 'date-time', 'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_1': {'type': ['string', 'null']}, 'lost_time': {'format': 'date-time', 'type': ['string', 'null']}, 'files_count': {'type': ['integer', 'null']}, '7f6a4c86fcc21a0f5001b7dd997566ff709d79a7': {'type': ['string', 'null']}, 'title': {'type': ['string', 'null']}, '560be1591f5c3eeb982f1a43f73c8cc6f9dd7f19': {'type': ['string', 'null']}, 'followers_count': {'type': ['integer', 'null']}, 'first_won_time': {'format': 'date-time', 'type': ['string', 'null']}, 'close_time': {'format': 'date-time', 'type': ['string', 'null']}, 'owner_name': {'type': ['string', 'null']}, 'next_activity_duration': {'type': ['string', 'null']}, '8736987144ca5adee8900ddd592604cafb766d68': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_country': {'type': ['string', 'null']}, 'org_id': {'type': ['integer', 'null']}, 'c309f97b01c3c91810bc057b96b5a2a6809fee4b': {'type': ['string', 'null']}, 'next_activity_date': {'type': ['string', 'null']}, 'b8fa89a2aacc21ea4f1d9bd4b226d74f551cde11': {'type': ['string', 'null']}, '7d10345f7b8bfad8fd59c68b2ddcf75f8df2d055': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_postal_code': {'type': ['string', 'null']}, 'deleted': {'type': ['boolean', 'null']}, 'next_activity_id': {'type': ['integer', 'null']}, 'last_activity_id': {'type': ['integer', 'null']}, '58fe86f2ba1f6716ef7cf31d5c87dcc4c0b933a1': {'type': ['string', 'null']}, 'stage_order_nr': {'type': ['integer', 'null']}, 'weighted_value_currency': {'type': ['string', 'null']}, 'email_messages_count': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_formatted_address': {'type': ['string', 'null']}, 'done_activities_count': {'type': ['integer', 'null']}, 'update_time': {'format': 'date-time', 'type': ['string', 'null']}, 'stage_change_time': {'format': 'date-time', 'type': ['string', 'null']}, 'ad75ae6ce334d1383bee83dbac8fd39f853f04a6': {'type': ['string', 'null']}, 'eeac3647750d674f47668a0060ab1713a830348d': {'type': ['string', 'null']}, 'next_activity_subject': {'type': ['string', 'null']}, 'status': {'type': ['string', 'null']}, 'probability': {'type': ['number', 'null']}, 'id': {'type': 'integer'}, 'cc_email': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_locality': {'type': ['string', 'null']}, 'creator_user_id': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4': {'type': ['string', 'null']}, '9d3b5db9aff7903b7a353715b14be92d3aa6d999': {'type': ['string', 'null']}, 'add_time': {'format': 'date-time', 'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_2': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_subpremise': {'type': ['string', 'null']}, 'last_incoming_mail_time': {'format': 'date-time', 'type': ['string', 'null']}, '9ac4d6226280789c1acf887648b4eaa168640b08': {'type': ['string', 'null']}, 'next_activity_note': {'type': ['string', 'null']}, 'ede292fd3271572a8ee43bf066faa6368da5bdec': {'type': ['string', 'null']}, 'next_activity_type': {'type': ['string', 'null']}, 'won_time': {'format': 'date-time', 'type': ['string', 'null']}, 'products_count': {'type': ['integer', 'null']}, 'currency': {'type': ['string', 'null']}, 'person_id': {'type': ['integer', 'null']}, 'rotten_time': {'format': 'date-time', 'type': ['string', 'null']}, '6ff4e1c32b8d100a63acc58b50efed41740d015a': {'type': ['string', 'null']}, '63011ec62a4f8528719fcd2e485578b374df13d0': {'type': ['string', 'null']}, '651685a82af190fa79db57f79421a05c6cbaeeed': {'type': ['string', 'null']}, '4130f450addd36c0f71f8b4513a8ce61eca6084c': {'type': ['string', 'null']}, '17c31746c32222b6ee130ed07fd22d2630c8b375': {'type': ['string', 'null']}, 'undone_activities_count': {'type': ['integer', 'null']}, 'activities_count': {'type': ['integer', 'null']}, 'weighted_value': {'type': ['number', 'null']}, 'org_hidden': {'type': ['boolean', 'null']}, 'pipeline_id': {'type': ['integer', 'null']}, 'fed79da883be601b7dcfe8dd00bd8c3b6ac07e71': {'type': ['string', 'null']}, 'user_id': {'type': ['integer', 'null']}, 'reference_activities_count': {'type': ['integer', 'null']}, 'visible_to': {'type': ['string', 'null']}, 'last_activity_date': {'type': ['string', 'null']}, 'formatted_weighted_value': {'type': ['string', 'null']}, 'formatted_value': {'type': ['string', 'null']}, 'lost_reason': {'type': ['string', 'null']}, 'notes_count': {'type': ['integer', 'null']}}, 'type': 'object'}] 2019-09-05 14:44:03,747Z tap - Traceback (most recent call last): 2019-09-05 14:44:03,747Z tap - File "tap-env/bin/tap-pipedrive", line 10, in 2019-09-05 14:44:03,747Z tap - sys.exit(main()) 2019-09-05 14:44:03,747Z tap - File "/code/orchestrator/tap-env/lib/python3.5/site-packages/tap_pipedrive/cli.py", line 34, in main 2019-09-05 14:44:03,747Z tap - raise e 2019-09-05 14:44:03,747Z tap - File "/code/orchestrator/tap-env/lib/python3.5/site-packages/tap_pipedrive/cli.py", line 31, in main 2019-09-05 14:44:03,747Z tap - main_impl() 2019-09-05 14:44:03,747Z tap - File "/code/orchestrator/tap-env/lib/python3.5/site-packages/tap_pipedrive/cli.py", line 26, in main_impl 2019-09-05 14:44:03,747Z tap - pipedrive_tap.do_sync(catalog) 2019-09-05 14:44:03,747Z tap - File "/code/orchestrator/tap-env/lib/python3.5/site-packages/tap_pipedrive/tap.py", line 151, in do_sync 2019-09-05 14:44:03,747Z tap - self.do_paginate(stream, stream_metadata) 2019-09-05 14:44:03,747Z tap - File "/code/orchestrator/tap-env/lib/python3.5/site-packages/tap_pipedrive/tap.py", line 197, in do_paginate 2019-09-05 14:44:03,747Z tap - row = optimus_prime.transform(row, stream.get_schema(), stream_metadata) 2019-09-05 14:44:03,747Z tap - File "/code/orchestrator/tap-env/lib/python3.5/site-packages/singer/transform.py", line 127, in transform 2019-09-05 14:44:03,748Z tap - raise SchemaMismatch(self.errors) 2019-09-05 14:44:03,748Z tap - singer.transform.SchemaMismatch: Errors during transform 2019-09-05 14:44:03,748Z tap - first_won_time: 0000-00-00 00:00:00 does not match {'format': 'date-time', 'type': ['string', 'null']} 2019-09-05 14:44:03,748Z tap - : {'7f6a4c86fcc21a0f5001b7dd997566ff709d79a7': '263', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_street_number': None, 'value': 1767.34, 'participants_count': 0, 'bac1f7da1572ffb203d4952c1d20b5dd18b7ed35': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_sublocality': None, 'stage_id': 123, 'expected_close_date': None, 'person_hidden': False, 'next_activity_time': None, '25ba250a3d4443dafcd0b59d5b8501bfad3a1d4c': '266', '567fc60ff309cb97fe7c570bd37ec12d880a14dc': None, 'org_name': 'BMW - Contrato', 'person_name': None, 'active': False, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_route': None, 'd0dcd82449a2a614970ffc2271b0d65a326b9070': None, '6dcc8245a6fb963676af5a24f79a02d0afa446f7': None, 'last_outgoing_mail_time': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_1': 'Santa Catarina', 'files_count': 0, 'lost_time': None, 'org_id': 11973, 'title': 'MANUTEN��O DOS SISTEMAS DE AUTOMA��O E/OU SEGURAN�A ELETR�NICA PREDIAL C�D - B1T NR', '560be1591f5c3eeb982f1a43f73c8cc6f9dd7f19': 'C05385004000582', 'e359700ae6ab944b9dc402eb1b34ab05db462d02': None, 'followers_count': 0, 'first_won_time': '0000-00-00 00:00:00', '7866911bdb49ba8ce2d6f15cc1a82de6f150a890': None, 'next_activity_note': None, '2959b6cf42b057ccb00516ccfead4e4d2b2103d0': None, 'close_time': '2019-08-21 13:40:53', 'owner_name': 'Amanda Domingues', '883562f9aa3cc5b57965cddb0ac25f7192a4ba40': None, 'next_activity_duration': None, '8736987144ca5adee8900ddd592604cafb766d68': None, '758706bcae449ad3a1a4284d0ed948485ab3f493': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_country': 'Brasil', 'fad73eb539ff739c9d40880dbd534f1629472a25': None, 'org_hidden': False, 'next_activity_date': None, 'b8fa89a2aacc21ea4f1d9bd4b226d74f551cde11': None, '7d10345f7b8bfad8fd59c68b2ddcf75f8df2d055': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_postal_code': None, 'deleted': True, 'a863255148d9dd52cda44afd39d9c9ad6366cb20': None, 'next_activity_id': None, 'last_activity_id': None, '58fe86f2ba1f6716ef7cf31d5c87dcc4c0b933a1': None, 'stage_order_nr': 9, 'weighted_value_currency': 'BRL', 'email_messages_count': 0, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_formatted_address': 'Joinville - SC, Brasil', 'done_activities_count': 0, 'update_time': '2019-08-21 13:40:53', 'stage_change_time': None, 'ad75ae6ce334d1383bee83dbac8fd39f853f04a6': '472-2', 'eeac3647750d674f47668a0060ab1713a830348d': None, 'ddc7f2156b24cb5f2eb4dea19f4c11a9d3370c95': None, 'next_activity_subject': None, 'status': 'deleted', 'probability': None, 'id': 12935, 'cc_email': 'evertical2+deal12935@pipedrivemail.com', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_locality': None, 'creator_user_id': 5759137, '59a7351d0b0ccbf6e67e38cbde07749117805ed4': 'JOINVILLE', 'aba3b830c7182f46bc48887725f13549bc53591e': None, '9d3b5db9aff7903b7a353715b14be92d3aa6d999': '180', 'cf029c16c837c08896473078a887c82fdd5eb7fd': None, 'add_time': '2019-08-20 21:39:09', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_2': 'Joinville', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_subpremise': None, 'last_incoming_mail_time': None, '9ac4d6226280789c1acf887648b4eaa168640b08': '1970-01-01', 'label': None, 'ede292fd3271572a8ee43bf066faa6368da5bdec': None, 'next_activity_type': None, 'won_time': None, 'products_count': 0, 'currency': 'BRL', '7b616bbf2165239959dc171d56a5f24bb250f9ca': None, 'person_id': None, 'rotten_time': None, '6ff4e1c32b8d100a63acc58b50efed41740d015a': None, '63011ec62a4f8528719fcd2e485578b374df13d0': None, '651685a82af190fa79db57f79421a05c6cbaeeed': None, '4130f450addd36c0f71f8b4513a8ce61eca6084c': 'BMW JOINVILLE', '17c31746c32222b6ee130ed07fd22d2630c8b375': None, 'undone_activities_count': 0, 'activities_count': 0, 'weighted_value': 1590.61, 'c309f97b01c3c91810bc057b96b5a2a6809fee4b': '2027-01-06', 'pipeline_id': 1, 'fed79da883be601b7dcfe8dd00bd8c3b6ac07e71': None, 'user_id': 5759137, 'reference_activities_count': 0, 'a691cae5c929fbb89310537063d6d94f719a0628': None, 'visible_to': '1', 'last_activity_date': None, 'formatted_weighted_value': 'R$\xa01.590,61', 'formatted_value': 'R$\xa01.767,34', 'lost_reason': None, 'notes_count': 0} does not match {'properties': {'59a7351d0b0ccbf6e67e38cbde07749117805ed4_street_number': {'type': ['string', 'null']}, 'value': {'type': ['number', 'null']}, 'participants_count': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_sublocality': {'type': ['string', 'null']}, 'pipeline': {'type': ['string', 'null']}, 'stage_id': {'type': ['integer', 'null']}, 'expected_close_date': {'type': ['string', 'null']}, 'person_hidden': {'type': ['boolean', 'null']}, 'next_activity_time': {'type': ['string', 'null']}, '25ba250a3d4443dafcd0b59d5b8501bfad3a1d4c': {'type': ['string', 'null']}, '567fc60ff309cb97fe7c570bd37ec12d880a14dc': {'type': ['string', 'null']}, 'org_name': {'type': ['string', 'null']}, 'person_name': {'type': ['string', 'null']}, 'active': {'type': ['boolean', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_route': {'type': ['string', 'null']}, '6dcc8245a6fb963676af5a24f79a02d0afa446f7': {'type': ['string', 'null']}, 'last_outgoing_mail_time': {'format': 'date-time', 'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_1': {'type': ['string', 'null']}, 'lost_time': {'format': 'date-time', 'type': ['string', 'null']}, 'files_count': {'type': ['integer', 'null']}, '7f6a4c86fcc21a0f5001b7dd997566ff709d79a7': {'type': ['string', 'null']}, 'title': {'type': ['string', 'null']}, '560be1591f5c3eeb982f1a43f73c8cc6f9dd7f19': {'type': ['string', 'null']}, 'followers_count': {'type': ['integer', 'null']}, 'first_won_time': {'format': 'date-time', 'type': ['string', 'null']}, 'close_time': {'format': 'date-time', 'type': ['string', 'null']}, 'owner_name': {'type': ['string', 'null']}, 'next_activity_duration': {'type': ['string', 'null']}, '8736987144ca5adee8900ddd592604cafb766d68': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_country': {'type': ['string', 'null']}, 'org_id': {'type': ['integer', 'null']}, 'c309f97b01c3c91810bc057b96b5a2a6809fee4b': {'type': ['string', 'null']}, 'next_activity_date': {'type': ['string', 'null']}, 'b8fa89a2aacc21ea4f1d9bd4b226d74f551cde11': {'type': ['string', 'null']}, '7d10345f7b8bfad8fd59c68b2ddcf75f8df2d055': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_postal_code': {'type': ['string', 'null']}, 'deleted': {'type': ['boolean', 'null']}, 'next_activity_id': {'type': ['integer', 'null']}, 'last_activity_id': {'type': ['integer', 'null']}, '58fe86f2ba1f6716ef7cf31d5c87dcc4c0b933a1': {'type': ['string', 'null']}, 'stage_order_nr': {'type': ['integer', 'null']}, 'weighted_value_currency': {'type': ['string', 'null']}, 'email_messages_count': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_formatted_address': {'type': ['string', 'null']}, 'done_activities_count': {'type': ['integer', 'null']}, 'update_time': {'format': 'date-time', 'type': ['string', 'null']}, 'stage_change_time': {'format': 'date-time', 'type': ['string', 'null']}, 'ad75ae6ce334d1383bee83dbac8fd39f853f04a6': {'type': ['string', 'null']}, 'eeac3647750d674f47668a0060ab1713a830348d': {'type': ['string', 'null']}, 'next_activity_subject': {'type': ['string', 'null']}, 'status': {'type': ['string', 'null']}, 'probability': {'type': ['number', 'null']}, 'id': {'type': 'integer'}, 'cc_email': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_locality': {'type': ['string', 'null']}, 'creator_user_id': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4': {'type': ['string', 'null']}, '9d3b5db9aff7903b7a353715b14be92d3aa6d999': {'type': ['string', 'null']}, 'add_time': {'format': 'date-time', 'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_2': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_subpremise': {'type': ['string', 'null']}, 'last_incoming_mail_time': {'format': 'date-time', 'type': ['string', 'null']}, '9ac4d6226280789c1acf887648b4eaa168640b08': {'type': ['string', 'null']}, 'next_activity_note': {'type': ['string', 'null']}, 'ede292fd3271572a8ee43bf066faa6368da5bdec': {'type': ['string', 'null']}, 'next_activity_type': {'type': ['string', 'null']}, 'won_time': {'format': 'date-time', 'type': ['string', 'null']}, 'products_count': {'type': ['integer', 'null']}, 'currency': {'type': ['string', 'null']}, 'person_id': {'type': ['integer', 'null']}, 'rotten_time': {'format': 'date-time', 'type': ['string', 'null']}, '6ff4e1c32b8d100a63acc58b50efed41740d015a': {'type': ['string', 'null']}, '63011ec62a4f8528719fcd2e485578b374df13d0': {'type': ['string', 'null']}, '651685a82af190fa79db57f79421a05c6cbaeeed': {'type': ['string', 'null']}, '4130f450addd36c0f71f8b4513a8ce61eca6084c': {'type': ['string', 'null']}, '17c31746c32222b6ee130ed07fd22d2630c8b375': {'type': ['string', 'null']}, 'undone_activities_count': {'type': ['integer', 'null']}, 'activities_count': {'type': ['integer', 'null']}, 'weighted_value': {'type': ['number', 'null']}, 'org_hidden': {'type': ['boolean', 'null']}, 'pipeline_id': {'type': ['integer', 'null']}, 'fed79da883be601b7dcfe8dd00bd8c3b6ac07e71': {'type': ['string', 'null']}, 'user_id': {'type': ['integer', 'null']}, 'reference_activities_count': {'type': ['integer', 'null']}, 'visible_to': {'type': ['string', 'null']}, 'last_activity_date': {'type': ['string', 'null']}, 'formatted_weighted_value': {'type': ['string', 'null']}, 'formatted_value': {'type': ['string', 'null']}, 'lost_reason': {'type': ['string', 'null']}, 'notes_count': {'type': ['integer', 'null']}}, 'type': 'object'} 2019-09-05 14:44:03,748Z tap - 2019-09-05 14:44:03,748Z tap - 2019-09-05 14:44:03,748Z tap - Errors during transform: [first_won_time: 0000-00-00 00:00:00 does not match {'format': 'date-time', 'type': ['string', 'null']}, : {'7f6a4c86fcc21a0f5001b7dd997566ff709d79a7': '263', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_street_number': None, 'value': 1767.34, 'participants_count': 0, 'bac1f7da1572ffb203d4952c1d20b5dd18b7ed35': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_sublocality': None, 'stage_id': 123, 'expected_close_date': None, 'person_hidden': False, 'next_activity_time': None, '25ba250a3d4443dafcd0b59d5b8501bfad3a1d4c': '266', '567fc60ff309cb97fe7c570bd37ec12d880a14dc': None, 'org_name': 'BMW - Contrato', 'person_name': None, 'active': False, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_route': None, 'd0dcd82449a2a614970ffc2271b0d65a326b9070': None, '6dcc8245a6fb963676af5a24f79a02d0afa446f7': None, 'last_outgoing_mail_time': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_1': 'Santa Catarina', 'files_count': 0, 'lost_time': None, 'org_id': 11973, 'title': 'MANUTEN��O DOS SISTEMAS DE AUTOMA��O E/OU SEGURAN�A ELETR�NICA PREDIAL C�D - B1T NR', '560be1591f5c3eeb982f1a43f73c8cc6f9dd7f19': 'C05385004000582', 'e359700ae6ab944b9dc402eb1b34ab05db462d02': None, 'followers_count': 0, 'first_won_time': '0000-00-00 00:00:00', '7866911bdb49ba8ce2d6f15cc1a82de6f150a890': None, 'next_activity_note': None, '2959b6cf42b057ccb00516ccfead4e4d2b2103d0': None, 'close_time': '2019-08-21 13:40:53', 'owner_name': 'Amanda Domingues', '883562f9aa3cc5b57965cddb0ac25f7192a4ba40': None, 'next_activity_duration': None, '8736987144ca5adee8900ddd592604cafb766d68': None, '758706bcae449ad3a1a4284d0ed948485ab3f493': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_country': 'Brasil', 'fad73eb539ff739c9d40880dbd534f1629472a25': None, 'org_hidden': False, 'next_activity_date': None, 'b8fa89a2aacc21ea4f1d9bd4b226d74f551cde11': None, '7d10345f7b8bfad8fd59c68b2ddcf75f8df2d055': None, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_postal_code': None, 'deleted': True, 'a863255148d9dd52cda44afd39d9c9ad6366cb20': None, 'next_activity_id': None, 'last_activity_id': None, '58fe86f2ba1f6716ef7cf31d5c87dcc4c0b933a1': None, 'stage_order_nr': 9, 'weighted_value_currency': 'BRL', 'email_messages_count': 0, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_formatted_address': 'Joinville - SC, Brasil', 'done_activities_count': 0, 'update_time': '2019-08-21 13:40:53', 'stage_change_time': None, 'ad75ae6ce334d1383bee83dbac8fd39f853f04a6': '472-2', 'eeac3647750d674f47668a0060ab1713a830348d': None, 'ddc7f2156b24cb5f2eb4dea19f4c11a9d3370c95': None, 'next_activity_subject': None, 'status': 'deleted', 'probability': None, 'id': 12935, 'cc_email': 'evertical2+deal12935@pipedrivemail.com', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_locality': None, 'creator_user_id': 5759137, '59a7351d0b0ccbf6e67e38cbde07749117805ed4': 'JOINVILLE', 'aba3b830c7182f46bc48887725f13549bc53591e': None, '9d3b5db9aff7903b7a353715b14be92d3aa6d999': '180', 'cf029c16c837c08896473078a887c82fdd5eb7fd': None, 'add_time': '2019-08-20 21:39:09', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_2': 'Joinville', '59a7351d0b0ccbf6e67e38cbde07749117805ed4_subpremise': None, 'last_incoming_mail_time': None, '9ac4d6226280789c1acf887648b4eaa168640b08': '1970-01-01', 'label': None, 'ede292fd3271572a8ee43bf066faa6368da5bdec': None, 'next_activity_type': None, 'won_time': None, 'products_count': 0, 'currency': 'BRL', '7b616bbf2165239959dc171d56a5f24bb250f9ca': None, 'person_id': None, 'rotten_time': None, '6ff4e1c32b8d100a63acc58b50efed41740d015a': None, '63011ec62a4f8528719fcd2e485578b374df13d0': None, '651685a82af190fa79db57f79421a05c6cbaeeed': None, '4130f450addd36c0f71f8b4513a8ce61eca6084c': 'BMW JOINVILLE', '17c31746c32222b6ee130ed07fd22d2630c8b375': None, 'undone_activities_count': 0, 'activities_count': 0, 'weighted_value': 1590.61, 'c309f97b01c3c91810bc057b96b5a2a6809fee4b': '2027-01-06', 'pipeline_id': 1, 'fed79da883be601b7dcfe8dd00bd8c3b6ac07e71': None, 'user_id': 5759137, 'reference_activities_count': 0, 'a691cae5c929fbb89310537063d6d94f719a0628': None, 'visible_to': '1', 'last_activity_date': None, 'formatted_weighted_value': 'R$\xa01.590,61', 'formatted_value': 'R$\xa01.767,34', 'lost_reason': None, 'notes_count': 0} does not match {'properties': {'59a7351d0b0ccbf6e67e38cbde07749117805ed4_street_number': {'type': ['string', 'null']}, 'value': {'type': ['number', 'null']}, 'participants_count': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_sublocality': {'type': ['string', 'null']}, 'pipeline': {'type': ['string', 'null']}, 'stage_id': {'type': ['integer', 'null']}, 'expected_close_date': {'type': ['string', 'null']}, 'person_hidden': {'type': ['boolean', 'null']}, 'next_activity_time': {'type': ['string', 'null']}, '25ba250a3d4443dafcd0b59d5b8501bfad3a1d4c': {'type': ['string', 'null']}, '567fc60ff309cb97fe7c570bd37ec12d880a14dc': {'type': ['string', 'null']}, 'org_name': {'type': ['string', 'null']}, 'person_name': {'type': ['string', 'null']}, 'active': {'type': ['boolean', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_route': {'type': ['string', 'null']}, '6dcc8245a6fb963676af5a24f79a02d0afa446f7': {'type': ['string', 'null']}, 'last_outgoing_mail_time': {'format': 'date-time', 'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_1': {'type': ['string', 'null']}, 'lost_time': {'format': 'date-time', 'type': ['string', 'null']}, 'files_count': {'type': ['integer', 'null']}, '7f6a4c86fcc21a0f5001b7dd997566ff709d79a7': {'type': ['string', 'null']}, 'title': {'type': ['string', 'null']}, '560be1591f5c3eeb982f1a43f73c8cc6f9dd7f19': {'type': ['string', 'null']}, 'followers_count': {'type': ['integer', 'null']}, 'first_won_time': {'format': 'date-time', 'type': ['string', 'null']}, 'close_time': {'format': 'date-time', 'type': ['string', 'null']}, 'owner_name': {'type': ['string', 'null']}, 'next_activity_duration': {'type': ['string', 'null']}, '8736987144ca5adee8900ddd592604cafb766d68': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_country': {'type': ['string', 'null']}, 'org_id': {'type': ['integer', 'null']}, 'c309f97b01c3c91810bc057b96b5a2a6809fee4b': {'type': ['string', 'null']}, 'next_activity_date': {'type': ['string', 'null']}, 'b8fa89a2aacc21ea4f1d9bd4b226d74f551cde11': {'type': ['string', 'null']}, '7d10345f7b8bfad8fd59c68b2ddcf75f8df2d055': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_postal_code': {'type': ['string', 'null']}, 'deleted': {'type': ['boolean', 'null']}, 'next_activity_id': {'type': ['integer', 'null']}, 'last_activity_id': {'type': ['integer', 'null']}, '58fe86f2ba1f6716ef7cf31d5c87dcc4c0b933a1': {'type': ['string', 'null']}, 'stage_order_nr': {'type': ['integer', 'null']}, 'weighted_value_currency': {'type': ['string', 'null']}, 'email_messages_count': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_formatted_address': {'type': ['string', 'null']}, 'done_activities_count': {'type': ['integer', 'null']}, 'update_time': {'format': 'date-time', 'type': ['string', 'null']}, 'stage_change_time': {'format': 'date-time', 'type': ['string', 'null']}, 'ad75ae6ce334d1383bee83dbac8fd39f853f04a6': {'type': ['string', 'null']}, 'eeac3647750d674f47668a0060ab1713a830348d': {'type': ['string', 'null']}, 'next_activity_subject': {'type': ['string', 'null']}, 'status': {'type': ['string', 'null']}, 'probability': {'type': ['number', 'null']}, 'id': {'type': 'integer'}, 'cc_email': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_locality': {'type': ['string', 'null']}, 'creator_user_id': {'type': ['integer', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4': {'type': ['string', 'null']}, '9d3b5db9aff7903b7a353715b14be92d3aa6d999': {'type': ['string', 'null']}, 'add_time': {'format': 'date-time', 'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_admin_area_level_2': {'type': ['string', 'null']}, '59a7351d0b0ccbf6e67e38cbde07749117805ed4_subpremise': {'type': ['string', 'null']}, 'last_incoming_mail_time': {'format': 'date-time', 'type': ['string', 'null']}, '9ac4d6226280789c1acf887648b4eaa168640b08': {'type': ['string', 'null']}, 'next_activity_note': {'type': ['string', 'null']}, 'ede292fd3271572a8ee43bf066faa6368da5bdec': {'type': ['string', 'null']}, 'next_activity_type': {'type': ['string', 'null']}, 'won_time': {'format': 'date-time', 'type': ['string', 'null']}, 'products_count': {'type': ['integer', 'null']}, 'currency': {'type': ['string', 'null']}, 'person_id': {'type': ['integer', 'null']}, 'rotten_time': {'format': 'date-time', 'type': ['string', 'null']}, '6ff4e1c32b8d100a63acc58b50efed41740d015a': {'type': ['string', 'null']}, '63011ec62a4f8528719fcd2e485578b374df13d0': {'type': ['string', 'null']}, '651685a82af190fa79db57f79421a05c6cbaeeed': {'type': ['string', 'null']}, '4130f450addd36c0f71f8b4513a8ce61eca6084c': {'type': ['string', 'null']}, '17c31746c32222b6ee130ed07fd22d2630c8b375': {'type': ['string', 'null']}, 'undone_activities_count': {'type': ['integer', 'null']}, 'activities_count': {'type': ['integer', 'null']}, 'weighted_value': {'type': ['number', 'null']}, 'org_hidden': {'type': ['boolean', 'null']}, 'pipeline_id': {'type': ['integer', 'null']}, 'fed79da883be601b7dcfe8dd00bd8c3b6ac07e71': {'type': ['string', 'null']}, 'user_id': {'type': ['integer', 'null']}, 'reference_activities_count': {'type': ['integer', 'null']}, 'visible_to': {'type': ['string', 'null']}, 'last_activity_date': {'type': ['string', 'null']}, 'formatted_weighted_value': {'type': ['string', 'null']}, 'formatted_value': {'type': ['string', 'null']}, 'lost_reason': {'type': ['string', 'null']}, 'notes_count': {'type': ['integer', 'null']}}, 'type': 'object'}] 2019-09-05 14:44:03,770Z target - INFO Sending batch with 76 messages for table deals to https://api.stitchdata.com/v2/import/batch 2019-09-05 14:44:04,009Z target - INFO Exiting normally 2019-09-05 14:44:04,039Z main - INFO Target exited normally with status 0 2019-09-05 14:44:04,040Z main - INFO Exit status is: Discovery succeeded. Tap failed with code 1 and error message: "Errors during transform". Target succeeded.

luandy64 commented 5 years ago

first_won_time: 0000-00-00 00:00:00

This is not a valid date. Can you change this in Pipedrive?

warwintryborn commented 4 years ago

I remove some fields from my extraction and worked it!