iterationlayer Extract Violations and Generate a Fine Summary
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.
APIs Used
Document Extraction (1 credit per page), Sheet Generation (1 credits/request)
Prerequisites
You need an Iteration Layer API key. Get one at platform.iterationlayer.com during the 7-day trial.
For full integration guidance (SDKs, auth, MCP, error handling), see the Iteration Layer Integration Guide.
Implementation
# 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"
}
]
]
}
]
}'
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.extractDocument({
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" },
],
],
},
],
});
from iterationlayer import IterationLayer
client = IterationLayer(api_key="YOUR_API_KEY")
# Step 1: Extract violation data from a fine notice
extraction = client.extract_document(
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"},
]
],
}
],
)
package main
import il "github.com/iterationlayer/sdk-go"
func main() {
client := il.NewClient("YOUR_API_KEY")
result, err := client.ExtractDocument(il.ExtractDocumentRequest{
Files: []il.FileInput{
il.FileInput{
Type: "url",
Name: "fine-notice-TRF-2026-4471.pdf",
Url: "https://example.com/fines/fine-notice-TRF-2026-4471.pdf",
},
},
Schema: il.ExtractionSchema{
Fields: []any{
il.TextFieldConfig{
Name: "violation_number",
Type: "TEXT",
Description: "Violation or ticket reference number",
},
il.DateFieldConfig{
Name: "violation_date",
Type: "DATE",
Description: "Date the violation occurred",
},
il.TextFieldConfig{
Name: "vehicle_plate",
Type: "TEXT",
Description: "License plate number",
},
il.TextFieldConfig{
Name: "driver_name",
Type: "TEXT",
Description: "Name of the driver if listed",
},
il.TextFieldConfig{
Name: "violation_type",
Type: "TEXT",
Description: "Type of violation, e.g. speeding, red light",
},
il.TextFieldConfig{
Name: "location",
Type: "TEXT",
Description: "Location where the violation occurred",
},
il.CurrencyAmountFieldConfig{
Name: "fine_amount",
Type: "CURRENCY_AMOUNT",
Description: "Fine amount",
},
il.DateFieldConfig{
Name: "due_date",
Type: "DATE",
Description: "Payment due date",
},
il.IntegerFieldConfig{
Name: "points",
Type: "INTEGER",
Description: "Penalty points assigned",
},
},
},
})
if err != nil {
panic(err)
}
_ = result
}
{
"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 on self-hosted n8n, or add it directly on n8n Cloud with Verified Community Nodes enabled.",
"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"
}
}
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.
Response
{
"success": true,
"data": {
"buffer": "UEsDBBQAAAA...",
"mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
}
}