Lukket

XLSX to REST API Program

Hi,

I am looking for someone to assemble a small GUI less appplication (language up to you, I have started one in Node but have grown tired of beating my head against the desk as I know little about Node) that does the following:

1: Checks to see if a XLSX file exists in a directory (file and directory will need to be defineable in a variable)

2: If exists, move to a working folder (file and directory will need to be defineable in a variable)

3: Parse XLSX file into a referenceable object or array. XLSX file will always only contain one sheet of information.

4: Call online REST API with GET method that returns JSON of records in online database. Note, this endpoint uses pagination, only returns 100 records at a time and can only be called synchronously (its singe threaded), so the program will need to loop through these calls and build one object at completion. The API returns a 'next_page' property and you use this as a query parameter on the URL. Example, '?page=2'

5: Split the parsed XLSX object, by record (step 3:) into two objects (or files might be easier) by comparing against the online records JSON returned in (step 4:) following the below logic.

*******************

INSERTS Object/File: If record.data.work_order IS NOT IN online database then this in an insert.

UPDATES Object/File: If record.data.work_order IS IN online database AND any of its fields contain different values than that of the corresponding record in the step4: object

*******************

Any records that dont match these above conditions should be discarded. That is, they are not new inserts and dont have any updated data as compared against the online record.

6: Call createRecord() REST API with POST Method for each record in INSERTS Object/File.

7: Call updateRecord() REST API with POST Method for each record in UPDATES Object/File.

8: Once each of the REST Calls have completed successfully (step 6: & step 7:) need to move each of the files/objects into a processed folder for archiving.

I would like the program to have extensive logging capabilities so we can track what it is up to and how many records its inserting and updating. That is, create a log file that is rolled each day (old ones kept).

I need to be able to schedule this program to run every hour BUT would also like the abililty to control independently how often the inserts are completed and how often the updates are completed.

The API requests need to be able to be configured to accept a proxy server.

The source of the program MUST be made available to me.

Documentation for the API is here: [url removed, login to view]

Note* can not use the import/ endpoint for this project as it creates too many unneccasary update transactions for things that havent even updated.

Copy of example XLSX file is attached.

Timing for this project is ASAP.

Færdigheder: Javascript, Microsoft, node.js, Software Arkitektur

Se mere: sprig mvc project with rest api calls and jsons, 160by2 api program, simple rest api php, rest api website, python rest api, python post rest api, creating rest api php, vbulletin rest api, heywatch rest api developers, list twitter followers rest api, heywatch rest api php examples, build rest api j2ee application, social network rest api, myspace java rest api, call rest api java

Om arbejdsgiveren:
( 0 bedømmelser ) Australia

Projekt-ID: #14872224

39 freelancere byder i gennemsnit $523 for dette job

helmot

I have +11 years of experience in Python programming. I can easily use Python openpyxl module to parse your xlsx file and requests module to call Logiforms REST API methods with your configured proxy. Relevant Skills Mere

$499 AUD in 10 dage
(154 bedømmelser)
7.9
esalem

I am interested in your project and like to have a deal with you.... Relevant Skills and Experience Excel, VBA, API consuming. Proposed Milestones $1578 AUD - Fianl product.

$1578 AUD in 15 dage
(14 bedømmelser)
6.8
shomuk

Hi We read the [url removed, login to view] have a strong team who can complete the project .Let us allow for that. Relevant Skills and Experience We are well sound on these technologies. SKILL : C+, API, ,AnguarJs, MySQL, JavaSc Mere

$555 AUD in 10 dage
(20 bedømmelser)
6.6
arifjaunpur

A proposal has not yet been provided

$742 AUD in 10 dage
(77 bedømmelser)
6.4
$555 AUD in 10 dage
(13 bedømmelser)
6.4
$555 AUD in 10 dage
(13 bedømmelser)
6.2
peterkurt

Hi, if you don 't care about languge, I can build this with PHP 7.1. Will need some test account on api. If you want we can store the update info in MySQL for better summery. Best regards Peter Relevant Skills and E Mere

$600 AUD in 3 dage
(16 bedømmelser)
5.7
elbruninh

Hi, i'm interested, could you give me more details please? could you send me a sample JSON response? do you have the RESP API documentation (createRecord and updateRecord)? Relevant Skills and Experience php Propos Mere

$500 AUD in 10 dage
(41 bedømmelser)
5.8
intelgeek

Will there be multiple XLXS files in the folder, or will there be only one file? I will be coding this in python, will this be ok with you? Relevant Skills and Experience Experienced in writing Lambda functions usin Mere

$499 AUD in 15 dage
(118 bedømmelser)
5.9
$555 AUD in 10 dage
(12 bedømmelser)
5.2
addy808

I have used rest APIs in the past and I have extensive scraping experience with sites that use Pagination and Ajax. The XLSX file can be processed and against each entry a GET/POST call can be made. Relevant Skills Mere

$750 AUD in 5 dage
(14 bedømmelser)
5.3
sheikDev

Hello,. My proposal is to develop a windows based application in .net. I would like to know where I have been done similar application for other client. I'm available to start the work immediately. Thanks, Sheik

$250 AUD in 5 dage
(33 bedømmelser)
5.3
laxaar

Hello, Greetings!! Thank for sharing your requirement. I have read the brief project description and I would like to be invited for further discussion on the job in detail. Relevant Skills and Experience We are a team Mere

$722 AUD in 10 dage
(9 bedømmelser)
5.3
$555 AUD in 10 dage
(5 bedømmelser)
5.5
mauricemarinus

This is rather easy. Ive done more than my fair share of API integration. Ive also worked with autmating excel. Basically Im your guy to do this. I wiill even drop my price to 150AUD Relevant Skills and Experience 17 Mere

$250 AUD in 10 dage
(40 bedømmelser)
4.8
$555 AUD in 10 dage
(20 bedømmelser)
4.7
rafwiel

Hello I am professional windows desktop developer, take a look at my portfolio please I propose c# application, i can start work right away Relevant Skills and Experience 10 years windows desktop programming Propose Mere

$450 AUD in 3 dage
(5 bedømmelser)
4.4
istvanc5

I had similar work in nodejs. profile: [url removed, login to view]~01b83853b885fb74c3 bulk imported from XLSX upserting. fetched missing data from REST APIs: [url removed, login to view] [url removed, login to view] Relevant Skills and Mere

$445 AUD in 10 dage
(2 bedømmelser)
3.5
Chinnusamy07

I am expert in REST api and i have done similar projects so i can quickly complete your requirement exactly what you need with good quality. Please share API key to start the work. Relevant Skills and Experience I am Mere

$400 AUD in 3 dage
(3 bedømmelser)
3.6
$555 AUD in 10 dage
(5 bedømmelser)
3.3