Jump to content

Search the Community

Showing results for tags 'json'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • Button Bar Icon - Text Alignment Issue

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 11 results

  1. Virtual list using JSON

    On a separate thread I asked Bruce Robertson if the new FM16 JSON functions could be used together with the virtual list technique he created. I haven’t experimented with it but I wonder if JSON adapt well to this great technique. Any thoughts? thanks!
  2. Ziptastic Revisited By: Doug West **Requires FileMaker Pro 16 Lookup the city and state for any ZIP Code quickly and easily using JSON data from the Ziptastic web service API with FileMaker Pro 16. Ziptastic is a simple web service for accessing geolocation data associated with postal codes. The API provided at getziptastic.com supports postal codes in 70 countries. By sending a US-based ZIP Code in a URL, we can quickly and easily get the associated city, county, and state. This service replaces the hassle of creating and updating an offline reference for postal codes. We first provided the Ziptastic tip file for this web service roughly four years ago as a demonstration of the Insert From URL script step that was introduced in FileMaker Pro 12. Enhancements in FileMaker Pro 16 now allow us to simplify this process even more. Let’s take a look at the fundamental differences: OLD Way (FileMaker Pro 12+) Insert From URL script step returns JSON results to a global field Separate script is called to parse field values out of the JSON data object NEW Way (FileMaker Pro 16+) Insert From URL script step returns JSON results to a global variable JSONGetElement function is called to parse field values out of the JSON data object Net Result We have eliminated the script for the JSON parsing and the global field we were using to store the response from the Ziptastic API. Adding this feature to a solution now requires only one script and no additional fields. The script can be triggered when the user exists the ZIP Code field, and the city and state will be looked up so the user doesn’t have to enter them manually. The Ziptastic service continues to be free for up to 100 requests per day, but now offers premium service levels for higher usage. The revenue generated by the subscriptions allows them to update the data monthly instead of only twice a year. Additional details for this web service can be found at getziptastic.com, but the concepts described in this tip are relevant to any web service using JSON as the data interchange format. •• Download FREE FileMaker Pro demo file •• **This article is provided for free and as-is, use, enjoy, learn, and experiment at your own risk – but have fun! eXcelisys does not offer any free support or free assistance with any of the contents of this blog post. If you would like help or assistance, please consider retaining eXcelisys’ FileMaker Pro consulting & development services. About eXcelisys, Inc.: Founded in 2001, eXcelisys (www.excelisys.com)is an FBA Platinum Partner and FileMaker Certified developer organization. eXcelisys specializes in designing, developing, customizing, supporting, consulting, migrating, upgrading, fixing, and integrating of database solutions for Desktop, Mobile, and Web applications. Our core technology competencies are FileMaker Pro, FileMaker Go, and MySQL for database frameworks, along with FileMaker WebDirect, WordPress, MySQL, PHP, CodeIgniter, PostgreSQL, Joomla, Drupal, Magento, CSS, HTML5, and Javascript for web sites and web applications. Aside from providing eXcellent customer service, our goals are to use these technologies to intuitively automate your organization’s data solution needs seamlessly and flawlessly across the web, mobile, and desktop platforms. Contact eXcelisys today for a free estimate and consultation about making your business more efficient through intuitive and effective software automation. 866-592-9235. eXcelisys, Inc. is an independent entity and this web site/information/blog post has not been authorized, sponsored, or otherwise affiliated with FileMaker, Inc. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. The post [FMP Tip-n-Trick] Ziptastic Revisited Using FileMaker Pro 16 appeared first on eXcelisys. View the full article
  3. I've been using Daniel Smith's JSON scripts from (http://www.modularfilemaker.org/module/json/) to parse JSON. It's worked quite reliably (thanks Daniel!), but I'm wondering if anyone has compared its parsing speed to MBS's JSON plugin or the new native Filemaker 16 JSON functions? I'm still on 15. I'm working with some larger JSON files that are taking a long time to parse and hoping for a faster solution. Any data on which option parses JSON fastest? Any disadvantages/advantages to each option? Thanks!
  4. FileMaker JSON Functions

    Native JSON functions have made it to the FileMaker platform! We dive into how to use the functions to create, modify, and parse JSON for REST APIs and more. Learn about the 6 new functions available, JSONSetElement, JSONDeleteElement, JSONGetElement, JSONListKeys, JSONListValues, JSONFormatElements. FileMaker JSON Functions David Happersberger dbservices.com
  5. With the introduction of cURL options in FM16's Insert from URL script step I've been investigating the possibility of being able to save a copy of my FM solution directly to my Dropbox folder using the https://content.dropboxapi.com/2/files/upload element from Dropbox V2 API. I've successfully created the access token to pass through as part of this step and the Insert from URL script step successfully creates the stated folder and file in my Dropbox. However, the file size is always 0 bytes. I've tried 2 different methods METHOD 1 #Export a compacted copy of this file to Temporary Folder Set Variable [ $file_path ; Get ( TemporaryPath ) & "Solution.fmp12" ] Save a Copy as [ "$file_path" ; compacted ] #Set my cURL options to variable Set Variable [ $curl_header ; "curl -X POST https://content.dropboxapi.com/2/files/upload \\" & ¶ & "--header \"Authorization: Bearer " & PREFERENCES::Dropbox_AccessToken & "\" \\" & ¶ & "--header \"Dropbox-API-Arg: {\\\"path\\\": \\\"/DB2FM/Solution.fmp12\\\"}\" \\" & ¶ & "--header \"Content-Type: application/octet-stream\" \\" & ¶ & "--data-binary @" & $file_path ] #Dropbox URL Set Variable [ $dropbox_url ; "https://content.dropboxapi.com/2/files/upload" ] #Make Request - Set to variable adn then format to JSON field Insert from URL [ Verify SSL Certificates ; With dialog: Off ; $json ; $dropbox_url ; cURL options: $curl_header ] Set Field [ PREFERENCES:Dropbox_JSON ; JSONFormatElements ( $json ) ] METHOD 2 #Export a compacted copy of this file to Temporary Folder and then import to a container field Set Variable [ $file_path ; Get ( TemporaryPath ) & "Solution.fmp12" ] //note1 Save a Copy as [ "$file_path" ; compacted ] //note1 Insert File [ PREFERENCES::Container ; "$file_path" ] //note1 #Set variable following instructions on FileMaker website which states: # - Direct file access is replaced with a FileMaker variable prefixed by the @ character. # - To access a file, you can set the variable to a container field, which contains the file, then use that variable as the parameter of the cURL option. Set Variable [ $container_path ; PREFERENCES::Container ] #Set my cURL options to variable Set Variable [ $curl_header ; "curl -X POST https://content.dropboxapi.com/2/files/upload \\" & ¶ & "--header \"Authorization: Bearer " & PREFERENCES::Dropbox_AccessToken & "\" \\" & ¶ & "--header \"Dropbox-API-Arg: {\\\"path\\\": \\\"/DB2FM/Solution.fmp12\\\"}\" \\" & ¶ & "--header \"Content-Type: application/octet-stream\" \\" & ¶ & "--data-binary @" & $container_path ] #Dropbox URL Set Variable [ $dropbox_url ; "https://content.dropboxapi.com/2/files/upload" ] #Make Request - Set to variable adn then format to JSON field Insert from URL [ Verify SSL Certificates ; With dialog: Off ; $json ; $dropbox_url ; cURL options: $curl_header ] Set Field [ PREFERENCES:Dropbox_JSON ; JSONFormatElements ( $json ) ] JSON Response For Both Methods I get the following JSON Response for both methods { "client_modified" : "2017-05-16T11:22:47Z", "content_hash" : "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855", "id" : "id:heJWQ1SWwJsAAAAAAcMWNw", "name" : "Solution.fmp12", "path_display" : "/DB2FM/Solution.fmp12", "path_lower" : "/db2fm/solution.fmp12", "rev" : "3a0412f00f58892", "server_modified" : "2017-05-16T11:22:48Z", "size" : 0 } Any ideas as to why the file is created but with no content. I've also tried this with a number of different file types (.png, .txt, .pdf) by manually inserting a file into the container and greying out the 3 steps marked //note1 above but the result is always the same.
  6. FileMaker 16 introduced a collection of built-in functions for manipulating data serialized as JSON. This makes it easier for FileMaker applications to interact with many web services. This will also make JSON the de facto standard format for scripts within FileMaker to pass parameters and results to each other, improving code sharing within the FileMaker community. JSON does not have a broad palette of scalar data types to choose from: text, number, boolean, and null. Even with those, FileMaker's JSONGetElement function always returns a text result, even when the serialized JSON value is a number or boolean. So I made a handful of custom functions and scripts for sending and receiving typed data with JSON. The module is hosted on GitHub, or you can download it directly.
  7. Hi everyone, I'm trying to post data to a Drupal application from FileMaker via the BaseElements plugin. I'm getting a token, setting authentication, headers, and the post variables via the BaseElements functions and I've followed examples but I'm getting the following error: {"error":"The type link relation must be specified.”} I can't find any information about what this error might be. Does anyone have any idea based on the output I've gathered below? A working cURL command that I'm basically trying to replicate that can be run from the command line is here: curl --include \ --request POST \ --user res_user:"password" \ --header 'Content-type: application/hal+json' \ --header "X-CSRF-Token: $X_CSRF_TOKEN" \ --data-binary '{"_links":{"type":{"href":"http://server.mskcc.org/rest/type/node/event"}}, "field_event_type":[{"value":"Seminar"}], "title":[{"value":”Novel Approaches to Mating Drosophila"}], "field_shared_datetime":[{"value":"2016-06-13T17:15:00"}], "body":[{"value":"Tea ?: Yes<br>Tea Time: Tea at 1:15 PM"}], "field_shared_location_text":[{"value":"ZRC Auditorium"}], "field_shared_sponsor":[{"value":"Developmental Biology"}], "field_event_hosts_text":[{"value":"Alexander Rudensky"}], "field_shared_people_text":[{"value":"Name of Speaker: Steven Reiner<br>Speaker\u0027s Credentials: M.D.<br>Speaker\u0027s Title: Professor, Department of Microbiology and Immunology<br>Speaker\u0027s Affiliation: Columbia University Medical Center<br>Institution Location: New York, NY"}], "type":[{"target_id":"event"}]}' \ http://dev.mskcc.org/entity/node?_format=hal_json I've attached the script I'm working with as an image. thanks in advance. Steven ----- BE_Curl_Trace returned: == Info: Trying 172.22.233.50... == Info: Connected to dev.mskcc.org (172.22.233.50) port 80 (#0) == Info: Server auth using Basic with user 'res_user' => Send header, 0x12c bytes (0x12c) 0000: POST /entity/node?_format=hal_json HTTP/1.1 0x2d: Host: server.mskcc.org 0x42: Authorization: Basic cmVzX2RydXBhbDpUcnU3SCZrQQ== 0x75: User-Agent: libcurl-agent-base-elements-plugin/3.2 0xa9: Accept: */* 0xb6: Content-Type: application/hal+json 0xda: X-CSRF-Token: q3LKwzWvNtlP2_X79TpJATfEnOB8HV-_lDaVCiTK8gg 0x115: Content-Length: 353 0x12a: => Send data, 0x161 bytes (0x161) 0000: " {\"_links\":{\"type\":{\"href\":\"http://dev.mskcc.org/rest/ty 0x40: pe/node/event\"}},.. \"field_event_type\":[{\"value\":\"Seminar 0x80: \"}],.. \"title\":[{\"value\":\"Sister Cells that Feast and Fas 0xc0: t --- Why Growth and Repair May Not be Fair XI\"}],.. \"field_s 0x100: hared_datetime\":[{\"value\":\"2016-06-13T17:15:00\"}],.. \"typ 0x140: e\":[{\"target_id\":\"event\"}]}" == Info: upload completely sent off: 353 out of 353 bytes <= Recv header, 0x1a bytes (0x1a) 0000: HTTP/1.1 400 Bad Request <= Recv header, 0xf bytes (0xf) 0000: Server: nginx <= Recv header, 0x24 bytes (0x24) 0000: Content-Type: application/hal+json <= Recv header, 0x1c bytes (0x1c) 0000: Transfer-Encoding: chunked <= Recv header, 0x18 bytes (0x18) 0000: Connection: keep-alive <= Recv header, 0x18 bytes (0x18) 0000: Keep-Alive: timeout=10 <= Recv header, 0x33 bytes (0x33) 0000: Cache-Control: must-revalidate, no-cache, private <= Recv header, 0x1a bytes (0x1a) 0000: X-UA-Compatible: IE=edge <= Recv header, 0x16 bytes (0x16) 0000: Content-language: en <= Recv header, 0x21 bytes (0x21) 0000: X-Content-Type-Options: nosniff <= Recv header, 0x1d bytes (0x1d) 0000: X-Frame-Options: SAMEORIGIN <= Recv header, 0x28 bytes (0x28) 0000: Expires: Sun, 19 Nov 1978 05:00:00 GMT <= Recv header, 0x25 bytes (0x25) 0000: Date: Wed, 03 Aug 2016 11:02:45 GMT <= Recv header, 0x2 bytes (0x2) 0000: <= Recv data, 0x40 bytes (0x40) 0000: 35 00x4: {"error":"The type link relation must be specified.”} <——— here's the error 0x3b: 0 0x3e: == Info: Closing connection 0 BE_Response_Headers returned: HTTP/1.1 400 Bad Request Server: nginx Content-Type: application/hal+json Transfer-Encoding: chunked Connection: keep-alive Keep-Alive: timeout=10 Cache-Control: must-revalidate, no-cache, private X-UA-Compatible: IE=edge Content-language: en X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN Expires: Sun, 19 Nov 1978 05:00:00 GMT Date: Wed, 03 Aug 2016 11:02:45 GMT
  8. fmresultsetjson.xsl

    Version 1.0.0

    7 downloads

    XSLT to convert Filemaker's REST web-service XML response into clean JSON https://twitter.com/alantrewartha 2017-03-06 Adapted from the original Six Fried Rice XSLT here http://sixfriedrice.com/wp/products/filemaker-to-json-converter/ Changed: * single quotes to JSON-standard double-quotes * removed "fieldDefinitions" block (personal preference) * stopped every field value being presented as an [ array ] even when not a "repeating field" * added whitespace escaping code The white-space escaping code was entirely cribbed from https://github.com/doekman/xml2json-xslt/blob/master/xml2json.xsl

    Free

  9. View File fmresultsetjson.xsl XSLT to convert Filemaker's REST web-service XML response into clean JSON https://twitter.com/alantrewartha 2017-03-06 Adapted from the original Six Fried Rice XSLT here http://sixfriedrice.com/wp/products/filemaker-to-json-converter/ Changed: * single quotes to JSON-standard double-quotes * removed "fieldDefinitions" block (personal preference) * stopped every field value being presented as an [ array ] even when not a "repeating field" * added whitespace escaping code The white-space escaping code was entirely cribbed from https://github.com/doekman/xml2json-xslt/blob/master/xml2json.xsl Submitter AlanTrewartha Submitted 03/06/2017 Category Solutions FM Version FM Version: 0  
  10. Version 1.0.0

    26 downloads

    Being unsatisfied with solutions I found on the internet and wanting a solution without plugin I created a set of custom functions that can read a path out of a json-string. Syntax: json_path ( json-string ; path ) examples: json_path( $user_prefs ; "Privileges/Modules" ) json_path( $json_data ; "Menus/Menu[10]/MenuItem[5]/Label" )

    Free

  11. View File read json custom function without plugin, FileMaker only Being unsatisfied with solutions I found on the internet and wanting a solution without plugin I created a set of custom functions that can read a path out of a json-string. Syntax: json_path ( json-string ; path ) examples: json_path( $user_prefs ; "Privileges/Modules" ) json_path( $json_data ; "Menus/Menu[10]/MenuItem[5]/Label" ) Submitter macjos Submitted 09/30/2016 Category Samples FM Version FM Version: 14  
×

Important Information

By using this site, you agree to our Terms of Use.