Retrieve DB connection parameters

[Arulprakash07]

How to retrieve database (query service) connection parameters including username and password by making a GET call

[Anuhya-Y]

@Arulprakash07 check out API call https://developer.adobe.com/experience-platform-apis/references/query-service/#tag/Connections/opera... 

[Arulprakash07]

@Anuhya-Y GET /connection_parameter API is not returning password. How to get the password? When connect programmatically need Password also. Right? like, UserName, Host, Post and DB_Name.

Thanks in advance !

[Anuhya-Y · Accepted solution]

compressedToken in the API response  is the password . 

From UI query service connection details are available as well. check out credentials section https://experienceleague.adobe.com/docs/experience-platform/query/ui/overview.html?lang=en 

[Arulprakash07]

@Anuhya-Y Thanks for your response, compressedToken will work for me since UI query service connection details are valid 24 Hrs only. Let me test it "compressedToken" and revert back. Thanks once again.

[Doreyvenables]

Read this discussion.May be this can help you here  https://doradomanana.xyz/  If yes then please mention me here.