# Mimic Dashboard Orders Overview

**URL:** <https://developer.squareup.com/forums/t/mimic-dashboard-orders-overview/850>\
**Category:** Questions\
**Tags:** orders-api\
**Created:** [August 28, 2020, 2:21am UTC](https://developer.squareup.com/forums/t/mimic-dashboard-orders-overview/850 "2020-08-28T02:21:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryanlath](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@ryanlath](https://developer.squareup.com/forums/u/ryanlath)\
**Post date:** [August 28, 2020, 2:21am UTC](https://developer.squareup.com/forums/t/mimic-dashboard-orders-overview/850/1 "2020-08-28T02:21:45Z")

</div>

I want to get all active/upcoming orders as listed in the dashboard (e.g. [https://squareup.com/dashboard/orders/overview](https://squareup.com/dashboard/orders/overview)). Ideally, just “todays” orders.

I thought it would be something simple like…  
`"query": { "filter": { "state_filter": { "states": ["OPEN"] } }`

But I seem to get all orders. The data returns seems to support them being OPEN (but they’re obviously closed, because they’'re not showing up in the dashboard). I’ve tried other queries with:  
`"fulfillment_filter": { "fulfillment_types": ["PICKUP"], "fulfillment_states": ["PROPOSED"],`  
No dice.

I even tried:  
`"date_time_filter": { "pickup_at": { "start_at": "2020-08-27T22:00:00:000Z", "end_at": "2020-08-27T23:99:99:999Z" } },`  
It didn’t throw an error, but didn’t work, either.

Anyway, I’m sure I’m missing something elementary, but I’d appreciate your help.

-Ryan

PS: Is there no post preview in this forum? Sorry, if it looks bad…

---

<div class="post-metadata">

**Author:** ![sjosey](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/sjosey/32/40_2.png) [@sjosey](https://developer.squareup.com/forums/u/sjosey)\
**Post date:** [August 28, 2020, 8:27pm UTC](https://developer.squareup.com/forums/t/mimic-dashboard-orders-overview/850/2 "2020-08-28T20:27:02Z")

</div>

Hi @ryanlath welcome to the forums!

So, for the first query, it definitely works, and you only get open orders (I tested it), although it wouldn’t just be from today, if you have older OPEN orders. The last one doesn’t work because there is no “pickup\_at” date filter (only `closed_at`, `created_at`, and `updated_at`). So there’s no real way to filter based on the pick up time, but you could also filter on the created time, something like:

```auto
{
  "location_ids": [
  	"{{location_id}}"
  	],
	"query": 
	{ 
		"filter": 
		{
			"state_filter": 
			{ 
				"states": ["OPEN"] 
			},
			"date_time_filter": {
				"created_at": {
					"start_at": "2020-08-27T22:00:00",
					"end_at": "2020-08-27T23:59:59"
				}
			}
		},
		"sort": {
			"sort_field": "CREATED_AT",
			"sort_order": "DESC"
		}
	} 
}

```

although you probably want to change the timezone by adding a “-/+” after the date. ex: “2020-08-27T22:00:00-08:00” for PST.

---

<div class="post-metadata">

**Author:** ![ryanlath](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@ryanlath](https://developer.squareup.com/forums/u/ryanlath)\
**Post date:** [August 29, 2020, 1:17am UTC](https://developer.squareup.com/forums/t/mimic-dashboard-orders-overview/850/3 "2020-08-29T01:17:59Z")

</div>

So this works in the sense that it returns data. Unfortunately, it’s not the data I want.

Is there really no way to use the api to get the data represented by:  
[https://squareup.com/dashboard/orders/overview](https://squareup.com/dashboard/orders/overview)

-Ryan

---

<div class="post-metadata">

**Author:** ![sjosey](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/sjosey/32/40_2.png) [@sjosey](https://developer.squareup.com/forums/u/sjosey)\
**Post date:** [August 31, 2020, 4:18pm UTC](https://developer.squareup.com/forums/t/mimic-dashboard-orders-overview/850/4 "2020-08-31T16:18:00Z")

</div>

Apologies for misunderstanding. So, unfortunately not directly. The main missing component here is being able to filter for paid orders (for an order must be paid before it shows up in the dashboard). You can find open orders, with open/proposed/reserver fulfillments, but there’s no way to search explicitly for paid orders. So you could get close - but then would need to do some manual filtering and searching to see if they’ve been paid for (have a `tenders` object, and checking to see if the tenders is equal to the entire order object, else it would only be partially paid).