Parent and Meta Sheet - sitechtimes/club-attendance-backend-v2 GitHub Wiki

All meta sheet Id and Parent Folder Id (for current clubs) can be found in the 'folder meta' sheet. This sheet allows the backend to quickly locate the meta file and folder for that years clubs.

This works with the 'findParentMeta.ts' function which is a function that finds the parent and meta

The 'findMeta_ParentFolder' searches for a row within the 'folder meta' sheet that matches the year provided and returns an object of that row. Meta_ParentFolder Meta Object:

{
 "Folder Name": string,
 "Meta Sheet ID" string,
 "Folder Id": string
}

This object can then be used with google api functions such as service.files.create({}) to create a file within the parent folder for the club. This can also be used with the 'getMetaSheet' function which will get return the selected row as raw data without converting it to an object.