Find Jobs
Hire Freelancers

XLSX to REST API Program

$250-750 AUD

已关闭
已发布超过 6 年前

$250-750 AUD

货到付款
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: [login to view URL] 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.
项目 ID: 14872224

关于此项目

34提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
34威客以平均价$528 AUD来参与此工作竞价
用户头像
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 and Experience I am expert in such scripting tasks with Python. I have done many projects working with different types of RES and, SOAP APIs. I took a look at Logiforms API and can easily follow rules with my script Proposed Milestones $499 AUD - complete work
$499 AUD 在10天之内
4.8 (175条评论)
8.0
8.0
用户头像
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.
$1,578 AUD 在15天之内
4.9 (27条评论)
7.1
7.1
用户头像
A proposal has not yet been provided
$742 AUD 在10天之内
4.8 (132条评论)
7.0
7.0
用户头像
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 Proposed Milestones $500 AUD - full project
$500 AUD 在10天之内
5.0 (61条评论)
6.1
6.1
用户头像
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 Proposed Milestones $450 AUD - C# application with source code
$450 AUD 在3天之内
5.0 (17条评论)
6.1
6.1
用户头像
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 using Nodejs/Python and Java. Proposed Milestones $499 AUD - Default Milestone
$499 AUD 在15天之内
4.9 (118条评论)
5.9
5.9
用户头像
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 Experience PHP MySQL REST Proposed Milestones $600 AUD - Project completion
$600 AUD 在3天之内
5.0 (17条评论)
5.8
5.8
用户头像
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 of 8 years experienced technocrats having an excellent expertise in NodeJS, Javascript
$722 AUD 在10天之内
5.0 (11条评论)
5.6
5.6
用户头像
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 在5天之内
4.9 (53条评论)
5.8
5.8
用户头像
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 and Experience I have 10 years of scraping experience and I have used POST/GET methods with C#.net. I also have done various projects that read data from Excel files. I also provide you money back guarantee. Proposed Milestones $750 AUD - Final Deliverable
$750 AUD 在5天之内
4.9 (14条评论)
5.3
5.3
用户头像
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 expert in Java, Nodejs.
$400 AUD 在3天之内
5.0 (4条评论)
3.9
3.9
用户头像
I did a similar project for my old company. I am sure that I can do it for you
$275 AUD 在2天之内
5.0 (8条评论)
3.6
3.6
用户头像
As per my understating We are trying to insert the records from xlsx to online API depending on the conditions and maintain a log record locally . This is a scheduled program and runs often.
$300 AUD 在1天之内
4.9 (4条评论)
3.3
3.3
用户头像
I can do this Relevant Skills and Experience javascript, jquery, angular Proposed Milestones $666 AUD - complete
$666 AUD 在10天之内
5.0 (2条评论)
1.0
1.0
用户头像
Hey, how’s it going? My name is Mike, I’m a Web Designer & Developer from Boston. I've had a look at your project description and feel that my skills match your requirements perfectly. Relevant Skills and Experience Graphic Design, Front End Development, PHP, WordPress Proposed Milestones $555 AUD - project milestone I recently did a very similar project which I can share with you.
$555 AUD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi There, If you hire us, we can complete the REST API work and write the XLSX to REST and other required task within very less time. And we've highly skilled resource in node.js Relevant Skills and Experience Javascript, Node.js. API. RESTful Proposed Milestones $250 AUD - Project MIlestone Please feel free to ask you doubts in chat. Thank you
$250 AUD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I have developed many applications which read data from Excel, perform some processing (include calling RESTful web service call) and saving data from excel and web service result. For excel processing I generally use Java with POI library. If you are interested in my proposal, I can give you a demo of the similar product I have developed.
$500 AUD 在20天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$250 AUD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
Proposed Milestones $555 AUD - first
$555 AUD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
We've done several project similar to your requirements .We've dedicated team of experts to deliver quality solution within your time frame.I can answer your queries on CHAT Relevant Skills and Experience 3-4 years Proposed Milestones $750 AUD - Project Milestone
$750 AUD 在10天之内
0.0 (0条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
Australia
0.0
0
会员自8月 7, 2017起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。