Need some script written for a Google spreadsheet that will interrogate a third party API and parse the data into the sheet. Not a big project, but there will likely be more script to write after this.
The spreadsheet holds availability data for about 20 inns in a small town. Starting with one of the inns, we want to populate availability from its hosted reservation system. Here from the API documentation are the formats of the request and the response:
(API doc is attached). We want the script to check and repopulate the data say four times a day.
The script didn't survive intact - you can find it in section 4.6.4 of the attached API doc.
6 freelancers are bidding on average $163 for this job
I have read the webservice API pdf doc. Can you send a sample spreadsheet for me to have a look? I want to check how data for all inns are organized. I have done a couple of apps using google apps script.