function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Paul KehoePaul Kehoe 

Non Profit request for some developer guidance

Got a question from a Non Profit customer below and it beyond my dev capabilities. Looking for someone to review the below and help me give the customer guidance on what do do next.

From Customer 
We provide office space to our customers who can book meeting rooms online. We have developed a meeting booking system to handle room bookings for our customers. We are currently using the PHP Toolkit on force.com in order to send meeting booking data from our system to Salesforce. This is done by using one account to send out multiple bookings across Salesforce.

The issue we've been having in the past days is that there are inconsistencies between the data that we send to you and what gets entered in the system. For example, for one booking, the array that we send to SF is this one https://prnt.sc/fxyzdp .

[“user_id”]=>
string (15) “0033800002dpAn9”
[“organisation_id”]=>
string (18) “0015000000LUAJDAA5”
[“title”]=>
string (4) “Test”
[“start”]=>
string (25) “2017-07-18T08:30:00+01:00”
[“end”]=>
string (25) “2017-07-18T09:30:00+01:00”
[“peak_hours”]=>
float (0.5)
[“off_peak_hours”]=>
float (0.5)
[“weekend_hours”]=>
int (0)
[“room”]=>
string (15) “a0H50000000t838”
[“description”]=>
string (0) “”
[“room_type”]=>
string (12) “Meeting room”

What you are interested in are the "start" and the "end" values in the array, which translate to Start Date & Time and End Date & Time in Salesforce. This is the format that we have used for quite some time to send data, we did not change anything with it. If you go to Salesforce, you can see that the booking has an 1 hour delay for every date https://prnt.sc/fx650e , not just the start time and end time, but the hour when the booking was made and the last update.