We have already covered loading time & deduction records from an S3 environment to the cloud, so let’s dig into the flow we built to automate this. Essentially, this builds the email footer. Using that parameter, it extracts that data and produce a file. The key thing is the SQL, which is what RPI built to automate the whole extract and populate those three record types in the system. For each parameter, we extract the file and move it to the SFTP server for CloudSuite, and then use it again l..