AppSheet Receipter

This is a development release

Takes JSON input from an appsheet webhook and writes it to a table. Purpose: to store records of events with a generic structure to be able to be rendered or recalled on demand.

POST data to create a receipt

POST: /appsheet/receipter/:id

{
  "UpdateMode": "",
  "Application": "Application Name",
  "TableName": "Table",
  "UserName": "Ben",
  "At": "12/6/2022 1:59:26 AM",
  "Data": {
    "ID": "2",
    "App": "AppSheetAppName-1234567",
    "Name": "",
    "Value": "",
    "User": "",
  }
}

GET data to view a receipt

GET: /appsheet/receipter/:id?template=https://path.to.html.url/

GET data to view a receipt

Serve your custom templates here if you like. GET: /appsheet/receipter/template/:templateName

Table Structure

| ID | Parent_ID | Data | User | Module | Table | Recorded | createdAt | updatedAt | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | uuid | :id from route | {"msg":"json"} | BBC | ModuleName | TableName | Recorded | created timestamp | updated timestamp |

Deployment

• Add package and pass in sequelize and mailer
• POST / GET and away you go.

I'm sure there will be issues - for the moment, that is all.