Đã hoàn thành

Program for integration between Powercode and UCRM using API

We are looking for someone to write a program for us to integrate data from our Powercode (WISP billing system) database and UISP database (Ubiquiti ISP management). We have a Linux intermediary server we can run the program/script on. We also have root access to both Powercode and UISP servers.

Powercode represents the authority between the two servers, therefore will always contain the most up to date and correct data. In this API, data will only flow one way. From Powercode to UISP.

What we want to accomplish:

Monitor Powercode for any of these events/changes:

- Any new account created, regardless of user - simple monitor for the "next" new Customer ID and if there send it to UISP.

- Updates to accounts - any shared fields that have the same data in Powercode and UISP that get updated in Powercode triggers and overwrite with the data from Powercode to UISP.

- Status change to "Not Active" or "Uninstall" in Powercode - delete customer in UISP and equipment in UNMS.

- Status change from Not Active or Uninstall in Powercode to Active or Lead - create customer in UISP with active or lead status

- Status change from Lead or Pre-install in Powercode to active - convert lead to active/regular client in UISP

- We would also like to explore options for adding/changing equipment in UNMS when it is added in Powercode


Customers have different IDs in Powercode than they do in UISP. We can manually change this on existing account in UISP by doing a backup, manipulating the backup and then restoring. We can also set the "next client ID" in UISP. Once the API is in use, we can set that number and staff will be taught to never create clients in UISP, only in Powercode. New customers then will match by default.

The preferred fix, if possible and the API is able, would be to simply import the customer ID with rest of the customer data.

Here is the existing API documentation for UISP - formerly known as UNMS/UCRM:

[login to view URL]

Here is Powercode's:

[login to view URL]

We currently have a working webhook that does some of what we need but is pretty limited.

Winning bid will get a copy of the webhook script for reference and what we currently are importing to UISP.

Kĩ năng: Linux, PHP, Kiến trúc phần mềm, JSON, API

Xem nhiều hơn: send mail facebook using api, facebook find contact email using api, sell products amazon using api, google checkout using api sample projects, outlook office integration reservation meeting room api, upload youtube videos using api, develop using api, write program student information system using database, program using api, integration multi sensor using, write program adds large integers using linked lists, write program will sum integers using pointers, using api payment integration, paypal api integration contact form using wordpress, paypal integration using api, write program solves puzzle problem using heuristic functions, formsite integration using api, Write .Net code to Upload items into Open Cart and Download Web Orders using API authentication, system integration using api, write a python program to display name using interactive mode

Về Bên Thuê:
( 1 Nhận xét ) Bolivar, United States

ID dự án: #30648781

Được trao cho:

(14 Đánh Giá)

9 freelancer chào giá trung bình$1253 cho công việc này


Hi, I saw that you need help with Software Architecture, JSON, PHP, Linux and API. I have 9 years of experience working on these frameworks. I believe I can help you with it. I would request you to have a look at my po Thêm

$1500 USD trong 21 ngày
(88 Nhận xét)

Hi, I can help u as i have done several similar jobs related to Linux, JSON, Software Architecture, PHP and API, I have read the details and furthermore discuss about it, plz initiate the chat. Regards

$1500 USD trong 21 ngày
(17 Nhận xét)

I am an expert full stack programmer with skills including WordPress, Website Design, PHP, Graphic Design and HTML.
 I have done several complex projects and provide continuous maintenance support. My goal has always b Thêm

$1400 USD trong 7 ngày
(29 Nhận xét)

Hi, my special skill is 100% safety, clean code, and correct deadline. This task caught my eye at the first time when i saw your requirements and i have interested in it. I have finished similar several projects and ha Thêm

$1000 USD trong 7 ngày
(5 Nhận xét)

Hi how are you doing I have checked your project's description in detail I think I can complete your requirements perfectly because I have rich experience in Linux for 10+ years I will provide the good result in time Thêm

$1125 USD trong 7 ngày
(2 Nhận xét)

Hello. As a full stack web developer, your project is very interesting to me. I have been working on several web projects for 7+ years and have plenty of experience with API integration and database management. I think Thêm

$1000 USD trong 10 ngày
(4 Nhận xét)

I can provide python, php or node solution. If you have any preferred language, I can support. I have good exeriences in api integration. So I can help you. I never disappoint the client.

$750 USD trong 5 ngày
(1 Nhận xét)

Hi There, from brief I summarize that your Project Title is Program for integration between Powercode and UCRM using API Right? Sure i'll provide you with Quality Work. Please award me the project so that we can discus Thêm

$1500 USD trong 49 ngày
(1 Nhận xét)