[FR] APIs to manipulate database components

AppFlowy-IO / AppFlowy

Bring projects, wikis, and teams together with AI. AppFlowy is an AI collaborative workspace where you achieve more without losing control of your data. The best open source alternative to Notion.

https://www.appflowy.io

GNU Affero General Public License v3.0

54.74k stars 3.58k forks source link

[FR] APIs to manipulate database components #4945

Open annieappflowy opened 5 months ago

annieappflowy commented 5 months ago

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 commented 3 months ago

We're very keen on an API as well.

zetashift commented 3 months ago

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 commented 3 months ago

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 commented 3 months ago

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

Jehu commented 3 months ago

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

annieappflowy commented 3 months ago

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

Jehu commented 3 months ago

@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 commented 3 months ago

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

Jehu commented 3 months ago

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