Filter $skip doesn't work for method sales_transaction_enquiry_views

Question

Hello Team,

Could you help me with the following issue?
I am using the method sales_transaction_enquiry_views to receive transaction allocations.

Example:
https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sales_transaction_enquiry_views?$filter=customer_id eq 1581643&$expand=allocation_session_items

But, when I add the filter $skip, Sage 200 returns the error message.

For other methods, filter Skip is working.

Could you please explain why for method sales_transaction_enquiry_views it doesn't work?

For other methods, filter Skip is working. Could you please explain why for method sales_transaction_enquiry_views it doesn't work?

ian brierley · Answer

This query was raised to Developer Services, and the following solution was given: 
 When using the skip parameter, you need to include an orderby clause to justify the usage of skip. For example, if you used &$skip=5&$top=5&$orderby=id desc this would return the top 5 items, after the first 5 have been passed over, ordered by their id in a descending order. 
 Further information can be found here

Sage 200 UKI

Filter $skip doesn't work for method sales_transaction_enquiry_views

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING