JSON Training for FileMaker - Analyze JSON & Create Database - Part 1 (JSON Fundamentals #18)

⚡️FREE JSON training course and downloadable files for FileMaker developers ⚡️

In this series of semi-advanced videos, we explore the process of parsing text using three interconnected tables: customers, invoices, and invoice line items, all built from scratch to facilitate learning. We acknowledge that this task requires advanced FileMaker skills, particularly as we navigate three intertwined loops, which may be challenging for beginners.

You will begin by analyzing a JSON structure that represents customer data, including details about invoices and line items, and emphasize the importance of understanding this structure for effective script building. As you create your FileMaker file, you will establish a preferences table to temporarily hold your JSON, followed by the creation of contacts, invoices, and invoice line items tables, ensuring that field names align with the JSON for easier referencing.

You also will be introduced to necessary ID fields to link the tables together, allowing for a relational database setup. Finally, you will prepare to insert your JSON into a global text field, setting the stage for the next part of the series where you will begin parsing customer data.

Knowing how to create, parse, and manipulate JSON is essential for integrating FileMaker with APIs, Claris Connect, Artificial Intelligence, and more. In the complete course, we cover everything you need to know about JSON from the perspective of a Claris FileMaker Developer.

Sign up at Productive Computing University for free and get access to more than 3 hours of content, 25 lessons, and multiple downloadable demo files.

== Get the course! ==




Connect with us if you're interested in more product information, tips and training:


Please subscribe if you like this content or want to stay informed on more Productive Computing and FileMaker training videos.


Thanks for watching!