Link Search Menu Expand Document

Invoice with line items in bordered table - TEMPLATES-SAMPLES

Document Parser sample in TEMPLATES-SAMPLES demonstrating ‘Invoice with line items in bordered table’

sampleTemplate.json
{
  "templateName": "Untitled template",
  "templateVersion": "4",
  "templatePriority": 0,
  "detectionRules": {
    "keywords": []
  },
  "objects": [
    {
      "name": "SearchBasedTable1",
      "objectType": "table",
      "tableProperties": {
        "start": {
          "expression": "({{LineStart}})(?={{Spaces}}WH)",
          "regex": true
        },
        "end": {
          "expression": "{{EndOfPage}}",
          "regex": true
        },
        "row": {
          "expression": "{{LineStart}}{{Spaces}}(?<WarehouseLoc>{{Letter}}){{Spaces}}(?<ItemNo>{{Number}}){{Spaces}}(?<Brand>{{SentenceWithSingleSpaces}}){{Spaces}}(?<Description>{{SentenceWithSingleSpaces}}){{Spaces}}(?<PackSize>{{LettersOrDigitsOrSymbols}}){{Spaces}}(?<Per>{{Letters}}){{Spaces}}(?<Quantity>{{Number}}){{Spaces}}(?<UnitPrice>{{Number}}){{Spaces}}(?<NetValue>{{Number}}){{Spaces}}(?<GSTAmount>{{Number}}){{Spaces}}(?<TotalAmount>{{Number}})",
          "regex": true
        },
        "columns": [
          {
            "name": "WH LOC",
            "dataType": "string"
          },
          {
            "name": "Item Number",
            "dataType": "integer"
          },
          {
            "name": "Brand",
            "dataType": "string"
          },
          {
            "name": "Description",
            "dataType": "string"
          },
          {
            "name": "Pack Size",
            "dataType": "string"
          },
          {
            "name": "Per",
            "dataType": "string"
          },
          {
            "name": "Quantity",
            "dataType": "integer"
          },
          {
            "name": "Unit Price",
            "dataType": "decimal or currency"
          },
          {
            "name": "Net Value",
            "dataType": "decimal or currency"
          },
          {
            "name": "GST Amount",
            "dataType": "decimal or currency"
          },
          {
            "name": "Total Amount",
            "dataType": "decimal or currency"
          }
        ]
      }
    },
    {
      "name": "Invoice #",
      "objectType": "field",
      "fieldProperties": {
        "fieldType": "macros",
        "expression": "Invoice #:{{Spaces}}{{Number}}",
        "regex": true,
        "dataType": "integer"
      }
    },
    {
      "name": "Date",
      "objectType": "field",
      "fieldProperties": {
        "fieldType": "macros",
        "expression": "Date:{{Spaces}}{{SmartDate}}",
        "regex": true,
        "dataType": "date",
        "dateFormat": "auto-dmy"
      }
    },
    {
      "name": "Order #",
      "objectType": "field",
      "fieldProperties": {
        "fieldType": "macros",
        "expression": "Order:{{Spaces}}{{Number}}",
        "regex": true,
        "dataType": "integer"
      }
    },
    {
      "name": "Total Net",
      "objectType": "field",
      "fieldProperties": {
        "fieldType": "macros",
        "expression": "Total Net:{{Spaces}}{{Number}}",
        "regex": true,
        "dataType": "decimal"
      }
    },
    {
      "name": "Total Invoice",
      "objectType": "field",
      "fieldProperties": {
        "fieldType": "macros",
        "expression": "Total Invoice:{{Spaces}}{{Number}}",
        "regex": true,
        "dataType": "decimal"
      }
    }
  ]
}

PDF.co Web API: the Web API with a set of tools for documents manipulation, data conversion, data extraction, splitting and merging of documents. Includes image recognition, built-in OCR, barcode generation and barcode decoders to decode bar codes from scans, pictures and pdf.

Get your PDF.co API key here!

Download Source Code (.zip)

return to the previous page explore Document Parser endpoint