foundset.getAsJson

Returns a JSON object representing the found set

Be the first to rate this function Log in to vote

Fabrice Nordmann - Show more from this author
1-more-thing
https://www.1-more-thing.com

Sample input:

foundset.getAsJson

Sample output:

{"idList":"6-8","layoutId":1,"layoutName":"SPLASH","recordId":6,"recordNumber":1,"sortOrder":null,"sortState":0,"windowMode":0}

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
   foundset.getAsJson () by Fabrice Nordmann, 1-more-thing
   Returns a JSON object representing the found set Requires FileMaker 2025 (22)
   v1 - July 2025
*/ 

JSONSetElement ( "{}"
 	; [ "layoutName" ; Get ( LayoutName ) ; JSONString ]
 	//; [ "layoutId" ; fm.name.ID ( Get ( LayoutName ) ; "L" ; Get ( FileName )) ; JSONNumber ] // enable if you want the layout ID.
 	; [ "recordNumber" ; Get ( RecordNumber ) ; JSONNumber ]
 	; [ "recordId" ; Get ( RecordID ) ; JSONNumber ]
 	; [ "idList" ; GetRecordIDsFromFoundSet ( 3 ) ; JSONString ]
 	; [ "windowMode" ; Get ( WindowMode ) ; JSONNumber ]
 	; [ "sortState" ; Get ( SortState ) ; JSONNumber ]
 	; [ "sortOrder" ; "" ; JSONNull ] // one day Claris will give us a function to get the sort order as a json object
)

Returns a JSON object representing the found set Requires FileMaker 2025 (22)

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

foundset.getAsJson

Comments

Support this website.

Support this website.