…and with a quoted “333” we get the “Item #” version. With an unquoted 333 we get the “Quantity” version… …returns 333 regardless of whether the value is quoted or not in the source JSON – but this conundrum is easily resolved with help from JSONGetElementType. Prior to FileMaker 19.5 this seemingly-innocuous little challenge would require some sort of work around because the standard way of deriving the value… …but if that value is text, i.e., wrapped in quotes, then your object will need to look like this. The value will be derived from array address, but there’s a catch… if that value is a number (i.e., not wrapped in quotes) then the object will look like this… You’ve been tasked with creating a tiny JSON object consisting of a single key/value pair. And note that the following example uses both the new JSONGetElementType function and the similarly named JSONGetElement function (which debuted in FMP 16). Okay, let’s move on to a more interesting challenge using the same data. For readability, the preceding spells out JSONObject and JSONArray, but the result is the same if we instead use the numeric equivalents. In the above example, the field contents are not valid JSON due to the accidental placement of a semicolon after the “ddd” element. This simple test will determine whether or not the contents of that field are indeed valid JSON. …and that field contains something that looks like it might be valid JSON. Specifically, if you point JSONGetElementType at a JSON structure, or at an element within a JSON structure, it will return the corresponding type in numeric format.įor example let’s assume we have a field called “source” in a table called “sandbox”… Over the years developers have come up with clever tricks to address both of these needs, but good news, we can now ditch the clever trickery because JSONGetElementType removes the guesswork.
Have you ever wished that FileMaker could target an element within a JSON structure and return the type (JSONNumber, JSONString, JSONObject, etc.)? For that matter, have you ever wished for a simple way to determine whether a block of text is valid JSON or not? FileMaker Pro 19.5 FeaturesįileMaker Pro client has several new features, including: JSONGetElementType ( json keyOrIndexOrPath ) Let’s take a look at what Claris FileMaker has to 19.5 offer. It builds on their open platform promise – introduced in FileMaker 19 – and strengthens the platform’s performance, security, and reliability. We now have the highly anticipated release of FileMaker 19.5! This article intends to share the highlights of new features, deep dive into a couple of examples and share some important news regarding bug fixes across the various platforms (FileMaker Pro, Server, and WebDirect).įileMaker 19.5 is Claris’ strongest release to date.
0 kommentar(er)
