This makes the item key a JSON object in one case and a JSON array in another, and we must parse it differently. In one such example below, the first order has four order items, but the second order only has one the API provider chose not to use an array for a single element. This is an inconsistent way of dealing with sub-items, but not all APIs are consistent that way. There are some APIs, for instance, that will use an array if there are multiple ‘children’ but not an array if there is only one child element. With the new function, you can do these checks more easily by verifying the JSON data type, which will work even if the input is an empty JSON object or empty JSON array: Verifying the JSON data type JSON data type can be verified even if the input is an empty JSON object or JSON arrayĪnd, of course, you can check any element within a JSON object or array to verify its data type before you set out to work with it: Check any element within a JSON object Check any element within a JSON array The downside of this approach is that it can be slow when the data is substantial you’d still have to do some text parsing of the result to detect an error or not (by looking for the leading “?”. Up to 19.4, you would typically use the JsonFormatElement() function on the data and check the result for an indication that the data was not something that can be touched with the JSON functions: Using jsonFormatElement() in FileMaker 19.4 Sometimes you just need to figure out whether a particular piece of data is a JSON object or array, something you can parse with the JSON functions. The next sections will describe what is new for each of the FileMaker platform components: Pro, Go, Server, WebDirect, and the Data Migration Tool.įileMaker Pro 19.5.1 New function: JSONGetElementType() In a recent blog post, we reviewed all the changes that were made to the platform in the last 12 months, which saw us progress from 19.2.2 all the way through 19.4.2. All releases that bump up the “minor” number are, in fact, major releases. ) typically carries meaning as to how important the release is, don’t let Claris’ numbering scheme fool you. While the version numbering scheme in software (. Review the release notes (links required at launch time) for FileMaker Pro, Go, and Server to see if those will affect your solution.

We will concentrate mostly on the new or changed features, but there are also a lot of bug fixes included with this release. This first release of the Claris FileMaker platform in 2022 is packed with changes, so let’s dive in and review the most important ones.

Filemaker go 19 requirements