{"id":335,"date":"2014-07-10T20:42:18","date_gmt":"2014-07-11T03:42:18","guid":{"rendered":"http:\/\/layneshipley.shipley.website\/?p=335"},"modified":"2024-11-18T11:59:55","modified_gmt":"2024-11-18T18:59:55","slug":"importing-json-data-filemaker","status":"publish","type":"post","link":"https:\/\/layne.eqlik.us\/index.php\/archives\/335","title":{"rendered":"Importing JSON Data Into FileMaker"},"content":{"rendered":"<p>I have a little challenge I&#8217;d like to complete. \u00a0I have a website that exports data in a JSON format. \u00a0I&#8217;d like to import that data into FileMaker. \u00a0Is this possible? \u00a0and has anyone done something like this? \u00a0I&#8217;ve been able to export data into a JSON format but&#8230; I hasn&#8217;t helped me import it. \u00a0Any help would be appreciated.<\/p>\n<p>I have been able to find a xsl stylesheet to export FileMaker data into JSON formatted data. \u00a0It can be found at\u00a0<a title=\"FileMaker to JSON\" href=\"http:\/\/sixfriedrice.com\/wp\/products\/filemaker-to-json-converter\/\" target=\"\">http:\/\/sixfriedrice.com\/wp\/products\/filemaker-to-json-converter\/<\/a>. \u00a0I&#8217;m more interested in taking JSON data and converting it into FileMaker data.<\/p>\n<p>The closest thing I&#8217;ve been able to find is:\u00a0<a title=\"Beezwax JSON to FileMaker\" href=\"http:\/\/www.beezwax.net\/solutions\/wsp\" target=\"\">http:\/\/www.beezwax.net\/solutions\/wsp<\/a>\u00a0\u00a0It&#8217;s a plugin that is suppose to import JSON data and convert into FileMaker data. \u00a0I haven&#8217;t tested it yet.<\/p>\n<p>This is the solution I found that worked for me.<\/p>\n<div><\/div>\n<div><a title=\"Parsing JSON\" href=\"http:\/\/www.soliantconsulting.com\/blog\/2011\/12\/how-to-parse-json-or-any-other-language-in-filemaker\/\" target=\"\">http:\/\/www.soliantconsulting.com\/blog\/2011\/12\/how-to-parse-json-or-any-other-language-in-filemaker\/<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I have a little challenge I&#8217;d like to complete. \u00a0I have a website that exports data in a JSON format. \u00a0I&#8217;d like to import that data into FileMaker. \u00a0Is this possible? \u00a0and has anyone done something like this? \u00a0I&#8217;ve been able to export data into a JSON format but&#8230; I hasn&#8217;t helped me import it. \u00a0Any help would be appreciated. I have been able to find a xsl stylesheet to export FileMaker data into JSON formatted data. \u00a0It can be found at\u00a0http:\/\/sixfriedrice.com\/wp\/products\/filemaker-to-json-converter\/. \u00a0I&#8217;m more interested in taking JSON data and converting it into FileMaker data. The closest thing I&#8217;ve been able to find is:\u00a0http:\/\/www.beezwax.net\/solutions\/wsp\u00a0\u00a0It&#8217;s a plugin that is suppose to import JSON data and convert into FileMaker data. \u00a0I haven&#8217;t tested it yet. This is the solution I found that worked for me. http:\/\/www.soliantconsulting.com\/blog\/2011\/12\/how-to-parse-json-or-any-other-language-in-filemaker\/<\/p>\n","protected":false},"author":1,"featured_media":346,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,6],"tags":[37,136],"class_list":["post-335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computers","category-filemaker","tag-filemaker-2","tag-json"],"acf":[],"_links":{"self":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":1,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"predecessor-version":[{"id":1384,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/335\/revisions\/1384"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media\/346"}],"wp:attachment":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}