Anyone successfully set up Pardot as a source? Get...
# replication-troubleshooting
c
Anyone successfully set up Pardot as a source? Getting this error
Copy code
requests.exceptions.HTTPError: 400 Client Error: Bad Request for url: https://pi.pardot.com/api/emailClick/version/4/do/query?format=json
2023-02-09 16:51:12 [44msource[0m > Finished syncing email_clicks
2023-02-09 16:51:12 [44msource[0m > SourcePardot runtimes:
Syncing stream email_clicks 0:00:00.061133
2023-02-09 16:51:12 [44msource[0m > 400 Client Error: Bad Request for url: https://pi.pardot.com/api/emailClick/version/4/do/query?format=json
Traceback (most recent call last):
  File "/airbyte/integration_code/main.py"
Copy code
2023-02-09 16:53:45 INFO i.a.w.g.DefaultReplicationWorker(getReplicationOutput):484 - failures: [ {
  "failureOrigin" : "source",
  "failureType" : "system_error",
  "internalMessage" : "400 Client Error: Bad Request for url: https://pi.pardot.com/api/emailClick/version/4/do/query?format=json",
  "externalMessage" : "Something went wrong in the connector. See the logs for more details.",
  "metadata" : {
    "attemptNumber" : 2,
    "jobId" : 139,
    "from_trace_message" : true,
    "connector_command" : "read"
  },
  "stacktrace" : "Traceback (most recent call last):\n  File \"/airbyte/integration_code/main.py\", line 13, in <module>\n    launch(source, sys.argv[1:])\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py\", line 131, in launch\n    for message in source_entrypoint.run(parsed_args):\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/entrypoint.py\", line 122, in run\n    for message in generator:\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py\", line 125, in read\n    raise e\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py\", line 111, in read\n    yield from self._read_stream(\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py\", line 180, in _read_stream\n    for record in record_iterator:\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/abstract_source.py\", line 243, in _read_incremental\n    for message_counter, record_data_or_message in enumerate(records, start=1):\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py\", line 413, in read_records\n    yield from self._read_pages(\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py\", line 429, in _read_pages\n    request, response = self._fetch_next_page(stream_slice, stream_state, next_page_token)\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py\", line 452, in _fetch_next_page\n    response = self._send_request(request, request_kwargs)\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py\", line 354, in _send_request\n    return backoff_handler(user_backoff_handler)(request, request_kwargs)\n  File \"/usr/local/lib/python3.9/site-packages/backoff/_sync.py\", line 105, in retry\n    ret = target(*args, **kwargs)\n  File \"/usr/local/lib/python3.9/site-packages/backoff/_sync.py\", line 105, in retry\n    ret = target(*args, **kwargs)\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py\", line 321, in _send\n    raise exc\n  File \"/usr/local/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/http.py\", line 318, in _send\n    response.raise_for_status()\n  File \"/usr/local/lib/python3.9/site-packages/requests/models.py\", line 1021, in raise_for_status\n    raise HTTPError(http_error_msg, response=self)\nrequests.exceptions.HTTPError: 400 Client Error: Bad Request for url: https://pi.pardot.com/api/emailClick/version/4/do/query?format=json\n",
  "timestamp" : 1675961614555
}, {
  "failureOrigin" : "source",
  "internalMessage" : "io.airbyte.workers.internal.exception.SourceException: Source process exited with non-zero exit code 1",
  "externalMessage" : "Something went wrong within the source connector",
  "metadata" : {
    "attemptNumber" : 2,
Copy code
Airbyte version 0.40.29
Pardot Source Connector version 0.1.1
Snowflake Destination Connector version 0.4.47
None of the Pardot objects will sync successfully including
Visitors
which looks to have had an update on Jan 4 https://github.com/airbytehq/airbyte/pull/19618
Pardot connection error using the url from the
Bad Request from url
error
Copy code
{
  "@attributes": {
    "stat": "fail",
    "version": 1,
    "err_code": 182
  },
  "err": "Invalid header value: Missing or empty Authorization header parsed from http headers"
}
m
@Tuan Nguyen do you mind taking a look in this comment from Carolina. They’re trying to use Pardot connector, any comments or info are welcome! 🙂
t
I don’t have access to the dev creds any more. Do we have one on LastPass @Marcos Marx (Airbyte)
thank you spin 1
c
Any update or guidance on this?
u
Hello Carolina Buckler, it's been a while without an update from us. Are you still having problems or did you find a solution? This connector might still be broken but creating an issue on our github would be appreciated!
c
No solution was shared - still have the error; thought an issue was created?
t
I can look into this if Airbyte can share a dev credentials @Saj Dider (Airbyte)
c