I am trying to delete a user from matillon which I have created by mistake using CURL command

Matillion ETL
1

So currently there are 2 user with similar id (one without space, other with space) in their ID. So I want to delete the user(other with space) but when I run the Delete Curl command it's not recognizing the userid (with space) in the curl command

command I run: curl -X DELETE -u "uxyzadmin:Uxyz@xyzpqr" -k "https://azrqwerty.uxyz.us/rest/v1/userconfig/user/instance?userName=smkum@uxyz.us " -H "Content-Type: application/json"

I tried using %20 like below

"https://azrqwerty.uxyz.us/rest/v1/userconfig/user/instance?userName=smkum@uxyz.us%20" -H "Content-Type: application/json"

Please suggest on how to delete the user "smkum@uxyz.us "

2

Hi @shambhavi.k777​

None of the links posted work. However, you can remove any existing user by clicking "X" on the right of the relevant user's name. It will ask you for the confirmation to remove the user. Source

Thanks,

Chika

3

Hi @shambhavi.k777​

You'd have to use the Use API against each of the nodes of the cluster and remove the user from all nodes. Let me know if this works.

Thanks,

Chika

4

Hi @shambhavi.k777​,

One thought I have that wasn't offered yet would be to execute the CURL statement fails then download the server log from the "Admin" menu in the user interface. The Catalina logs are quite robust and may point you to the solution. I hope that helps!

5

Hi

Thanks for your reply

I like to mention that I am trying it in clustered environment so the " User Configuration " tab is generally not present.
If I understood you correct your mentioned approach is only possible when I can go through the “User configuration”.

Please let me know if there is any way to do it in clustered environment.

Thanks & Regards
Shambhavi kumari

6

tried the following cmd

curl -X POST -u "pqrstadmin:pqrst@********" -k "azrusexxxxxxx.PQR.us/rest/v1/userconfig/user/instance/…" -H "Content-Type: application/json"

And the response I got is: {"success":false,"msg":"Unable to find user with name [XYZ@PQR.us ].","id":-1}

when i observe the response looks like i am getting an extra dot after square bracket ending. Do you have any insights or suggestion on this please

7

sure i will try to look into logs but considering a simple delete of user should not be so complicated.

tried the following cmd

curl -X POST -u "pqrstadmin:pqrst@********" -k "azrusexxxxxxx.PQR.us/rest/v1/userconfig/user/instance/…" -H "Content-Type: application/json"

And the response I got is: {"success":false,"msg":"Unable to find user with name [XYZ@PQR.us ].","id":-1}

when i observe the response looks like i am getting an extra dot after square bracket ending. Do you have any insights or suggestion on this please