Power BI Connector for TicketCounter API
€250-750 EUR
Paid on delivery
Project Description:
I am looking for an experienced developer to create a custom Power BI connector for the TicketCounter API. The connector should enable incremental data loads into a Power BI table, fetching only new or updated data during each refresh. I have the ability to develop the connector myself but am going outside to save time.
The relevant API documentation can be found at TicketCounter API Documentation ([login to view URL]). For this project, the connector needs to work with:
1) Authentication: The connector must implement the authentication mechanism specified in the API documentation to access the endpoints. Refer to the bottom of the API docs for details.
2) /api/v1/statistics/soldtickets Endpoint: This endpoint of the StatisticsApi will be used to retrieve ticket sales data. The fromDate parameter will allow fetching only new data since the last refresh, while the offset parameter ensures all records are retrieved when there are multiple refreshes or large datasets.
Scope of Work:
1) Connector Development:
- Configure the connector to interact with the TicketCounter API, focusing on authentication and the soldTickets endpoint.
- Implement incremental data loads, using the fromDate parameter to fetch new or updated data and the offset parameter to handle scenarios with large datasets or multiple refreshes on the same day.
- Ensure compatibility with Power BI's data source settings.
- Allow for seamless integration into Power BI datasets (note: report/visual creation is out of scope).
2) Testing:
- Verify the connector handles incremental data loads correctly with realistic data inputs.
- Ensure the connector retrieves all relevant records, even when data volume exceeds the API's response limit or multiple refreshes occur.
- Validate data integrity to avoid duplication or loss during refreshes.
3) Bug Fixes:
- Provide support for any bugs discovered during testing and the initial deployment phase.
- Documentation: Provide clear documentation on how to set up, authenticate, configure, and use the connector within Power BI.
4) Live Repository Access:
- Maintain a live repository (e.g., GitHub, GitLab, Bitbucket) during development, granting access for monitoring progress and testing features incrementally.
Project Milestones:
1) Milestone 1: Authentication and Initial Integration
- Set up authentication with the TicketCounter API as per the documentation.
- Implement connectivity to the soldTickets endpoint to enable data retrieval.
- Payment: 30% of the total project cost.
2) Milestone 2: Incremental Data Loads and Testing
- Develop functionality for incremental data loads using the fromDate and offset parameters.
- Conduct comprehensive testing to validate functionality, ensuring data integrity and proper handling of large datasets or multiple refreshes.
- Resolve any bugs discovered during testing.
- Payment: 40% of the total project cost.
3) Milestone 3: Delivery, Documentation, and Support
- Deliver the finalized Power BI connector.
- Provide detailed documentation for setup, configuration, and usage.
- Offer post-completion support for bug fixes during an agreed-upon period.
- Payment: 30% of the total project cost.
Deliverables:
1) A functional Power BI connector that:
- Authenticates with the TicketCounter API.
- Implements incremental data loads using the fromDate and offset parameters.
- Is stable and optimized for performance.
2) Comprehensive documentation.
3) Live repository access during development for progress monitoring.
4) Support for bug fixes for an agreed-upon period post-completion.
Requirements:
1) Experience developing Power BI connectors.
2) Familiarity with REST APIs, authentication mechanisms, and incremental data loading.
3) Ability to work with the TicketCounter API or similar APIs.
Budget and Timeline:
I estimate the budget to be $500-$750, with completion expected within 1 week. Please provide a detailed breakdown of your bid, including testing and bug fixes.
Important Notes for Bidders:
1) No Placeholder Bids: All bids must reflect the final amount. Placeholder bids will not be considered.
Question Period: Bidders are encouraged to ask questions while the project is open to clarify any details.
2) No Bid Revisions: Bids cannot be revised after submission. If you realize you misunderstood the project requirements, you may revoke your bid, but no adjustments to the bid amount will be allowed.
3) Final Deliverable Expectations: The selected bidder is expected to deliver a functional and tested Power BI connector within the agreed timeline and budget.
4) All IP is owned by the client (me).
Project ID: #38949330
About the project
34 freelancers are bidding on average €529 for this job
Hi there! As I have read, I see you need help with Power BI connectors, and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 p More
Hi, I will create a Power BI Dashboard to analyze and visualize your data. My services include: Connectivity to data sources such as Excel, QuickBooks, SQL, Access. Data Modeling Cleaning and Sorting of Data Data More
Hello, I am thrilled about the opportunity to develop a custom Power BI connector for the TicketCounter API. My experience in developing Power BI connectors, working with REST APIs, and implementing incremental data l More
Hi Good afternoon , I have read the brief details on your job listing . I see you have been looking for someone experienced with Microsoft PowerBI, REST API, OAuth and Data Integration. Its been 8 years since I have be More
Hey A. Joseph W., I just finished reading the job description and I see you are looking for someone experienced in Data Integration, OAuth, Microsoft PowerBI and REST API. This is something I can do. Please review my More
Hello A., I am excited about the opportunity to develop a custom Power BI connector for the TicketCounter API. With over 5 years of experience in creating efficient data integration solutions, I can ensure that the co More
As an experienced data analyst and Power BI developer, I am perfectly positioned to take on your project. My skills in navigating and manipulating data, as well as my expertise in using formulas and functions to perfor More
If you are interested I'll do it for 200€ I have strong experience in Power BI connector development and API integration. I am skilled in implementing authentication mechanisms, managing incremental data loads, and ens More
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the More
Hi Good evening This is Umair You can see clearly from my profile that all my reviews/feedbacks are 5 stars and that's for a sole reason that I only take those projects which are doable for me. I am very much famil More
