Iteration Layer

Extract Supplier Invoice Data for ERP Import

Extract supplier invoice details structured for direct import into ERP systems like SAP, Oracle, or Microsoft Dynamics.

No credit card required — start with free trial credits

Who this is for

Finance agencies and outsourced AP teams use this recipe to process supplier invoices into structured data that maps directly to ERP import fields — vendor ID, GL codes, tax breakdowns, and payment terms — eliminating manual data entry.

Request
curl -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": "supplier-invoice-SI-8842.pdf",
        "url": "https://example.com/invoices/supplier-invoice-SI-8842.pdf"
      }
    ],
    "schema": {
      "fields": [
        {
          "name": "vendor_name",
          "type": "TEXT",
          "description": "Supplier or vendor company name"
        },
        {
          "name": "vendor_tax_id",
          "type": "TEXT",
          "description": "Vendor VAT or tax identification number"
        },
        {
          "name": "vendor_iban",
          "type": "IBAN",
          "description": "Vendor bank account IBAN"
        },
        {
          "name": "invoice_number",
          "type": "TEXT",
          "description": "Supplier invoice number"
        },
        {
          "name": "invoice_date",
          "type": "DATE",
          "description": "Invoice issue date"
        },
        {
          "name": "due_date",
          "type": "DATE",
          "description": "Payment due date"
        },
        {
          "name": "payment_terms",
          "type": "TEXT",
          "description": "Payment terms, e.g. Net 30"
        },
        {
          "name": "currency",
          "type": "CURRENCY_CODE",
          "description": "Invoice currency"
        },
        {
          "name": "line_items",
          "type": "ARRAY",
          "description": "Invoice line items",
          "item_schema": {
            "fields": [
              {
                "name": "description",
                "type": "TEXT",
                "description": "Item or service description"
              },
              {
                "name": "gl_code",
                "type": "TEXT",
                "description": "General ledger account code if present"
              },
              {
                "name": "quantity",
                "type": "DECIMAL",
                "description": "Quantity"
              },
              {
                "name": "unit_price",
                "type": "CURRENCY_AMOUNT",
                "description": "Unit price"
              },
              {
                "name": "line_total",
                "type": "CURRENCY_AMOUNT",
                "description": "Line item total"
              }
            ]
          }
        },
        {
          "name": "subtotal",
          "type": "CURRENCY_AMOUNT",
          "description": "Subtotal before tax"
        },
        {
          "name": "tax_amount",
          "type": "CURRENCY_AMOUNT",
          "description": "Total tax amount"
        },
        {
          "name": "tax_rate",
          "type": "DECIMAL",
          "description": "Tax rate as a percentage"
        },
        {
          "name": "total_amount",
          "type": "CURRENCY_AMOUNT",
          "description": "Total amount due"
        }
      ]
    }
  }'
Response
{
  "success": true,
  "data": {
    "vendor_name": {
      "value": "Brenner Industrial Supply GmbH",
      "confidence": 0.98,
      "citations": [
        "Brenner Industrial Supply GmbH"
      ]
    },
    "vendor_tax_id": {
      "value": "DE298374561",
      "confidence": 0.97,
      "citations": [
        "USt-IdNr.: DE298374561"
      ]
    },
    "vendor_iban": {
      "value": "DE89370400440532013000",
      "confidence": 0.96,
      "citations": [
        "IBAN: DE89 3704 0044 0532 0130 00"
      ]
    },
    "invoice_number": {
      "value": "SI-8842",
      "confidence": 0.99,
      "citations": [
        "Rechnung Nr. SI-8842"
      ]
    },
    "invoice_date": {
      "value": "2026-03-20",
      "confidence": 0.98,
      "citations": [
        "Datum: 20.03.2026"
      ]
    },
    "due_date": {
      "value": "2026-04-19",
      "confidence": 0.97,
      "citations": [
        "Zahlungsziel: 19.04.2026"
      ]
    },
    "payment_terms": {
      "value": "Net 30",
      "confidence": 0.95,
      "citations": [
        "Zahlungsbedingungen: 30 Tage netto"
      ]
    },
    "currency": {
      "value": "EUR",
      "confidence": 0.99,
      "citations": [
        "EUR"
      ]
    },
    "line_items": {
      "value": [
        {
          "description": {
            "value": "Hydraulic press maintenance kit",
            "confidence": 0.96,
            "citations": [
              "Hydraulic press maintenance kit"
            ]
          },
          "gl_code": {
            "value": "6200",
            "confidence": 0.88,
            "citations": [
              "Konto 6200"
            ]
          },
          "quantity": {
            "value": 2.0,
            "confidence": 0.98,
            "citations": [
              "Menge: 2"
            ]
          },
          "unit_price": {
            "value": {
              "amount": "340.00",
              "currency": "EUR"
            },
            "confidence": 0.97,
            "citations": [
              "340,00 EUR"
            ]
          },
          "line_total": {
            "value": {
              "amount": "680.00",
              "currency": "EUR"
            },
            "confidence": 0.97,
            "citations": [
              "680,00 EUR"
            ]
          }
        }
      ],
      "confidence": 0.96,
      "citations": []
    },
    "subtotal": {
      "value": {
        "amount": "680.00",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "Nettobetrag: 680,00 EUR"
      ]
    },
    "tax_amount": {
      "value": {
        "amount": "129.20",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "MwSt. 19%: 129,20 EUR"
      ]
    },
    "tax_rate": {
      "value": 19.0,
      "confidence": 0.98,
      "citations": [
        "19%"
      ]
    },
    "total_amount": {
      "value": {
        "amount": "809.20",
        "currency": "EUR"
      },
      "confidence": 0.98,
      "citations": [
        "Gesamtbetrag: 809,20 EUR"
      ]
    }
  }
}
Request
import { IterationLayer } from "iterationlayer";
const client = new IterationLayer({ apiKey: "YOUR_API_KEY" });

const result = await client.extract({
  files: [
    {
      type: "url",
      name: "supplier-invoice-SI-8842.pdf",
      url: "https://example.com/invoices/supplier-invoice-SI-8842.pdf",
    },
  ],
  schema: {
    fields: [
      { name: "vendor_name", type: "TEXT", description: "Supplier or vendor company name" },
      { name: "vendor_tax_id", type: "TEXT", description: "Vendor VAT or tax identification number" },
      { name: "vendor_iban", type: "IBAN", description: "Vendor bank account IBAN" },
      { name: "invoice_number", type: "TEXT", description: "Supplier invoice number" },
      { name: "invoice_date", type: "DATE", description: "Invoice issue date" },
      { name: "due_date", type: "DATE", description: "Payment due date" },
      { name: "payment_terms", type: "TEXT", description: "Payment terms, e.g. Net 30" },
      { name: "currency", type: "CURRENCY_CODE", description: "Invoice currency" },
      {
        name: "line_items",
        type: "ARRAY",
        description: "Invoice line items",
        item_schema: {
          fields: [
            { name: "description", type: "TEXT", description: "Item or service description" },
            { name: "gl_code", type: "TEXT", description: "General ledger account code if present" },
            { name: "quantity", type: "DECIMAL", description: "Quantity" },
            { name: "unit_price", type: "CURRENCY_AMOUNT", description: "Unit price" },
            { name: "line_total", type: "CURRENCY_AMOUNT", description: "Line item total" },
          ],
        },
      },
      { name: "subtotal", type: "CURRENCY_AMOUNT", description: "Subtotal before tax" },
      { name: "tax_amount", type: "CURRENCY_AMOUNT", description: "Total tax amount" },
      { name: "tax_rate", type: "DECIMAL", description: "Tax rate as a percentage" },
      { name: "total_amount", type: "CURRENCY_AMOUNT", description: "Total amount due" },
    ],
  },
});
Response
{
  "success": true,
  "data": {
    "vendor_name": {
      "value": "Brenner Industrial Supply GmbH",
      "confidence": 0.98,
      "citations": [
        "Brenner Industrial Supply GmbH"
      ]
    },
    "vendor_tax_id": {
      "value": "DE298374561",
      "confidence": 0.97,
      "citations": [
        "USt-IdNr.: DE298374561"
      ]
    },
    "vendor_iban": {
      "value": "DE89370400440532013000",
      "confidence": 0.96,
      "citations": [
        "IBAN: DE89 3704 0044 0532 0130 00"
      ]
    },
    "invoice_number": {
      "value": "SI-8842",
      "confidence": 0.99,
      "citations": [
        "Rechnung Nr. SI-8842"
      ]
    },
    "invoice_date": {
      "value": "2026-03-20",
      "confidence": 0.98,
      "citations": [
        "Datum: 20.03.2026"
      ]
    },
    "due_date": {
      "value": "2026-04-19",
      "confidence": 0.97,
      "citations": [
        "Zahlungsziel: 19.04.2026"
      ]
    },
    "payment_terms": {
      "value": "Net 30",
      "confidence": 0.95,
      "citations": [
        "Zahlungsbedingungen: 30 Tage netto"
      ]
    },
    "currency": {
      "value": "EUR",
      "confidence": 0.99,
      "citations": [
        "EUR"
      ]
    },
    "line_items": {
      "value": [
        {
          "description": {
            "value": "Hydraulic press maintenance kit",
            "confidence": 0.96,
            "citations": [
              "Hydraulic press maintenance kit"
            ]
          },
          "gl_code": {
            "value": "6200",
            "confidence": 0.88,
            "citations": [
              "Konto 6200"
            ]
          },
          "quantity": {
            "value": 2.0,
            "confidence": 0.98,
            "citations": [
              "Menge: 2"
            ]
          },
          "unit_price": {
            "value": {
              "amount": "340.00",
              "currency": "EUR"
            },
            "confidence": 0.97,
            "citations": [
              "340,00 EUR"
            ]
          },
          "line_total": {
            "value": {
              "amount": "680.00",
              "currency": "EUR"
            },
            "confidence": 0.97,
            "citations": [
              "680,00 EUR"
            ]
          }
        }
      ],
      "confidence": 0.96,
      "citations": []
    },
    "subtotal": {
      "value": {
        "amount": "680.00",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "Nettobetrag: 680,00 EUR"
      ]
    },
    "tax_amount": {
      "value": {
        "amount": "129.20",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "MwSt. 19%: 129,20 EUR"
      ]
    },
    "tax_rate": {
      "value": 19.0,
      "confidence": 0.98,
      "citations": [
        "19%"
      ]
    },
    "total_amount": {
      "value": {
        "amount": "809.20",
        "currency": "EUR"
      },
      "confidence": 0.98,
      "citations": [
        "Gesamtbetrag: 809,20 EUR"
      ]
    }
  }
}
Request
from iterationlayer import IterationLayer
client = IterationLayer(api_key="YOUR_API_KEY")

result = client.extract(
    files=[
        {
            "type": "url",
            "name": "supplier-invoice-SI-8842.pdf",
            "url": "https://example.com/invoices/supplier-invoice-SI-8842.pdf",
        }
    ],
    schema={
        "fields": [
            {"name": "vendor_name", "type": "TEXT", "description": "Supplier or vendor company name"},
            {"name": "vendor_tax_id", "type": "TEXT", "description": "Vendor VAT or tax identification number"},
            {"name": "vendor_iban", "type": "IBAN", "description": "Vendor bank account IBAN"},
            {"name": "invoice_number", "type": "TEXT", "description": "Supplier invoice number"},
            {"name": "invoice_date", "type": "DATE", "description": "Invoice issue date"},
            {"name": "due_date", "type": "DATE", "description": "Payment due date"},
            {"name": "payment_terms", "type": "TEXT", "description": "Payment terms, e.g. Net 30"},
            {"name": "currency", "type": "CURRENCY_CODE", "description": "Invoice currency"},
            {
                "name": "line_items",
                "type": "ARRAY",
                "description": "Invoice line items",
                "item_schema": {
                    "fields": [
                        {"name": "description", "type": "TEXT", "description": "Item or service description"},
                        {"name": "gl_code", "type": "TEXT", "description": "General ledger account code if present"},
                        {"name": "quantity", "type": "DECIMAL", "description": "Quantity"},
                        {"name": "unit_price", "type": "CURRENCY_AMOUNT", "description": "Unit price"},
                        {"name": "line_total", "type": "CURRENCY_AMOUNT", "description": "Line item total"},
                    ]
                },
            },
            {"name": "subtotal", "type": "CURRENCY_AMOUNT", "description": "Subtotal before tax"},
            {"name": "tax_amount", "type": "CURRENCY_AMOUNT", "description": "Total tax amount"},
            {"name": "tax_rate", "type": "DECIMAL", "description": "Tax rate as a percentage"},
            {"name": "total_amount", "type": "CURRENCY_AMOUNT", "description": "Total amount due"},
        ]
    },
)
Response
{
  "success": true,
  "data": {
    "vendor_name": {
      "value": "Brenner Industrial Supply GmbH",
      "confidence": 0.98,
      "citations": [
        "Brenner Industrial Supply GmbH"
      ]
    },
    "vendor_tax_id": {
      "value": "DE298374561",
      "confidence": 0.97,
      "citations": [
        "USt-IdNr.: DE298374561"
      ]
    },
    "vendor_iban": {
      "value": "DE89370400440532013000",
      "confidence": 0.96,
      "citations": [
        "IBAN: DE89 3704 0044 0532 0130 00"
      ]
    },
    "invoice_number": {
      "value": "SI-8842",
      "confidence": 0.99,
      "citations": [
        "Rechnung Nr. SI-8842"
      ]
    },
    "invoice_date": {
      "value": "2026-03-20",
      "confidence": 0.98,
      "citations": [
        "Datum: 20.03.2026"
      ]
    },
    "due_date": {
      "value": "2026-04-19",
      "confidence": 0.97,
      "citations": [
        "Zahlungsziel: 19.04.2026"
      ]
    },
    "payment_terms": {
      "value": "Net 30",
      "confidence": 0.95,
      "citations": [
        "Zahlungsbedingungen: 30 Tage netto"
      ]
    },
    "currency": {
      "value": "EUR",
      "confidence": 0.99,
      "citations": [
        "EUR"
      ]
    },
    "line_items": {
      "value": [
        {
          "description": {
            "value": "Hydraulic press maintenance kit",
            "confidence": 0.96,
            "citations": [
              "Hydraulic press maintenance kit"
            ]
          },
          "gl_code": {
            "value": "6200",
            "confidence": 0.88,
            "citations": [
              "Konto 6200"
            ]
          },
          "quantity": {
            "value": 2.0,
            "confidence": 0.98,
            "citations": [
              "Menge: 2"
            ]
          },
          "unit_price": {
            "value": {
              "amount": "340.00",
              "currency": "EUR"
            },
            "confidence": 0.97,
            "citations": [
              "340,00 EUR"
            ]
          },
          "line_total": {
            "value": {
              "amount": "680.00",
              "currency": "EUR"
            },
            "confidence": 0.97,
            "citations": [
              "680,00 EUR"
            ]
          }
        }
      ],
      "confidence": 0.96,
      "citations": []
    },
    "subtotal": {
      "value": {
        "amount": "680.00",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "Nettobetrag: 680,00 EUR"
      ]
    },
    "tax_amount": {
      "value": {
        "amount": "129.20",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "MwSt. 19%: 129,20 EUR"
      ]
    },
    "tax_rate": {
      "value": 19.0,
      "confidence": 0.98,
      "citations": [
        "19%"
      ]
    },
    "total_amount": {
      "value": {
        "amount": "809.20",
        "currency": "EUR"
      },
      "confidence": 0.98,
      "citations": [
        "Gesamtbetrag: 809,20 EUR"
      ]
    }
  }
}
Request
package main

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

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

    result, err := client.Extract(il.ExtractRequest{
        Files: []il.FileInput{
            il.NewFileFromURL("supplier-invoice-SI-8842.pdf", "https://example.com/invoices/supplier-invoice-SI-8842.pdf"),
        },
        Schema: il.ExtractionSchema{
            "vendor_name":   il.NewTextFieldConfig("vendor_name", "Supplier or vendor company name"),
            "vendor_tax_id": il.NewTextFieldConfig("vendor_tax_id", "Vendor VAT or tax identification number"),
            "vendor_iban":   il.NewIbanFieldConfig("vendor_iban", "Vendor bank account IBAN"),
            "invoice_number": il.NewTextFieldConfig("invoice_number", "Supplier invoice number"),
            "invoice_date":  il.NewDateFieldConfig("invoice_date", "Invoice issue date"),
            "due_date":      il.NewDateFieldConfig("due_date", "Payment due date"),
            "payment_terms": il.NewTextFieldConfig("payment_terms", "Payment terms, e.g. Net 30"),
            "currency":      il.NewCurrencyCodeFieldConfig("currency", "Invoice currency"),
            "line_items": il.NewArrayFieldConfig("line_items", "Invoice line items", []il.FieldConfig{
                il.NewTextFieldConfig("description", "Item or service description"),
                il.NewTextFieldConfig("gl_code", "General ledger account code if present"),
                il.NewDecimalFieldConfig("quantity", "Quantity"),
                il.NewCurrencyAmountFieldConfig("unit_price", "Unit price"),
                il.NewCurrencyAmountFieldConfig("line_total", "Line item total"),
            }),
            "subtotal":     il.NewCurrencyAmountFieldConfig("subtotal", "Subtotal before tax"),
            "tax_amount":   il.NewCurrencyAmountFieldConfig("tax_amount", "Total tax amount"),
            "tax_rate":     il.NewDecimalFieldConfig("tax_rate", "Tax rate as a percentage"),
            "total_amount": il.NewCurrencyAmountFieldConfig("total_amount", "Total amount due"),
        },
    })
    if err != nil {
        panic(err)
    }
    _ = result
}
Response
{
  "success": true,
  "data": {
    "vendor_name": {
      "value": "Brenner Industrial Supply GmbH",
      "confidence": 0.98,
      "citations": [
        "Brenner Industrial Supply GmbH"
      ]
    },
    "vendor_tax_id": {
      "value": "DE298374561",
      "confidence": 0.97,
      "citations": [
        "USt-IdNr.: DE298374561"
      ]
    },
    "vendor_iban": {
      "value": "DE89370400440532013000",
      "confidence": 0.96,
      "citations": [
        "IBAN: DE89 3704 0044 0532 0130 00"
      ]
    },
    "invoice_number": {
      "value": "SI-8842",
      "confidence": 0.99,
      "citations": [
        "Rechnung Nr. SI-8842"
      ]
    },
    "invoice_date": {
      "value": "2026-03-20",
      "confidence": 0.98,
      "citations": [
        "Datum: 20.03.2026"
      ]
    },
    "due_date": {
      "value": "2026-04-19",
      "confidence": 0.97,
      "citations": [
        "Zahlungsziel: 19.04.2026"
      ]
    },
    "payment_terms": {
      "value": "Net 30",
      "confidence": 0.95,
      "citations": [
        "Zahlungsbedingungen: 30 Tage netto"
      ]
    },
    "currency": {
      "value": "EUR",
      "confidence": 0.99,
      "citations": [
        "EUR"
      ]
    },
    "line_items": {
      "value": [
        {
          "description": {
            "value": "Hydraulic press maintenance kit",
            "confidence": 0.96,
            "citations": [
              "Hydraulic press maintenance kit"
            ]
          },
          "gl_code": {
            "value": "6200",
            "confidence": 0.88,
            "citations": [
              "Konto 6200"
            ]
          },
          "quantity": {
            "value": 2.0,
            "confidence": 0.98,
            "citations": [
              "Menge: 2"
            ]
          },
          "unit_price": {
            "value": {
              "amount": "340.00",
              "currency": "EUR"
            },
            "confidence": 0.97,
            "citations": [
              "340,00 EUR"
            ]
          },
          "line_total": {
            "value": {
              "amount": "680.00",
              "currency": "EUR"
            },
            "confidence": 0.97,
            "citations": [
              "680,00 EUR"
            ]
          }
        }
      ],
      "confidence": 0.96,
      "citations": []
    },
    "subtotal": {
      "value": {
        "amount": "680.00",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "Nettobetrag: 680,00 EUR"
      ]
    },
    "tax_amount": {
      "value": {
        "amount": "129.20",
        "currency": "EUR"
      },
      "confidence": 0.97,
      "citations": [
        "MwSt. 19%: 129,20 EUR"
      ]
    },
    "tax_rate": {
      "value": 19.0,
      "confidence": 0.98,
      "citations": [
        "19%"
      ]
    },
    "total_amount": {
      "value": {
        "amount": "809.20",
        "currency": "EUR"
      },
      "confidence": 0.98,
      "citations": [
        "Gesamtbetrag: 809,20 EUR"
      ]
    }
  }
}
Template
{
  "name": "Extract supplier invoice data for ERP import in Iteration Layer",
  "nodes": [
    {
      "parameters": {
        "content": "## Extract Supplier Invoice Data for ERP Import\n\nFinance agencies and outsourced AP teams use this recipe to process supplier invoices into structured data that maps directly to ERP import fields — vendor ID, GL codes, tax breakdowns, and payment terms — eliminating manual data entry.\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": "a7b8c9d0-e1f2-3456-abcd-456789012301",
      "name": "Overview"
    },
    {
      "parameters": {
        "content": "### Step 1: Extract Invoice 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": "a7b8c9d0-e1f2-3456-abcd-456789012302",
      "name": "Step 1 Note"
    },
    {
      "parameters": {},
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        250,
        300
      ],
      "id": "a7b8c9d0-e1f2-3456-abcd-456789012303",
      "name": "Manual Trigger"
    },
    {
      "parameters": {
        "resource": "documentExtraction",
        "schemaInputMode": "rawJson",
        "schemaJson": "{\"fields\":[{\"name\":\"vendor_name\",\"type\":\"TEXT\",\"description\":\"Supplier or vendor company name\"},{\"name\":\"vendor_tax_id\",\"type\":\"TEXT\",\"description\":\"Vendor VAT or tax identification number\"},{\"name\":\"vendor_iban\",\"type\":\"IBAN\",\"description\":\"Vendor bank account IBAN\"},{\"name\":\"invoice_number\",\"type\":\"TEXT\",\"description\":\"Supplier invoice number\"},{\"name\":\"invoice_date\",\"type\":\"DATE\",\"description\":\"Invoice issue date\"},{\"name\":\"due_date\",\"type\":\"DATE\",\"description\":\"Payment due date\"},{\"name\":\"payment_terms\",\"type\":\"TEXT\",\"description\":\"Payment terms\"},{\"name\":\"currency\",\"type\":\"CURRENCY_CODE\",\"description\":\"Invoice currency\"},{\"name\":\"line_items\",\"type\":\"ARRAY\",\"description\":\"Invoice line items\",\"item_schema\":{\"fields\":[{\"name\":\"description\",\"type\":\"TEXT\",\"description\":\"Item or service description\"},{\"name\":\"gl_code\",\"type\":\"TEXT\",\"description\":\"General ledger account code\"},{\"name\":\"quantity\",\"type\":\"DECIMAL\",\"description\":\"Quantity\"},{\"name\":\"unit_price\",\"type\":\"CURRENCY_AMOUNT\",\"description\":\"Unit price\"},{\"name\":\"line_total\",\"type\":\"CURRENCY_AMOUNT\",\"description\":\"Line item total\"}]}},{\"name\":\"subtotal\",\"type\":\"CURRENCY_AMOUNT\",\"description\":\"Subtotal before tax\"},{\"name\":\"tax_amount\",\"type\":\"CURRENCY_AMOUNT\",\"description\":\"Total tax amount\"},{\"name\":\"tax_rate\",\"type\":\"DECIMAL\",\"description\":\"Tax rate as a percentage\"},{\"name\":\"total_amount\",\"type\":\"CURRENCY_AMOUNT\",\"description\":\"Total amount due\"}]}",
        "files": {
          "fileValues": [
            {
              "fileInputMode": "url",
              "fileName": "supplier-invoice-SI-8842.pdf",
              "fileUrl": "https://example.com/invoices/supplier-invoice-SI-8842.pdf"
            }
          ]
        }
      },
      "type": "n8n-nodes-iterationlayer.iterationLayer",
      "typeVersion": 1,
      "position": [
        500,
        300
      ],
      "id": "a7b8c9d0-e1f2-3456-abcd-456789012304",
      "name": "Extract Invoice Data",
      "credentials": {
        "iterationLayerApi": {
          "id": "1",
          "name": "Iteration Layer API"
        }
      }
    }
  ],
  "connections": {
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Extract Invoice Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  }
}
Prompt
Extract supplier invoice data for ERP import from the file at [file URL]. Use the extract_document tool with these fields:

- vendor_name (TEXT): Supplier or vendor company name
- vendor_tax_id (TEXT): Vendor VAT or tax identification number
- vendor_iban (IBAN): Vendor bank account IBAN
- invoice_number (TEXT): Supplier invoice number
- invoice_date (DATE): Invoice issue date
- due_date (DATE): Payment due date
- payment_terms (TEXT): Payment terms, e.g. Net 30
- currency (CURRENCY_CODE): Invoice currency
- line_items (ARRAY): Each with description (TEXT), gl_code (TEXT), quantity (DECIMAL), unit_price (CURRENCY_AMOUNT), line_total (CURRENCY_AMOUNT)
- subtotal (CURRENCY_AMOUNT): Subtotal before tax
- tax_amount (CURRENCY_AMOUNT): Total tax amount
- tax_rate (DECIMAL): Tax rate as a percentage
- total_amount (CURRENCY_AMOUNT): Total amount due

Related Recipes

Try with your own data

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