Azure Shiprocket Excel Integration
Budget: ₹600 – ₹1,500 INR
I want my existing Excel workbook to stay in sync with Shiprocket almost as soon as anything changes. The workbook should automatically receive every new order status, shipment status, tracking detail, and the corresponding charges without me having to export files or press refresh.
Here is the flow I have in mind. When Shiprocket fires its webhook, an Azure-hosted component (Function, Logic App, or a design you recommend) will capture the payload, validate it, and then write the relevant fields into specific tables in the workbook. The Excel file lives in Microsoft 365, so use the Graph API, Office Scripts, or another secure method you are comfortable with to perform the write operation.
I need you to:
• Build the Azure resources, secure them with Managed Identity or another best-practice approach, and store secrets in Key Vault.
• Transform the webhook JSON so that order status, shipment status, tracking information, and charge amounts land in the correct columns.
• Add basic error logging and alerting so I know if something fails.
• Provide clear, step-by-step documentation plus a brief remote session to walk me through deployment and maintenance.
Please deliver clean, well-commented code and a maintainable architecture that will scale as order volume grows. If you have done a similar Shiprocket or e-commerce integration before, let me know; it will help me gauge how quickly we can move.
Here is the flow I have in mind. When Shiprocket fires its webhook, an Azure-hosted component (Function, Logic App, or a design you recommend) will capture the payload, validate it, and then write the relevant fields into specific tables in the workbook. The Excel file lives in Microsoft 365, so use the Graph API, Office Scripts, or another secure method you are comfortable with to perform the write operation.
I need you to:
• Build the Azure resources, secure them with Managed Identity or another best-practice approach, and store secrets in Key Vault.
• Transform the webhook JSON so that order status, shipment status, tracking information, and charge amounts land in the correct columns.
• Add basic error logging and alerting so I know if something fails.
• Provide clear, step-by-step documentation plus a brief remote session to walk me through deployment and maintenance.
Please deliver clean, well-commented code and a maintainable architecture that will scale as order volume grows. If you have done a similar Shiprocket or e-commerce integration before, let me know; it will help me gauge how quickly we can move.