This seemingly easy question doesn't seem so easy to answer. In other threads like e.g. https://community.clover.com/questions/2473/order-fully-paidgetstate-shows-locked.html it is said that order state (open vs. locked) is only for internal use and not reliable (I wonder what is the use of an unreliable field??).
1) Can I reliably get all orders from the REST API (i.e. without downloading unnecessary open orders that might change already minutes after) that have at least a partial payment by using the field payType? The condition to have one of these values (SPLITGUEST, SPLIT_ITEM, SPLIT_CUSTOM, FULL) should be fine to get all orders that are either partially or full paid, right?
1b) I checked also the requests of the Reporting app of Clover in the sandbox dashboard, but it makes requests using a reports endpoint that is undocumented, https://sandbox.dev.clover.com/v3/merchants/DJKVE9F13JTM9/reports so not sure if this offers anything useful ?!
2) I understand from this thread https://community.clover.com/questions/2473/order-fully-paidgetstate-shows-locked.html that if one needs to know if the order has been partially OR fully paid one needs to compare it with already available payments.
My goal would be to calculate the revenues of today and make further calculations based on this. Since I don't want to fetch all orders, but only those which have connected payments, there should be a way. Just not sure if option 1) is reliable? or is there any other way, besides downloading all orders and all payments and then check which orders have already payments?
@Jeffrey Blattman It seems you are the expert in this, could you please help? (it seems the system for tagging a person is broken)