This is a resource page for my September 3rd FM Training TV expanded “encore presentation” of a session I did last month at the [Full Access] conference.
Session Description
JSON in FileMaker seems pretty straight-forward… until it isn’t. We will explore a number of traps lurking for the unwary and how to avoid them, a couple tricks to dramatically speed up JSON creation, implicit vs. explicit arrays, the JSONMakeArray function, some helpful JSON custom functions, when it is (and isn’t) okay to use JSONRaw, and various other aspects of the endlessly-fascinating micro-universe that is JSON in FileMaker.
YouTube Link
- Coming soon
JSON Demo Files
JSON and Related Articles
- Thinking About JSON, part 1
- Thinking About JSON, part 2
- Thinking About JSON, part 3
- Thinking About JSON, part 4
- JSON.GetValueType
- JSON Custom Functions for FM 19.5, part 1
- JSON Custom Functions for FM 19.5, part 2
- JSON Custom Functions for FM, part 3
- Ordering Elements within JSON Objects
- OnWindowTransaction JSON
- Set Variable By Name Re-Revisited
- Fast Summaries (original article from 2011)
- Fast Summaries to JSON part 1 and part 2
- Jan 2025 – YouTube presentation: JSON Custom Functions
- JSON – Force Standard Notation
- When 2 is Greater than 10
- FastRange Custom Function
- JSON Object Destringification
- JSON Optimization in FM 21
- Render Found Set as JSON Object
- FM 26: Virtual List with Window UUIDs
JSONQuery
- https://github.com/steve-ssh/FMP_JSONQuery
- JSONQuery, part 1
- JSONQuery, part 2
- Jan 2022 – FMDiSC YouTube presentation (Steve & Kevin)
- Feb 2022 – FMDiSC YouTube presentation (Steve goes under the hood)
- JSONQuery v2 Conversation with Steve Senft-Herrera, part 1
- JSONQuery v2 Conversation with Steve Senft-Herrera, part 2
- Jul 2024 – DIGFM YouTube presentation (Kevin w/ Steve)
- Sep 2024 – FMDiSC YouTube presentation (Kevin w/ Steve)
- JSONQuery Odds and Ends
Other Resources
- JSONLint – JSON validator, prettifier, differ, etc.
- Database Guide – What is NDJSON?
- Claris Help Page – JSONGetElementType