Forum Discussion

navnak's avatar
navnak
New Contributor
2 years ago

Data Validation after Running a POST Request

I'm quite new to Ready API and API testing, but need help with needing to validate that after running a post request that the request has been successfully inserted into the database and fetch the status column from the db, which I will use with assertions

The db is running on GCP...

 

Any help is greatly appreciated 

Assertions
Data-Driven Testing
Function Tests
Integrations
Scripting
Test Results
  • richie's avatar
    richie
    2 years ago

    Hey navnak 

     

    the first thing you'll have to do is identify the RDBMS that is supported by GCP.

     

    For on premise database connections I typically use JDBC (JDBC thin drivers with a JDBC connection string) to configure a database connection. 

     

    With cloud based RDBMS's like MS Azure SQL (which is a cloud based version of SQL Server) rather than using JDBC, I've had to connect using something like XRMToolbox and connect using REST instead and all database queries are done via REST rather than JDBC (SQL) instead.

     

    If you find out what RDBMS that GCP supports (the database you want to query) we can then go forward and assist with the other stuff to get you connected.

     

    Cheers,

     

    Rich

  • navnak's avatar
    navnak
    New Contributor
    2 years ago

    Thank you Rich, that's helped out and also got help in running it from one of the ReadyAPI guys.

  • richie's avatar
    richie
    Community Hero
    2 years ago

    Hey navnak 

     

    the first thing you'll have to do is identify the RDBMS that is supported by GCP.

     

    For on premise database connections I typically use JDBC (JDBC thin drivers with a JDBC connection string) to configure a database connection. 

     

    With cloud based RDBMS's like MS Azure SQL (which is a cloud based version of SQL Server) rather than using JDBC, I've had to connect using something like XRMToolbox and connect using REST instead and all database queries are done via REST rather than JDBC (SQL) instead.

     

    If you find out what RDBMS that GCP supports (the database you want to query) we can then go forward and assist with the other stuff to get you connected.

     

    Cheers,

     

    Rich