encodeFM v1.0.0

Published by Soliant Consulting on March 10, 2021
Updated on March 10, 2021
Tags: Development
Download Send To Carafe
Download Send To Carafe
Created By: ryng64
Version: 1.0.0

Windows Tested: Yes
Offline Compatible: Yes

Description:

Usage


Paste in a any valid JSON and click Translate or Translate 💥 (exploded)


Translate buttons convert JSON to a FileMaker expression in all versions of FM that support a webviewer.



Example Data


FileMaker dapi request


{
"layouts":"Projects",
"limit":25,
"offset":5,
"query":[
{
"Status":"Active",
"AssignedTo":"Ricky"
}
],
"sort":[
{
"fieldName":"Priority",
"sortOrder":"ascend"
}
]
}

JSON Types


{
"Null": null,
"True": true,
"False": false,
"Empty": "",
"Text": "Test Text",
"Number": 420,
"ObjectEmpty": {},
"Object": {"A":1, "b":"two"},
"ArrayNested": [1,"two",{"A":1, "b":"two"},[1,2,"three"]],
"ArrayStrings": ["one","two","three"],
"ArrayNumber": [1,2,3],
"ArrayEmpty": []
}
A FileMaker tool to convert JSON syntax into the FileMaker JSONSetElement syntax
References:

0 Comments

Leave a Comment