Skip to content

source-paypal INVALID_DATE_TIME_FORMAT for list_disputes table #67619

@jsnorthrup

Description

@jsnorthrup

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

'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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions