I got the test script to output data and now after I have corrected my PDO I get this:
{"data":[{"ProductID":1,"ProductName":"test","QuantityPerUnit":1,"UnitPrice":1,"UnitsInStock":1,"Discontinued":"true"},{"ProductID":2,"ProductName":"test2 ","QuantityPerUnit":1,"UnitPrice":2,"UnitsInStock":3,"Discontinued":"false"}]}
Followed by an empty grid.
Any thoughts?