writing test for api code example

Example 1: generating test data in api

For API Part: I use "https://www.mockaroo.com/" ==> 
generates multiple format (CSV, JSON, XML, etc)

Example 2: what to test in api

Basicall we are checking response body
to verify if request matches with response.
After that we are writing SQL query
to double check if database matches.
We can say happy path if all pass