Bearer Auth Token - How to pass as header for each API resource
Hello People, I am new to Ready API and API automation in general. For our API testing (JSON), initially we have to authorize with a bearer token in SWAGGER UI. Two API resources are present /auth/login & /auth/base64 and both these return an access token and user details respectively in encrypted format. The final bearer token format is: </auth/login: accesstoken>.</auth/base64 : message> The bearer token has session time of 15 minutes after which we need to generate a new one. Could anyone please let me know resources or steps on how to set the bearer token details for every Test Case in Ready API?Solved5KViews0likes2CommentsAdd multiple values from a table to request headers
Is there a method for adding values from multiple records from a table (or any source) to a request name/value combination (header for instance) without knowing the "Name" and "Value" values prior to loading them? Example: SQL table name: RequestHeader SQL table Fields: ID, HeaderKey, HeaderValue In ReadyAPI: A POST request where "Name" and "Value" properties under the "Request" tab in the request must be populated from the table. "Name" = RequestHeader.HeaderKey "Value" = RequestHeader.HeaderValue There could be zero or more entries in this "RequestHeader" table for multiple, discrete test cases. The name and value of each header are unknown to the ReadyAPI request prior to being loaded to the "Name/Value" properties in the "Request" tab from the table at run time. I want to be able to load multiple records from the table to the request header so that value from the "HeaderKey" field in each record loads to a discrete "Name" property and the value from "HeaderValue" field in each record loads to the associated "Value" property. Can this be done in the provided ReadyAPI request object or will this require a request that is scripted in Groovy? If this request must be scripted, are there any examples of this specific scenario?Solved2.8KViews0likes12CommentsUsing Property Transfer in Ready API, How Can I Transfer a Numeric Value into JSON object?
Hi, When fetching data source from EXCEL file, I need to transfer some of the values to JSON objects. All values are being parsed in as string format. How can I parse in values as integer instead when using property transfer step?Solved2.5KViews0likes12CommentsFailed to obtain JDBC Connection / Failed do update dashboard db?
I asked question earlierRe: Failed to import a definition / no subject alt... - SmartBear Community Briefly description: I try to make a API call via HTTPS, the definition of URL couldn't import and parsed successfully. The testing environment, both the web service server and testtool client are within private network. I followed some suggestion to enable log (cmd > ready-api.bat>C:\log.txt 2>&1) And found there are several ERROR related to DB as the following. What's the dashboad db? Should I setup a JDBC connection before call API? I thought JDBC connection is only for DataSource purpose, am I wrong? Are those ERRORS the causes that I always get the invalid responses? ERROR [DashboardSchemaChecker] Failed do update dashboard db. ERROR [SoapUI] An error occurred [Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: "Locked by another process: C:/Users/Administrator/.readyapi/db/dashboard.lock.db". Possible solutions: close all other connection(s); use the server mode [90020-200]], see error log for details 08:56:14,969 ERROR [errorlog] org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: "Locked by another process: C:/Users/Administrator/.readyapi/db/dashboard.lock.db". Possible solutions: close all other connection(s); use the server mode [90020-200] org. springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: "Locked by another process: C:/Users/Administrator/.readyapi/db/dashboard.lock.db". Possible solutions: close all other connection(s); use the server mode [90020-200] ERROR [MixpanelCustomEngine]analytics01.smartbear.com2.5KViews0likes5CommentsJDBC connection error indicating SSL issue
I have configured a MS SQL DB in my data source step. If i test it , the connection is successful. But while running the data source step alone, i am facing the following error: I have copied the latest MS SQL JDBC Drivers(12.4.1 and 12.4.0) into the ReadyAPI bin path. Kindly help me to resolve the same. Cannot get a connection for the specified properties com.microsoft.sqlserver.jdbc.SQLServerException: "encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target. ClientConnectionId:6f0f5b46-4e69-446f-80ee-866d05e2b8e2 I have added the following properties "encrypt" as false and "trustServerCertificate" as true in the database configuration.Solved2.2KViews0likes2Commentsencoding of utf-8 is set for some APIs test cases and not for some in project properties
Hi mates, I am sending unicode characters in Json request payload. The server is returning "NO success" response. But If I add encoding as UTF-8 in that test case(REST) properties, response comes as "SUCCESS". Is it the the right thing to send UTF-8 explicitly ? And if yes, how does this will be addressed when any integrations call that API ? And, I could see some other APIs test cases shows UTF-8 as encoding by default in ReadyAPI. So, not sure whats going on. Appreciate any help. Thanks. Ravi.2.1KViews0likes2Comments