FileMaker Pro API Integration


  • 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
    August 2024
  • 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
    August 2024
  • FileMaker Pro Advanced

    The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.

    Hannah Griffiths
    August 2024
  • 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
    August 2024
  • An enjoyable and productive day. A flexible content and pace of work which suited our needs.

    Guardian News & Media
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • FileMaker Pro Introduction

    The set up was very professional and my trainer was very knowledgeable. Highly recommended.

    Bladeroom
    August 2024
  • An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

    August 2024
  • Great delivery, enjoyable training session.

    August 2024

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
FULL OUTLINE
  • 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
    August 2024
  • 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
    August 2024
  • FileMaker Pro Advanced

    The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.

    Hannah Griffiths
    August 2024
  • 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
    August 2024
  • An enjoyable and productive day. A flexible content and pace of work which suited our needs.

    Guardian News & Media
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • 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
    August 2024
  • FileMaker Pro Introduction

    The set up was very professional and my trainer was very knowledgeable. Highly recommended.

    Bladeroom
    August 2024
  • An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

    August 2024
  • Great delivery, enjoyable training session.

    August 2024

Private One-to-One Training

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

Enquire Now

Team Training for Companies

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

Enquire Now

Team Training and Bespoke Sessions

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 £525 + VAT.

Overview

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!
Read More...

Course Outline

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

Worked example of connecting to a fully-functioned API (MailChimp)

  • Reviewing the MailChimp API documentation
  • Identifying the MailChimp settings needed to make a successful call to the API
  • Formatting the JSON data to send
  • Interpreting the JSON data returned
  • Understanding the syntax of the procedure
  • Adding a contact as subscriber to a MailChimp audienc
  • Removing a contact as subscriber from a MailChimp audience
  • Unsubscribing an existing subscriber
  • Re-subscribing an existing contact
  • Retrieving a list of all current subscribers

Our Clients

Our Recent Success Stories

eLearning Training

eLearning

Julie's Story

Learning Technologist at Imperial College

InDesign Training

InDesign

Sumble's Story

Graphic Designer at Houses of Parliament

InDesign Training

InDesign

Cassie's Story

Designer at Dixon Interiors

30 years working with Claris
Five Star Training Five Star Training Five Star Training Five Star Training Five Star Training   600+ Reviews

Why Transmedia?

Unlimited Training Support

We offer unlimited training support after your course.

Bespoke Training Solutions

Customised training and software solutions based on your exact specification.

Worldwide Creative Skills Training

Join our authorised training courses live online from anywhere in the world.

Authorised Training Professionals

Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.

Courses Live Online

Join our virtual classrooms to learn from the comfort of your own space in real time from our accredited training experts.

SEE COURSES

Classroom Training

Join us at one of our Authorised Training Centres for a traditional classroom-based experience.

We have everything ready for you to have the best training experience.

SEE COURSES

Private Courses

One-to-one tuition or a private group training with just you or your colleagues.

We can train you live online, at one of our centres or onsite, wherever you are located.

SEE COURSES

Useful Links

Latest Help Station Articles