I am trying to get NET closeout totals for last 5 days.
I know reports can be generated, but I need the numeric values. Is there an API or a convenient SDK feature, that can return totals per day (at closeout) ?
The other option - i see is : Look at each order, addup line items, tax, tips, refunds etc - for EACH order, then total them - for EACH day.
Any guidance on this is appreciated.
You will need to implement the calculation on your end as you've noted.
If all you require is the NET closeout, you should be able to add up all "total" from GET /orders, which accounts for tax, modifications, refunds, etc. Tips will have to be calculated separately.
If you need more detailed information and decide to expand multiple fields, the request can become costly very quickly. If you feel your app will hit our request rate limit (50/sec per app, 15/sec per token), consider using our bulk exporter. https://github.com/clover/export-api-...
Thanks for the response.
As my requirements refined, there is a subtle variation what I require. I need to find order totals - only for - card processing (i.e. Credit and Debit cards used). I don't care about Tips or the Overall closeout amount. Just need overall card processing amount (5 day history).
In that case, what part of the Orders response - should I look to sum up ? orders -> authorizations -> amount ?
https://apisandbox.dev.clover.com:443/v3/merchants/{mid}/payments?expand=cardTransaction The "State" = "CLOSED" corresponds with a completely closedout payment. Adding all payment total with tender type credit/debit that has "State" = "CLOSED" should return all payments that's been closed. When a payment was closedout is not available via API.
2 People are following this question.
