Handling data type in JSON

Idea created by jbante on May 12, 2017
    Active
    Score11

    FileMaker 16 introduced a collection of built-in functions for manipulating data serialized as JSON. This makes it easier for FileMaker applications to interact with many web services. This will also make JSON the de facto standard format for scripts within FileMaker to pass parameters and results to each other, improving code sharing within the FileMaker community.

     

    JSON does not have a broad palette of scalar data types to choose from: text, number, boolean, and null. FileMaker supports more data types than that, such as date, time, timestamp, and container. So I made a handful of custom functions and scripts for sending and receiving typed data with JSON.

     

    The module is hosted on GitHub, or you can download it directly.