Hi, yesterday updated Notion Formula 2.0 is broken something in API.
Pipedream didn’t fetch data from col with formula type, if in formula contains operations, like 2+2 or DataA+DataB, if setp just a number, it os ok.
1 Like
i have exactly the same problem. New Formula 2.0 properties are always null/empty/0 when being read by Pipedream apps
Hi @art.magomaev @s.dabrowskii, in order for me to reproduce your issue, would you mind sharing the screenshot of your Notion action/source that use Formula 2.0?
Here is a picture
Problem is that it works well in Notion’s frontend (here result is number 5), but when you retrieve this page via API (https://api.notion.com/v1/pages/{page_id}), this property of type Formula is equal to 0 or null
However it works well with “old formulas”, when you have simple operations like a+b etc.
looks like rootcause is related to newly implemented engine of mapping and giving the results as a list.
On the other hand, the other API endpoint (https://api.notion.com/v1/pages/{page_id}/properties/{property_id}) returns proper and good value
Hi @s.dabrowskii, from my understanding, it looks like this is a problem with the Notion API, would you mind sending a support ticket to Notion to ask for your case?
sure think, but being open with you - i dont see “notion support ticket” page anywehere, where can i create it?
You can refer to Notion help page, they have an support email at team@makenotion.com, or you can join their community which is listed in the help page also
Notion didn’t help with this bug. Maybe you, as a pipedream product can communicate about this with them? Cause i we can’t use you service at full power, while Notion API is broken
Hi @art.magomaev, thank you for raising this issue. I’ve created a ticket here to track the issue: [BUG] Notion - Get Page returns `null` value for Formula 2.0 property · Issue #8094 · PipedreamHQ/pipedream · GitHub
Kindly subscribe to the ticket to be noticed when it is fixed!