Hey there, I'm trying to retrieve data using Portal Web API, similar to this SQL query below.
SELECT *
FROM table_name
LIMIT 5 OFFSET 3
I've tried both of these formats below but they both return an error.
/_api/table_name?&top=5&$skip=3
/_api/table_name?&top=5&$offset=3
Here is the error message.
{"error":{"code":"9004010D","message":"Common Data Service error occurred.","cdscode":"0x0"}}
Is it possible to do this in current version of Portal Web API? If so, what is the correct syntax? Thanks.