Purchase order PDFs in FastAPI

Why purchase orders become PDFs

A purchase order is the document a supplier's accounts team matches an invoice against, and it travels by email between two organisations that share no system. That is the difference between a document and a view of a database, and it is why procurement teams keep asking for this.

What a purchase order has to carry

Before any of the code below matters, the template has to produce a document that is actually a purchase order. These are the fields that make it one, and the ones a reader or an auditor will look for first.

• the PO number, which the supplier invoice must quote back
• the ordering entity and the ship-to address, which are often different
• the bill-to address and any cost centre or GL code
• each line with the agreed price, not the supplier list price
• the delivery date required, and the approval reference

Turning your Jinja2Templates template into a document

You already have the markup. Templates.get_template("invoice.html").render(context) gives you it as a string, which is the only input the render needs. TemplateResponse is for returning HTML to a browser. When the HTML is going to a renderer you want the string, so call the underlying Jinja template directly rather than unwrapping a Response you never send.

The FastAPI implementation

httpx is the client most projects here already have. The render happens in an async endpoint returning StreamingResponse, and you return StreamingResponse over the httpx byte iterator.

# routers/purchase_orders.py
import httpx
from fastapi import APIRouter, Depends
from fastapi.responses import StreamingResponse
from fastapi.templating import Jinja2Templates

router = APIRouter()
templates = Jinja2Templates(directory="templates")


@router.get("/purchase-orders/{purchase_order_id}.pdf")
async def purchase_order_pdf(purchase_order_id: int, db=Depends(get_db)):
    purchase_order = await db.get_purchase_order(purchase_order_id)

    # The template directly, not TemplateResponse: we want the string, and
    # TemplateResponse is for HTML you are actually sending to a browser.
    html = templates.get_template("purchase_order.html").render(purchase_order=purchase_order)

    client = httpx.AsyncClient(timeout=60.0)
    request = client.build_request(
        "POST",
        "https://api.pdfpipe.xyz/v1/pdf",
        headers={"Authorization": f"Bearer {settings.pdfpipe_key}"},
        json={"html": html, "options": {"format": "A4", "printBackground": True}},
    )
    upstream = await client.send(request, stream=True)
    upstream.raise_for_status()

    return StreamingResponse(
        upstream.aiter_bytes(),
        media_type="application/pdf",
        background=BackgroundTask(upstream.aclose),
    )

The CSS that makes a purchase order page correctly

The layout problem specific to this document is that delivery and billing addresses sit alongside a line item table, and both must stay on the first page where a supplier looks for them. These rules handle it.

/* Backgrounds are dropped unless printBackground is set on the
   request, which is the usual reason a document renders in plain
   black and white when it looked right in the browser. */
@page {
  size: A4;
  margin: 18mm 16mm;
}

table { break-inside: avoid; }
h2    { break-after: avoid; }

What goes wrong in FastAPI

Calling a synchronous HTTP client inside an async def endpoint blocks the event loop for the whole render, which stalls every other request on that worker. Either use httpx.AsyncClient, or declare the endpoint def rather than async def so it runs in the threadpool.

What people try first

Most FastAPI projects reach for WeasyPrint called from a background task, which moves the memory cost off the request but not out of the process. That works until it is running on more than one machine, at which point the browser becomes the thing you operate rather than the thing you use.

Where the purchase order lives afterwards

Rendering is the short part. A PO is retained alongside the invoice it authorised, because the pair is what an auditor matches. In practice it lives in the procurement system for as long as the supplier relationship does, which is longer than most teams plan for.

Getting the document right

• Check the PO number, because an invoice quoting the wrong one will not be paid.
• Generation is triggered by an approval completing in a procurement workflow, so size the timeout for that path rather than for a health check.
• These are produced one at a time by a person who is waiting, so latency is felt directly.
• Backgrounds are painted by default here, so a design that uses colour needs nothing set. Only an explicit print_background of false turns them off.

Frequently asked

Related

Other FastAPI documents, and the same purchase order in other stacks.