This site uses tracking cookies. By using this site, you agree to our Privacy Policy. If you don't opt in, some parts of the site might not function.
Blog
Home / Blog / FileMaker / Your Guide to Using the FileMaker Data API to Enhance Your Application
03Apr 2018

Your Guide to Using the FileMaker Data API to Enhance Your Application

About the Author

Wim Decorte Wim Decorte

Wim is a Senior Technical Architect at Soliant. He is a FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15 and 16 Certified FileMaker Developer and the author of numerous Tech Briefs and articles on FileMaker Server. Wim is one of the very few multiple FileMaker Excellence Award winners and was most recently awarded the FileMaker Community Leader of the Year award at the 2015 FileMaker Developer Conference. He is also a frequent speaker at the FileMaker Developer Conference and at FileMaker Developer groups throughout the world. In addition to being a renowned expert on FileMaker Server, Wim also specializes in integrating FileMaker with other applications and systems. His pet project is the open source fmDotNet connector class that he created.

Comments (2)

A Kim - April 14, 2018

How do I parse JSON in FMP to get the first object whose value is a certain string. For example if in the FMP example, how would I find the price of the first bakery item whose name contains “Chocolate?

Reply
    Wim Decorte
    Wim Decorte - May 9, 2018

    The FileMaker JSON parsing features do not support the use of wildcards, that means that in order to find what you describe you have to iterate over the json to find what you need. You can do that by looping in a script or by creating a recursive custom function.

Leave a Reply