EOIR Case Access Integration to Azure
Budget: $250 – $750 USD
I run a U.S. law firm and need a secure, compliant way to pull hearing-date information from the EOIR Case Access authenticated portal and push it into our existing Microsoft Azure environment.
The piece I still need built is the EOIR Case Access integration itself. Everything else—Azure SQL tables, Microsoft 365 endpoints, and downstream reporting—already exists and is ready to receive data.
Core needs
• A fully RPA-based solution that signs into the portal through Okta MFA, built in Microsoft Power Automate Desktop.
• Robust error handling so the flow can recover gracefully from timeouts, CAPTCHA, or authentication challenges.
• Parsed docket data returned in JSON or CSV and posted to our Azure SQL stored procedures.
• Change tracking inside the bot so only new or updated hearing dates trigger the write operation.
• Clear logging to an existing Microsoft 365 mailbox or Teams channel for audit purposes.
Acceptance test
I will supply a small set of A-numbers; the bot should retrieve the hearing information, write rows to the target Azure SQL table, and send a confirmation email through Microsoft 365. Execution must complete without manual intervention and pass MFA automatically.
If you have previous experience with Okta MFA scripting, Azure SQL connectivity, and Power Automate Desktop UI flows, I would love to see a brief outline of your proposed approach and any relevant references.
The piece I still need built is the EOIR Case Access integration itself. Everything else—Azure SQL tables, Microsoft 365 endpoints, and downstream reporting—already exists and is ready to receive data.
Core needs
• A fully RPA-based solution that signs into the portal through Okta MFA, built in Microsoft Power Automate Desktop.
• Robust error handling so the flow can recover gracefully from timeouts, CAPTCHA, or authentication challenges.
• Parsed docket data returned in JSON or CSV and posted to our Azure SQL stored procedures.
• Change tracking inside the bot so only new or updated hearing dates trigger the write operation.
• Clear logging to an existing Microsoft 365 mailbox or Teams channel for audit purposes.
Acceptance test
I will supply a small set of A-numbers; the bot should retrieve the hearing information, write rows to the target Azure SQL table, and send a confirmation email through Microsoft 365. Execution must complete without manual intervention and pass MFA automatically.
If you have previous experience with Okta MFA scripting, Azure SQL connectivity, and Power Automate Desktop UI flows, I would love to see a brief outline of your proposed approach and any relevant references.
Related categories:
SQL
Software Development
Microsoft SQL Server
JSON
Microsoft Azure
Automation
Microsoft 365
RPA Development