A FileMaker tool to convert JSON syntax into the FileMaker JSONSetElement syntax
- Translate : converts JSON contents into JSONSetElement(...) expression
- $vars : generate variable names based on the Keys of the object.
- ;[leading] : placement of semicolons (;) on the left (leading) or the right (trailing)
this project uses Parcel to build. I highly recomend taking the time to set up a parcel build as it saves soo much time in development.
npm install
npm run dev
In a browser, go to http://localhost:1234/
Page will resfresh live as you update and save your code.
this may build a lot of files into a dist/ folder, however the index.html file in this folder will contain all the javascript, css and html inlined into a single file. This build file is the added to the html field in the Web Direct Source Layout for encodeFM.
npm run build
- dist/index.html ( inlined html, css, javascript )
- put contents into encodeFM::html
check out www.ausom.dev for more information.
checkout
Data API Request Example
{
"layouts":"Projects",
"limit":25,
"offset":5,
"query":[
{
"Status":"Active",
"AssignedTo":"Ricky"
}
],
"sort":[
{
"fieldName":"Priority",
"sortOrder":"ascend"
}
]
}
Test with different 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": []
}