Pagbank Api Integration and Boleto Webhook for E-commerce Order Status Updates

We are seeking an experienced developer to update our e-commerce system's payment gateway integration. The current setup uses old PagSeguro endpoints, and we need to migrate to the new PagBank API. The primary goal is to accurately retrieve and synchronize order statuses (e.g., Paid, pending, expired) from PagBank with our SQL database records. Additionally, a crucial part of this project involves extending our notification handler to process Boleto webhooks. Specifically, when a Boleto payment is successfully completed and confirmed in Pagbank, the corresponding order in our sql database must be marked as 'paid' in the same manner that pix payments are currently handled. This project requires expertise in API integration, database management, and webhook implementation to ensure seamless and accurate order status synchronization.