Connect to Azure Cosmos DB from ReadyApi

Question

Hi all,&nbsp;I am trying to find a way to connect to Azure Cosmos DB from readyApi. I assume the best way is to do it using a groovy script but I am not really sure. I searched for a solution here and on the web in general, and even though I can see that I am definitely not the first one trying to achieve this, I was unable so far to find any answer that provides an actual solution...Any help on this subject would be more than welcome !&nbsp;Thanks guys

richie · Accepted Answer

Hey _Oliver_In that case i'd go back and confirm the Cosmos DB version. If that resource i pointed you to was a little old, i know that MS have changed REST auth schemes for a number of their products over the last 5 years.  Perhaps those instructions i found were out of date.Essentially there will be a number of URI/QUERY and HEADER parms you'll need to specify with the correct details, otherwise it wont work.  Did you confirm and re-confirm youd specified the correct value for each of those parms defined in the postman instructions? If even one of those parms are incorrect, you wont be able to connect.Alternatively im guessing you might be able to ask Dev?  Considering youre testing their code, it seems logical to think they might know something about this.CheersRich

richie · Answer

Hey&nbsp;_Oliver_&nbsp;
&nbsp;
have a look here --&gt;&nbsp;https://sajeetharan.com/2019/07/01/easily-explore-cosmos-db-rest-apis-with-postman/
&nbsp;
I know it says postman - but authentication is authentication and as long as you have all the mandatory headers setup (ignoring the stupid dynamically generated postman ones) you should be able to setup the connection in ReadyAPI!
&nbsp;
Hit back if you're still struggling after trying to apply the postman instructions
&nbsp;
ta
&nbsp;
Rich
&nbsp;

_oliver_ · Answer

Thanks Rich for your replies.&nbsp;I saw these instructions and tried to use them but the authorization generation does not work for some reasons...I tried to use this in my groovy script :https://www.jokecamp.com/blog/examples-of-creating-base64-hashes-using-hmac-sha256-in-different-languages/#groovyEverything else is okay, it is the authorization part which fails.

richie · Answer

Hey&nbsp;_Oliver_&nbsp;
&nbsp;
&nbsp;
have a look at the following link - someone else asked about this awhile ago for SoapUI.
&nbsp;
the link provides further link to setup your DB connection using REST rather than JDBC - as long as you're doing reasonably simple queries - using the REST API rather than JDBC should sort you fine.
&nbsp;
https://community.smartbear.com/t5/SoapUI-Open-Source/Does-soap-UI-support-cosmos-DB-testing/td-p/203048
&nbsp;
Cheers,
&nbsp;
Rich
&nbsp;

_oliver_ · Answer

Hi Rich,&nbsp;Thanks. I did see this link but it does not provide a solution for the authentication part, which is the most tricky part to put in place. Apologies, I did not mention that specific item in my previous message.&nbsp;RegardsOlivier

_oliver_ · Answer

Thanks Rich.&nbsp;The dev team cannot help, they did not implement neither use these APIs. One of the dev tried to help but the MS documentation is not the best IMHO 😞&nbsp;RegardsOlivier

Forum Discussion

Connect to Azure Cosmos DB from ReadyApi

8 Replies

Related Content

ReadyAPI and AzureSQL server connection

Readyapi Kafka Connection

ReadyAPI connectivity to Azure SQL

ReadyAPI and TestEngine with Zephyr Scale

Connecting ReadyAPI! to nonstandard GitLab domain

Recent Discussions

JDBC results are stored in the ReadyAPI project

Azure Git Integration?

How to run specific test case in particular environment?

How to remove (not clear) test case properties from SaveScript

Parameterising JDBC Connection Settings..Can you do it?