Appsheet Scheduled Automation for Appsheet Database Update

[lochtefeldm]

Hi All,

Can I utilize a scheduled automation to update an appsheet database (not Google sheet, sql, etc), via calling an appscript? There is some public data I utilize that has an api I'd like to call with an appscript to keep my database in sync with updates & adds. They don't support web hooks, but do release updates quarterly that can be called.

[TeeSee1 · Accepted solution]

You should be able to do it by something like (at least I do not see why you cannot do it)

1. Call the Apps Script on a scheduled event

2. The AS retrieves the published data

3. The AS invokes an AppSheet APIs to

    3-1 read the table first

    3-2 prepare data to add to and update the table

The API s do not care about the type of your database because they do not directly manipulate it.

[lochtefeldm]

Thank you!