Annulleret

Write some Software

REQUIREMENTS OVERVIEW

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.

SETUP/IMPLEMENTATION

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.

OUTPUT

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

Færdigheder: 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 freelancers are bidding on average $1348 for this job

fleetways

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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)
4.1
vandyimp

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 Mere

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

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 Mere

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

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] Mere

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

A proposal has not yet been provided

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

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 Mere

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

Aucune proposition n'a encore été fournie.

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

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 Mere

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

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 Mere

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

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)
0.0
bzant

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 Mere

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