I Built a QuickBooks Connector for an AI Knowledge Graph — Here’s What I Learned

Description and use

Built a QuickBooks connector to ingest financial records into Cognee’s AI knowledge graph with incremental sync, deletion detection, and automated tests.

Problem

Integrate QuickBooks Online financial data into an AI knowledge graph while maintaining data consistency and handling authentication, sync, and deletion.

Outcome

Implemented a robust QuickBooks connector with incremental sync, deletion detection, retry handling, and automated tests, enabling seamless ingestion of financial records into Cognee’s AI knowledge graph.

Workflow

• Authenticate via OAuth 2.0 and refresh tokens
• Retrieve records from QuickBooks API
• Format records into Markdown documents
• Send documents through Cognee ingestion workflow
• Incrementally sync using Metadata.LastUpdatedTime
• Detect deletions via QuickBooks CDC
• Reconcile on empty sync to avoid accidental deletions
• Handle retries and safeguard against accidental deletion

Evidence

I worked on a connector that brings QuickBooks financial records into Cognee's AI memory workflow.

Source

The connector supports: Ingesting invoices, vendor bills, and credit memos. OAuth 2.0 authentication and token refresh. Incremental sync to retrieve new and updated records. Deletion detection to help remove outdated information. Retry handling and safeguards against accidental deletion. Automated tests and offline pipeline verification using DuckDB.

Source

The submitted test suite documents 12 passing tests, covering data formatting, synchronization, deletion handling, and retry behavior.

Source

This contribution taught me that building a data connector is about much more than calling an API.

Source