{"id":13284,"date":"2021-05-22T10:14:40","date_gmt":"2021-05-22T17:14:40","guid":{"rendered":"https:\/\/www.seedcode.com\/?p=13284"},"modified":"2021-05-22T10:14:40","modified_gmt":"2021-05-22T17:14:40","slug":"filemaker-and-json-files","status":"publish","type":"post","link":"https:\/\/seedcode.com\/filemaker-and-json-files\/","title":{"rendered":"FileMaker and JSON Files"},"content":{"rendered":"

FileMaker introduced its JSON functions in version 16. They\u2019ve changed how many developers work, both as a protocol for handling data interchange within FileMaker and working with external APIs. The JSON functions are for working with text, but what if we run into a situation where we need to work with actual JSON files? Does FileMaker provide the tools to read and write .json files as well as JSON text?<\/p>\n

[ba-box background=”#ffffd1″ border=”#374c77″ textcolor=”#F7F7F7″]<\/p>\n

Looking for our article and example file on the JSON Parsing Function? Here it is: FileMaker JSON Functons<\/a>.<\/p>\n

[\/ba-box]<\/p>\n

FileMaker JSON: Reading Files<\/h3>\n

JSON files are really utf-8 text files, and we have a few different ways of handling them in FileMaker.<\/p>\n

The Insert From URL script step can be used to insert .json files that are local to the system or downloaded from an external site or API. The way these files are inserted depends on the target that\u2019s specified in the script step. For example, if a variable or text field is specified as the target, then Insert From URL will simply read the .json file and insert it as text. As text, we can then use the JSONGetElement<\/a> function to parse the specific values.<\/p>\n

\"FileMaker<\/a>
Sample script For inserting JSON as text<\/figcaption><\/figure>\n

If a container field is specified as the target in the Insert From URL step, then the .json file is inserted into the container as an actual JSON file.<\/p>\n

\"FileMaker<\/a>
JSON file inserted into a container as .json file<\/figcaption><\/figure>\n

Since .json files are actually utf-8 encoded text files, we can read the text right from the container using the TextDecode function and specifying utf-8 as the encoding. However, it\u2019s also possible these .json files are getting into the container field using a method that\u2019s not Insert From URL, and the option of specifying the target is not available. Hence, the TextDecode function is useful in that scenario as well.<\/p>\n

\"Using<\/a>
Insert JSON as a file and then read contents with TextDecode<\/figcaption><\/figure>\n

Writing JSON Files from FileMaker<\/h3>\n

There are also scenarios where you may want to store or send your JSON from FileMaker as a .json file rather than as text. For example, some APIs recommend that you upload a .json file if the payload is very large instead of writing the JSON text inline as part of your request.<\/p>\n

Let\u2019s say we want to create the following JSON from FileMaker data and then turn it into a .json file.<\/p>\n

{\n    \"contact\" : \n    {\n        \"email1\" : \"support@seedcode.com\",\n        \"email2\" : \"support@dayback.com\",\n        \"phone\" : \"855-733-3263\"\n    },\n    \"name\" : \"Jason Young\",\n    \"title\" : \"Developer\"\n}<\/pre>\n
The first thing we\u2019ll do is to create the JSON with our JSONSetElement function like this.<\/p>\n
JSONSetElement ( \"{}\" ; \n\n\n\t[ \"name\" ; \"Jason Young\" ; JSONString ];\n\t[ \"title\" ; \"Developer\" ; JSONString ];\n\t[ \"contact\" ; JSONSetElement ( \"{}\" ;\n\t\t[ \"phone\" ; \"855-733-3263\" ; JSONString ];\n\t\t[ \"email1\" ; \"support@seedcode.com\" ; JSONString ];\n\t\t[ \"email2\" ; \"support@dayback.com\" ; JSONString ] )\n\t; JSONObject ]\n\t\n\n)<\/pre>\n
If we\u2019re using FileMaker client, we can set the JSON into a text field and then use Export Field Contents and specify the file name with the .json extension and then re-insert the file into our container: we\u2019re all set. However, if we want this to run on the server or WebDirect, we need to handle this differently as Export Field Contents is unavailable on the server and is limited on WebDirect. As discussed earlier, .json files are just utf-8 text files, so we can use the TextEncode function to convert our JSON text to a file. When we do this, we get a file named utf-8.txt, but we need this to be a .json file with a specific name. To change the file name and extension, we can encode the file as Base64 and then decode it and specify the file name with the Base64Decode function\u2019s optional second parameter. Here\u2019s an example script showing how we can create the .json file with the name Example2.json.<\/p>\n
\"Using<\/a>
Create .json file by encoding and then decoding as base64<\/figcaption><\/figure>\n
We now have a properly encoded .json file ready for an API or for storing as a file.<\/p>\n
\"Export<\/a>
.json file created by a FileMaker script<\/figcaption><\/figure>\n
Conclusions<\/h3>\n
\n
In addition to the JSON text functions like JSONSetElement and JSONGetElement, FileMaker also provides us with the TextEncode and TextDecode functions. These, in combination with the JSON functions, allow us to not only read and write JSON as text but to write as .json files as well, extending the platform to cover whatever our JSON requirement may be.<\/p>\n<\/div>\n
<\/figure>\n","protected":false},"excerpt":{"rendered":"
FileMaker introduced its JSON functions in version 16. They\u2019ve changed how many developers work, both as a protocol for handling data interchange within FileMaker and working with external APIs. The JSON functions are for working with text, but what if we run into a situation where we need to work with actual JSON files? Does FileMaker provide the tools to read and write .json files as well as JSON text? [ba-box background=”#ffffd1″ border=”#374c77″ textcolor=”#F7F7F7″] Looking for our article and example file on the JSON Parsing Function? Here it is: FileMaker JSON Functons. [\/ba-box] FileMaker JSON: Reading Files JSON files are really utf-8 text files, and we have a few different ways of handling them in FileMaker. The Insert From URL script step can be used to insert .json files that are local to the system or downloaded from an external site or API. The way these files are inserted depends on the target that\u2019s specified in the script step. For example, if a variable or text field is specified as the target, then Insert From URL will simply read the .json file and insert it as text. As text, we can then use the JSONGetElement function to parse the specific values. If a container field is specified as the target in the Insert From URL step, then the .json file is inserted into the container as an actual JSON file. Since .json files are actually utf-8 encoded text files, we can read the text right from the container using the TextDecode function and specifying utf-8 as the encoding. However, it\u2019s also possible these .json files are getting into the container field using a method that\u2019s not Insert From URL, and the option of specifying the target is not available. Hence, the TextDecode function is useful in that scenario as well.<\/p>\n","protected":false},"author":3,"featured_media":13301,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[40],"class_list":["post-13284","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-filemaker-19"],"yoast_head":"\nFileMaker JSON Files - Reading & Writing - SeedCode<\/title>\n<meta name=\"description\" content=\"Does FileMaker provide the tools to read and write .json files as well as JSON text? Read and write JSON files from FileMaker.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/seedcode.com\/filemaker-and-json-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FileMaker JSON Files - Reading & Writing - SeedCode\" \/>\n<meta property=\"og:description\" content=\"Does FileMaker provide the tools to read and write .json files as well as JSON text? Read and write JSON files from FileMaker.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/seedcode.com\/filemaker-and-json-files\/\" \/>\n<meta property=\"og:site_name\" content=\"SeedCode\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/seedcoder\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-22T17:14:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/JSONFilesFeat.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1506\" \/>\n\t<meta property=\"og:image:height\" content=\"847\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"jasonchryoung\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/JSONFilesFeat.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@dayback\" \/>\n<meta name=\"twitter:site\" content=\"@dayback\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"jasonchryoung\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/\"},\"author\":{\"name\":\"jasonchryoung\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/21c8e63200786c642eb068377e428ebd\"},\"headline\":\"FileMaker and JSON Files\",\"datePublished\":\"2021-05-22T17:14:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/\"},\"wordCount\":737,\"commentCount\":7,\"publisher\":{\"@id\":\"https:\/\/seedcode.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/jsonfeatmini.png\",\"keywords\":[\"FileMaker 19\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/seedcode.com\/filemaker-and-json-files\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/\",\"url\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/\",\"name\":\"FileMaker JSON Files - Reading & Writing - SeedCode\",\"isPartOf\":{\"@id\":\"https:\/\/seedcode.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/jsonfeatmini.png\",\"datePublished\":\"2021-05-22T17:14:40+00:00\",\"description\":\"Does FileMaker provide the tools to read and write .json files as well as JSON text? Read and write JSON files from FileMaker.\",\"breadcrumb\":{\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seedcode.com\/filemaker-and-json-files\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/#primaryimage\",\"url\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/jsonfeatmini.png\",\"contentUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/jsonfeatmini.png\",\"width\":319,\"height\":325},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seedcode.com\/filemaker-and-json-files\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seedcode.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FileMaker and JSON Files\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/seedcode.com\/#website\",\"url\":\"https:\/\/seedcode.com\/\",\"name\":\"SeedCode\",\"description\":\"Build the Software You've Always Wanted\",\"publisher\":{\"@id\":\"https:\/\/seedcode.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/seedcode.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/seedcode.com\/#organization\",\"name\":\"SeedCode\",\"url\":\"https:\/\/seedcode.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png\",\"contentUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png\",\"width\":595,\"height\":189,\"caption\":\"SeedCode\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/seedcoder\",\"https:\/\/x.com\/dayback\",\"https:\/\/www.linkedin.com\/company\/seedcode\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/21c8e63200786c642eb068377e428ebd\",\"name\":\"jasonchryoung\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"jasonchryoung\"},\"url\":\"https:\/\/seedcode.com\/author\/jasonchryoung\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FileMaker JSON Files - Reading & Writing - SeedCode","description":"Does FileMaker provide the tools to read and write .json files as well as JSON text? Read and write JSON files from FileMaker.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/seedcode.com\/filemaker-and-json-files\/","og_locale":"en_US","og_type":"article","og_title":"FileMaker JSON Files - Reading & Writing - SeedCode","og_description":"Does FileMaker provide the tools to read and write .json files as well as JSON text? Read and write JSON files from FileMaker.","og_url":"https:\/\/seedcode.com\/filemaker-and-json-files\/","og_site_name":"SeedCode","article_publisher":"https:\/\/www.facebook.com\/seedcoder","article_published_time":"2021-05-22T17:14:40+00:00","og_image":[{"width":1506,"height":847,"url":"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/JSONFilesFeat.jpg","type":"image\/jpeg"}],"author":"jasonchryoung","twitter_card":"summary_large_image","twitter_image":"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/JSONFilesFeat.jpg","twitter_creator":"@dayback","twitter_site":"@dayback","twitter_misc":{"Written by":"jasonchryoung","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/#article","isPartOf":{"@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/"},"author":{"name":"jasonchryoung","@id":"https:\/\/seedcode.com\/#\/schema\/person\/21c8e63200786c642eb068377e428ebd"},"headline":"FileMaker and JSON Files","datePublished":"2021-05-22T17:14:40+00:00","mainEntityOfPage":{"@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/"},"wordCount":737,"commentCount":7,"publisher":{"@id":"https:\/\/seedcode.com\/#organization"},"image":{"@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/#primaryimage"},"thumbnailUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/jsonfeatmini.png","keywords":["FileMaker 19"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/seedcode.com\/filemaker-and-json-files\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/","url":"https:\/\/seedcode.com\/filemaker-and-json-files\/","name":"FileMaker JSON Files - Reading & Writing - SeedCode","isPartOf":{"@id":"https:\/\/seedcode.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/#primaryimage"},"image":{"@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/#primaryimage"},"thumbnailUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/jsonfeatmini.png","datePublished":"2021-05-22T17:14:40+00:00","description":"Does FileMaker provide the tools to read and write .json files as well as JSON text? Read and write JSON files from FileMaker.","breadcrumb":{"@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seedcode.com\/filemaker-and-json-files\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/#primaryimage","url":"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/jsonfeatmini.png","contentUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2021\/05\/jsonfeatmini.png","width":319,"height":325},{"@type":"BreadcrumbList","@id":"https:\/\/seedcode.com\/filemaker-and-json-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seedcode.com\/"},{"@type":"ListItem","position":2,"name":"FileMaker and JSON Files"}]},{"@type":"WebSite","@id":"https:\/\/seedcode.com\/#website","url":"https:\/\/seedcode.com\/","name":"SeedCode","description":"Build the Software You've Always Wanted","publisher":{"@id":"https:\/\/seedcode.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/seedcode.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/seedcode.com\/#organization","name":"SeedCode","url":"https:\/\/seedcode.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/#\/schema\/logo\/image\/","url":"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png","contentUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png","width":595,"height":189,"caption":"SeedCode"},"image":{"@id":"https:\/\/seedcode.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/seedcoder","https:\/\/x.com\/dayback","https:\/\/www.linkedin.com\/company\/seedcode\/"]},{"@type":"Person","@id":"https:\/\/seedcode.com\/#\/schema\/person\/21c8e63200786c642eb068377e428ebd","name":"jasonchryoung","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"jasonchryoung"},"url":"https:\/\/seedcode.com\/author\/jasonchryoung\/"}]}},"_links":{"self":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts\/13284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/comments?post=13284"}],"version-history":[{"count":0,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts\/13284\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/media\/13301"}],"wp:attachment":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/media?parent=13284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/categories?post=13284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/tags?post=13284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}