Read and write to Ms SQL

[jeniperiasamy]

I just need to read data from HP QC and place it in the MS SQL database via API.

I just checked I’m able to check whether I can read list of projects or test sets etc.
The result is in XML format.

Do anyone please help how I can read and push it to database?

Thanks,
JP

[jetison]

Hi there @jeniperiasamy -

It looks like similar questions have already been asked. Feel free to weigh in with your own use case in the threads linked below, if these discussions don’t help.

Database Connectivity and Checkpoints

Hi, Is there any way to connect to DB server within Postman and how database checkpoints (assertions) are applied in Postman?

Postman and database

I put together a collection/some documentation at the following link which shows how you can use some popular tooling for MySQL/PostgreSQL to get this going at a basic level: https://www.postman.com/postman/workspace/postman-team-collections/collection/5922408-41044117-22a7-4f36-869c-13f73310b7e9?ctx=documentation There’s undoubtedly other libraries out there to make a REST API available for other database solutions if you aren’t using either of these two.