Query orders by timestamps (in date range) through Wix Store API

Ask the community
, ,
1

Dear Wix Developer,

Hope this finds you well and healthy. I am Ricky from Machool company. I am working on integrating our platform with our customer Wix Stores through Wix API to fulfill their orders.
But we need your help to overcome the issue with querying the list of orders from a Wix Store by dateCreated (from to ) via Wix API. I looked the following document and tried with query below but it did not work as expected. It listed out all orders of that store instead of just returning number of orders placed between declared timestamps (dateCreated).
Wix API document:

API call (I used postman for making a api call)::
POST
https://www.wixapis.com/stores/v2/orders/query
body:)
POST:
POST
https://www.wixapis.com/stores/v2/orders/query
body:)
https://www.wixapis.com/stores/v2/orders/query:
POST
https://www.wixapis.com/stores/v2/orders/query
body:)
body::
POST
https://www.wixapis.com/stores/v2/orders/query
body:)


{
    "filter": { "dateCreated": { 
                   "$hasSome": ["2020-04-20T15:35:41.700Z", "2020-04-23T15:35:41.700Z"]
  }
 }
}

Please give me some hints or suggestions in this case. Thank you so much and have a great day!

2

no answer?

3

where you able to figure it out? running into the same issue…!

4 
{
  "paymentStatus": "PAID",
  "$and": [
    {
      "dateCreated": {
        "$gte": "2023-12-01T00:00:00.000Z"
      }
    },
    {
      "dateCreated": {
        "$lte": "2023-12-31T23:59:59.999Z"
      }
    }
  ]
}