> ## Documentation Index
> Fetch the complete documentation index at: https://code.dcycle.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk Delete Vehicle Consumptions by Filters (Organization)

> Delete every consumption record in the organization matching a set of filter criteria, e.g. an entire uploaded file

# Bulk Delete Vehicle Consumptions by Filters (Organization)

Delete every consumption record across the organization that matches a set of filter criteria — most commonly `file_id[]`, to remove every consumption created from one bulk upload, across every vehicle it was split into. Uses the same two-step, hash-confirmed workflow as the per-vehicle equivalent.

<Warning>
  **Permanent Action**: Deleting consumption records is permanent and cannot be undone. All associated emissions data will be removed from your organization's totals.
</Warning>

<Note>
  **Single organization only**: This endpoint never reaches into child organizations of a holding. If a parent-company file was split across several organizations (not just several vehicles in one organization), each organization's consumptions must be deleted separately.
</Note>

## How It Works

1. Call `GET /v2/vehicle_consumptions` with your desired filters — the response includes a `filter_hash` field.
2. Call this endpoint with the same query filters **and** pass the `filter_hash` in the request body.
3. The API verifies the hash matches the current filter results to prevent stale-data race conditions.

## Request

### Headers

<ParamField header="x-api-key" type="string" required>
  Your API key for authentication

  **Example:** `sk_live_1234567890abcdef`
</ParamField>

<ParamField header="x-organization-id" type="string" required>
  Your organization UUID

  **Example:** `a8315ef3-dd50-43f8-b7ce-d839e68d51fa`
</ParamField>

### Body Parameters

<ParamField body="filter_hash" type="string" required>
  The hash returned in the `filter_hash` field of the [list](/api-reference/vehicles/consumptions-org-list) response. Confirms you are deleting exactly the records you saw.

  **Example:** `"b4c2d3e5f6a7b8c9"`
</ParamField>

### Query Parameters

At least one filter parameter is required — a bare "delete everything" is rejected.

<ParamField query="vehicle_id[]" type="array[string]">
  Narrow the deletion to specific vehicle UUIDs
</ParamField>

<ParamField query="status[]" type="array[string]">
  Filter by consumption status

  **Available values:** `active`, `success`, `loading`, `error`
</ParamField>

<ParamField query="unit_id[]" type="array[string]">
  Filter by fuel unit UUIDs
</ParamField>

<ParamField query="custom_id" type="string">
  Filter by custom identifier
</ParamField>

<ParamField query="start_date" type="string">
  Filter consumptions with a start date on or after this date (YYYY-MM-DD)
</ParamField>

<ParamField query="end_date" type="string">
  Filter consumptions with an end date on or before this date (YYYY-MM-DD)
</ParamField>

<ParamField query="file_id[]" type="array[string]">
  Filter by source file UUIDs — delete every consumption imported from a specific file, across all vehicles it was split into

  **Example:** `file_id[]=880e8400-e29b-41d4-a716-446655440000`
</ParamField>

<ParamField query="created_at_from" type="string">
  Filter consumptions created on or after this datetime (ISO 8601)
</ParamField>

<ParamField query="created_at_to" type="string">
  Filter consumptions created on or before this datetime (ISO 8601)
</ParamField>

<ParamField query="co2e_status" type="string">
  Filter by CO2e calculation status

  **Available values:** `calculated`, `not_calculated`
</ParamField>

## Response

Returns `200 OK` with a JSON summary of the operation.

<ResponseField name="success_count" type="integer">
  Number of consumption records successfully deleted
</ResponseField>

<ResponseField name="success_ids" type="array[string]">
  UUIDs of successfully deleted consumption records
</ResponseField>

<ResponseField name="failed_count" type="integer">
  Number of records that failed to delete
</ResponseField>

<ResponseField name="failed_ids" type="array[string]">
  UUIDs of records that failed to delete
</ResponseField>

<ResponseField name="message" type="string">
  Human-readable summary of the operation
</ResponseField>

## Example

<CodeGroup>
  ```bash cURL theme={"theme":{"light":"github-light","dark":"github-dark"}}
  # Step 1: get list with filters to obtain filter_hash
  curl -X GET "https://api.dcycle.io/v2/vehicle_consumptions?file_id[]=880e8400-e29b-41d4-a716-446655440000" \
    -H "x-api-key: ${DCYCLE_API_KEY}" \
    -H "x-organization-id: ${DCYCLE_ORG_ID}"

  # Step 2: bulk delete using the filter_hash from the list response
  curl -X POST "https://api.dcycle.io/v2/vehicle_consumptions/bulk-delete-by-filters?file_id[]=880e8400-e29b-41d4-a716-446655440000" \
    -H "x-api-key: ${DCYCLE_API_KEY}" \
    -H "x-organization-id: ${DCYCLE_ORG_ID}" \
    -H "Content-Type: application/json" \
    -d '{"filter_hash": "b4c2d3e5f6a7b8c9"}'
  ```

  ```python Python theme={"theme":{"light":"github-light","dark":"github-dark"}}
  import requests
  import os

  api_key = os.getenv("DCYCLE_API_KEY")
  org_id = os.getenv("DCYCLE_ORG_ID")

  headers = {
      "x-api-key": api_key,
      "x-organization-id": org_id,
      "Content-Type": "application/json"
  }

  filters = {"file_id[]": ["880e8400-e29b-41d4-a716-446655440000"]}

  # Step 1: fetch list to get filter_hash
  list_response = requests.get(
      "https://api.dcycle.io/v2/vehicle_consumptions",
      headers=headers,
      params=filters
  )
  filter_hash = list_response.json()["filter_hash"]

  # Step 2: bulk delete with hash confirmation
  response = requests.post(
      "https://api.dcycle.io/v2/vehicle_consumptions/bulk-delete-by-filters",
      headers=headers,
      params=filters,
      json={"filter_hash": filter_hash}
  )

  result = response.json()
  print(f"Deleted: {result['success_count']}, Failed: {result['failed_count']}")
  print(result["message"])
  ```

  ```javascript JavaScript theme={"theme":{"light":"github-light","dark":"github-dark"}}
  const axios = require('axios');

  const apiKey = process.env.DCYCLE_API_KEY;
  const orgId = process.env.DCYCLE_ORG_ID;

  const headers = {
    'x-api-key': apiKey,
    'x-organization-id': orgId,
    'Content-Type': 'application/json'
  };

  const filters = { 'file_id[]': ['880e8400-e29b-41d4-a716-446655440000'] };

  // Step 1: fetch list to get filter_hash
  axios.get(
    'https://api.dcycle.io/v2/vehicle_consumptions',
    { headers, params: filters }
  )
    .then(listResponse => {
      const filterHash = listResponse.data.filter_hash;

      // Step 2: bulk delete with hash confirmation
      return axios.post(
        'https://api.dcycle.io/v2/vehicle_consumptions/bulk-delete-by-filters',
        { filter_hash: filterHash },
        { headers, params: filters }
      );
    })
    .then(response => {
      const result = response.data;
      console.log(`Deleted: ${result.success_count}, Failed: ${result.failed_count}`);
      console.log(result.message);
    })
    .catch(error => console.error(error));
  ```
</CodeGroup>

### Successful Response

```json theme={"theme":{"light":"github-light","dark":"github-dark"}}
{
  "success_count": 100,
  "success_ids": [
    "660e8400-e29b-41d4-a716-446655440000",
    "770e8400-e29b-41d4-a716-446655440001"
  ],
  "failed_count": 0,
  "failed_ids": [],
  "message": "Successfully deleted 100 vehicle consumption(s)"
}
```

## Common Errors

### 401 Unauthorized

**Cause:** Missing or invalid API key

```json theme={"theme":{"light":"github-light","dark":"github-dark"}}
{
  "detail": "Invalid API key",
  "code": "INVALID_API_KEY"
}
```

### 409 Conflict — Filter Hash Mismatch

**Cause:** The `filter_hash` does not match the current filter results. The underlying data changed between the list call and the delete call.

```json theme={"theme":{"light":"github-light","dark":"github-dark"}}
{
  "detail": "Filter hash mismatch. The filters have changed since the list was loaded. Please refresh and try again."
}
```

**Solution:** Re-fetch the consumption list with the same filters to get a fresh `filter_hash`, then retry.

### 422 Unprocessable Entity — No Filters Provided

**Cause:** No filter query parameters were supplied. At least one filter is required to prevent accidental mass deletion.

```json theme={"theme":{"light":"github-light","dark":"github-dark"}}
{
  "detail": "At least one filter parameter is required for bulk delete by filters."
}
```

### 422 Validation Error

**Cause:** Invalid query parameter value (e.g. unknown status enum)

```json theme={"theme":{"light":"github-light","dark":"github-dark"}}
{
  "detail": [
    {
      "loc": ["query", "status[]"],
      "msg": "value is not a valid enumeration member; permitted: 'active', 'success', 'loading', 'error'",
      "type": "type_error.enum"
    }
  ]
}
```

## Related Endpoints

<CardGroup cols={2}>
  <Card title="List Vehicle Consumptions (Organization)" icon="list" href="/api-reference/vehicles/consumptions-org-list">
    List consumptions and obtain the filter\_hash
  </Card>

  <Card title="Unique Values (Organization)" icon="chart-bar" href="/api-reference/vehicles/consumptions-org-unique-values">
    Get the list of source files to filter by
  </Card>

  <Card title="Bulk Delete (Organization)" icon="trash" href="/api-reference/vehicles/consumptions-org-bulk-delete">
    Delete specific consumption records by ID
  </Card>

  <Card title="Bulk Delete Consumptions by Filters" icon="filter" href="/api-reference/vehicles/consumptions-bulk-delete-by-filters">
    The single-vehicle equivalent of this endpoint
  </Card>
</CardGroup>