Sorting Invoices within certain date range(using the API)?

I need to produce a list of purchases of a certain product that have been made between July 1-July 31 but we’ve sold this same product for years, so using the API to call invoices with this Product IS creates huge lists of data we don’t need and it ends up crashing the script. Is there a way to query only Invoices that are before or after a certain date?

Hope this explains it :wink:

1 Like

@John_Borelli I was searching for exactly this question, saw your answer and then saw the video was using the app rather than the api. Do you know how this can be achieved using a dsQuery api call as it looks like you can only use one query filter per field and there appears not to be a “between” query option. Any advice gratefully received