• Facebook
  • Skype
  • Mail
  • Linkedin
Providing Custom Business Apps since 2014
Bespoke Business Apps
  • Home
  • Development
  • Our Work
  • Our Story
  • Latest News
  • Free Consultation
  • Search
  • Menu

FileMaker Data API and Portal Filters

May 24, 2019/0 Comments/in FileMaker /by StevenAdmin

We’re currently working on a project where we are exposing the FileMaker Data API to some web technologies. The team working on the Web side of things have asked for the portal data passed back by the Data API to be filtered between a date range.

To do this with a relationship would mean having the current date in every parent record and we’d need to update this daily. Not the smartest way but it would work.

However we wondered if portal filters would work and sure enough the JSON passed back by the Data API was filtered based on the portal filter we placed on the layout.

tldr; You can use portal filters on a FileMaker layout and this will translate over to the FileMaker Data API response.

We also discovered that if you give your portal an object name, this too will be reflected in the Data API response object

{
 "response": {
  "data": [
   {
    "fieldData": {...},
    "portalData": {
     portalLayoutObjectName: [...],
    },
    ...
   },
   {...}
  ]
 },
 "messages": {...}
 "fieldData": "...",
 "portalData": 
 ...
}

Tags: data-api, filemaker, filters, portal
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on Google+
  • Share on Pinterest
  • Share on Linkedin
  • Share on Tumblr
  • Share on Vk
  • Share on Reddit
  • Share by Mail
You might also like
A CSV Parser that converts CSV into JSON on the FileMaker Pro Platform. fm-csv2json
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

  • FileMaker Data API and Portal Filters
  • fm-csv2json
  • FileMaker Web Direct Clock
  • fm-mime-types
  • fm-xml2json

Recent Comments

  • Tkakeshi Nakano on fm-xml2json
  • Takeshi Nakano on fm-xml2json
  • menno on fm-xml2json
  • tuxun on fm-mime-types
  • Neil Nguyen on fm-xml2json

Archives

  • May 2019
  • April 2019
  • March 2019
  • June 2018

Categories

  • FileMaker
  • fmapi
  • News

Bespoke Business Apps

We provide Bespoke Business Apps tailored to how you run your business.

We utilise our highly specialised Certified FileMaker Developers to create elegant and efficient Business Apps that transform your business processes and fulfil your custom business needs.

Based around the Central Belt of Scotland, UK.

Head Office

Units 18/19
Waverley Street Industrial Estate
Bathgate
United Kingdom
EH48 4HY

Email Us!

Latest Work

  • Shift.online – Booking ScreenApril 3, 2020 - 12:04 am
  • MCR PathwaysMCR PathwaysMCR Pathways – Local Authority UpgradeMarch 6, 2018 - 5:55 pm
  • MCR PathwaysMCR PathwaysMCR PathwaysJuly 27, 2016 - 3:05 pm
  • Callum Innes StudioCallum Innes StudioCallum Innes StudioJune 27, 2016 - 3:03 pm
  • BusinessMan ERPComputech IT ServicesBusinessMan ERPApril 1, 2013 - 4:26 pm

Sitemap

  • Bespoke Business Apps
  • Development Process
  • Free Consultation
  • Latest News
  • Our Story
  • Our Work
  • Privacy Policy
©2018 WhiteSpace Systems. All rights reserved. - powered by Enfold WordPress Theme
  • Facebook
  • Skype
  • Mail
  • Linkedin
fm-csv2json A CSV Parser that converts CSV into JSON on the FileMaker Pro Platform.
Scroll to top

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.

OKLearn more

Cookie and Privacy Settings

How we use cookies

We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.

Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.

Essential Website Cookies

These cookies are strictly necessary to provide you with services available through our website and to use some of its features.

Because these cookies are strictly necessary to deliver the website, you cannot refuse them without impacting how our site functions. You can block or delete them by changing your browser settings and force blocking all cookies on this website.

Other external services

We also use different external services like Google Webfonts, Google Maps and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.

Google Webfont Settings:

Google Map Settings:

Vimeo and Youtube video embeds:

Privacy Policy

You can read about our cookies and privacy settings in detail on our Privacy Policy Page.

Privacy Policy