In my last post, I went over how to create an AWS Lambda function without needing to code any Javascript. The function was used to generate static HTML pages from JSON, with the help of the low-code powerhouse TiddlyWiki. But how do we go about actually getting JSON into AWS and triggering the Lambda function to make our pages? In this guide, I’ll be generating static HTML from Google Sheets, with Lambda, API Gateway and TiddlyWiki.
The purpose of this list is to make a sitemap of all of the Topics covered on the news website Purple News. In our Test Event in the Lambda console, we had dropped our data into the Lambda Wiki as follows.
In our case, each Tiddler will be represented as a list item on a single HTML page. (Note that we aren’t limited to creating just one HTML page… We could use the –rendertiddlers command to create a separate page for each Tiddler if we wanted.)
Gsheets is always nice, because it’s quick and familiar and it has collaboration built-in. Importantly, it can also be setup to send out POST requests with JSON payloads.