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

Описание и применение

Создан коннектор QuickBooks для интеграции финансовых данных в граф знаний Cognee, реализован синхронизация, обнаружение удалений и тесты.

Задача

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

Результат

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.

Рабочий процесс

• 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

Доказательства

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

Источник

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.

Источник

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

Источник

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

Источник