auto column update from remote server

Hi there,
I have a table. Let’s call it Customers. There are some column in the table that have to be always in sync form external server. I seem to cannot find any solution related to it.
Is there any way to do this?
One way is to do a cron job.
Second way is to add a column having a button and run automation to update the related columns (not preferred).
Please let me know if the framework/tool provides such capabilities.

Thank you

Hello there @shahabgohar,

We do have our own API and apps framework.

You could use our API directly to get data from your monday boards and update/erase/create data in them. If you can integrate with the other platform, will depend on their API (if they have one) and its capabilities.

If the other platform has its own API with which you can interact, then you might be able to create an integration (this would require a script (code) on your end that would need to be hosted in your own server or hosting service). You could get webhooks from monday or from the other platform, and then use the APIs to pass information from one platform to the other. You could also try to build this using a no-code platform such as Workato, Zapier or Make.com.

You can also create an app in monday with an integration feature. In the backend, this would also be using the API, but with a custom app, you could give the users more visibility into what the integration does.

Cheers,
Matias