CSV-to-API Cloud-Based Solution Required

Hi Good evening , I have read the brief details on your job listing . I see you have been looking for someone experienced with Cloud Based Solution Development. Its been 8 years since I have been working on freelancer.com, I have 9 years of experience doing similar jobs. I would request you to check my profile and review projects, feedbacks of projects related to those skills. Questions: 1. These are all the requirements of your job or do you have more? If yes, Please provide detailed requirements in chat and let me review and get back with queries. 2. Do you currently have anything done or this job has to be done from scratch? 3. What is the timeline to get this job done? 4. Are you open to use 3rd party APIS for it even if they are paid? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Please initiate the chat so we could discuss it in detail and we will continue from there. Thanks! Awais

Greetings Matthew, Please see below answers: 1. What else do you need from us to get this project started? LEADconcept: We will just need to see the data source for better understanding of the task. 2. Where will the data be stored? LEADconcept: As the data needs to be fetched through API, then it should be stored within some database. We will recommend to use MySQL. 3. How can we update it (frequently)? LEADconcept: We can develop a backend Admin Control from where you can see the updated data as well as be able to add data. 4. Although we only need one API key, how do we manage keys? LEADconcept: Regarding the API key, we can setup one API key and Secret and use Auth/Barrier toke. ======= We have creative UI/UX Designers & experienced Developers team working on different tech stacks, so we will provide you quality services with 5 months FREE support and longterm relationship guarantee. For quick response & one-on-one communication, you may click on the chat button, as I am online most of the time. Look forward to hearing from you thru' chat. Regards, Yasir LEADconcept PS: Let me know, if you want to see our team past work to determine our skills/expertise or past customer's references.

I'm Raman, an experienced web and app developer with a strong understanding of APIs. My extensive skillset in PHP and WordPress development, among others, equips me to tackle your CSV-to-API cloud-based project head-on. Having maintained 712+ satisfied clients and an impeccable track record, I assure you that I can get this done accurately and efficiently. To answer your questions meaningfully: 1. Prior to beginning the project, I would need access to your mapping tool's CSV data and necessary details for the API. 2. For storing your business data, I propose a cloud-based database storage solution for easy scalability and accessibility. 3. To update the data frequently, we can set up an automated process using various tools such as cron jobs for seamless monthly updates of your CSV file. 4. Even though you only need one API key, proper key management is pivotal for security purposes; we can establish an efficient key-handling mechanism. With my dedication to on-time delivery, strict adherence to budget constraints, and a customer-centric approach, I am confident that I am the ideal match for your project needs. Looking forward to discussing this further with you!

I am interested in working on the CSV-to-API cloud-based solution project. With my extensive experience in web development, I am confident in creating a rest API to handle your small dataset of business names and ratings from a CSV file. I have worked with similar data mapping tools and can integrate them seamlessly with the API. To start the project, I would need the CSV file and any specific requirements regarding the API endpoints and data presentation. The data can be stored in a secure database, preferably MySQL or PostgreSQL. For frequent updates, we can set up a scheduled task or use a webhook to automatically update the CSV file and trigger the API to refresh the data. As for API key management, we can implement a secure authentication system where you can manage the keys and restrict access as needed. This will ensure that only authorized users can access the API endpoints. I invite you to review my profile for feedback and portfolio to see examples of my previous work. Let's start chatting to discuss the project in more detail and address any additional questions or concerns you may have.

➥ To get started, I would need access to the CSV file, details on the desired API endpoints, and any specific requirements for the API responses. Additionally, information on the server or hosting environment where the API will be deployed is necessary. ➥ The data can be stored in a database of your choice, such as MySQL, PostgreSQL, or a NoSQL database like MongoDB, depending on your specific needs and preferences. ➥ For frequent updates, a script or automation process can be set up to replace the existing CSV file with the updated one. ➥ To manage API keys, a secure authentication mechanism can be implemented, such as using API tokens or keys with proper access controls. Thank you. Irfan.

Hi there, ★★★ API / PHP / Python / Node.js Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to setup a rest api with the data (and have the ability to update the CSV every month).. As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

1. Please share the mock data to understand it better    2. Where will the data be stored?      I propose storing the data in a cloud database (MySQL) - AWS instead of a CSV file    3. How can we update it (frequently)?      Data can be updated/viewed using REST API    4. Although we only need one API key, how do we manage keys?      I will be using another API to create time bound JWT tokens      You can use these API's in your mapping tool to update/fetch data.      Will use MySQL, Python and Flask to create REST API and can be hosted in a AWS EC2 Instance I would prefer working on a fixed cost basis if the inputs and details you share enable me to assess scope of work precisely. I will submit my fixed cost accordingly. Detailed specifications and inputs will also help me make an informed commitment and deliver as required. I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project.

Dear Matthew F.,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in Database Administration, Database Programming, SQLite, RESTful, API and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details or let's appoint time for Zoom meeting to meet and discuss your project in details.    Best regards, Sales department Tangram Canada Inc.   

Hello, I can do this project using Python. I have been doing web scrapping for over 10 years now. I am amongst the top 1% freelancer on this site. I would love to know more about the project. You may review the projects I have done in the past. https://www.freelancer.com/projects/32814860 (Automated Scrapping using Linux and Python) https://www.freelancer.com/projects/33234428 (Scrapes Ebay Order Details) https://www.freelancer.com/projects/32854816 (Website Scrapping) https://www.freelancer.com/projects/32360285 (Listings Scrapping) https://www.freelancer.com/projects/34159975 (Google result scraping and upload to DB) 1. I’ll need the API, mockup data and CSV 2. We can save the date on your computer or maybe the cloud server 3. We can run even daily if you want 4. It will be stored in the python script Best, Aisha

Hi there, I am a Certified PHP, Python and SQL developer and I have worked on multiple projects in the past related with data-science and data or structures manipulation. Are you looking for a calling point to request data from the CSV? This is what I have got from the description. 1. I need mockup data/sample data from you. 2. I can query the csv to get the data and I can also store the data in database. I would recommend to store the data in database. 3. This third point, how can we update can't be answer here. I have some questions related to this that I would like to discuss with you in chat. 4. The auth key system will be implement with all of its features. If you will generate one, you can use one key. I have shared the project brief and I hope you will consider my proposal and experience for this project. I will be glad to answer your queries about the project. I am waiting for you to have a word in chat. Thanks.

Hi Sir, Please review my inline comment sand happy to discuss further to start the project. 1. What else do you need from us to get this project started? Need a quick discussion to close the flow of API working and volume of users consuming API. 2. Where will the data be stored? Mysql can be utilised to store data and expose as API response. 3. How can we update it (frequently)? We can build a cron to read csv data on any set frequency and update database. 4. Although we only need one API key, how do we manage keys? Can give a admin facility to share API/Create key for specific to users which needs to e passed as header to get results. Thanks

Hello, I understand your requirement and I allow myself to offer my service as a software developer. I propose to develop a system that reads and parse the csv file and an app that stores the information in a SQL server database through a REST-API or connecting directly. API keys can be stored in a configuration file or in the database. The system can update the information based on a task scheduler or you can do it manually whenever you want. Please contact me by chat Thanks Andres

Hi I can help you build an REST API for CSV data you have. I have experience on API development and OpenAPI principles for clean code base. To store the data, we can select one of the free solutions to store data of the CSV (Firebase, Supabase, MongoDB or in an SQL database that you can host) if records are not in millions. I can also offer few different & new approaches according to specifications such as how many people will use it, will it be used in-house or will it be open to public use etc. To update (sync) data, I can also provide an automation script that will update the CSV everyday (or any interval you see suitable). I can work with Python(Flask or FastAPI), Java Spring or JS (Express) according to our need. I hope we can work together.

I can surely help you with this project. Let me give answers to the four questions: 1. To get started, I would need the mock data you mentioned, the specific details of the API endpoints you want to create, and any specific requirements or preferences you have for the API setup. 2. The data can be stored in a database such as MySQL, PostgreSQL, or MongoDB, depending on your specific needs and preferences. 3. To update the data frequently, we can set up a scheduled task or job to automatically update the database with the new CSV file every month. 4. For managing API keys, we can use a secure method such as token-based authentication. Each user or application that needs access to the API can be provided with a unique API key, and we can implement a system for key management and access control. If you like my answers, please feel free to reach out to me. My goal as a software engineer is to effectively solve client's problems. I am available to discuss your project immediately.

Hi, I have experience developing BI solutions like apigui for business. I'm data scientist and bam professional with +4 years experience. I would solve this with kivi or tkinter, depending 1. What else do you need from us to get this project started? App place (desktop/web/ios/android), budget , relation between data, outputs required, and time 2. Where will the data be stored? Cloud (your sql server...your cloud..Gdrive...) or phisical (your pc server) 3. How can we update it (frequently)? All the times you use it 4. Although we only need one API key, how do we manage keys? Creating a list of users/keys/data related in another csv

As a Senior Full stack Developer with over 10 years of unquestionable experience, I guarantee to provide the most effective solution to your project requirements. I hold a bachelor's degree in computer science which endows me with a robust understanding of data management, making your data safe and accessible will be my priority. Storing the data can be tailored to your preferences whether you want it on the cloud or locally, I've got you covered. Being very well-versed in handling CSV files, updating the dataset frequently won’t be an issue at all. Rest assured, I guarantee to make it not only seamless but also efficient so that your data is readily available and up to date for your mapping tool usage. Regarding API key management, my ten years plus experience taught me better ways to manage keys. Securing your API should always be prioritized and that will be my approach as well. I am open to suggestions that you might have and promise to incorporate those into the system as well. Running an efficient business needs accurate data evaluation tools and I can assist in providing that through this API from CSV solution. Give me the chance of bringing it to fruition and you will never regret counting on me.

I have read the job description and understood your project details. I believe that am the best guy for this project and this is because am well experienced in this field. My priority is to deliver quality and timely work. Be assured that I will always follow the laid down instructions. You can trust me to deliver a perfect product. Regards

Hello, I have extensive experience in setting up REST APIs and managing data from CSV files. For your project, I'll create a robust API that retrieves data from your CSV file, ensuring seamless updates monthly. To proceed, I'll require access to your current CSV file structure and a sample of your mapping tool's CSV for integration. The data will be stored securely on a server or cloud service of your choice, ensuring privacy and accessibility. For updating the data monthly, we can automate the process using a scheduled task or a script triggered by your data update cycle. Regarding API key management, we can implement a simple yet effective system where you provide us with a unique API key, and we'll handle its security and access control. Could we discuss your specific requirements and preferences further to tailor the solution to your needs? Best regards

Hello 1) ========= Sample data: As you mentioned, you can provide mock data. This will be useful for setting up the initial structure of your API. Tools and technologies: Do you have any preferences for the programming language or framework for building the API? Knowing this will help in choosing the right tools for the job. Endpoint requirements: What are the specific functionalities you want the API to provide? For example, endpoints for fetching all businesses, fetching a single business by ID, updating data, etc. 2) ========= Considering the simplicity of the project and the size of the dataset, a lightweight database like SQLite might be sufficient. The choice will depend on factors like the expected growth of your dataset and the complexity of queries you might need. 3) ========= Since you mentioned updating the data every month, you could automate this process using a script. This script could read the new CSV file and update the database accordingly. This can be scheduled as a monthly job on a server or a cloud service. 4) ========== For a small project with a single API key, you could store the key securely in your server environment variables or a configuration file. Make sure not to expose it in your code repository. If you later need to scale and manage multiple keys or have more security considerations, you might want to explore API management tools or frameworks that provide key management and access control features. Best Regards Hung Do

1. We just need data set. 2. It can be stored on server or firebase can also be used. 3. We can use cron job to update automatically. 4. Can discuss after seeing the data. Thanks