The answers to every question are sent to the backend SQL Server by a custom log call. This log call is called in the Outcome blocks. When you add / change content that affects that log call, you will need to work with the Data Team and test to make sure the changes are coming through correctly. Changes to the Outcome blocks will likely happen when you add questions, add answer choice, remove answer choices, etc.
Working with the Data Team
After you have finalized the new Outcome block content:
- Update the Excel Index-Mapping sheet with the new information
- Send the index mapping Excel file to Ravi and let him know of the changes. He will tell you if there are problems or if he has to make new queries.
You can access the full development health bot at https://covid19healthbot-dev.cdc.gov/. The data and answers from sessions in this bot will go to the dev SQL Server and PowerBI.