API Fundamentals for FileMaker Developers
Subscribe $149.00 / year Free Preview
Course Overview and Benefits
Sending andreceiving data through an API (Application Programming Interface) has explodedin popularity. Though APIs were once just an alternative method to access ortransfer data between two sources, it is becoming the standard way to integratethousands of platforms and apps to increase efficiency and productivity.
While all APIs arevery similar, they are also very different. Understanding the general conceptswill be extremely helpful for any API process. Seeing a step by step processthat points out the common pitfalls with specific examples will open a whole newworld of possibility in solutions for you and your clients.
This course focuseson the general API process and specifically teaches you to connect to a hostedFileMaker database through the FileMaker Data API.
Whether you are newto APIs or have some experience with APIs, this course will show the processfrom start to finish and save you time from reading through vague, confusing,or incomplete documentation.
The course has beenupdated 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 otherformats such as comma-separated text.
You will also learnthe “rules of the road” for JSON formatting: how it’s constructed, what each ofthe symbols represents, how they work together, and how to handle differenttypes of data in different situations.
If you arecompletely new to APIs and want to understand the concepts, have a look at ourblog 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
-
- Welcome FREE PREVIEW
- About Stuart Hite / Productive Computing FREE PREVIEW
- How To Use This Course FREE PREVIEW
- Course Overview FREE PREVIEW
-
Course Version History
-
-
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)
- JSON Get Element Type (Function) FREE PREVIEW
(Video) API Fundamentals for FileMaker Developers Course Overview -
-
-
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
-
-
-
Thank You!
-
Other Offerings from Productive Computing
-

About this course
- $149.00 / year
- 28 lessons
- 4 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 More
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 you need and it also opened my mind what else I need to build on. For the money, it's a no brainer. Thank youJonathan
Read Less
Just 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 More
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 functionalities in my databases.
Read Less
Excellent 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 More
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 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 Less
API 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 Less
Informative 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 Less
General Topics
Philippe Moreau
perfect, clear, 100% good
perfect, clear, 100% good
Read Less
Great 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 Less
Have a look at our additional API courses.
- Connect FileMaker to DocuSign API Course This 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. $149 / year
- Connect FileMaker to Mailchimp Course 4.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 Course 5.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 first payment, $199.00 / year onwards
Entire University Bundle
Gain access to all PCU courses with a subscription to the bundle.
(Video) Getting Started with the FileMaker Data API
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
Stuart has been developing software for over 30 years, starting long before earning a Bachelor’s Degree in Computer Science in 1992. For over 14 years, he was the primary in-house FileMaker developer and the top nationwide instructor for a large education organization. He has been featured in hundreds of live and online courses on many different topics. He now gets to combine his passion for teaching and love of software development into one. “I love breaking down complex projects into simple tangible concepts in a fun way. Knowing that the student is going to be able to accomplish so much more in less time after my course brings a lot of fulfillment.” - Stuart Hite, Instructional Design Specialist, Productive Computing, Inc.
President/CEO/Founder Productive Computing, Inc. Marc Larochelle
Starting in 1991, Marc worked for the National Association of Music Merchants (NAMM) for 5 years and built the trade show database in FileMaker which tracked 1000 exhibitors and 12 football fields worth of exhibit space. NAMM is one of the world’s largest trade shows and FileMaker was keeping track of everything. While at NAMM, Marc taught computer classes at night helping users with their Macintosh, MS Word, Excel, etc. In addition, he taught music/multimedia classes at local community colleges. Marc Larochelle and his brother Keith started Productive Computing, Inc. (PCI) in 1996. The company now in its twenty-second year, serves customers who use FileMaker and QuickBooks in the areas of custom development, solutions, plug-ins, hosting and licensing.Marc is certified in FileMaker versions 7 through 18 and he also holds a certification in AWS (Amazon Web Services). Marc has been to 19 FileMaker DevCons (18 as an exhibitor) and is considered a prime influencer within the FileMaker community.
API Fundamentals for FileMaker Developers
Learn how APIs work, why they are used, and common use cases.
FAQs
Does FileMaker have an API? ›
The FileMaker Data API is an application programming interface (API) that allows web services to access databases hosted by FileMaker Server or FileMaker Cloud. Because this API conforms to Representational State Transfer (REST) architecture, the FileMaker Data API is a REST API.
What does API? ›What does API stand for? API stands for Application Programming Interface. In the context of APIs, the word Application refers to any software with a distinct function. Interface can be thought of as a contract of service between two applications.
Which language is used in FileMaker? ›The FileMaker Dynamic Markup Language or FDML was a markup language used in the earlier versions of FileMaker introduced in 1998. FDML is also often referred to as Claris Dynamic Markup Language or CDML, named after its former company Claris.
Does FileMaker use SQL? ›As a database developer, you can use Claris® FileMaker Pro® to create database solutions without any knowledge of SQL. But if you have some knowledge of SQL, you can use a FileMaker Pro database file as an ODBC or JDBC data source, sharing your data with other applications using ODBC and JDBC.
What are the 4 types of API? ›There are four principal types of API commonly used in web-based applications: public, partner, private and composite. In this context, the API "type" indicates the intended scope of use.
What are API examples? ›- Twitter Bots.
- Log-In Using XYZ.
- Weather Snippers.
- Pay with PayPal.
- Google Maps.
- Travel Booking.
- E-Commerce.
API is an acronym that stands for “application programming interface,” and it allows apps to send information between each other. While there are numerous protocols and technologies involved, the underlying purpose of APIs is always the same: to let one piece of software communicate with another.
Is there a future for FileMaker? ›- FileMaker will grow, taking market share away from OTHER FRAMEWORKS (all-in-one, and other DBs - YOUR COMPETITION), with aggressive pricing and innovative features.
Can FileMaker generate QR codes? ›If you're a FileMaker developer and already familiar with APIs, you can easily connect to the free QR Code Generator API to create QR codes.
Is FileMaker Pro Low code? ›FileMaker, the innovative low-code platform. your data deserve
FileMaker allows you to design collaborative and cross-platform applications (Windows, macOS, iPhone/iPad, Web), but also to integrate with your other data systems (e-mail, calendar, cloud…), to automate and orchestrate them.
Do people still use FileMaker? ›
We have data on 23,318 companies that use FileMaker Pro. The companies using FileMaker Pro are most often found in United States and in the Information Technology and Services industry. FileMaker Pro is most often used by companies with 10-50 employees and 1M-10M dollars in revenue.
Does FileMaker use Java? ›Java is a programming language that FileMaker Server uses for the following components: Web Publishing Engine. Server Administration Console (FileMaker Server 16 and earlier) Admin Server (FileMaker Server 16 and earlier)
Is FileMaker a CRM? ›FileMaker is an easy-to-use and flexible platform for creating a CRM solution that's customizable and cost effective for small businesses.
What skills are needed for API? ›- Cross-platform development. ...
- API design. ...
- Front-end development. ...
- Different coding languages. ...
- Integration knowledge. ...
- API orchestration skills. ...
- Programming tools.
- Skyscanner Flight Search – Learn More.
- Open Weather Map – Learn More.
- API-FOOTBALL – Learn More.
- The Cocktail DB – Learn More.
- REST Countries v1 – Learn More.
- Yahoo Finance – Learn More.
- Love Calculator – Learn More.
- URL Shortener Service – Learn More.
Fiber is one of the fastest frameworks for building APIs.
What are the three most common types of APIs? ›There are also three common types of API architectures: REST, a collection of guidelines for lightweight, scalable web APIs. SOAP, a stricter protocol for more secure APIs. RPC, a protocol for invoking processes that can be written with XML (XML-RPC) or JSON (JSON-RPC).
What are the main types of API? ›- Open APIs. Open APIs, also known as external or public APIs, are available to developers and other users with minimal restrictions. ...
- Internal APIs. In contrast to open APIs, internal APIs are designed to be hidden from external users. ...
- Partner APIs. ...
- Composite APIs. ...
- REST. ...
- JSON-RPC and XML-RPC. ...
- SOAP.
The Google Maps API and Twitter API may be among the most widely used API examples, but most software-as-a-service (SaaS) providers offer APIs that let developers write code that posts data to and retrieves data from the provider's site as well.
What is the disadvantage of API? ›The API may have a limit on the number of active sessions an organization or user can have at any given time (example, NetSuite). This adds an implied constraint on how you interact with the API during the session. For example, an error may occur while performing a lookup to the same API you are using for source data.
What exactly is an API and how do they work? ›
API stands for “Application Programming Interface.” An API is a software intermediary that allows two applications to talk to each other. In other words, an API is the messenger that delivers your request to the provider that you're requesting it from and then delivers the response back to you.
Does anyone still use FileMaker Pro? ›We have data on 23,318 companies that use FileMaker Pro. The companies using FileMaker Pro are most often found in United States and in the Information Technology and Services industry. FileMaker Pro is most often used by companies with 10-50 employees and 1M-10M dollars in revenue.
How does FileMaker store data? ›Data that's stored externally is by default encrypted, using secure storage, and can only be read by the FileMaker Pro application. FileMaker Pro manages the encrypted files automatically. However, you can use the open storage option, which removes encryption and keeps the files in their native formats.
Can FileMaker send text messages? ›Set up FileMaker app with scripts to send a text message and to process the response. Set up a Twilio account and project. Create a Claris Connect webhook which our FileMaker app will call to send the text message. Create a flow, triggered by the webhook, to ask Twilio to send the message.
What is Fulcrum API? ›The Fulcrum JSON API uses REST endpoints for querying, creating, updating, and deleting data. The API provides users the ability to: query the URL for information using a GET request, update the object by sending a PUT, or delete the object by sending a DELETE request.
What can I use instead of FileMaker? ›- Quickbase.
- Power Apps.
- Application Express (APEX)
- Zoho Creator.
- Google App Maker (Legacy)
- TrackVia.
FileMaker Barcode Add-On
The Barcode Add-On provides you up to 18 different barcodes to choose from, including Code128 and Code39, and generates a barcode image from field data. Easily add the Barcode Generator Add-On in layout mode by dragging and dropping directly onto a layout.
FileMaker can now send HTML emails natively! By using a little scripting and some simple cURL options, you can send beautifully designed HTML emails, eliminating the need of 3rd-party products and helping you grab your customers attention. Contact us if you would like help sending native HTML emails out of FileMaker.
Is FileMaker still used? ›And yet, Claris FileMaker remains. The relational database program, now on version 19, continues to have a dedicated following of business and power users. Besides Mac, FileMaker is also available on Windows and iOS.
Is API a hardware or software? ›API is the acronym for Application Programming Interface, which is a software intermediary that allows two applications to talk to each other. Each time you use an app like Facebook, send an instant message, or check the weather on your phone, you're using an API.
What does full API access mean? ›
API access ensures that only authorized users can obtain specific bundles of resources from your API. Simply put, API access is the process of allowing mobile apps, developers' frameworks, building management tools, and software applications to access and use pertinent data from a given API.
What is ETL and API? ›Integration Platform as a Service (IPaaS) and Extract, Transform, and Load (ETLs) are both data integration systems. You can use them to consolidate data from various sources into a single dataset, acting as your one source of truth.