Custom Functions for Returning ExecuteSQL result as JSON

Document created by steve_ssh on Mar 31, 2018Last modified by steve_ssh on Apr 5, 2018
Version 4Show Document
  • View in full screen mode

There is already an existing Community discussion post for this topic:

 

      •  https://community.filemaker.com/thread/184595

 

  This document simply serves as a resting place for the two sample files originally associated with the above post.

 

 

Snippet from linked discussion:

 

  "In early 2017 I became interested in the question of whether I could write a FileMaker custom function which would allow me to return ExecuteSQL results in the form of JSON.  My typical use-case was grabbing data that I would then feed to code within a WebViewer..."

 

 

Reference links to two videos with some background information:

 

    •  https://www.youtube.com/watch?v=Z-GxR9jmIv4

    •  https://www.youtube.com/watch?v=FQg6aZgYhls

 

 

Sample files:

 

There should be two sample files attached to this Community document (the original, and a subsequent update).  Originally they were attached to the discussion post, but it later became evident that it would be easier to update the files if they were instead attached to this document.

 

 

Thanks again:

 

Many thanks to all of the people mentioned in the discussion post, as well as all those who participated in it.

2 people found this helpful

Outcomes