US Congress Stock Trading API examples & templates
Use these vals as a playground to view and fork US Congress Stock Trading API examples and templates on Val Town. Run any example below or find templates that can be used as a pre-built solution.
switchbot
@stevekrouse
HTTP (deprecated)
Open the Val Town Office Doors with Switchbot We installed two switchbot robots in our office: Ground Floor Office Door This webpage will let Val Town employees or guests to use these bots. The original version of this val was for a party. That fork is preserved here: @stevekrouse/switchbot_party Next steps [ ] Remove party theme [ ] Add one of @pomdtr's login methods [ ] Allow all @val.town emails to login [ ] Have any other email login ping me for approval or make a private val with a list of approved emails [ ] Add the office door to the site [ ] Add instructions (ie turn off wifi completely downstairs; be gentle with the office door one) Switchbot API This val authenticates to the switchbot API with SWITCHBOT_TOKEN and SWITCHBOT_KEY . Learn how to get your own Switchbot API keys here: Switchbot Docs .
SteamPlaytimeHistory_playHistoryToSqlite
@alvi
Cron
This val is part of the SteamPlaytimeHistory project which consists of logging your recently played games on steam everyday through valve's API. I wanted to log this data so I can analyse which days do I game the most ? which periods do I log the most hours in my confort game (Dead By Daylight) ? And so on. I think the data viz possibilities are super interesting, just like when Valve releases the "Steam in review" at the end of the year This val fetches your recent playtime history from valve's API and stores it in a database every day ! The project uses multiple vals to work: First you need to create the table to store the data: https://www.val.town/v/alvi/SteamPlaytimeHistory_createPlayHistoryTable You can then interact with the table using this drizzle schema: https://www.val.town/v/alvi/SteamPlaytimeHistory_playHistorySchema Optionnaly, you can backup your data with a csv file in your email every month: https://www.val.town/v/alvi/SteamPlaytimeHistory_exportDbToEmail Finally, you can run this val every day (or more) to log the data to the sqlite table To run this project, you'll need: A steam web api key: https://steamcommunity.com/login/home/?goto=%2Fdev%2Fapikey SteamID of the user (profile needs to be public) Discord websocket url (for error messages)
glideImportDemo
@dvdsgl
Script
Glide API 2.0: Bulk Import You can fork this Val to implement your own bulk import to Glide. Glide's high-performance bulk import API can load millions of rows
into Big Tables. It's designed for importing your business data
into Glide on a regular schedule (e.g. nightly). We designed this API for customers who regularly import tens of
thousands of rows or more to Glide using tools like Make. Our goal
was to make this process more efficient and less expensive. Note: This API is currently free to use. Future usage will cost
approximately 1 update per 10k rows.