The aim for the project is to create Excel tool to manage vacation rentals availability calendar with excel. Our partner is Rentals United ([login to view URL]), their API documentation is attached to this posting.
Task #1 is to create a procedure to create a new reservation through API to Rentals United. We have a ready made excel tool (attached) and this feature should be inserted as a new feature. Information transferred will be at minimum name, arrival, departure, property ID, price.
How it shoud work?
I get a manual reservation from client and I want to update the availability to Rentals United. I will open the excel tool and create the reservation normally. I hit the button on Excel, and it is saving customer data to a row on customer sheet.
New XML procedure is getting needed information from the sheet and specified row, it will send the information to RU.
Task #2 is to import new reservation from RU.
I get a reservation from our sales channel, RU is informing me about new reservation. I need a procedure to import reservation data to customer sheet new row. Imported information is at minimum Name, Address, Telephone, Arrival and departure, PropertyID, amount of persons and addtitional information.
I am searching quite flexible approach to this project, the aim is to get quick and dirty solution.
I will provide further information and access for testing purposes.
16 freelancers are bidding on average €190 for this job
It an Interesting project to work. I will be very happy to work on this project. I had worked on many xml projects but this is something interesting for me.