GetAllJSON

All 129 Get Function results as JSONString

Be the first to rate this function Log in to vote

Joshua Paul - Show more from this author
Neo Code
http://www.neocode.com

Sample input:

Sample output:

{
"Get(AccountExtendedPrivileges)" : "",
"Get(AccountGroupName)" : "",
"Get(AccountName)" : "",
"Get(AccountPrivilegeSetName)" : "",
"Get(AccountType)" : "FileMaker File",
"Get(ActiveFieldContents)" : "",
"Get(ActiveFieldName)" : "",
"Get(ActiveFieldTableName)" : "",
"Get(ActiveLayoutObjectName)" : "",
"Get(ActiveModifierKeys)" : "0",
"Get(ActivePortalRowNumber)" : "",
"Get(ActiveRecordNumber)" : "",
"Get(ActiveRepetitionNumber)" : "0",
"Get(ActiveSelectionSize)" : "",
"Get(ActiveSelectionStart)" : "",
"Get(AllowAbortState)" : "1",
"Get(AllowFormattingBarState)" : "",
"Get(ApplicationArchitecture)" : "x86_64",
"Get(ApplicationLanguage)" : "English",
"Get(ApplicationVersion)" : "Pro 19.3.2",
"Get(CalculationRepetitionNumber)" : "1",
"Get(ConnectionAttributes)" : "",
"Get(ConnectionState)" : "0",
"Get(CurrentDate)" : "2021-07-24",
"Get(CurrentExtendedPrivileges)" : "",
"Get(CurrentHostTimestamp)" : "2021-07-24 1:52:29 PM",
"Get(CurrentPrivilegeSetName)" : "",
"Get(CurrentTime)" : "1:52:29 PM",
"Get(CurrentTimeUTCMilliseconds)" : "63762756749426",
"Get(CurrentTimestamp)" : "2021-07-24 1:52:29 PM",

etc..

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

Let ( jsondata = ""; JSONFormatElements ( JSONSetElement ( jsondata;
 [ "Get(AccountExtendedPrivileges)" ; Get(AccountExtendedPrivileges) ; JSONString  ] ; 
 [ "Get(AccountGroupName)" ; Get(AccountGroupName) ; JSONString  ] ; 
 [ "Get(AccountName)" ; Get(AccountName) ; JSONString  ] ; 
 [ "Get(AccountPrivilegeSetName)" ; Get(AccountPrivilegeSetName) ; JSONString  ] ; 
 [ "Get(AccountType)" ; Get(AccountType) ; JSONString  ] ; 
 [ "Get(ActiveFieldContents)" ; Get(ActiveFieldContents) ; JSONString  ] ; 
 [ "Get(ActiveFieldName)" ; Get(ActiveFieldName) ; JSONString  ] ; 
 [ "Get(ActiveFieldTableName)" ; Get(ActiveFieldTableName) ; JSONString  ] ; 
 [ "Get(ActiveLayoutObjectName)" ; Get(ActiveLayoutObjectName) ; JSONString  ] ; 
 [ "Get(ActiveModifierKeys)" ; Get(ActiveModifierKeys) ; JSONString  ] ; 
 [ "Get(ActivePortalRowNumber)" ; Get(ActivePortalRowNumber) ; JSONString  ] ; 
 [ "Get(ActiveRecordNumber)" ; Get(ActiveRecordNumber) ; JSONString  ] ; 
 [ "Get(ActiveRepetitionNumber)" ; Get(ActiveRepetitionNumber) ; JSONString  ] ; 
 [ "Get(ActiveSelectionSize)" ; Get(ActiveSelectionSize) ; JSONString  ] ; 
 [ "Get(ActiveSelectionStart)" ; Get(ActiveSelectionStart) ; JSONString  ] ; 
 [ "Get(AllowAbortState)" ; Get(AllowAbortState) ; JSONString  ] ; 
 [ "Get(AllowFormattingBarState)" ; Get(AllowFormattingBarState) ; JSONString  ] ; 
 [ "Get(ApplicationArchitecture)" ; Get(ApplicationArchitecture) ; JSONString  ] ; 
 [ "Get(ApplicationLanguage)" ; Get(ApplicationLanguage) ; JSONString  ] ; 
 [ "Get(ApplicationVersion)" ; Get(ApplicationVersion) ; JSONString  ] ; 
 [ "Get(CalculationRepetitionNumber)" ; Get(CalculationRepetitionNumber) ; JSONString  ] ; 
 [ "Get(ConnectionAttributes)" ; Get(ConnectionAttributes) ; JSONString  ] ; 
 [ "Get(ConnectionState)" ; Get(ConnectionState) ; JSONString  ] ; 
 [ "Get(CurrentDate)" ; Get(CurrentDate) ; JSONString  ] ; 
 [ "Get(CurrentExtendedPrivileges)" ; Get(CurrentExtendedPrivileges) ; JSONString  ] ; 
 [ "Get(CurrentHostTimestamp)" ; Get(CurrentHostTimestamp) ; JSONString  ] ; 
 [ "Get(CurrentPrivilegeSetName)" ; Get(CurrentPrivilegeSetName) ; JSONString  ] ; 
 [ "Get(CurrentTime)" ; Get(CurrentTime) ; JSONString  ] ; 
 [ "Get(CurrentTimestamp)" ; Get(CurrentTimestamp) ; JSONString  ] ; 
 [ "Get(CurrentTimeUTCMilliseconds)" ; Get(CurrentTimeUTCMilliseconds) ; JSONString  ] ; 
 [ "Get(CustomMenuSetName)" ; Get(CustomMenuSetName) ; JSONString  ] ; 
 [ "Get(DesktopPath)" ; Get(DesktopPath) ; JSONString  ] ; 
 [ "Get(Device)" ; Get(Device) ; JSONString  ] ; 
 [ "Get(DocumentsPath)" ; Get(DocumentsPath) ; JSONString  ] ; 
 [ "Get(DocumentsPathListing)" ; Get(DocumentsPathListing) ; JSONString  ] ; 
 [ "Get(EncryptionState)" ; Get(EncryptionState) ; JSONString  ] ; 
 [ "Get(ErrorCaptureState)" ; Get(ErrorCaptureState) ; JSONString  ] ; 
 [ "Get(FileLocaleElements)" ; Get(FileLocaleElements) ; JSONString  ] ; 
 [ "Get(FileMakerPath)" ; Get(FileMakerPath) ; JSONString  ] ; 
 [ "Get(FileName)" ; Get(FileName) ; JSONString  ] ; 
 [ "Get(FilePath)" ; Get(FilePath) ; JSONString  ] ; 
 [ "Get(FileSize)" ; Get(FileSize) ; JSONString  ] ; 
 [ "Get(FoundCount)" ; Get(FoundCount) ; JSONString  ] ; 
 [ "Get(HighContrastState)" ; Get(HighContrastState) ; JSONString  ] ; 
 [ "Get(HostApplicationVersion)" ; Get(HostApplicationVersion) ; JSONString  ] ; 
 [ "Get(HostIPAddress)" ; Get(HostIPAddress) ; JSONString  ] ; 
 [ "Get(HostName)" ; Get(HostName) ; JSONString  ] ; 
 [ "Get(InstalledFMPlugins)" ; Get(InstalledFMPlugins) ; JSONString  ] ; 
 [ "Get(InstalledFMPluginsAsJSON)" ; Get(InstalledFMPluginsAsJSON) ; JSONString  ] ; 
 [ "Get(LastError)" ; Get(LastError) ; JSONString  ] ; 
 [ "Get(LastErrorDetail)" ; Get(LastErrorDetail) ; JSONString  ] ; 
 [ "Get(LastErrorLocation)" ; Get(LastErrorLocation) ; JSONString  ] ; 
 [ "Get(LastMessageChoice)" ; Get(LastMessageChoice) ; JSONString  ] ; 
 [ "Get(LayoutAccess)" ; Get(LayoutAccess) ; JSONString  ] ; 
 [ "Get(LayoutCount)" ; Get(LayoutCount) ; JSONString  ] ; 
 [ "Get(LayoutName)" ; Get(LayoutName) ; JSONString  ] ; 
 [ "Get(LayoutNumber)" ; Get(LayoutNumber) ; JSONString  ] ; 
 [ "Get(LayoutTableName)" ; Get(LayoutTableName) ; JSONString  ] ; 
 [ "Get(LayoutViewState)" ; Get(LayoutViewState) ; JSONString  ] ; 
 [ "Get(MenubarState)" ; Get(MenubarState) ; JSONString  ] ; 
 [ "Get(ModifiedFields)" ; Get(ModifiedFields) ; JSONString  ] ; 
 [ "Get(MultiUserState)" ; Get(MultiUserState) ; JSONString  ] ; 
 [ "Get(NetworkProtocol)" ; Get(NetworkProtocol) ; JSONString  ] ; 
 [ "Get(NetworkType)" ; Get(NetworkType) ; JSONString  ] ; 
 [ "Get(OpenDataFileInfo)" ; Get(OpenDataFileInfo) ; JSONString  ] ; 
 [ "Get(PageCount)" ; Get(PageCount) ; JSONString  ] ; 
 [ "Get(PageNumber)" ; Get(PageNumber) ; JSONString  ] ; 
 [ "Get(PersistentID)" ; Get(PersistentID) ; JSONString  ] ; 
 [ "Get(PreferencesPath)" ; Get(PreferencesPath) ; JSONString  ] ; 
 [ "Get(PrinterName)" ; Get(PrinterName) ; JSONString  ] ; 
 [ "Get(QuickFindText)" ; Get(QuickFindText) ; JSONString  ] ; 
 [ "Get(RecordAccess)" ; Get(RecordAccess) ; JSONString  ] ; 
 [ "Get(RecordID)" ; Get(RecordID) ; JSONString  ] ; 
 [ "Get(RecordModificationCount)" ; Get(RecordModificationCount) ; JSONString  ] ; 
 [ "Get(RecordNumber)" ; Get(RecordNumber) ; JSONString  ] ; 
 [ "Get(RecordOpenCount)" ; Get(RecordOpenCount) ; JSONString  ] ; 
 [ "Get(RecordOpenState)" ; Get(RecordOpenState) ; JSONString  ] ; 
 [ "Get(RegionMonitorEvents)" ; Get(RegionMonitorEvents) ; JSONString  ] ; 
 [ "Get(RequestCount)" ; Get(RequestCount) ; JSONString  ] ; 
 [ "Get(RequestOmitState)" ; Get(RequestOmitState) ; JSONString  ] ; 
 [ "Get(ScreenDepth)" ; Get(ScreenDepth) ; JSONString  ] ; 
 [ "Get(ScreenHeight)" ; Get(ScreenHeight) ; JSONString  ] ; 
 [ "Get(ScreenScaleFactor)" ; Get(ScreenScaleFactor) ; JSONString  ] ; 
 [ "Get(ScreenWidth)" ; Get(ScreenWidth) ; JSONString  ] ; 
 [ "Get(ScriptAnimationState)" ; Get(ScriptAnimationState) ; JSONString  ] ; 
 [ "Get(ScriptName)" ; Get(ScriptName) ; JSONString  ] ; 
 [ "Get(ScriptParameter)" ; Get(ScriptParameter) ; JSONString  ] ; 
 [ "Get(ScriptResult)" ; Get(ScriptResult) ; JSONString  ] ; 
 [ "Get(SessionIdentifier)" ; Get(SessionIdentifier) ; JSONString  ] ; 
 [ "Get(SortState)" ; Get(SortState) ; JSONString  ] ; 
 [ "Get(StatusAreaState)" ; Get(StatusAreaState) ; JSONString  ] ; 
 [ "Get(SystemAppearance)" ; Get(SystemAppearance) ; JSONString  ] ; 
 [ "Get(SystemDrive)" ; Get(SystemDrive) ; JSONString  ] ; 
 [ "Get(SystemIPAddress)" ; Get(SystemIPAddress) ; JSONString  ] ; 
 [ "Get(SystemLanguage)" ; Get(SystemLanguage) ; JSONString  ] ; 
 [ "Get(SystemLocaleElements)" ; Get(SystemLocaleElements) ; JSONString  ] ; 
 [ "Get(SystemNICAddress)" ; Get(SystemNICAddress) ; JSONString  ] ; 
 [ "Get(SystemPlatform)" ; Get(SystemPlatform) ; JSONString  ] ; 
 [ "Get(SystemVersion)" ; Get(SystemVersion) ; JSONString  ] ; 
 [ "Get(TemporaryPath)" ; Get(TemporaryPath) ; JSONString  ] ; 
 [ "Get(TextRulerVisible)" ; Get(TextRulerVisible) ; JSONString  ] ; 
 [ "Get(TotalRecordCount)" ; Get(TotalRecordCount) ; JSONString  ] ; 
 [ "Get(TouchKeyboardState)" ; Get(TouchKeyboardState) ; JSONString  ] ; 
 [ "Get(TransactionOpenState)" ; Get(TransactionOpenState) ; JSONString  ] ; 
 [ "Get(TriggerCurrentPanel)" ; Get(TriggerCurrentPanel) ; JSONString  ] ; 
 [ "Get(TriggerExternalEvent)" ; Get(TriggerExternalEvent) ; JSONString  ] ; 
 [ "Get(TriggerGestureInfo)" ; Get(TriggerGestureInfo) ; JSONString  ] ; 
 [ "Get(TriggerKeystroke)" ; Get(TriggerKeystroke) ; JSONString  ] ; 
 [ "Get(TriggerModifierKeys)" ; Get(TriggerModifierKeys) ; JSONString  ] ; 
 [ "Get(TriggerTargetPanel)" ; Get(TriggerTargetPanel) ; JSONString  ] ; 
 [ "Get(UserCount)" ; Get(UserCount) ; JSONString  ] ; 
 [ "Get(UserName)" ; Get(UserName) ; JSONString  ] ; 
 [ "Get(UseSystemFormatsState)" ; Get(UseSystemFormatsState) ; JSONString  ] ; 
 [ "Get(UUID)" ; Get(UUID) ; JSONString  ] ; 
 [ "Get(UUIDNumber)" ; Get(UUIDNumber) ; JSONString  ] ; 
 [ "Get(WindowContentHeight)" ; Get(WindowContentHeight) ; JSONString  ] ; 
 [ "Get(WindowContentWidth)" ; Get(WindowContentWidth) ; JSONString  ] ; 
 [ "Get(WindowDesktopHeight)" ; Get(WindowDesktopHeight) ; JSONString  ] ; 
 [ "Get(WindowDesktopWidth)" ; Get(WindowDesktopWidth) ; JSONString  ] ; 
 [ "Get(WindowHeight)" ; Get(WindowHeight) ; JSONString  ] ; 
 [ "Get(WindowLeft)" ; Get(WindowLeft) ; JSONString  ] ; 
 [ "Get(WindowMode)" ; Get(WindowMode) ; JSONString  ] ; 
 [ "Get(WindowName)" ; Get(WindowName) ; JSONString  ] ; 
 [ "Get(WindowOrientation)" ; Get(WindowOrientation) ; JSONString  ] ; 
 [ "Get(WindowStyle)" ; Get(WindowStyle) ; JSONString  ] ; 
 [ "Get(WindowTop)" ; Get(WindowTop) ; JSONString  ] ; 
 [ "Get(WindowVisible)" ; Get(WindowVisible) ; JSONString  ] ; 
 [ "Get(WindowWidth)" ; Get(WindowWidth) ; JSONString  ] ; 
 [ "Get(WindowZoomLevel)" ; Get(WindowZoomLevel) ; JSONString  ] 
)))

Original GetAll function here https://www.briandunning.com/cf/2501

*** USE WITH CARE ***

All 129 Get Function results as JSONString from https://help.claris.com/en/pro-help/content/functions-reference.html

Generates alot of data. Use with care.

Helpful for speedtest, debugging, looking for values.

Source here
https://docs.google.com/spreadsheets/d/1GQXVKV6Ynok8JFY4arqwZ7lVwHOI3g8_St0WwSXdJNY

Comments

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

GetAllJSON

Comments

Support this website.

Support this website.