JSON Training for FileMaker - Create JSON with Execute FileMaker Data API (JSON Fundamentals #11)

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

In this video, you will learn how to create JSON in FileMaker using the Execute FileMaker Data API script step, focusing on a simple database of countries with fields for name, population, continent, and capital.

You will see how to construct JSON by placing each record in its own array, along with related records, and introduce a built-in function that simplifies this process. By creating a new script called "Create JSON from Execute Data API," you will use the JSON setElement function to generate a basic JSON request. You will execute the script and view the results, which include all records and portal information from the specified layout.

You also will discover how to format the JSON for easier readability and discuss the additional information included in the response, such as return codes and record IDs.

Furthermore, we illustrate the dynamic nature of this function by duplicating the layout and script to selectively include or exclude data based on the fields present. This powerful tool allows for efficient data gathering in JSON format without the need for complex scripting, making it a valuable resource for working with FileMaker 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!