API tests for reporting