Hi,
I have implemented your suggestion of URL encoding the + sign (I think this should be made clear in the documentation for the APIs by the way) This does not address my main issue in that the two calls to fetch orders and order count behave inconsistently.
This allowed me to fetch the order correctly last week, but now that we have had a change to daylight savings it is no longer working correctly and I am not getting the orders back propertly.
I implemented the offset by querying the for the Shop details and parsing the time zone (currently this shows GMT+12:00 which is correct) and use this to then append the time zone offset to the updated_at parameters. However I created a new order this morning at 09:51 am New Zealand local time. I then queried for the Shop details and got the +12 offset.
{
“shop”: {
“timezone”: “(GMT+12:00) Wellington”
}
}
This results in the query
/admin/orders.json?updated_at_min=2017-09-25T09:45:00%2B12:00&updated_at_max=2017-09-25T10:00:00%2B12:00&status=any&financial_status=paid&fields=updated_at,id,number,financial_status
No orders were returned.
I changed the query to use updated_at_min one day previously and got the following result
{
“orders”: [
{
“id”: 5897221009,
“updated_at”: “2017-09-25T09:51:53+13:00”,
“number”: 19,
“financial_status”: “paid”
}
]
}
As you can see the updated_at for the order is showing +13 which is incorrect and is why my original query is not working. NZ will not be 13 hours ahead of GMT until UK changes their time on 29th October when they put their clocks back an hour.
The order count query using the %2B12:00 also does not return a sales count, however it does if I do not explicitly set the time zone offset. eg
admin/orders/count.json?updated_at_min=2017-09-25T09:45:00&updated_at_max=2017-09-25T10:00:00&status=any&financial_status=paid
Removing the timezone offset does not work when querying order details.
Unless I am missing something, I cannot see how I can consistently create a query to fetch orders reliably.
Can someone please sort this out. It has become very frustrating for our customers, and I would expect the time zones to be managed properly at the Shopify end and not have to put hacks in to our system to test for dates and daylight savings every time a call is made to Shopify and also to change the query time periods depending on whether querying for orders or order counts.