Jump to content
Sign in to follow this  
liamob1

Google authentication (Without a plugin)

Recommended Posts

I'm looking for a method of authenticating with google via FileMaker. I would like to run post commands via the Insert from URL command to allow my FMDB to publish Cal Events to a specific calendar. Realistically I'd want this to be automatic when an appointment is assigned on the system. 

At the moment, I can get a post to work, but it returns an error. I imagine this is because the authentication hasn't taken place. 

Has anyone managed to get a working OAuth 2.0 setup/Google Login on Filemaker that will work with POST and GETs. 

Once I've got Calendar to work, then I want to start on Drive and Gmail. 

Thanks! :)

Share this post


Link to post
Share on other sites

There are a few plugins that can help you here.  A good one is the free BaseElements one.

The 'insert from url' can take you a fair part of the road but it does not allow you for instance to set the custom headers for an HTTP POST that are usually required for interacting with such an API.

Share this post


Link to post
Share on other sites
31 minutes ago, Wim Decorte said:

There are a few plugins that can help you here.  A good one is the free BaseElements one.

The 'insert from url' can take you a fair part of the road but it does not allow you for instance to set the custom headers for an HTTP POST that are usually required for interacting with such an API.

 

I've been using the insert from URL for the POST and GET communication, however, I'm getting a bad request return from Google because of the authentication. It's literally the OAuth I need to calculate. 

One thing I should mention is, we want this to work on iPads, using Go? I'm starting to wonder if its going to be possible. 

Share this post


Link to post
Share on other sites

You may be able to do it using javascript in a web viewer on Go, or you can use PSoS and use a plugin server-side.

You can't do oAuth authentication through the "insert from URL", because of what I mentioned: you can't set the custom headers that are required.

Share this post


Link to post
Share on other sites
Just now, Wim Decorte said:

You may be able to do it using javascript in a web viewer on Go, or you can use PSoS and use a plugin server-side.

You can't do oAuth authentication through the "insert from URL", because of what I mentioned: you can't set the custom headers that are required.

 

I see!! I've not played with POST and GET commands much until now. I will attempt something with those two methods. 

Thanks for your help!

Share this post


Link to post
Share on other sites

You can use 'Perform Script on Server', and have the plug-in installed on the server, to get around the fact that FM Go does not support plug-ins.

Or you could wait for FM 16 since FMI's roadmap shows built-in support for the commands that you are currently relying on the plug-in for. They say they will include 'Enhanced cURL options — Provides cURL options to configure HTTP/HTTPS calls that work with REST APIs.' in the next version.

Share this post


Link to post
Share on other sites
1 minute ago, rwoods said:

You can use 'Perform Script on Server', and have the plug-in installed on the server, to get around the fact that FM Go does not support plug-ins.

Or you could wait for FM 16 since FMI's roadmap shows built-in support for the commands that you are currently relying on the plug-in for. They say they will include 'Enhanced cURL options — Provides cURL options to configure HTTP/HTTPS calls that work with REST APIs.' in the next version.

 

Music to my ears!! I might have to just wait for a little while. I have enough to develop in the mean time! 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By troi
      Internet plug-in for FileMaker 17 further streamlines OAuth authorization on macOS.
       
        Alphen aan den Rijn, the Netherlands, March 20, 2019–Troi today announced the immediate availability of Troi URL Plug-in 6.0 for FileMaker 17.
      What is Troi URL Plug-in?
      Troi URL Plug-in can help you fill in forms on internet, all from FileMaker Pro. It also retrieves data or images from web sites.
      use the POST command to fill in a web form and retrieve the result directly in FileMaker Pro use the GET command to retrieve data use the PUT command to to transfer files or upload data to web servers use the DELETE command to delete items on web servers use a secure connection (HTTPS) using SSL get access to password protected web pages, including web services that require OAuth authorization get JPEG, PNG and GIF images directly into a container field specify cookies and proxy server settings send tweets to Twitter with ease! What is new in version 6.0?
      We rewrote Troi URL Plug-in for FileMaker 17 and it now has the following new functionality:
      Tested and made compatible with FileMaker Pro 17.0.4. Added new TURL_AuthorizeWithCallbackScript function, which lets a user authorize Troi URL Plug-in to use a web service, for example Twitter. After authorization a script is triggered with a script parameter which contains the access token and secret. By storing these you can then use the web service (like sending a tweet). Currently this is a macOS only function. (Windows) Added code signing to the plug-in for Windows. (On macOS code signing was already added in version 5.0). The plug-in now indicates if an external script step is compatible with a product. The step is shown in grey if it is incompatible for that product (for example for iOS) in the script editing pane (center) and the script steps pane (right). (macOS) Prepared the plug-in for notarization: the plug-in can now be added to a runtime, to create a hardened FileMaker runtime app which can be notarized by Apple. Notarization gives users more confidence, as the runtime has been checked by Apple for malicious components. Modernized the code, made small bug fixes and updated the User Guide and example files. IMPORTANT (macOS only) The minimum supported FileMaker version is now FileMaker Pro 14. Also the minimum supported Mac OS version is now OS X 10.9 (Mavericks). You can keep using v5.x for older versions of FileMaker Pro or Mac OS X. (macOS) The plug-in no longer has the 32-bit code included. More detailed information on all changes and improvements implemented in Troi URL Plug-in 6.0 can be found on the URL Plug-in page.
      Pricing & Availability
      A fully functional demo version of Troi URL Plug-in 6.0 is available on the URL Plug-in page.
      Licenses cost US$ 79 per user. Details on developer licenses and multi-user discounts can be found on the URL Plug-in page. You can order licenses from our shop.
      Upgrade information
      Version 6.0 needs a new registration. The upgrade is free for users who bought a license for Troi URL Plug-in on or after June 26, 2017. Eligible users will be sent a new registration. Contact us if you have not received yours after March 22, 2019.
      Upgrades from licenses bought before June 26, 2017 are available from US$ 49 per user. Upgrade prices for other licenses can be found in the shop. You can order upgrades there.
    • By Richard Carlton
      We have a new fix for Google Maps in FMSP & the FMI Contacts Starter Solution
      Vid 1 - Getting your API Key:

      Vid 2 - FMI Contacts Starter Solution Fix

      Vid 3 - FMSP Fix

      Get up to speed with the FileMaker Video Training Course!
      FileMaker is a cross-platform relational database application from FileMaker Inc. https://en.wikipedia.org/wiki/FileMaker
      Top Rated Course by FileMaker Expert, Richard Carlton.
      http://learningfilemaker.com/fmpro17.php
      Customer relationship management, processes implemented to manage a company's interactions with customers and prospects
      https://en.wikipedia.org/wiki/CRM
      Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions.
      The course is 50 hours of video content!
      Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide.
      Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers.
      He has offices in California, Nevada, and Texas.
      Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.
      Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.
      Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
      Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.
      RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA.
      http://www.rcconsulting.com/
      Contact us at support@rcconsulting.com
      FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
      Transform your business with the FileMaker Platform
      https://sites.google.com/site/filemakerprotrainingd2n/home/filemaker-training
      Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
      FileMaker Training -FileMaker Video Training Course-FileMaker News-FileMaker Experts
      https://www.youtube.com/watch?v=RO3Do8QIQOE
      https://www.youtube.com/watch?v=RO3Do8QIQOE&index=2&list=PLjTvUZtwtgBTWVT38kPvgjCfkZmMmvCOk&t=25s
      FileMaker What's New-Top Ten Things To Know About FileMaker -FileMaker News
      https://youtu.be/6ZcnQEOF9XE
      https://www.youtube.com/watch?v=6ZcnQEOF9XE&index=1&list=PLjTvUZtwtgBTWVT38kPvgjCfkZmMmvCOk&t=25s
      Sharing a FileMaker Solution-The Basics-Sharing FileMaker Database-FileMaker Experts
      https://youtu.be/a5o5Mt8DnFI
      https://www.youtube.com/watch?v=a5o5Mt8DnFI&index=9&list=PLjTvUZtwtgBQukMafXx60CF5rcXwNmGWl&t=0s
      A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
      Official site SDK, Developer's Guide, Reference, and Android Market for the open source project
      http://learningfilemaker.com/FIAS.html
      Video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw
      Free FileMaker videos check out ...http://www.filemakervideos.com
      Download the FileMaker Pro & FileMaker GO for mobile devices training videos at http://www.learningfilemaker.com
      Download FileMaker Go video training at http://learningfilemaker.com/FMGO-17/index.php
      Download FileMaker Full Video Training Bundle at http://learningfilemaker.com/subscription.php
      Learn how to use FileMaker to create an app with the FileMaker Training Series
      Comment, Like & Share All of Our Videos.
      Feel Free to Embed any of Our Videos on Your Blog or Website.
      Follow Us on Your Favorite Social Media
      Facebook
      Twitter
      Google+
      #FileMakerGoogleMaps
      #FileMakerAPI
      #FileMakerGoogleMapsAPI
      #FileMakerFreeVideoTraining
      #FileMakerTrainingVideos
      #FilemakerProTraining
      #FileMakerVideoTutorial
      #FileMakerProVideos
    • By Peter Wagemans
      I try to login this morning with google authentication, and the login dialog does not go away. All the rest is standard: Safari comes to the foreground, asks if it can authenticate, I click the OK button. But nothing happens.
      I tried
      restarting FileMaker restarting Safari relogin to Google account another browser ( Vivaldi ) restarting the Mac throwing away com.filemaker.client.advanced12.plist I tried on my old MacBook ( I switched to a new one recently ) and there everything works correctly.
      Next thing I will try is to start throwing away caches, but I wonder: did anyone experience this already? How did you solve it? Please do not tell me I have to reinstall my Mac...:-)
    • By margolisd
      Hi. I just tried implementing OAuth using Google for FM16. When I set up my OAuth client ID on Google I stupidly put HTTPS instead of HTTP in the URL of our Filemaker server. So when I clicked on sign in with Google from FM I get an error 400 from Google.
      So I went back to my Google Console and fixed the URL. Everything saved fine. But still when I click on sign in with Google from FM it tries to use the incorrect address with HTTPS. It's like it is cached in a preference somewhere and I don't know how to get rid of it. So far I have:
      Restarted FMS Restarted the server Turned off Google under client authentication, restarted the server and started again. Tried a fresh install of FM Client on a different computer. Completely deleted my credentials in Google and started with a fresh client ID and done all the above again. Still it tries to use the wrong URL for my server. Although the URL has updated with my new client ID from Google.
      I have ran out of ideas. Any help appreciated.
×
×
  • Create New...

Important Information

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