Scoro API Integration with Excel via Heroku

Description

Description:We are looking for an experienced developer to help us integrate Scoro’s API with Excel via a PostgreSQL database on Heroku. The goal is to enable dynamic data extraction from Scoro and allow real-time reporting in Excel with automated data refresh capabilities.
Scope of Work:Set Up PostgreSQL Database on Heroku
Configure a database to store data extracted from Scoro.Ensure secure and efficient data management.Extract & Sync Data from Scoro API
Connect to Scoro’s API and retrieve relevant data (quotes, project profitability, sales performance).Automate data extraction at scheduled intervals.Connect Heroku Database to Excel
Enable Excel to query and pull data directly from Heroku.Ensure data refresh with minimal manual input.Testing & Optimization
Ensure data accuracy and smooth integration.Provide basic guidance on how to refresh reports and troubleshoot.Requirements:✅ Experience with Scoro API (or similar CRM/business management APIs).✅ Strong knowledge of PostgreSQL & Heroku deployment.✅ Proficiency in Excel’s data connection tools (Power Query, ODBC, or API connections).✅ Ability to write Python or Node.js scripts to automate data extraction.✅ Good communication skills to provide documentation or guidance on usage.
Project Budget:We are open to proposals, but we estimate the budget to be £500–£1000 depending on experience and project timeline.
Project Timeline:Ideally, we’d like this completed within 2–3 weeks.
How to Apply:Please submit a proposal outlining:
Your experience with similar API integrations.A brief overview of how you’d approach this project.Any relevant projects or portfolio examples.Looking forward to working with the right expert on this project!