Develop Controlled Access Database with REST API (Zoho)

Suljettu Julkaistu 3 kuukautta sitten Maksettu toimituksen yhteydessä
Suljettu Maksettu toimituksen yhteydessä

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.

Tietokantaohjelmointi Tietojärjestelmäarkkitehtuuri Zoho RESTful JSON

Projektin tunnus: #36722840

Tietoa projektista

52 ehdotusta Etäprojekti Aktiivinen 2 kuukautta sitten

52 freelanceria on tarjonnut keskimäärin $2687 tähän työhön


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 Lisää

$3000 USD 75 päivässä
(86 arvostelua)

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 Lisää

$3000 USD 6 päivässä
(80 arvostelua)

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 Lisää

$2250 USD 35 päivässä
(83 arvostelua)

Based on your project requirements, I propose to use my expertise to develop a controlled access database on Zoho using REST API. My extensive experience in Zoho development and REST API coupled with my strong understa Lisää

$2700 USD 10 päivässä
(20 arvostelua)

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 Lisää

$2550 USD 30 päivässä
(5 arvostelua)

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 Lisää

$2250 USD 7 päivässä
(9 arvostelua)

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 Lisää

$2250 USD 7 päivässä
(8 arvostelua)

Nice to meet you dlevitan,The requirements of your project match my areas of work and skills, to introduce myself. My name is Anthony Muñoz and i am the lead engineer for DS Pro IT agency. I have worked for over 10 ye Lisää

$4242 USD 7 päivässä
(2 arvostelua)

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 Lisää

$2250 USD 7 päivässä
(4 arvostelua)

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 Lisää

$2250 USD 2 päivässä
(1 arvostelu)

Developing a Controlled Access Database with REST API using Zoho is a complex project that requires a combination of technical skills and experience in API development and database design. Based on the project requirem Lisää

$2250 USD 7 päivässä
(1 arvostelu)

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 Lisää

$1500 USD 2 päivässä
(1 arvostelu)

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?

$1500 USD 7 päivässä
(1 arvostelu)

Hello. This is Caleb from US who has been working as a senior software engineer for over 10 years. I have gone through your project description and can do fulfill your requirements successfully. I am able to start work Lisää

$3000 USD 15 päivässä
(1 arvostelu)

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 Lisää

$2250 USD 7 päivässä
(0 arvostelua)

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 Lisää

$2300 USD 7 päivässä
(0 arvostelua)

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 Lisää

$2500 USD 3 päivässä
(0 arvostelua)

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 Lisää

$1500 USD 7 päivässä
(0 arvostelua)

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 Lisää

$1500 USD 5 päivässä
(0 arvostelua)

I have extensive experience in Zoho development, REST API integration, and database design. I'll create a secure, efficient controlled access database for you. Key qualifications: Zoho expertise, REST API knowledge, Lisää

$2250 USD 7 päivässä
(0 arvostelua)