MessageBird Chatbot

The first step is this chatbot that will register information in a DB and communicate with an API in some cases and the second step is a Web Scrapping bot that will be another project launched on Freelancer that will be responsible for using the data received by the chatbot and register on a site through web scrapping. If you are interested in developing the second part (web scrapping) as well, let me know. -------Structure of tables------- Accounts Table: PK_ID, INDICATION, CPF, EMAIL, USERNAME, PASSWORD, PHONE, ACCOUNT CREATION FLAG, ERROR FLAG, ACCOUNT LOCKED FLAG Deposit Table: PK_ID, ACCOUNT_FK_ID(Account Table), Number that requested the deposit, Amount, date and time, flag if completed, flag if balance was entered in XXX -------Chatbot flow------- Chatbot, analyzes the number of the person who sent the message and checks the Database if it is an existing customer, checks the database flag (Table of Accounts) if the account is created successfully and proceeds with options 2,3 and 4. If the account creation (Account Table) error flag is set, it directs to an attendant. If it is a new account, normally the user will start the conversation through a link that has an automatic message informing what the indication is, the chatbot needs to get this information so that it can be inserted in the Database (Table of Accounts). 1 - Create XXX Account Chatbot takes the information for the account to be created, inserts it into the BD with a flag. The account creation flag (Table of Accounts) must be periodically consulted to inform the user that the account was created in XXX After having created the account it presents options 2, 3 and 4. 2 - Make Deposit Query an own API that returns a copy and paste PIX (Payment QR Code) for the user to pay, register this deposit in the deposit table. It needs to be consulted periodically if the deposit has been completed to inform the user at chatbot It needs to be consulted periodically if the balance has been updated at XXX to inform the user at chatbot 3 - Check deposit It asks the deposit number that the user wants to consult, validates if that deposit belongs to this phone number's account (Deposit Table) and returns the status of that deposit to the user. 4 - Make Withdrawal Directly forward to the attendant for the operations department in MessageBird Inbox. 5 - Talk to an attendant Directly forward to the customer support department attendant in MessageBird Inbox.