Hi all, I am continuing to work on a Quickbooks Custom Integration. I have recently run into what I expect may be a common issue when modeling data into Fibery from other systems. The integration has Invoice and Invoice Line databases in a one-to-many relationship. Quickbooks does not have a way to …

Hi, Unfortunately, integration won’t solve this at the moment. We don’t support nested data syncs for this case. BTW, your solution with automation is nice idea.

Understood, unfortunate that it can’t be done in a simpler way. Would you consider adding a feature that allows for a filtered full sync? Meaning that a full sync is performed for entities match a certain criteria (invoice line’s invoice id is __). This could be kept really simple so you can only f…

Update: Since integration sync order is not predictable and databases update one-by-one using automations did not work out as I expected. I may be able to do it with javascript but I am avoiding that since it won’t be available on my plan.

[image] Tommy_Hedley: it’s impossible to know what lines have been deleted from Quickbooks It seems like your CI app should be able to deduce the individual line changes if it stores the Quickbooks data in a local DB. …though this approach would probably introduce a lot of complexity in your…

I had the same thought process and that may be what I end up with. However, the idea of storing every line id, (not uuids of course) for every datatype that has lines, for every Quickbooks account that the integration is used for and handling all of the race conditions seems like a bad way to solve …

Custom Integration - Handling Delta Syncs and Webhooks for nested data

API & Programming

Tommy_Hedley December 17, 2024, 1:48am 7

I added a feature request for the filtered full sync, please consider it if this would be helpful for you. Filtered Full Sync for Custom Integrations

Topic		Replies	Views
Filtered Full Sync for Custom Integrations Integrations	0	49	December 17, 2024
Integration API: Records Deleted Using Edit Fields to Sync API & Programming	2	306	January 3, 2024
Files field broken on Custom Integrations Bugs & Issues	10	180	May 19, 2025
🧮 Feature Suggestion: Query from external database and create types and entities Integrations	32	2623	October 30, 2026
Limitations of Custom Integration Filters? Get Help integration	2	306	June 7, 2023

Custom Integration - Handling Delta Syncs and Webhooks for nested data

Related topics