hey im trying to connect to pardot (salesforce) and for some reason i get an ssl error:

airbyte-worker                    | 2023-05-30 17:34:48 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - Backing off _make_request(...) for 120.0s (requests.exceptions.SSLError: HTTPSConnectionPool(host='<http://login.salesforce.com|login.salesforce.com>', port=443): Max retries exceeded with url: /services/oauth2/token (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)'))))
airbyte-worker                    | 2023-05-30 17:34:48 INFO i.a.w.i.VersionedAirbyteStreamFactory(internalLog):317 - Caught retryable error 'HTTPSConnectionPool(host='<http://login.salesforce.com|login.salesforce.com>', port=443): Max retries exceeded with url: /services/oauth2/token (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')))' after 4 tries. Waiting 120 seconds then retrying...

wondering if this is something on my server end, or if i need to talk to a salesforce dev? i have airbyte running in an ec2 on http, i can setup a self-signed but that won't be any good when someone else checks...

A message from kapa.ai

as a side note, i created my own connector that went directly to

<https://pi.demo.pardot.com>

and it worked

@Jake Kagan Hi , I was able to connect to Pardot through a custom connector too. The only issue we see is that we cannot paginate through the pages that are returned. Pardot uses NextURL for pagination. Did you have success with this?