Iteration Layer
Products
Use Cases
Resources
Pricing
Login Get Started

Extract Violations and Generate a Fine Summary

Extract traffic violation data from fine notices, then generate a spreadsheet summarizing all violations for fleet management.

Get Your Free API Key

No credit card required — start with free trial credits

Who this is for

Fleet management agencies use this pipeline to process stacks of traffic fine notices — extracting violation details and generating a consolidated spreadsheet for client review, accounting, and driver accountability.

Logistics & Shipping
Request
# Step 1: Extract violation data from a fine notice
EXTRACTION=$(curl -s -X POST https://api.iterationlayer.com/document-extraction/v1/extract \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "files": [
      {
        "type": "url",
        "name": "fine-notice-TRF-2026-4471.pdf",
        "url": "https://example.com/fines/fine-notice-TRF-2026-4471.pdf"
      }
    ],
    "schema": {
      "fields": [
        {
          "name": "violation_number",
          "type": "TEXT",
          "description": "Violation or ticket reference number"
        },
        {
          "name": "violation_date",
          "type": "DATE",
          "description": "Date the violation occurred"
        },
        {
          "name": "vehicle_plate",
          "type": "TEXT",
          "description": "License plate number"
        },
        {
          "name": "driver_name",
          "type": "TEXT",
          "description": "Name of the driver if listed"
        },
        {
          "name": "violation_type",
          "type": "TEXT",
          "description": "Type of violation, e.g. speeding, red light"
        },
        {
          "name": "location",
          "type": "TEXT",
          "description": "Location where the violation occurred"
        },
        {
          "name": "fine_amount",
          "type": "CURRENCY_AMOUNT",
          "description": "Fine amount"
        },
        {
          "name": "due_date",
          "type": "DATE",
          "description": "Payment due date"
        },
        {
          "name": "points",
          "type": "INTEGER",
          "description": "Penalty points assigned"
        }
      ]
    }
  }')

# Step 2: Generate a summary spreadsheet
curl -X POST https://api.iterationlayer.com/sheet-generation/v1/generate \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "format": "xlsx",
    "sheets": [
      {
        "name": "Violation Summary",
        "columns": [
          {
            "name": "Violation #",
            "width": 20
          },
          {
            "name": "Date",
            "width": 14
          },
          {
            "name": "Plate",
            "width": 14
          },
          {
            "name": "Driver",
            "width": 22
          },
          {
            "name": "Type",
            "width": 18
          },
          {
            "name": "Location",
            "width": 30
          },
          {
            "name": "Fine",
            "width": 14
          },
          {
            "name": "Due Date",
            "width": 14
          },
          {
            "name": "Points",
            "width": 10
          }
        ],
        "rows": [
          [
            {
              "value": "TRF-2026-4471"
            },
            {
              "value": "2026-03-12",
              "format": "date"
            },
            {
              "value": "FL-8823-KM"
            },
            {
              "value": "Marco Vitali"
            },
            {
              "value": "Speeding (22 km/h over)"
            },
            {
              "value": "A1 Motorway, km 142.3, Lazio"
            },
            {
              "value": 185.00,
              "format": "currency",
              "currency_code": "EUR"
            },
            {
              "value": "2026-04-11",
              "format": "date"
            },
            {
              "value": 3,
              "format": "number"
            }
          ]
        ]
      }
    ]
  }'
Response
{
  "success": true,
  "data": {
    "buffer": "UEsDBBQAAAA...",
    "mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
  }
}
Request
import { IterationLayer } from "iterationlayer";
const client = new IterationLayer({ apiKey: "YOUR_API_KEY" });

// Step 1: Extract violation data from a fine notice
const extraction = await client.extract({
  files: [
    {
      type: "url",
      name: "fine-notice-TRF-2026-4471.pdf",
      url: "https://example.com/fines/fine-notice-TRF-2026-4471.pdf",
    },
  ],
  schema: {
    fields: [
      { name: "violation_number", type: "TEXT", description: "Violation or ticket reference number" },
      { name: "violation_date", type: "DATE", description: "Date the violation occurred" },
      { name: "vehicle_plate", type: "TEXT", description: "License plate number" },
      { name: "driver_name", type: "TEXT", description: "Name of the driver if listed" },
      { name: "violation_type", type: "TEXT", description: "Type of violation, e.g. speeding, red light" },
      { name: "location", type: "TEXT", description: "Location where the violation occurred" },
      { name: "fine_amount", type: "CURRENCY_AMOUNT", description: "Fine amount" },
      { name: "due_date", type: "DATE", description: "Payment due date" },
      { name: "points", type: "INTEGER", description: "Penalty points assigned" },
    ],
  },
});

const violationNumber = String(extraction["violation_number"].value);
const violationDate = String(extraction["violation_date"].value);
const vehiclePlate = String(extraction["vehicle_plate"].value);
const driverName = String(extraction["driver_name"].value);
const violationType = String(extraction["violation_type"].value);
const location = String(extraction["location"].value);
const fineAmount = extraction["fine_amount"].value as { amount: string; currency: string };
const dueDate = String(extraction["due_date"].value);
const points = Number(extraction["points"].value);

// Step 2: Generate a summary spreadsheet
const sheet = await client.generateSheet({
  format: "xlsx",
  sheets: [
    {
      name: "Violation Summary",
      columns: [
        { name: "Violation #", width: 20 },
        { name: "Date", width: 14 },
        { name: "Plate", width: 14 },
        { name: "Driver", width: 22 },
        { name: "Type", width: 18 },
        { name: "Location", width: 30 },
        { name: "Fine", width: 14 },
        { name: "Due Date", width: 14 },
        { name: "Points", width: 10 },
      ],
      rows: [
        [
          { value: violationNumber },
          { value: violationDate, format: "date" },
          { value: vehiclePlate },
          { value: driverName },
          { value: violationType },
          { value: location },
          { value: parseFloat(fineAmount.amount), format: "currency", currency_code: fineAmount.currency },
          { value: dueDate, format: "date" },
          { value: points, format: "number" },
        ],
      ],
    },
  ],
});
Response
{
  "success": true,
  "data": {
    "buffer": "UEsDBBQAAAA...",
    "mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
  }
}
Request
from iterationlayer import IterationLayer
client = IterationLayer(api_key="YOUR_API_KEY")

# Step 1: Extract violation data from a fine notice
extraction = client.extract(
    files=[
        {
            "type": "url",
            "name": "fine-notice-TRF-2026-4471.pdf",
            "url": "https://example.com/fines/fine-notice-TRF-2026-4471.pdf",
        }
    ],
    schema={
        "fields": [
            {"name": "violation_number", "type": "TEXT", "description": "Violation or ticket reference number"},
            {"name": "violation_date", "type": "DATE", "description": "Date the violation occurred"},
            {"name": "vehicle_plate", "type": "TEXT", "description": "License plate number"},
            {"name": "driver_name", "type": "TEXT", "description": "Name of the driver if listed"},
            {"name": "violation_type", "type": "TEXT", "description": "Type of violation, e.g. speeding, red light"},
            {"name": "location", "type": "TEXT", "description": "Location where the violation occurred"},
            {"name": "fine_amount", "type": "CURRENCY_AMOUNT", "description": "Fine amount"},
            {"name": "due_date", "type": "DATE", "description": "Payment due date"},
            {"name": "points", "type": "INTEGER", "description": "Penalty points assigned"},
        ]
    },
)

violation_number = extraction["violation_number"]["value"]
violation_date = extraction["violation_date"]["value"]
vehicle_plate = extraction["vehicle_plate"]["value"]
driver_name = extraction["driver_name"]["value"]
violation_type = extraction["violation_type"]["value"]
location = extraction["location"]["value"]
fine_amount = extraction["fine_amount"]["value"]
due_date = extraction["due_date"]["value"]
points = extraction["points"]["value"]

# Step 2: Generate a summary spreadsheet
sheet = client.generate_sheet(
    format="xlsx",
    sheets=[
        {
            "name": "Violation Summary",
            "columns": [
                {"name": "Violation #", "width": 20},
                {"name": "Date", "width": 14},
                {"name": "Plate", "width": 14},
                {"name": "Driver", "width": 22},
                {"name": "Type", "width": 18},
                {"name": "Location", "width": 30},
                {"name": "Fine", "width": 14},
                {"name": "Due Date", "width": 14},
                {"name": "Points", "width": 10},
            ],
            "rows": [
                [
                    {"value": violation_number},
                    {"value": violation_date, "format": "date"},
                    {"value": vehicle_plate},
                    {"value": driver_name},
                    {"value": violation_type},
                    {"value": location},
                    {"value": fine_amount["amount"], "format": "currency", "currency_code": fine_amount["currency"]},
                    {"value": due_date, "format": "date"},
                    {"value": points, "format": "number"},
                ]
            ],
        }
    ],
)
Response
{
  "success": true,
  "data": {
    "buffer": "UEsDBBQAAAA...",
    "mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
  }
}
Request
package main

import (
    "fmt"

    il "github.com/iterationlayer/sdk-go"
)

func main() {
    client := il.NewClient("YOUR_API_KEY")

    // Step 1: Extract violation data from a fine notice
    extraction, err := client.Extract(il.ExtractRequest{
        Files: []il.FileInput{
            il.NewFileFromURL("fine-notice-TRF-2026-4471.pdf", "https://example.com/fines/fine-notice-TRF-2026-4471.pdf"),
        },
        Schema: il.ExtractionSchema{
            "violation_number": il.NewTextFieldConfig("violation_number", "Violation or ticket reference number"),
            "violation_date":   il.NewDateFieldConfig("violation_date", "Date the violation occurred"),
            "vehicle_plate":    il.NewTextFieldConfig("vehicle_plate", "License plate number"),
            "driver_name":      il.NewTextFieldConfig("driver_name", "Name of the driver if listed"),
            "violation_type":   il.NewTextFieldConfig("violation_type", "Type of violation, e.g. speeding, red light"),
            "location":         il.NewTextFieldConfig("location", "Location where the violation occurred"),
            "fine_amount":      il.NewCurrencyAmountFieldConfig("fine_amount", "Fine amount"),
            "due_date":         il.NewDateFieldConfig("due_date", "Payment due date"),
            "points":           il.NewIntegerFieldConfig("points", "Penalty points assigned"),
        },
    })
    if err != nil {
        panic(err)
    }

    violationNumber := fmt.Sprintf("%v", (*extraction)["violation_number"].Value)
    violationDate := fmt.Sprintf("%v", (*extraction)["violation_date"].Value)
    vehiclePlate := fmt.Sprintf("%v", (*extraction)["vehicle_plate"].Value)
    driverName := fmt.Sprintf("%v", (*extraction)["driver_name"].Value)
    violationType := fmt.Sprintf("%v", (*extraction)["violation_type"].Value)
    location := fmt.Sprintf("%v", (*extraction)["location"].Value)
    dueDate := fmt.Sprintf("%v", (*extraction)["due_date"].Value)

    // Step 2: Generate a summary spreadsheet
    _, err = client.GenerateSheet(il.GenerateSheetRequest{
        Format: "xlsx",
        Sheets: []il.Sheet{
            {
                Name: "Violation Summary",
                Columns: []il.SheetColumn{
                    {Name: "Violation #", Width: 20},
                    {Name: "Date", Width: 14},
                    {Name: "Plate", Width: 14},
                    {Name: "Driver", Width: 22},
                    {Name: "Type", Width: 18},
                    {Name: "Location", Width: 30},
                    {Name: "Fine", Width: 14},
                    {Name: "Due Date", Width: 14},
                    {Name: "Points", Width: 10},
                },
                Rows: [][]il.SheetCell{
                    {
                        {Value: violationNumber},
                        {Value: violationDate, Format: "date"},
                        {Value: vehiclePlate},
                        {Value: driverName},
                        {Value: violationType},
                        {Value: location},
                        {Value: 185.00, Format: "currency", CurrencyCode: "EUR"},
                        {Value: dueDate, Format: "date"},
                        {Value: 3, Format: "number"},
                    },
                },
            },
        },
    })
    if err != nil {
        panic(err)
    }
}
Response
{
  "success": true,
  "data": {
    "buffer": "UEsDBBQAAAA...",
    "mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
  }
}
Template
{
  "name": "Extract violations and generate fine summary in Iteration Layer",
  "nodes": [
    {
      "parameters": {
        "content": "## Extract Violations and Generate a Fine Summary\n\nFleet management agencies use this pipeline to process stacks of traffic fine notices — extracting violation details and generating a consolidated spreadsheet for client review, accounting, and driver accountability.\n\n**Note:** This workflow uses the Iteration Layer community node (`n8n-nodes-iterationlayer`). Install it via Settings > Community Nodes before importing. Self-hosted n8n only.",
        "height": 280,
        "width": 500,
        "color": 2
      },
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        200,
        40
      ],
      "id": "d4e5f6a7-b8c9-0123-defa-123456789001",
      "name": "Overview"
    },
    {
      "parameters": {
        "content": "### Step 1: Extract Violation Data\nResource: **Document Extraction**\n\nConfigure the Document Extraction parameters below, then connect your credentials.",
        "height": 160,
        "width": 300,
        "color": 6
      },
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        475,
        100
      ],
      "id": "d4e5f6a7-b8c9-0123-defa-123456789002",
      "name": "Step 1 Note"
    },
    {
      "parameters": {
        "content": "### Step 2: Generate Summary Spreadsheet\nResource: **Sheet Generation**\n\nConfigure the Sheet Generation parameters below, then connect your credentials.",
        "height": 160,
        "width": 300,
        "color": 6
      },
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        725,
        100
      ],
      "id": "d4e5f6a7-b8c9-0123-defa-123456789003",
      "name": "Step 2 Note"
    },
    {
      "parameters": {},
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        250,
        300
      ],
      "id": "d4e5f6a7-b8c9-0123-defa-123456789004",
      "name": "Manual Trigger"
    },
    {
      "parameters": {
        "resource": "documentExtraction",
        "schemaInputMode": "rawJson",
        "schemaJson": "{\"fields\":[{\"name\":\"violation_number\",\"type\":\"TEXT\",\"description\":\"Violation or ticket reference number\"},{\"name\":\"violation_date\",\"type\":\"DATE\",\"description\":\"Date the violation occurred\"},{\"name\":\"vehicle_plate\",\"type\":\"TEXT\",\"description\":\"License plate number\"},{\"name\":\"driver_name\",\"type\":\"TEXT\",\"description\":\"Name of the driver if listed\"},{\"name\":\"violation_type\",\"type\":\"TEXT\",\"description\":\"Type of violation\"},{\"name\":\"location\",\"type\":\"TEXT\",\"description\":\"Location where the violation occurred\"},{\"name\":\"fine_amount\",\"type\":\"CURRENCY_AMOUNT\",\"description\":\"Fine amount\"},{\"name\":\"due_date\",\"type\":\"DATE\",\"description\":\"Payment due date\"},{\"name\":\"points\",\"type\":\"INTEGER\",\"description\":\"Penalty points assigned\"}]}",
        "files": {
          "fileValues": [
            {
              "fileInputMode": "url",
              "fileName": "fine-notice-TRF-2026-4471.pdf",
              "fileUrl": "https://example.com/fines/fine-notice-TRF-2026-4471.pdf"
            }
          ]
        }
      },
      "type": "n8n-nodes-iterationlayer.iterationLayer",
      "typeVersion": 1,
      "position": [
        500,
        300
      ],
      "id": "d4e5f6a7-b8c9-0123-defa-123456789005",
      "name": "Extract Violation Data",
      "credentials": {
        "iterationLayerApi": {
          "id": "1",
          "name": "Iteration Layer API"
        }
      }
    },
    {
      "parameters": {
        "resource": "sheetGeneration",
        "format": "xlsx",
        "sheetsJson": "[{\"name\":\"Violation Summary\",\"columns\":[{\"name\":\"Violation #\",\"width\":20},{\"name\":\"Date\",\"width\":14},{\"name\":\"Plate\",\"width\":14},{\"name\":\"Driver\",\"width\":22},{\"name\":\"Type\",\"width\":18},{\"name\":\"Location\",\"width\":30},{\"name\":\"Fine\",\"width\":14},{\"name\":\"Due Date\",\"width\":14},{\"name\":\"Points\",\"width\":10}],\"rows\":[[{\"value\":\"{{ $json.violation_number }}\"},{\"value\":\"{{ $json.violation_date }}\",\"format\":\"date\"},{\"value\":\"{{ $json.vehicle_plate }}\"},{\"value\":\"{{ $json.driver_name }}\"},{\"value\":\"{{ $json.violation_type }}\"},{\"value\":\"{{ $json.location }}\"},{\"value\":\"{{ $json.fine_amount }}\",\"format\":\"currency\",\"currency_code\":\"EUR\"},{\"value\":\"{{ $json.due_date }}\",\"format\":\"date\"},{\"value\":\"{{ $json.points }}\",\"format\":\"number\"}]]}]"
      },
      "type": "n8n-nodes-iterationlayer.iterationLayer",
      "typeVersion": 1,
      "position": [
        750,
        300
      ],
      "id": "d4e5f6a7-b8c9-0123-defa-123456789006",
      "name": "Generate Summary Spreadsheet",
      "credentials": {
        "iterationLayerApi": {
          "id": "1",
          "name": "Iteration Layer API"
        }
      }
    }
  ],
  "connections": {
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Extract Violation Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Violation Data": {
      "main": [
        [
          {
            "node": "Generate Summary Spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  }
}
Prompt
Extract traffic violation data from the fine notice at [file URL], then generate a summary spreadsheet. Use the extract_document tool with these fields:

- violation_number (TEXT): Violation or ticket reference number
- violation_date (DATE): Date the violation occurred
- vehicle_plate (TEXT): License plate number
- driver_name (TEXT): Name of the driver if listed
- violation_type (TEXT): Type of violation, e.g. speeding, red light
- location (TEXT): Location where the violation occurred
- fine_amount (CURRENCY_AMOUNT): Fine amount
- due_date (DATE): Payment due date
- points (INTEGER): Penalty points assigned

Then use the generate_sheet tool to create an XLSX spreadsheet with columns for each field, containing the extracted violation data.

Related Recipes

Extract Academic Paper Metadata

Extract title, authors, abstract, and citation info from academic papers.

Extract Article Text

Extract clean article content — title, author, date, and body text — from PDFs, Word docs, and web pages.

Extract Carrier Invoices to Spreadsheet

Extract line-level charges from multiple carrier invoices, then generate an XLSX freight cost tracker in a single pipeline.

Try with your own data

Get a free API key and run this recipe in minutes. No credit card required.

Document Extraction

Extract structured data from any document. 500 free document extractions included.

Sheet Generation

Generate Excel spreadsheets from structured data. 100 free sheet generations included.
Get Your Free API Key