SQL and Appian RPA Integration

Overview

The SQL and Appian RPA Integration Library are used to update the database table based on the success or failure of the bot's operation. If the searched text set is not found in Wikipedia, the bot writes 'Results not found. Invalid Input' in an Excel sheet, along with the corresponding searched text, and logs the table as 'FAILURE' with the exception. If the text is found, it scrapes the data and writes it to the Excel sheet, along with the searched text, and logs the table as 'SUCCESS.' In both success and failure cases, the bot logs the corresponding searched text and timestamp in the database table.

Key Features & Functionality

1. Integration Tools: The use of SQL and the Appian RPA Integration Library is a key feature in the system.
2. Database Table Updates: The system can dynamically update a database table based on the outcome (success or failure) of the bot's operations.
3. Handling Unsuccessful Searches: When the bot cannot find the searched text in Wikipedia:
4. Error Handling: The bot captures the error by writing 'Results not found. Invalid Input' in an Excel sheet.
5. Logging Failures: It logs the operation as 'FAILURE' along with any exception encountered.
6. Successful Searches: When the bot successfully locates the text in Wikipedia:
7. Data Extraction: It scrapes the relevant data.
8. Data Storage: This data is then written to an Excel sheet.
9. Logging Success: The operation is logged as 'SUCCESS.'
10. Comprehensive Logging: Regardless of success or failure, the system logs:
11. Searched Text: The text that was searched for.
12. Timestamps: The timestamp of the operation.
13. Status: Whether the operation was a success or failure.