Hi,

I am working with a team to develop a web and mobile front end for an organisation running on on premise solution of Sage 200c. They upgraded to the 2018 version of Sage and we are using this documentation as guidance for integration via APIs: developer.columbus.sage.com/docs

There appears to be a limit of 500 records returned when we call Sage via APIs. Is this correct?

Given this we are using $skip as described here: https://developer.columbus.sage.com/docs#/uk/sage200extra/accounts/gs-how-to-query-data

But, when we try /customers?$skip=500 we are receiving the following error "Incorrect syntax near 'OFFSET’. Invalid usage of the option NEXT in the FETCH statement."

Could someone help us to troubleshoot the issue?

Thanks,

Lisa White