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.