Write some Software


We need scripts written in Ruby to pull case and user data from the [url removed, login to view] APIs. This data will then be converted from JSON into CSV files.


The script(s) will be run via cron on a Linux server. They will need to deal with [url removed, login to view] API rate limits as well as any performance issues resulting from the volume of data that they fetch.

The script(s) should be configurable for each [url removed, login to view] object we want to pull. We will want to fully refresh some each time the script is run. We will only want to pull new and updated records for others.


Upon completion, the script should parse the JSON returned by the Desk API into multiple CSV files whose structure matches each table described in the database schema we provide. These tables should be capable of being copied into a relational database with no additional transformations required.

Since pulling large amounts of data from the Desk API can be time-consuming and full refreshes of some tables are not ideal, the tools should be able to do the following:

(i) Create files containing new records to be loaded from tables that contain solely static entities (for example, history_events)

(ii) Pull new & updated information from objects that have the potential to change, compare it to master files of activity tied to those events that took place over the last N days (where N is a number we can configure), then use this to generate final files of (i) existing records that need to be updated & (ii) records that need to be created in the database

(iii) Name the files appropriately (i.e. [url removed, login to view] or [url removed, login to view]) so that we can build file name parsing logic when loading into a database.

(Suggestions for an alternate approach are welcome if a better way of doing this is readily apparent)

Desired fields and objects to be pulled can be discussed upon further interest.

Desired Skills

JSON, Ruby, API, Desk API

Evner: Programmering af database, Ruby, Software Arkitektur

Se mere: implementation of data structure, software ruby, master software, write name software, architecture linux server, write linux script, compare large file, write relational database, php json write, linux parse file name, cron database schema, php api json server, write json file server, json csv, json refresh, php parse json, parsing output script, create php api json output, php json output, write json file php, master linux server, php output json, csv json, software cron, ruby api

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #6038613

13 freelancere byder i gennemsnit $1348 på dette job


Thank you for looking at our bid. Kindly advise whether we can provide a PHP based scripts. Appreciate some details on [url removed, login to view] objects that need to pulled, that can help us to explore the API before posting more co Flere

$1578 USD in 30 dage
(60 bedømmelser)

Why did you limit yourself to Ruby!? I have +10 years of experience in Python programming and have worked with tens of such REST APIs before. I take a look at documentation. First thing I mentioned was that desk API Flere

$999 USD in 15 dage
(54 bedømmelser)

Hi there! Warm Greetings... I have reviewed your requirements and you can see with our past work samples that we have the capability to deliver you the best. We have very good expertise in this field and confi Flere

$1159 USD in 20 dage
(5 bedømmelser)

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s Flere

$1134 USD in 20 dage
(13 bedømmelser)

Hi, I would like to apply for this Ruby project. Please contact me if you have any questions. Best wishes, Sasha

$750 USD in 9 dage
(5 bedømmelser)

I got a fair comprehension about your project. Please come on chat for further discussion. Benefits you get: 1. 2 Months Free Technical Support 2. W3C Compliant Code, So Pages Load Faster & Rank Well in Search Flere

$789 USD in 15 dage
(2 bedømmelser)

Dear Client, I have gone through your job description and understood that what kind of resources your are looking at and I am sure that I can confidently work on your requirements. Please send me your skype id or conta Flere

$866 USD in 20 dage
(1 bedømmelse)

I'll be happy to complete this project for you. I have the relevant skills and can see clearly how the implementation would be structured. My plan is to - Use the freely available "desk" gem ([url removed, login to view] Flere

$797 USD in 14 dage
(1 bedømmelse)

A proposal has not yet been provided

$3333 USD in 60 dage
(0 bedømmelser)

Hello, I have a 3+ years of experience in Ruby on Rails platform & have worked on project in various domains. I have good expertise in Front End development with Bootstrap framework as well back end development Flere

$944 USD in 10 dage
(0 bedømmelser)

Aucune proposition n'a encore été fournie.

$1250 USD in 3 dage
(0 bedømmelser)

Hello, Greetings from geniuskline webtech solutions pvt ltd. Following are our past work, have a look. [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] htt Flere

$1237 USD in 20 dage
(0 bedømmelser)

Dear Client. I worked on several RoR works and I can parse Ruby on Rails response and convert it to JSON format. These are my following works [url removed, login to view] (cooking site) https://fantasycapit Flere

$2631 USD in 20 dage
(0 bedømmelser)

We are highly interested in this project. We are well verse with the technology demand of this project. We can have more discussion if you are interested.

$1250 USD in 20 dage
(0 bedømmelser)

Hi! I have previously integrated Paymill's API in Ruby on Rails project and have used AWS S3 and SES in 2 other projects (one in Rails and the other PHP). I have also successfully integrated with Mailchimp's API in Flere

$760 USD in 15 dage
(0 bedømmelser)