Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Mambu - Enable true incremental sync (or equivalent performance improvement) for DEPOSIT_TRANSACTION (+ DEPOSIT_TRANSACTION_FEE)

Answered
Fearghal Caulfield User

Customer problem / impact
• Customer/prospect must sync DEPOSIT_TRANSACTION and DEPOSIT_TRANSACTION_FEE (cannot deselect these to improve runtimes).
• Current connector sync duration is ~4 hours; this is a major blocker for the deal.

Customer context
• Customer states their custom pipeline performs incremental sync for deposit transactions today.

Customer-proposed approach 
Customer proposes implementing incremental logic for the deposit transaction endpoints using a two-pronged strategy:

A) “Normal” transactions
• Fetch only transactions booked between two syncs.
• Watermark candidate: creationDate or id (big integer). Customer asserts both are ascending chronologically and sequentially.

B) Adjusted / reversed transactions
• Adjusting (reversing) a transaction creates a new transaction booked “now” that is equal and opposite.
• The original transaction record is updated to link to the new reversal transaction record.
• Due to Mambu limitations, guaranteeing completeness would require scanning all historic transactions for adjusted updates (not scalable).
• Proposed compromise: add a lookback period to re-fetch a recent historical window to capture adjustments.
• Customer will deduplicate/upsert downstream upon receiving data.

API endpoint documentation (customer-provided)
• Mambu API v2 deposit transactions search: https://docs.mambu.com/api/api-v2/deposits_transactions/search/

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Syead Mujtaba Imam Rizwi Fivetranner

    Hi Fearghal,

    Thank you for taking the time to share your detailed feature request regarding the incremental sync for deposit transactions. We truly appreciate your input and the clear explanation of the problem and proposed approach.

    I want to confirm that we have added your request to our backlog. We prioritize features based on customer demand and the overall impact on our platform, and we will assess this request accordingly. 

    We understand the importance of optimizing sync durations and the impact it has on your operations. Rest assured, we will keep you updated with any future developments regarding this feature.

    Thank you once again for your valuable feedback.

    Best regards,
    Syead Mujtaba Imam Rizwi