Dear Systems/Google Sheets Integration

Hi, I am Anna with more than 6 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, WordPress template & plugin, WooCommerce. I will write PHP script to sync from Dear System to Google Sheets for sale, purchase, stock, product, product family, supplier, customer. I am ready to discuss and start now. If I am chosen for this project, I commit preparing the development site and updating project status daily or whenever you message me. Thank you for your consideration. I am looking forward to your reply. Sincerely, Anna

Hello Denial, I can pull information from Dear systems into a Google Sheet through the API as per your given brief on project post. Let me know when you available to discuss more in detailed. Regards Rina

I know how to pull data from various APIs (like JSON, REST) into Google Sheets. I have excellent command on Google Sheets. I have completed similar projects before. For instance - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo using JSON API in google sheets - Extract mails and attachments from gmail to google sheet and drive respectively using API - Twitter functionality like retweet, auto-tweet, and so on (Twitter API) - Extract data from bookeo and humanity using respective APIs You can see the reviews of the same in my profile

Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile/ All your requirements are achievable using Google Apps Script. Thank you for your time ! John

Hello Daniel V. Hope you are doing good!! I have seen your requirement & understand your project "Dear Systems/Google Sheets Integration" . I am expressing my interest toward this project specially because I have a huge experience in the required skills such as Google App Engine, Javascript, Software Architecture. Previously I have developed something similar too which is successfully working for our client. I can do this within your budget too $250 - $750 AUD Just to gain your confidence I can share few of my previous similar work across to you. Thanks I need to be able to pull information from Dear systems into a Google Sheet through the API. I need to be able to get access to the following data: - Sale - Purchase - Stock - Product - Product family

Hi, I have a very good experience with Google apps script and 3rd party api. I read your job proposal carefully and understand the requirements. U WANT TO PULL THE DATA from DEAR INVENTORY in Google Spreadsheet through an Api. Can you share a demo spreadsheet with header column and some dummy row. Looking at the demo spreadsheet, it is easy to move the project in the right direction. I will start your project immediately. Can we connect for more discussion about the project. Thanks and Regard, Haroon

Hello, Interested in the job. I am a Software Engineer specializing in end-to-end Web Development with expertise crafting applications that integrate 3rd party APIs with Google's GSuite platform (which spans Google Docs, Drive, Forms, Calendar, Gmail and, of course, Google Sheets). The Dear Systems platform supports a robust REST-based API that I can utilize using Google Apps Script - GSuite's native scripting language (based on JavaScript). Accessing the desired data-sets listed in your proposal are straight-forward tasks as there are explicit end points available to retrieve data for each item. But this project is not without challenges. The difficult part of working with the Dear Systems API is the unreliable up times of its network. As stated in the documentation, developers will need to account for irregularities in network availability and maintain a queue (of requests) to allow applications to re-try requests to the API. This complicates integration with the platform. But there are techniques that I can effectively leverage to handle this scenario. Thank you for taking the time to review my application. I look forward to discussing your project in greater detail if afforded the opportunity. Regards, Damion Murray DimuDesigns

Hello sir greetings please provide me detailed information about this. I am an IT solutions provider and I will provide my best services as per the need.

Hi Daniel, I've got experience retrieving data via Google's own API to budgeting and quoting sheets; it's what I do at work, and I'll be covering it in my blog (see profile). I've also developed my own API for a startup and have experience querying and testing API endpoints. I think the easiest route for you is to set up a Google Sheet with an embedded script. This means you'd have a drop-down menu at the top of the sheet (alongside Tools, File, etc.) with items to poll the Dear API for what you need. From there, the script can set up new sheets with the relevant data tabulated, and make it easy for you to filter without requiring any extra technical knowledge from you. I took a look at the API docs and they're fairly standard. To get this started I'll need a clear articulation of how you're using Dear and how this project's going to benefit you, and some technical info like API keys. We can set up a meeting through video call, or go by email. Based on the API's responsiveness, the time it takes for me to familiarise myself with it (should be quick - 1 week), any specific details you might raise in communications, it would take about three weeks to do well. "Do well" meaning set up in a way that won't give you grief later down the track, and is extensible if you need extra work done. Regards Tom