We’re trying to create revenue reports in our own system that pulls in payment amounts from Invoice Ninja. Payments received in the last 365 days, last 30 days, etc. From what I can find about the Rest API, we can only filter by updated_at, so we use:
https://app.invoiceninja.com/api/v1/payments?updated_at=#{since.to_i}&per_page=25&include=invoice
Then we need to look at the payment_date attribute and filter it ourselves. It’s possible to miss a payment with this call because the payment_date might have been updated to be in the past.
Is there any way to use the API to query payments by payment_date instead of updated_at? Maybe in v5? We pay for hosting at app.invoiceninja.com.