question

Hi,

I am updating my api call for getting orders to take a start and end time of 90 days.

In testing, i'm using February 1st, 2023 and February 10th, 2023 as my createdTime filters.

My transaction with externalReferenceId=12587 was createdTime February 2nd 2023

https://api.clover.com/v3/merchants/[merchant-id]/orders?expand=refunds,lineItems,payments,discounts,lineItems&filter=createdTime>=1674864000&filter=createdTime<=1676092800&filter=externalReferenceId=12587

This returns

{
    "elements": [],
    "href": "http://api.clover.com/v3/merchants/[merchant-id]/orders?filter=createdTime%3E%3D1677346800&filter=createdTime%3C%3D1677645600&filter=externalReferenceId%3D12587&filter=stateIS%20NOT%20NULL&limit=100"
}

If I remove the external reference id I still get no orders for between those days

https://api.clover.com/v3/merchants/[merchant-id]/orders?expand=refunds,lineItems,payments,discounts,lineItems&filter=createdTime>=1674864000&filter=createdTime<=1676092800

Even tho the clover dashboard shows 11.

If I remove all the other filters and just use the createdTime>= I get a result set

https://api.clover.com/v3/merchants/[merchant-id]/orders?expand=refunds,lineItems,payments,discounts,lineItems&filter=createdTime>=1674864000

Now in the api reference I read this line..

Note: Search results for the list of orders list is restricted to the last 90 days if the filter fields include: [deletedTime, externalReferenceId, createdTime, total, payType, title, note, state, manualTransaction, cardTransaction.last4, testMode, touched]

Does this mean if you use externalReferenceId there is no longer the ability to find orders by externalReferenceId that were created more than 90 days ago?

This has broken quite a bit of functionality in the application, and the documentation is not very clear.

There is also a typo in the documentation found here, there shouldn't be an escape character in the last createdTime

https://docs.clover.com/docs/limits-added-to-calls-to-payments-and-orders-endpoints

Thank you