FileMaker Read

[Landaman]

As a QRA Administrator, I want the ability to read FileMaker data into DynamoDB, so that the site frontend can reflect the real data stored in FileMaker

https://help.claris.com/en/connect-help/content/webhooks.html
https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fhelp.claris.com%2Fen%2Fdata-api-guide%2Fcontent%2Findex.html&data=05%7C02%7Cirwright%40wpi.edu%7Cc11513e270484758230f08dbfc196a61%7C589c76f5ca1541f9884b55ec15a0672a%7C0%7C0%7C638380958324812819%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2FC2qJGAHckhq62XAeoBqoqJBGf%2FvcTwUkoAcQrTYfnQ%3D&reserved=0

Acceptance Criteria:

• All regatta/duel data migrates from DynamoDB to FileMaker with a button press in the admin dashboard
• Ability to migrate all data (ever), and then only current/future data
• Remember the edge case that a regatta/heat/whatever can be deleted so upsert by ID alone is not sufficient

[Landaman]

Tasks for duels:

• Seed not in seed 😦
• High schools don't always save results - new result type? (Historical?)
• How to merge regattas (e.g., the Clark/WPI joint hosting - how do we know when to combine to determine progression and how do we save the fact that it's joint hosting). Can probably make this an array at the regatta level and a field at the heat level would be the easiest way
• Host for individual heats
• Remove PETITE/GRAND/HEAT from hostname when applicable