Office Tools FileMaker Pro Courses

FileMaker Pro API Integration | Training Course

Claris Authorised
Training Provider

FileMaker Pro Introduction

We attended the FileMaker course with Nick. He was very through and patient with our questions or when we couldn't make something work properly. Really looking forward to redesigning our database.
Mondrian Investment Partners Limited
March 2025
FileMaker Pro Advanced

The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.
Hannah Griffiths
March 2025
I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo.
Paresh Dudhaiya
March 2025
FileMaker Pro Advanced

We had a fantastic session with Tony focused on designing for print. Tony tailored the day to our needs and left us feeling confident with a lot of new knowledge.
Rebecca F
March 2025
I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database. My invoicing layouts now work perfectly. Thank you very much!
Julian Support
March 2025
FileMaker Pro Advanced

I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you showed this week. The time I spent learning FileMaker properly was so worth the money and time!
Trinitas Consulting
February 2025
Creating and deploying iOS apps using FileMaker Pro and FileMaker Go

Outstanding bespoke training delivered by Nick at Transmedia. Nick's level of knowledge on FileMaker Pro teamed with his incredible teaching skills have set my colleague and I up for success.
Techedology
February 2025
FileMaker Pro Introduction

The set up was very professional and my trainer was very knowledgeable. Highly recommended.
Bladeroom
February 2025
Thank you for organising my FileMaker training day. I learned so much with my trainer, Nick, and have come away with such a great database. Thank you Transmedia for being so helpful!
Lucie M
February 2025
An enjoyable and productive day. A flexible content and pace of work which suited our needs.
Guardian News & Media
February 2025
FileMaker Pro Introduction

I was very impressed. Nick was very reassuring and patient. Really delighted with the content we managed to get through and am now feeling more confident with my new learned skills and abilities.
Beaulieu Motor Museum
February 2025
FileMaker Pro Introduction

My Transmedia consultant was incredibly patient and thorough and after just a few days of his tutelage, it's clear we have been shown enough to give us all many hours of our lives back with a more efficient system!
The White Wall Company
February 2025
Great delivery, enjoyable training session.

February 2025
An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

February 2025

Course Facts

2 day course
Our Trainers are Authorised Professionals
Live Online or Classroom-based
Certificate of completion
Maximum class size of 6 for scheduled courses
Unlimited support after your course
Courses at all levels: Introduction, Intermediate, Advanced and Masterclasses

Course Outline

Enhancing Insert From URL with cURL options
Components of an API Call
API Security Methods
Understanding JSON
Using the FileMaker JSON functions
Worked example of connecting to a fully-functioned API (MailChimp)

FULL OUTLINE

Related Courses

FileMaker Pro Introduction

We attended the FileMaker course with Nick. He was very through and patient with our questions or when we couldn't make something work properly. Really looking forward to redesigning our database.
Mondrian Investment Partners Limited
March 2025
FileMaker Pro Advanced

The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.
Hannah Griffiths
March 2025
I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo.
Paresh Dudhaiya
March 2025
FileMaker Pro Advanced

We had a fantastic session with Tony focused on designing for print. Tony tailored the day to our needs and left us feeling confident with a lot of new knowledge.
Rebecca F
March 2025
I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database. My invoicing layouts now work perfectly. Thank you very much!
Julian Support
March 2025
FileMaker Pro Advanced

I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you showed this week. The time I spent learning FileMaker properly was so worth the money and time!
Trinitas Consulting
February 2025
Creating and deploying iOS apps using FileMaker Pro and FileMaker Go

Outstanding bespoke training delivered by Nick at Transmedia. Nick's level of knowledge on FileMaker Pro teamed with his incredible teaching skills have set my colleague and I up for success.
Techedology
February 2025
FileMaker Pro Introduction

The set up was very professional and my trainer was very knowledgeable. Highly recommended.
Bladeroom
February 2025
Thank you for organising my FileMaker training day. I learned so much with my trainer, Nick, and have come away with such a great database. Thank you Transmedia for being so helpful!
Lucie M
February 2025
An enjoyable and productive day. A flexible content and pace of work which suited our needs.
Guardian News & Media
February 2025
FileMaker Pro Introduction

I was very impressed. Nick was very reassuring and patient. Really delighted with the content we managed to get through and am now feeling more confident with my new learned skills and abilities.
Beaulieu Motor Museum
February 2025
FileMaker Pro Introduction

My Transmedia consultant was incredibly patient and thorough and after just a few days of his tutelage, it's clear we have been shown enough to give us all many hours of our lives back with a more efficient system!
The White Wall Company
February 2025
Great delivery, enjoyable training session.

February 2025
An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

February 2025

We offer FileMaker Pro API Integration as a private course, which means the course content can be fully customised to your exact learning requirements and run on your preferred dates.

FileMaker Pro Private One-to-One Training

One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.

Enquire Now

FileMaker Pro Team Training for Companies

Group bookings provide you with the most cost-effective way to train your team.

Enquire Now

FileMaker Pro API Integration — Team and Bespoke Training

Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.

Sessions can be run online or in person, on your site or at our London training centre.
We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
We offer a free consultation service to work out every detail of your course.

Prices for bespoke sessions with our expert trainers start at £595 + VAT, depending on the course and number of people.
Costs include all preparation time to customise the course to your exact requirements.

FAQs about the FileMaker Pro API Integration course

Is this FileMaker Pro API Integration course suitable for me?

This course is designed for developers with strong existing skills in FileMaker Pro who would like to learn how to retrieve data from websites and bring it into FileMaker Pro using APIs and the REST protocol. If you are have any questions about whether the course could meet your needs, please speak to our customer service team, who will be delighted to advise you.

How is the content taught throughout the FileMaker Pro API Integration course?

Our FileMaker Pro API Integration course is extremely interactive. You will be using FileMaker Pro throughout the day, working through API examples under the guidance of our trainer, who will be supporting you through each step.

Should I attend the FileMaker Pro API Integration course in person or live online?

For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.

Will I receive a certificate upon completion of my FileMaker Pro API Integration course?

Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our FileMaker Pro API Integration course. Our certificates note our Authorised Training Centre status.

How many people are likely to be in the class when I attend the FileMaker Pro API Integration course?

For private classes in FileMaker Pro API Integration , we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.

What support is available after I attend the FileMaker Pro API Integration course?

We offer ongoing support to our FileMaker Pro API Integration course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.

What you will learn

Exploring the power of APIs in FileMaker Pro, enabling you to connect your database solutions with other applications and services.
How to use InsertFromURL, cURL options and JSON to exchange data with web services, empowering you to integrate FileMaker Pro with external systems.
Understanding authentication, authorisation and security protocols, helping you protect sensitive data and ensure secure communication.
How to automate tasks and workflows using APIs, enabling you to streamline processes and enhance the functionality of your solutions.
Exploring common integration scenarios, such as CRM, currency exchange rates and MailChimp, helping you use APIs to extend the capabilities of your FileMaker Pro applications.
How to troubleshoot and debug API integrations, empowering you to resolve issues and ensure seamless connectivity.
Understanding best practices for API design, documentation and maintenance, helping you build reliable and scalable integrations that meet business needs effectively.

Overview of FileMaker Pro API Integration

There are countless web services available on the internet. As a Claris FIleMaker developer, have you been ignoring them? If so, that's a mistake. There are so many services that have an API that you can connect with, once you know how. If a service is RESTful, you can work with it in FileMaker. Most are. And this is the course that shows you how to do it. Over two days, our FileMaker and API Integration course will introduce you to the basics of HTTP, JSON data structure and cURL options. You will see how web services structure their RESTful APIs to deliver data when queried remotely. Practical examples will take you from structuring simple queries to building more complex ones, with different endpoints and cURL options. Along the way, you'll learn the basics of JavaScript Object Notation (JSON) and how to use the FileMaker JSON functions to translate the data returned to FileMaker in JSON format into field names and values. You'll also write scripts to create records from this data. You'll also learn how to create a JSON Object from fields in a FileMaker table, and how to pass this to RESTful APIs. In the final part of the course we use the techniques we have learned with simpler examples to interact fully with the MailChimp API, to draw down data and add and remove subscribers from a MailChimp subscriber list. Don't wait, start integrating!

Course Outline for FileMaker Pro API Integration

Getting started

Introduction to web services
The Insert From URL FileMaker script step
File protocols supported by Insert From URL
Methods supported: GET (to retrieve data from a specified resource) and POST (to submit data to be processed to a specified resource)
Parameters explained: Target, Specify URL, Verify SSL Certificates, Specify cURL options
Testing Insert From URL with a simple example
Further examples

Enhancing Insert From URL with cURL options

What is cURL?
Some common cURL options
The cURL options supported in FileMaker
File protocols supported by Insert From URL

Components of an API Call

The URL
The endpoint
The header
The body

API Security Methods

Open API
HTTP basic
API Keys
OAuth

Understanding JSON

Overview of the JSON data types
JSON Strings
JSON Numbers
JSON Objects
JSON Arrays
JSON Booleans

Using the FileMaker JSON functions

Using JSONFormatElements to create a JSON Object from FileMaker field values
Using JSONListKeys to identify the equivalent of field names in a JSON Array
Using JSONGetElement to identify the equivalent of a field value in a specific member of an Array (record equivalent)
Using JSONListValues to identify all the field values in an arrange (record set equivalent)
Using JSONSetElement to add a key/value pair to a JSON object
Using JSONDeleteElement to remove a key/value pair from a JSON object
Combining functions as needed to send data to an API or to create records in a FileMaker table from data retrieved from an API