Gogoboy123

Extracting financial disclosure reports and police blotter narratives using OpenAI's Structured Output

tl;dr this demo shows how to call OpenAI's gpt-4o-mini model, provide it with URL of a screenshot of a document, and extract data that follows a schema you define. The results are pretty solid even with little effort in defining the data — and no effort doing data prep. OpenAI's API could be a cost-efficient tool for large scale data gathering projects involving public documents.

OpenAI announced Structured Outputs for its API, a feature that allows users to specify the fields and schema of extracted data, and guarantees that the JSON output will follow that specification.

For example, given a Congressional financial disclosure report, with assets defined in a table like this:

	---
	name: frontend-design
	description: Create distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, or applications. Generates creative, polished code that avoids generic AI aesthetics.
	license: Complete terms in LICENSE.txt
	---

	This skill guides creation of distinctive, production-grade frontend interfaces that avoid generic "AI slop" aesthetics. Implement real working code with exceptional attention to aesthetic details and creative choices.

	The user provides frontend requirements: a component, page, application, or interface to build. They may include context about the purpose, audience, or technical constraints.

	function main() {
	/******************************************
	* PMax Search Terms Report
	* @version: 1.0
	* @authors: Frederick Vallaeys (Optmyzr)
	* -------------------------------
	* Install this script in your Google Ads account (not an MCC account)
	* to generate a spreadsheet containing the search terms in your Performance Max campaigns.
	* The spreadsheet also includes data about category labels (groupings of search terms).
	* Metrics include conversion value, conversions, clicks, and impressions