TomFrankly/pipedream-notion-recurring-tasks

API response error

Closed this issue · 11 comments

I get an error when trying to use the pipdream automation. It is for the ultimate task list. See screenshot for more information.
Scherm­afbeelding 2024-07-01 om 11 43 08
Scherm­afbeelding 2024-07-01 om 11 43 23

@leenhos02 does your connected database have a formula-type property called UTC Offset?

@TomFrankly Yes, but its always 0.

@TomFrankly can you help me?

@leenhos02 can you show the bottom of your Logs tab when you get the error? Seeing what the final log is might help here.

Ok, it looks like the script is failing when it tries to update your "Type" property. A couple things to check:

  1. Does your tasks database have a property called Type, which is a formula property? If so, what is currently there?

  2. Are you on version 0.1.83 of the workflow? If not, you can deploy the latest version here: https://thomasjfrank.com/notion-automated-recurring-tasks/#automated-recurring-tasks-pipedream-workflow

CleanShot 2024-07-15 at 09 08 42@2x

  1. Yes and this is the formula:
    !prop("Recur Interval (days)")
    ? "⏳One-Time"
    : "🔄Recurring"

  2. I already have the 0.1.83 version

@leenhos02 alright, Martin and I have looked into this further. We believe it has to do with the fact that your formula currently references a property called "Recur Interval (days)"

I'm guessing you built your own version of Ultimate Tasks from scratch? In our templates, the property is just called "Recur Interval"

So what's likely happening is that the script is trying to update the formula, but can't find the property it's expecting:

CleanShot 2024-07-17 at 08 20 15@2x

(It updates the formula for legacy reasons that are technical and not very relevant here)

So in the medium-term, we can look into updating the script so that it's more resiliant to people re-naming their properties.

But for now, if you renamed your "Recur Interval (days)" property to "Recur Interval", that should fix the problem.

Thanks! It worked

Glad to hear! The workflow is now updated as well.