Find Jobs
Hire Freelancers

Dear Systems/Google Sheets Integration

$250-750 AUD

Closed
Posted over 5 years ago

$250-750 AUD

Paid on delivery
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 - Supplier - Customer I need to be able to pull data based on the date, and would like to be able to pull data from multiple areas in Dear, for example, Sales Order Number, Salesperson, Date Raised and deposit paid. Below is a link to the API docs and the Dear Systems website. [login to view URL] [login to view URL] Cheers, Daniel
Project ID: 17835127

About the project

13 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
13 freelancers are bidding on average $714 AUD for this job
User Avatar
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
$750 AUD in 21 days
4.9 (117 reviews)
7.7
7.7
User Avatar
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
$1,666 AUD in 23 days
5.0 (41 reviews)
6.3
6.3
User Avatar
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
$400 AUD in 5 days
4.9 (38 reviews)
5.6
5.6
User Avatar
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
$377 AUD in 10 days
5.0 (55 reviews)
5.5
5.5
User Avatar
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
$450 AUD in 12 days
5.0 (10 reviews)
4.7
4.7
User Avatar
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
$444 AUD in 7 days
5.0 (4 reviews)
2.5
2.5
User Avatar
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
$833 AUD in 21 days
5.0 (1 review)
0.8
0.8
User Avatar
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.
$950 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$555 AUD in 21 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! My name is Nadya, I am web-developer. I write with Python.I have experience with different API. I can solve your problem.
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Umina Beach, Australia
0.0
0
Member since Apr 10, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.