Develop Controlled Access Database with REST API (Zoho)
$1500-3000 USD
Оплачивается при доставке
I am looking for a developer to create a controlled access database using Zoho with REST API. The database will be used to store customer information with advanced user access control using custom permissions.
Database Structure:
- General idea for the format of the database
Ideal Skills and Experience:
- Experience with Zoho development and REST API
- Strong understanding of database design and implementation
- Experience with advanced user access control and custom permissions
Project Overview
The scope is to build a database that provides our clients with controlled and filtered access via REST API to information related to their use of our products and services, specifically including subscription and invoice information. Clients need to be able to extract their tiered data via the API for use with their business systems.
Source information is located in Zoho Subscriptions or Invoice and will need to be securely extracted to this external database using Zoho's REST API. These REST API’s follow standard REST, HTTP messaging and utilize the JSON format as well as each resource as an exposed URL. Familiarity and experience with the Zoho API’s is preferable. More information on the Zoho API is attached.
The external database must be populated on a regularly scheduled basis, at least every 12 hours as a cron job. A ‘health check’ script showing if the cron job has run on time, whether hourly, every 6/12 or 24 hours shall run with a confirmation that the job has run and all messages received. The job will be required to send a confirmation message or alert in the event of failure.
The developer(s) will use API Postman or an equivalent tool that has automated documentation and integrated testing. Documentation must be updated throughout the project and will be a key deliverable. The developer will deliver both forward and reverse proxies. Coordination for proxies will be assisted by the company with the API developer.
You will enable common protocols to include OIDC for authentication and OAuth2 for authorization or equivalents. Design the API to provide basic rules to block malicious character sets commonly used in injection attacks, and with capability that includes restricting incoming API requests based on API schema definitions or manual configuration. Restrictions can be placed on parameter lengths, parameter values, array sizes, etc. Development should take into account the OWASP Top 10 API advisory [login to view URL] and develop the API in accordance with the published 2019 recommendations as well as the forthcoming 2023 draft.
Data Overview
Our customer structure has 4 tiers, specified as Parent/Child/End Customer/Location. Not all tiers are used with any individual subscription or service invoice. Clients will need to pull filtered data from this external database via the created REST API based on any level of their eligible customer information and apply filters to date ranges as well. More detail attached.
The API will have the ability to add additional tiers to be used at a later date to expand the fields to Parent:Child:Grand-Child:Great Grand-Child:End Customer:Customer Location N+ (to allow for multiple locations).
Administration - The system needs to:
• have an administrative panel to assign user login credentials to our clients and set the filters for the data they are allowed to access.
• allow for multiple users with access to the same subset of data.
• have a high level of security to ensure that the API is not misused or attacked.
• The ability to edit OAuth, tokens, authentication needs to be accessible from the admin panel
• have logs that provide visibility to data ingest from Zoho to this external database, as well as client data use.
Schedule and Payment
The system must be specified by June 14th, prototyped by June 28th and have completed test by July 3rd, 2023. Payments will be based on agreed project milestones.
ID проекта: #36722840
О проекте
52 фрилансеров(-а) готовы выполнить эту работу в среднем за $2687
Hi Good evening , I have read the brief details on your job listing . I see you have been looking for someone experienced with Access DB, Rest API Development. Its been 8 years since I have been working on freelancer.c Больше
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 Больше
I understand that you are looking for a developer to create a controlled access database using Zoho with REST API. If you allow me to demonstrate my skillset, I believe that I am the perfect fit for this project. I a Больше
Dear Client, We are delighted to submit a proposal for your project, "Develop Controlled Access Database with REST API (Zoho)." With over 20 years of experience in the IT industry, N&T Negocios y Tecnologias s.r.l. ha Больше
Hi there, my name is Nikhil and I'm a Full Stack Developer with extensive experience in database programming, RESTful APIs, software architecture and Zoho. I have worked on projects such as mobile applications, web app Больше
Hello Client, I understand that you are looking for a developer to create a controlled access database using Zoho with REST API. I believe that our team is the perfect fit for this project as we have extensive experi Больше
Hi there I'm Maksym Riaboshapko, and I'd love to work on your project I'm a great fit because I have relevant experience. which I find similar to your project. I m very familiar with Zoho and Rest API development. I Больше
Hello greetings, After going through your project description, I feel confident and excited to work on this project for you I am confident that I have the required skills and experience to deliver high-quality work th Больше
Hello, We have stumbled upon your project brief "Develop Controlled Access Database with REST API (Zoho)" and would be thrilled to partner with you to accomplish your goal for this project. Chainbot Solutions, LLC is Больше
Robust knowledge of Zoho api integration and Database design and rest api generation. I have been working as backend engineer for 10 years and very proficient in database management. Could you please ping me?
I understand that you are looking for a developer to create a controlled access database using Zoho with REST API. I believe that I am the perfect fit for this project due to my extensive knowledge in web development a Больше
Hello dlevitan, We would like to grab this opportunity and will work till you get 100% satisfied with our work. I can work full time for you and your project. I can start work immediately. I am an expert develop Больше
Hi, I am very interested in your project. I have extensive experience in Full Stack development. So I can help you to develop Controlled Access Database with REST API . I can start your project immediately. I look Больше
Hi there! My name is Saravanan and I am an experienced Java Developer with 8 years of professional expertise in designing, developing, and maintaining high-performance Java applications. I understand that you are look Больше
Hi ❤️❤️❤️❤️❤️❤️❤️ 100% Satisfaction ❤️❤️❤️❤️❤️❤️❤️ 24/7 Full time support. I have just read your proposal and understand the requirements. As a senior full stack web developer, I am pretty sure I can complete your proj Больше
