[API] deleting connections doesn't work #33069

NachoAlasia · 2023-12-04T19:16:47Z

NachoAlasia
Dec 4, 2023

Hi there!

Im using the API for deleting connections, following the docs
(https://airbyte-public-api-docs.s3.us-east-2.amazonaws.com/rapidoc-api-docs.html#post-/v1/connections/delete,
https://reference.airbyte.com/reference/deleteconnection
Yes, I tried with this 2 options :sonrisa: )
but when I tried, response this.

<html>
<head>
    <title>405 Not Allowed</title>
</head>
<script language="javascript" \>
    window.TRACKING_STRATEGY = "segment";
                window.AIRBYTE_VERSION = "0.40.26";
                window.API_URL = "/api/v1/";
                window.CONNECTOR_BUILDER_API_URL = "/connector-builder-api";
</script>.

Why this happen? If I use the API for the rest of actions and work fine.
Why Im not allowed?
Btw, I tried this code in 2 different versions of Airbyte. (0.40.26) and (0.50.29)

pgrant87 · 2023-12-05T10:00:48Z

pgrant87
Dec 5, 2023

Hi Nacho,

What does your delete request look like at the moment? If you can share this, I'll investigate further

A 405 error usually happens when a client attempts to use an HTTP method that is not allowed by the server. For example, this can occur when a user tries to use a method such as PUT or DELETE on a resource that only allows GET or POST requests.

I'd also advise trying this with the latest version of Airbyte to see if the same error is returned

1 reply

NachoAlasia Dec 5, 2023
Author

Yes, I know that! for that its weird, I think Im doing well, but Im human :D,
Yes, for sure, I attached the 2 ways I tried.

Hope this pictures helps you.

I send this following this two docs.
https://airbyte-public-api-docs.s3.us-east-2.amazonaws.com/rapidoc-api-docs.html#post-/v1/connections/delete,
https://reference.airbyte.com/reference/deleteconnection

Thanks!

pgrant87 · 2023-12-05T16:46:31Z

pgrant87
Dec 5, 2023

Nacho can I ask what interface you're using here to send your request to the API? What authentication are you using?

If you use a simple curl are you able to delete a connection?

I've tried this locally on the latest version of Airbyte and was able to delete a test connection of mines, like so:

curl -s --location --request DELETE "http://localhost:8006/v1/connections/87bc5f93-af80-48d9-b181-58b3019fc93b" --header "Authorization: Basic YWlyYnl0ZTpwYXNzd29yZA=="

Thanks!

8 replies

pgrant87 Dec 6, 2023

Getting the curl to work is imperative as I would see that as the simplest way to use the API. In my curl command in the previous comment, I've passed my username and password encoded as base64 in the --header section as authentication. What type of authentication are you using when trying to hit the API with a curl?

Can I ask, what sort of Airbyte installation is this, is it on docker-compose or Kubernetes?

Would you be able to share with me a curl to the API that works alongside the one to the delete endpoint to see if there's any discrepancy I can see?

Thank you!

NachoAlasia Dec 6, 2023
Author

Im sending this curl, with authorization in base64 aswell.

curl -s --location --request DELETE http://airbyte-ec2.companyURL.com:8000/v1/connections/2841ed89-123123-adsas-37ebe0b671a8 --header "Authorization: Basic YW--------------E5elM="

This instalation is on docker-compose, deploying in a EC2

NachoAlasia Dec 6, 2023
Author

But if I tried this one, work!

curl -s --location --request POST http://airbyte-ec2companyURLl.com:8000/api/v1/workspaces/list --header "Authorization: Basic YW--------------E5elM="

There's the weird thing, I tried with the connection paused and unpaused.

pgrant87 Dec 7, 2023

Thanks for those, I appreciate it. Your request looks fine to me here.

The only other thing I'd like to check at this stage is the connectionID that you're passing. If you hit the connection endpoint with the following request, do you see the ID you're trying to delete listed there:

curl -s --location --request GET "http://<yourAirbyteUrl>:8000/v1/connections" --header "Authorization: Basic YWlyYnl0ZTpwYXNzd29yZA=="

pgrant87 Dec 7, 2023

Having a search on your 405 error, I also found the following: https://discuss.airbyte.io/t/starting-the-airbyte-api-on-a-self-hosted-instance/2698

This looks like an older version of the API but here the user had to pass Content-Type and Accept json as headers, this may be worth a try here too

NachoAlasia · 2023-12-07T15:31:28Z

NachoAlasia
Dec 7, 2023
Author

I tried and this happend

Really, Idk whats going on here, its super weird

1 reply

pgrant87 Dec 8, 2023

Thanks for trying that Nacho, would it be possible to share your docker-compose.yaml and your .env file to check on your configuration here? Please be sure to redact any sensitive information from these before sharing.

Thank you!

1043038630 · 2023-12-21T08:34:19Z

1043038630
Dec 21, 2023

hi I also have this issue, but if I send other requests, they will return the HTML code to me

1 reply

pgrant87 Dec 21, 2023

Hi @1043038630 Can you confirm what version of Airbyte you're seeing the issue in? Do you have a docker or k8s install? Could you also provide the full delete request that fails? Thank you!

[API] deleting connections doesn't work #33069

Uh oh!

Uh oh!

Replies: 4 comments · 11 replies

Uh oh!

Uh oh!

NachoAlasia Dec 5, 2023 Author

Uh oh!

Uh oh!

Uh oh!

NachoAlasia Dec 6, 2023 Author

Uh oh!

NachoAlasia Dec 6, 2023 Author

Uh oh!

Uh oh!

Uh oh!

NachoAlasia Dec 7, 2023 Author

Uh oh!

Uh oh!

Uh oh!

Replies: 4 comments 11 replies

NachoAlasia Dec 5, 2023
Author

NachoAlasia Dec 6, 2023
Author

NachoAlasia Dec 6, 2023
Author

NachoAlasia
Dec 7, 2023
Author