API execution test

API execution test

I am not getting the expected response from my API script. 

(It is picking up some records but not others) 

Is there somewhere that I can test the output of a query?