Course Overview and Benefits
Sending and receiving data through an API (Application Programming Interface) has exploded in popularity. Though APIs were once just an alternative method to access or transfer data between two sources, it is becoming the standard way to integrate thousands of platforms and apps to increase efficiency and productivity.
While all APIs are very similar, they are also very different. Understanding the general concepts will be extremely helpful for any API process. Seeing a step by step process that points out the common pitfalls with specific examples will open a whole new world of possibility in solutions for you and your clients.
This course focuses on the general API process and specifically teaches you to connect to a hosted FileMaker database through the FileMaker Data API.
Whether you are new to APIs or have some experience with APIs, this course will show the process from start to finish and save you time from reading through vague, confusing, or incomplete documentation.
The course has been updated with a dedicated section explaining what JSON is, how it’s formatted, why it’s important, how it’s used today, and what makes it different than other formats such as comma-separated text.
You will also learn the “rules of the road” for JSON formatting: how it’s constructed, what each of the symbols represents, how they work together, and how to handle different types of data in different situations.
If you are completely new to APIs and want to understand the concepts, have a look at our blog post "Exploring the Basics of API Integration with FileMaker".
The course offers 4 hours of video lessons and includes multiple sample files to help your work on your API development locally, test with data on the server, and parse JSON requests.
Course Curriculum
-
-
JSON Fundamentals Intro
-
What is JSON and Why Do We Need It?
FREE PREVIEW -
JSON Format and Rules
-
Creating JSON Using Claris Pro (FileMaker Pro)
-
Parsing JSON Using Claris Pro (FileMaker)
-
Create JSON Advanced Example (Part 1)
-
Create JSON Advanced Example (Part 2)
-
Working with Decimals In the Key (Use Bracket Notation)
-
JSON Get Element Type (Function)
FREE PREVIEW
-
-
-
Introduction to Data API
-
Download Sample Files
-
Server Checklist
-
Database Checklist
-
General API Process
-
Database Metadata API Calls
-
Authentication
-
Database Metadata API Calls (Continued)
-
Record Data API Calls Part 1
-
Record Data API Calls Part 2
-
Record Data API Calls Part 3
-
Scripts with Data API
-
Summary
-
-
-
Analyze JSON & Create Database (Part 1)
-
Parse Customers (Part 2)
-
Parse Invoices (Part 3)
-
Parse Line Items (Part 4)
-
-
-
Thank You!
-
Other Offerings from Productive Computing
-

About this course
- $149.00 / year
- 33 lessons
- 5 hours of video content
Reviews
Really worked of me
Jonathan Waller
I had zero knowledge of API's, let alone any other types of programming knowledge outside of FileMaker, but now I do. The course explained the basics that yo...
Read MoreI had zero knowledge of API's, let alone any other types of programming knowledge outside of FileMaker, but now I do. The course explained the basics that you need and it also opened my mind what else I need to build on. For the money, it's a no brainer. Thank you Jonathan
Read LessJust what I needed
Darrel Hampton
This course covered so many details that I was not able to find anywhere else. This has opened up a ton of possibilities for improvements and functionalitie...
Read MoreThis course covered so many details that I was not able to find anywhere else. This has opened up a ton of possibilities for improvements and functionalities in my databases.
Read LessExcellent step by step introduction to the topic
Benedick Miller
The course is an excellent step by step, a guided learning-by-doing, introduction to this important topic. This course will quickly get anyone up and running...
Read MoreThe course is an excellent step by step, a guided learning-by-doing, introduction to this important topic. This course will quickly get anyone up and running with how to connect to the FileMaker Data API in easy steps. The course shows you the basics of how to connect at the same time as giving you the tools and teaching you the skills to move on tho more complex queries working on your own.
Read LessAPI Fundamentals
Robert Jackson
This course provides a very useful platform to help developers to manage integrations with web technologies.
This course provides a very useful platform to help developers to manage integrations with web technologies.
Read LessInformative Course
Sayed Bondok
All that I need to perform API data to FileMaker - without this course, one would be lost ... Thanks P.C guys!
All that I need to perform API data to FileMaker - without this course, one would be lost ... Thanks P.C guys!
Read LessGeneral Topics
Philippe Moreau
perfect, clear, 100% good
perfect, clear, 100% good
Read LessGreat Job!!!
Alejandro Félix H.
A very interesting course, with a lot of valuable material
A very interesting course, with a lot of valuable material
Read LessHave a look at our additional API courses.
-
Connect FileMaker to DocuSign API
CourseThis course is designed for the developer who wants to learn how to connect FileMaker to the DocuSign API. Use the included unlocked FileMaker demo file to make the connections and save hours of time with development.
-
Connect FileMaker to Mailchimp
Course4.7 average rating (3 reviews)Learn how to seamlessly connect FileMaker to the Mailchimp API. In this update, we completely rebuilt all course lessons from scratch to coincide with the updated Mailchimp Marketing API and added new lessons. Includes a sample file.
$149 / year
-
Connect FileMaker to Stripe API
Course5.0 average rating (2 reviews)This course is designed for the FileMaker developer who wants to learn how to seamlessly connect FileMaker to the Stripe API. From start to finish, we will walk through the sample file to reveal the common mistakes and undocumented requirements.
$99 / year
-
$299.00 / year
Entire University Bundle
Gain access to all PCU courses with a subscription to the bundle.
Prerequisites
- You have a working copy of FileMaker Pro Advanced 18 or higher
- You have a working server with FileMaker Server 18 or higher installed
- You are using a compatible Windows or Mac computer and server
- You have a good understanding of FileMaker development and scripting
Your Instructor

Instructional Design Specialist Stuart Hite
