AppFlowy-IO/AppFlowy

Fork 0

mirror of https://github.com/AppFlowy-IO/AppFlowy.git synced 2026-03-24 04:46:56 +00:00

[GH-ISSUE #4945] [FR] APIs to manipulate database components #2202

New issue

Closed

opened 2026-03-23 21:20:32 +00:00 by mirror · 12 comments

mirror commented

2026-03-23 21:20:32 +00:00

Owner

Originally created by @annieappflowy on GitHub (Mar 20, 2024).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/4945

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

Originally created by @annieappflowy on GitHub (Mar 20, 2024). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/4945 ### 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_

mirror

2026-03-23 21:20:32 +00:00

closed this issue
added the
new feature
label

mirror commented

2026-03-23 21:20:33 +00:00

Author

Owner

@bjohas commented on GitHub (May 11, 2024):

We're very keen on an API as well.

@bjohas commented on GitHub (May 11, 2024): We're very keen on an API as well.

mirror commented

2026-03-23 21:20:33 +00:00

Author

Owner

@zetashift commented on GitHub (May 31, 2024):

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'!

@zetashift commented on GitHub (May 31, 2024): 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](https://www.raycast.com/), 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'!

mirror commented

2026-03-23 21:20:33 +00:00

Author

Owner

@Jehu commented on GitHub (Jun 6, 2024):

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.

@Jehu commented on GitHub (Jun 6, 2024): 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.

mirror commented

2026-03-23 21:20:33 +00:00

Author

Owner

@annieappflowy commented on GitHub (Jun 6, 2024):

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

@annieappflowy commented on GitHub (Jun 6, 2024): Is Supabase the only db solution for you @Jehu ? Can other cloud services be considered?

mirror commented

2026-03-23 21:20:33 +00:00

Author

Owner

@Jehu commented on GitHub (Jun 6, 2024):

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

@Jehu commented on GitHub (Jun 6, 2024): @annieappflowy selfhosted supabase would be the best solution because it could be a data hub which provides easy automation integration

mirror commented

2026-03-23 21:20:34 +00:00

Author

Owner

@annieappflowy commented on GitHub (Jun 6, 2024):

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

@annieappflowy commented on GitHub (Jun 6, 2024): @Jehu , they don't support multi-user collaboration which AppFlowy users would need

mirror commented

2026-03-23 21:20:34 +00:00

Author

Owner

@Jehu commented on GitHub (Jun 6, 2024):

@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.

@Jehu commented on GitHub (Jun 6, 2024): @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.

mirror commented

2026-03-23 21:20:34 +00:00

Author

Owner

@annieappflowy commented on GitHub (Jun 6, 2024):

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

@annieappflowy commented on GitHub (Jun 6, 2024): @Jehu , we plan to work on APIs (integrations) in Q3, but the Supabase solution will not be maintained

mirror commented

2026-03-23 21:20:34 +00:00

Author

Owner

@Jehu commented on GitHub (Jun 6, 2024):

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

@Jehu commented on GitHub (Jun 6, 2024): Thanks for the information @annieappflowy. I will look at this again when the API is available.

mirror commented

2026-03-23 21:20:34 +00:00

Author

Owner

@thecoderdotin commented on GitHub (Oct 11, 2024):

@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!

@thecoderdotin commented on GitHub (Oct 11, 2024): > @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!

mirror commented

2026-03-23 21:20:34 +00:00

Author

Owner

@Plaidmustache commented on GitHub (Jan 24, 2025):

any update on this? keen to know if you can connect via with appflowy if self hosting.

@Plaidmustache commented on GitHub (Jan 24, 2025): any update on this? keen to know if you can connect via with appflowy if self hosting.

mirror commented

2026-03-23 21:20:34 +00:00

Author

Owner

@khorshuheng commented on GitHub (Jan 24, 2025):

The OpenAPI doc for those endpoints are here: https://github.com/AppFlowy-IO/AppFlowy-Docs/tree/main/documentation/appflowy-cloud/openapi

And here is some examples on how to use them, in Python: https://github.com/khorshuheng/appflowy-integration

However, only basic operations are supported at the moment. If there are some operations which you wish to achieve but not covered by the API, let us know.

If you don't wish to write your own scriptI, we also support Zapier.

@khorshuheng commented on GitHub (Jan 24, 2025): The OpenAPI doc for those endpoints are here: https://github.com/AppFlowy-IO/AppFlowy-Docs/tree/main/documentation/appflowy-cloud/openapi And here is some examples on how to use them, in Python: https://github.com/khorshuheng/appflowy-integration However, only basic operations are supported at the moment. If there are some operations which you wish to achieve but not covered by the API, let us know. If you don't wish to write your own scriptI, we also support Zapier.