Forum Discussion
Would you please provide the following?
1. Screen shot showing groovy script test along with script (fully visible). Also appreciate if you can attach the full script in text mode which will quickly help try.
2. Assuming that you are using MS SQL Server. What driver / library files available under ReadyAPI?
3. Full stacktrace of the error.
Hi,
So when I press "get the token" it opens up our login pages, so I created 'automation' scripts to handle those login screens. Page 1 is the Enter User Name screen. Page 2, the Enter Password screen, Page 3, the Request authentication code screen, and Page 4, the Enter authentication code screen.
What I'm trying to do is make a database call from within the automation script which goes to our database and gets the authentication token, rather than trying to get it from our emails, or text messages, which I would imagine is even harder to code into the automation script. But the SQL calls I'm making in the script shown below work fine if I pull them out into a separate Groovy script, just not inside the Oath2 automation script. So I'm curious why it's not working. After I get the authorization code from the database I intended on putting that in the field on the screen and pressing submit.
Thank you,
Roy
Page 1
if (document.getElementById('txtUserName')) {
document.getElementById('txtUserName').value = '${#Project#Prop_UserName}';
document.getElementById('btnNext').click();
}
Page 2
if (document.getElementById('txtPassword')) {
document.getElementById('txtPassword').value = '${#Project#Prop_Password}';
document.getElementById('btnSignin').click();
}
Page 3
if (document.getElementById('MainContent_rblDeliveryMethods_0')) {
document.getElementById('MainContent_rblDeliveryMethods_0').click();
document.getElementById('btnRequestCode').click();
}
Page 4
if (document.getElementById('MainContent_AccessCodeRequiredFieldValidator')) {
MyDBServer = "<removed for security reasons>";
MyUser = "<removed for security reasons>";
Mysql = sql.newInstance('jdbc:sqlserver://' + MyDBServer + ':1433;databaseName=<removed for security reasons>;integratedSecurity=true','','','com.microsoft.sqlserver.jdbc.SQLServerDriver');
Mydata = Mysql.firstRow("SELECT AC.AccessCode FROM UserAccessCodes AC JOIN Users US ON AC.UserID = US.UserID Where US.UserName = '"+MyUser+"' and AC.ActiveFlag = 1");
AuthCode = Mydata;
Mysql.close();
document.getElementById('MainContent_AccessCodeRequiredFieldValidator').value = AuthCode;
document.getElementById('btnConfirmCode').click();
}
- Rmuenks15 years agoOccasional Contributor
- TanyaYatskovska5 years agoSmartBear Alumni (Retired)
Thanks for the clarification, Rmuenks1.
Community, nmrao, richie, groovyguy, HimanshuTayal, what can we suggest?
- TanyaYatskovska5 years agoSmartBear Alumni (Retired)
Hi Rmuenks1,
It looks like this issue is very specific to your project. Could you please submit this question to our Support Team so that they can test it in our test lab? You can contact them here: