# Query to run to generate a csv of orders in one fulfilment status automatically daily

**URL:** <https://community.shiphero.com/t/query-to-run-to-generate-a-csv-of-orders-in-one-fulfilment-status-automatically-daily/2909>\
**Category:** Getting Started\
**Created:** [April 29, 2024, 6:21pm UTC](https://community.shiphero.com/t/query-to-run-to-generate-a-csv-of-orders-in-one-fulfilment-status-automatically-daily/2909 "2024-04-29T18:21:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lflaerty](https://avatars.discourse-cdn.com/v4/letter/l/7ba0ec/32.png) [@lflaerty](https://community.shiphero.com/u/lflaerty)\
**Post date:** [April 29, 2024, 6:21pm UTC](https://community.shiphero.com/t/query-to-run-to-generate-a-csv-of-orders-in-one-fulfilment-status-automatically-daily/2909/1 "2024-04-29T18:21:51Z")

</div>

Hi all,

I need a csv sent to me every morning containing order information (name, address, contact info, box) for orders in a specific fulfilment status. Is there a query that I run to have this done automatically?

Thanks for any support

---

<div class="post-metadata">

**Author:** ![tomasfd](https://avatars.discourse-cdn.com/v4/letter/t/5daacb/32.png) [@tomasfd](https://community.shiphero.com/u/tomasfd)\
**Post date:** [April 29, 2024, 7:37pm UTC](https://community.shiphero.com/t/query-to-run-to-generate-a-csv-of-orders-in-one-fulfilment-status-automatically-daily/2909/2 "2024-04-29T19:37:25Z")

</div>

Hello @lflaerty! We do not have something that does the CSV part, but you can run a query that returns orders in a specific status and returns a JSON. This is an example query:

```auto
query {
  orders(fulfillment_status: "string") {
    request_id
    complexity
    data {
      edges {
        node {
          id
          legacy_id
          order_number
          shipping_address {
            first_name
            last_name
            address1
            city
            state
            zip
            country
            email
            phone
          }
        }
      }
    }
  }
}

```

You can find more details on available fields and filters in our schema: [https://developer.shiphero.com/wp-content/uploads/spectaql/#query-orders](https://developer.shiphero.com/wp-content/uploads/spectaql/#query-orders)

Have a nice day!