INT02 - Use JSON to Get Arrays - Daisy Graves

Document created by communitymanager on Jul 20, 2018Last modified by dgraves on Aug 17, 2018
Version 7Show Document
  • View in full screen mode

Daisy Graves (Harmonic)

Session Description

JSON is the new lingua franca of inter system communication, including FileMaker's Data API, but in this session, there are no APIs allowed. There are many other useful reasons to learn and understand JSON and integrate it into your system, even without an outside API. Use FileMaker's native JSON functions to build a data-driven culture. JSON empowers you to create a database within a database. Organize data and move it quickly from where you have it to where you need it.

What you should know

Basic calculation, scripting, and function skills.

Products & Technologies

  • Pro/Advanced

Session Materials

  • Please see the attachment(s) below.

What You Will Learn

  • Use FileMaker JSON functions to get started quickly
  • Understand JSON structure & syntax - {Objects} vs [Arrays]
  • Datapoint consolidation and schema alternatives—multiple script parameters, variable consolidation
  • Applying JSON to the real world


FMP file will login as Guest and has been set to [Full Access]