airbytehq / airbytehq/airbyte

source-paypal INVALID_DATE_TIME_FORMAT for list_disputes table

Ouverte
#67,619 6 commentaires 0 réactions 0 personnes assignées Voir sur GitHub
area/connectors autoteam community needs-triage team/extensibility team/use type/bug
Langage dominant
Python
Étoiles
22.1k
Forks
5.3k
Métriques de merge des PR
Métriques de PR en attente

Description

### Connector Name

source-paypal

### Connector Version

2.6.14

### What step the error happened?

During the sync

### Relevant information

The `list_disputes` table is repeatedly failing due to the error below. The PayPal API expects `update_time_before` and `update_time_after` to be formatted like this: `yyyy-MM-ddTHH:mm:ss.SSSZ`, but its sending values like this: `2025-04-20T21:28:19.828000.000Z`.
https://developer.paypal.com/docs/api/customer-disputes/v1/#disputes_list

All the other tables are syncing just fine, but it makes the whole sync time go from ~2 minutes to ~45 minutes. Upgrading from v2.6.11 to v2.6.14 made no difference.

### Relevant log output

```shell
'GET' request to 'https://api-m.paypal.com/v1/customer/disputes?page_size=50&update_time_after=2025-04-13T21%3A28%3A20.828000Z&update_time_before=2025-04-20T21%3A28%3A19.828000Z' failed with status code '400' and error message: 'Request is not well-formed, syntactically incorrect, or violates schema.'. Request (body): 'None'. Response (body): '{'name': 'INVALID_REQUEST', 'message': 'Request is not well-formed, syntactically incorrect, or violates schema.', 'debug_id': '9e61746f584dc', 'information_link': 'https://developer.paypal.com/docs/api/customer-disputes/v1/#errors', 'details': [{'field': 'update_time_before', 'value': '2025-04-20T21:28:19.828000.000Z', 'location': 'query', 'issue': 'INVALID_DATE_TIME_FORMAT'}, {'field': 'update_time_after', 'value': '2025-04-13T21:28:20.828000.000Z', 'location': 'query', 'issue': 'INVALID_DATE_TIME_FORMAT'}], 'links': []}'. Response (headers): '{'Connection': 'keep-alive', 'Content-Length': '502', 'access-control-expose-headers': 'Server-Timing', 'set-cookie': 'l7_az=ccg13.slc; Path=/; Domain=paypal.com; Expires=Fri, 10 Oct 2025 21:58:21 GMT; HttpOnly; Secure', 'server-timing': 'traceparent;desc="00-00000000000000000009e61746f584dc-ebfb8379df7a250e-01"', 'content-type': 'application/json', 'cache-control': 'max-age=0, no-cache, no-store, must-revalidate', 'paypal-debug-id': '9e61746f584dc', 'Edge-Control': 'max-age=0', 'Accept-Ranges': 'bytes', 'Date': 'Fri, 10 Oct 2025 21:28:21 GMT', 'Via': '1.1 varnish', 'Strict-Transport-Security': 'max-age=63072000; includeSubDomains; preload', 'X-Served-By': 'cache-iad-kcgs7200040-IAD, cache-iad-kcgs7200104-IAD', 'X-Cache': 'MISS, MISS', 'X-Cache-Hits': '0, 0', 'X-Timer': 'S1760131702.534205,VS0,VE139', 'Vary': 'Accept-Encoding'}'.
```

### Contribute

- [ ] Yes, I want to contribute

Guide de contribution

Ouvrir le guide de contribution

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.