API´s question

[Aparicio_Pineyr]

Hello there!

Question.
Eg: If I have an app in Appsheet that is connected to a cloud server and I want to send the data to a table of another cloud server through an API, so that the data of the other cloud server is always updated with the same data in my cloud DB,¿ what type of API should I generate so that everything is updated simultaneously? Added, edited and deleted information.

[MultiTech]

You would need a workflow for each situation, each configured to send the appropriate webhook to your DB.

This would only work for updates made via the app, just FYI. But having a workflow for adding records, updating records, and deleting them should keep things up-to-date - again, as long as every update to the data was made via the app.

[Aparicio_Pineyr]

When you said for each situation, what do you mean?
I will need for each table an API for add, another API for update and another API for delete for each table?
Also, how interacts the API with the DB that is going to be updated, added or deleted data?
How the data is going to be interact between DB´s? For an entire ROW that I had the same key value for that ROW in both DB´s how the API is going to work by adding, updating or deleting data?
It will match the key and create the changes regarding that key in both DB´s, so after Sync the data will be the same in all DB´s?

[Phil]

What you need to do is entirely dependent on the API that your target database exposes.
I suggest you start by investigating that. It is possible that they expose so form of generic interface like ODBC, or they may only offer some form of proprietary interface. You need to determine that first.