[FR] APIs to manipulate database components

[annieappflowy]

Description

I'm using scripts extensively in my workflow with Notion through their API. I'm working in the animation industry and have to manage multiple shots with each their tasks. For example, I'm using n8n to connect and batch update some "link" properties of the shots. Or automatically update number of frames int property. Furthermore, I can work the over way around and read notion shots to get their status property and connect it to my render farm setup, etc...

I think there is a lot of interest in having scripting capabilities for a database focused solution. And being limited in the number of blocks in Notion I went on a quest to find a open source solution to maybe host the software myself. Not having found anything suitable, I decided to migrate my workspace to the my studio's paid plan of notion.

Impact

Developer type of users

Additional Context

No response

[bjohas]

We're very keen on an API as well.

[zetashift]

Hi! I'm interested in this as well!

Use cases

• I would like to create/update/list/delete tasks/pages outside of AppFlowy.
  • Here I'm bring AppFlowy into my workflow rather seamlessly. With an API, I can wire up AppFlowy to things like Raycast, GitHub webhooks, or JIRA, without adding maintenance burden for the team.

Things like:

• From my code editor: list all tasks from a certain database in AppFlowy for the next 7 days.(if you give me all the tasks I can still filter on it!)
• Quick add, from Raycast, a note to an inbox page.
• Highlights from Readwise/BookFusion should be put in pages.

There is overlap with Zapier, so feel free to just say 'use Zapier'!

[Jehu]

I wanted to start with AppFlowy and supabase yesterday and just found out that supabase support is sunsetted now. I wanted to use supabase as a central database where i can use the supabase API and n8n for automations. Now that there is no more AppFlowy supabase support we need some alternative for integrating AppFlowy with third party systems. Therefore we stopped our plans using AppFlowy as our knowledge base because of the lack of integrations for now.

This topic might be important for many people i think.

[annieappflowy]

Is Supabase the only db solution for you @Jehu ? Can other cloud services be considered?

[Jehu]

@annieappflowy selfhosted supabase would be the best solution because it could be a data hub which provides easy automation integration

[annieappflowy]

@Jehu , they don't support multi-user collaboration which AppFlowy users would need

[Jehu]

@annieappflowy I can't say anything about that. The important thing for me is the ability to have all the apps in my system talk to each other.

[annieappflowy]

@Jehu , we plan to work on APIs (integrations) in Q3, but the Supabase solution will not be maintained

[Jehu]

Thanks for the information @annieappflowy. I will look at this again when the API is available.

[thecoderdotin]

@Jehu , we plan to work on APIs (integrations) in Q3, but the Supabase solution will not be maintained

Hi @annieappflowy, I couldn't locate the status of this time on the roadmap. Could you let me know how this is going? Thanks!