OINO.cloud APIs support SQL limits and paging using parameters oinosqllimit in the request URL.
You can give a limit of how many results you want and which page of that you want like N page M.
Page starts from 1 and can be omitted to just get the N first results.
ProductName
UnitPrice
UnitsInStock
UnitsOnOrder