# Query Order Fields

**URL:** <https://integration.keap.com/t/query-order-fields/85393>\
**Category:** API Q&A\
**Tags:** api\
**Created:** [October 25, 2021, 7:11pm UTC](https://integration.keap.com/t/query-order-fields/85393 "2021-10-25T19:11:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cb\_dev](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/cb_dev/32/13199_2.png) [@cb\_dev](https://integration.keap.com/u/cb_dev)\
**Post date:** [October 25, 2021, 7:11pm UTC](https://integration.keap.com/t/query-order-fields/85393/1 "2021-10-25T19:11:29Z")

</div>

Hello, I am looking to query specific fields within the orders endpoint using the REST API. There is a business requirement within our eCommerce company to periodically get new data matching certain criteria from Keap/Infusionsoft.

One example is orders with the title “Manual” or “local pickup”. I’ve attempted several different ways to query this data through filtering specific days using the “since” query parameter, but have only succeeded in pulling the entire day’s worth of data from the orders endpoint.

Is this currently possible with the REST API? It seems strange I couldn’t query data based on field values.

Example mock-up code, written in Python:

```auto
query_params = {'title': 'manual', 'since': f'{today_datetime}'}

get_manual_orders = requests.get(
    order_API_URL, headers=request_headers, params=query_params)
get_manual_orders.raise_for_status()

```

This code returns the entire days worth of order data.

---

<div class="post-metadata">

**Author:** ![JustinGourley](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/justingourley/32/12672_2.png) [@JustinGourley](https://integration.keap.com/u/JustinGourley)\
**Post date:** [October 25, 2021, 10:56pm UTC](https://integration.keap.com/t/query-order-fields/85393/2 "2021-10-25T22:56:04Z")

</div>

In order to query by title, you are going to need to leverage the XMLRPC API. Use the DataService.query method on the table called Job. The title field is labeled “JobTitle”.

[Table documentation](https://developer.infusionsoft.com/docs/table-schema/#Job)  
[DataService.query documentation](https://developer.infusionsoft.com/docs/xml-rpc/#data-query-a-data-table)