Find answers, ask questions, and connect with our community of business solutions developers, and partners.
Create – Update an Event in Google Calendar from FileMaker using API
This a featured post from our affiliate FMDBSolutions. In this post, we will talk about how to create and update an event in the Google Calendar using FileMaker API. It will work above FileMaker version 16.
First, we need to integrate the FileMaker and Google calendar for creating an event in the Google Calendar. After that we can able to create and update the event in Google Calendar from the FileMaker using Google Calendar API. This can be achieved by the following steps.
Integration of FileMaker and Google Calendar:
⦁ Go to the Google Developer Console (https://console.developers.google.com/) and create a project.
⦁ Navigate to the Google APIs and go to Calendar API then click “Enable API”.
⦁ Set a Name for the Client ID and set the Authorized redirect URI to “https://fmdbsolutions.com”, it is important that the redirect URI matches exactly. Then click “Create client ID”.
⦁ Give your product a name and any other options. This is what end user will see when authorizing your solution to manipulate their calendar. Click “Continue”.
⦁ Click “Done” then click on the Client Name you just created.
⦁ Enter the provided Client ID and client Secret Id in the FileMaker Database.
After the Integration process is complete, In order to create an event in the Google Calendar we need to mention the Date, Time, Color, Title, Location, Guests for the event in the FileMaker database as given below.
After the Event information entered, we need to run the script to create event. In the script step, we need to mention those Date, Time, Color, Title, Location, Guests fields in the “Let” function under the JSONSetElement () function in a variable of the script to create an event.
After that using “Insert from URL” script step will pass the Event information values to the Google calendar to create an event.
After creating the event, we can view the event in the Google Calendar.
If we need to update the event then we can modify the Date, Time, Color, Title, Location, Guests and update the event using the Event id.
If we implement the above mentioned steps, then we can create and update an Event in Google Calendar from FileMaker using API.
The team at FMDBSolutions hopes this article taught you how to import XML File data to FileMaker without XSLT file. FMDBSolutions is a team of well-qualified experts that have a lot of experience with the many versions of FileMaker Pro and the FileMaker Go app too.
Our team knows all about transitioning, migrating, converting, and upgrading for FileMaker. Companies that require FileMaker Integration can also use our services. We have worked with clients from the USA, Australia, and Singapore and will complete your FileMaker assignment in the best possible way at a lower price but the same or higher level of excellence.
If you want solutions to your FileMaker database, we can help. Click the below box for a free FileMaker consultation