How to Partially Update a Notion Database Item Without Overwriting Existing Data?

Need help
1

Context:

  • I’m using Activepieces to automate data entry into a Notion database.
  • The trigger is a webhook sending my iPhone Health data 3 times per day.
  • I have a “Daily Tracking” database in Notion. Each time data arrives, I use the “Update Database Item” module to fill the day’s info.

The Problem:

  • Whenever the new data gets pushed, it overwrites (zeros out or blank) any fields I haven’t provided in the webhook.
  • I only want to update specific fields and leave the rest of my manual entries intact.

My Goal:

  • Perform a partial update.
  • Only change fields if the webhook has actual data.
  • Leave existing data untouched if the webhook’s field is empty or not provided.

Questions for the Community:

  • Does Activepieces have a built-in way to do partial updates on Notion without manually fetching and merging data?
  • If not, what’s the most efficient workaround you’ve used to handle “patch”-style updates?

Thanks in advance for any tips or best practices!

2

@Rida , which fields are being overwritten by the update action? I think it must be the MultiSelect fields. I will open an issue for it, and the team will fix it.

3

@kishanprmr all field are being overwritten : checkboxes, raw data (numbers etc), and multi-select. It would be awesome to just update the fields we want to be updated that have a value in there, and when it’s left blank not to be touched