fmSMS Now Supports New Quiubas SMS API

fmSMS now supports the new Quiubas SMS API. Quiubas originally started as an SMS Gateway delivering to Mexico and now delivers to other countries in Latin America, including:

  • Argentina
  • Bolivia
  • Brazil
  • Chile
  • Colombia
  • Costa Rica
  • Cuba
  • Dominican Republic
  • Ecuador
  • El Salvador
  • Guadalupe
  • Guatemala
  • Haiti
  • Honduras
  • Martinique
  • Mexico
  • Nicaragua
  • Panama
  • Paraguay
  • Peru
  • Puerto Rico
  • Uruguay
  • Venezuela

You can download a trial version of fmSMS to test with the Quiubas SMS Gateway from here – please get in touch if you have any questions about using fmSMS and the updated Quiubas SMS Gateway

2018 – Another Big Year for APIs

2018 was another big year for the API (application programming interface) economy – the ProgrammableWeb directory, which tracks APIs, passed the 19,000-API mark in January of 2018 and currently sits at 20,653 on the last day of 2018. There has been an explosion in growth in the last 5 years, with more than 2,000 APIs being added every year to their directory.

Earlier this year I attended the annual Xero Developer Roadshow in Melbourne and this slide caught my attention (apologies for the resolution/quality):

Xero released their first API in 2007 – the first cloud accounting API – and now receive more than 450 million API calls each month! There was another slide showing the number of ASW Servers they deploy for handling these API calls, which from memory was in the hundreds but could have been in the thousands.

Gartner have been talking about the concept of an API economy for a number of years and that businesses should put APIs at the centre of their digital business platform. An API economy is an enabler for turning a business or organisation into a platform which is something we’ve seen with APIs like the Xero API, which now has 40,000 active developer partners and over 700 certified application partners.

2018 also saw FileMaker, Inc. ship the FileMaker Data API as part of FileMaker Server/Cloud 17 platform. This is the first REST API (Representational State Transfer) from FileMaker which makes connecting other applications and web services much easier. You can now choose your programming language of choice when connecting to the FileMaker Data API – you can even use a FileMaker client such as FileMaker Pro or FileMaker Go which we’ve done on a number of projects (see our earlier article if you’re wondering why you would do this).

We specialise in FileMaker integration here at Databuzz, which more often than not means working with APIs. We’re typically connecting FileMaker to another platform such as Xero for accounting integration or Shopify for ecommerce integration, allowing our customers to easily exchange information between different platforms and streamlining business workflows.

Looking back at the projects we’ve worked on in 2018 here’s a partial list of the APIs that we connected the FileMaker platform to over the last 12 months:

We already have a few projects lined up for 2019 which will see us working on some new APIs for the first time. Now that the FileMaker platform can easily integrate with APIs, both as a client and as a server, working on integration projects has never been easier.

If you would like to discuss integrating FileMaker with an API for your business please get in touch for a free initial consultation to discuss your requirements.

Using DocuSign Webhooks to Push Completed PDF files to FileMaker Server

Earlier this year we wrote about how you can integrate FileMaker with DocuSign, the leading electronic signature platform, to automate the electronic document signing workflow using the FileMaker platform. In that article and video we demonstrated how you could generate a PDF from a FileMaker layout with merge fields then send a document signing request to the recipient using the DocuSign API, all from within FileMaker Pro.

At the time we were manually downloading the completed/signed PDF from DocuSign once we received the email notification from DocuSign that it had been completed. Since that article we done a number of FileMaker/DocuSign integrations and had some requests to automate the downloading of the completed PDF so users don’t need to manually download this. There’s two main options available here – Polling or Webhooks:

  • Polling involves making a request to DocuSign for the current status of an envelope. For example you could create a FileMaker Server scheduled script to run periodically to check the status of a DocuSign request, and then if it is completed download the final PDF. You are limited to checking the status of each envelope to once every 15 minutes – polling rates are checked by DocuSign and exceeding this limit can lead to failures with the automated review process
  • Webhooks are the preferred option as DocuSign can automatically notify you when the status of a DocuSign envelope changes. You don’t have to make unnecessary polling requests to continually check the status of an envelope – DocuSign will notify your application via the URL you specify when setting up your particular webhook.

In our experience we receive the Webhook notification within 15-30 seconds on average after the event without having to make any requests to DocuSign. We just wait for the notification from DocuSign that a request has been completed and then download the completed PDF into a FileMaker container field. We’ve written about how we use Webhooks for some of our other solutions, including XeroWooCommerce and Shopify to be automatically notified of specified events, such as a new online order or a customer payment. Using DocuSign Webhooks is another example of how you can automate your business workflows and remove any unnecessary polling requests.

Here’s a short video showing the ‘Envelope Signed/Completed’ Webhook in action (you can also watch it on YouTube here):

If you would like to discuss integrating DocuSign with your FileMaker solution please get in touch for a free initial consultation to discuss your requirements.

 

fmEcommerce Link (WooCommerce Edition) Now Supports Order Uploads


Since we first released fmEcommerce Link (WooCommerce Edition) back in 2016 we’ve had a number of requests from customers asking us to include the ability to upload Orders from FileMaker to WooCommerce. fmEcommerce Link was created from a solution we built for our own business to solve a very pressing problem at the time – automate the downloading of Orders from WooCommerce into FileMaker so we didn’t have to manually enter these one-by-one.

At the time we didn’t see a huge need for having the ability to go the other way, as the whole point of WooCommerce is to handle online orders from your website. Having spoken with our customers who were requesting this and also having used fmEcommerce Link in our own business for a few years we can now see some scenarios where it would be helpful to have the ability to upload Orders entered in FileMaker to WooCommerce, including:

  • not all Orders for your products are entered directly into WooCommerce by all customers. Some customers might receive your product as part of a larger consulting project, or have to use payment methods that are not accepted on your store.
  • sometimes you just need to send the customer to your store to pay for an Order without wanting them to start from scratch and select the various products, add them to the cart and complete the checkout page. There is a way to create an Order for a customer and send them the link to the customer payment page so all they need to do is enter their credit card/payment details (see video below)
  • you might have orders from legacy systems that pre-date your WooCommerce store which you wish to upload so WooCommerce is in sync with your CRM software, allowing customers to be able to login and download updates and see their full history

Having had to enter a number of Orders manually into WooCommerce over the past few years we saw the light and started work on an update to fmEcommerce Link that includes the ability to upload Orders from FileMaker to WooCommerce. We’re pleased to announce that v1.53 of fmEcommerce Link (WooCommerce Edition) is now available as a free update for all existing customers.

When working with Order uploads to WooCommerce please be aware of the following:

  • the tax fields are “read only” in the API so when you upload an Order we then download the updated details from WooCommerce which include the tax amounts that WooCommerce calculates automatically
  • Coupons are not applied when they are included in an Order upload with the REST API v2 that we currently support, so we’ve decided not to include them to avoid any confusion. The REST API v3 that was recently released includes some changes around Automatic total calculations when applying/removing coupons, so this is something we will included when we release an update designed to work with the v3 API
  • if you want to delete an Order Line item you don’t delete the line item in FileMaker – just set the Qty to 0 and include that when uploading and WooCommerce will remove it from the Order for you

Here’s a video showing the Order upload in action, including the ability to retrieve the URL for the customer payment page if you wish to send your customer a link to pay for an Order you create in FileMaker.

 

You can view the full release notes on our version history page.

fmAccounting Link (MYOB AccountRight Edition) v1.3 Update

We’ve just released an update to fmAccounting Link (MYOB AccountRight Edition), our FileMaker solution for integrating with MYOB AccountRight in Australia and New Zealand. Version 1.3 is a big release packed with lots of new examples. Here’s some of the highlights:

  • added Sale Orders examples (download and upload Sale Orders)
  • added Supplier Payments examples (download and upload Supplier Payments)
  • added Inventory Adjustments examples (download and upload Inventory Adjustments)
  • added Inventory Item Price Matrix (Custom Price Levels) examples (download and update Custom Price Levels)
  • added new button/script to just get the Contact Balances from MYOB
  • added button to download current balance from MYOB for an Invoice
  • added button to download any Customer Payments from MYOB for an Invoice

Once again this is a free update for all existing customers. You can view the full release notes on our version history page.

fmEcommerce Link (Shopify Edition) Now Runs Natively on FileMaker 16/17 Platform and supports Order Creation Webhooks

 

We’re pleased to announce that v1.3 of fmEcommerce Link (Shopify Edition) is now available and includes a number of new features, including native support for FileMaker Pro v16 and later. This is a free update to all existing customers (simply download using the same link that was on your original order email).

With the release of the FileMaker 16 platform we got a number of new functions and script steps, including support for working with JSON data and being able to specify supported cURL options with the Insert From URL script step. These new features meant that we were no longer dependent on plug-in functions and we could replace these with native FileMaker features.

We’ve updated all the requests for downloading and uploading to the Shopify API to use native FileMaker functions and script steps so you no longer need to use a FileMaker plug-in if you’re using FileMaker Pro v16 or higher. This means you can also use fmEcommerce Link on FileMaker Go natively (requires FileMaker Go 16 or higher).

Like our previous updates for native FileMaker functionality for our other products we’ve simply updated the scripts to check which version of FileMaker Pro, FileMaker Go or FileMaker Server is being used and if you’re using v15 or earlier we simply use the previous plug-in functionality, and if you’re using v16 or later we now use native functionality. Everything works exactly the same regardless of which version of FileMaker Pro you’re using, but we can now include support for FileMaker Go as well as having one less dependency to worry about.

This release also includes support for Shopify Webhooks – see our earlier post for a short video demonstrating how the Order Creation Webhook works. Instructions for setting up the Order Creation Webhook can be found here.

You can get all the details on our version history page – we’re continuing to work on adding native FileMaker 16 support to our other products, as well as some further updates to fmEcommerce Link (Shopify Edition) including support for processing Fulfilments in FileMaker and uploading to Shopify.

Databuzz 2018 End of Year Xmas Sale – 20% Off All Licenses

 

The Databuzz End of Year Xmas Sale is now on – all Product Licenses are now 20% off, including:

Use the coupon XMAS2018 at checkout on any purchase and the 20% discount will be applied to your order. The sale runs until the end of the day on January 04, 2019 (Australian Eastern Daylight Time). Click here to start shopping.

Free trial versions are available for all of our products – please contact us to request a trial version. We’ve updated all of our products in the past few weeks with new features, including:

All our prices are in Australian dollars – if you’re purchasing from outside of Australia you’ll also get to take advantage of the low Australian dollar (1 Australian Dollar equals approximately 0.72 US Dollars).

We also have a similar sale on fmSMS Licenses (20% off) – click here to visit the fmSMS website for further details.

Xero surpasses one million subscribers across Australia and New Zealand

The announcement this week by Xero, the global small business platform (it no longer positions itself as just an accounting platform) that it had surpassed one million subscribers across Australia and New Zealand made me check where our fmAccounting Link (Xero Edition) customers are located.

We now have hundreds of customers around the world using our fmAccounting Link (Xero Edition) solution every day to automate the exchange of data between Xero and the FileMaker platform. Typical integrations involve automating the uploading of Contacts, Invoices, Bills, and Purchase Orders and the downloading of Payments, all at the click of a button or automated via FileMaker Server schedules.

Last time we mapped our fmAccounting Link (Xero Edition) customers in February 2017 Xero had a total of 862,000 subscribers spread across their four main market regions of:

  • Australia
  • New Zealand
  • UK
  • North America

with Australian and New Zealand being the two largest markets and our customer map reflected this spread.

Xero now has 1.6 million subscribers in over 180 countries, including 355,000 in the UK. We’ve just updated our map again:

and we now have many more pins in the same four markets, with a few in South Asia as well as South Africa. We’re noticing an increase in interest from Canada, the United States and South Asia where Xero is just getting started in the market. According to Xero the penetration of cloud accounting sits at around 40 percent in Australia and New Zealand, more than double what it is worldwide.

We expect as other regions adopt cloud accounting at the rate we have here in Australia and New Zealand that Xero will continue to grow it’s subscriber base worldwide. We look forward to revisiting the Xero subscriber numbers in 12 months time and updating our customer map again.

fmEcommerce Link (Shopify Edition) and Webhooks

We will be releasing a new version of fmEcommerce Link (Shopify Edition) in the next few days – this is our long awaited update that includes native functionality for the FileMaker v16 platform and later so you don’t need to use a plug-in anymore. This means you can use the fmEcommerce Link solution on any FileMaker client application: FileMaker Go, FileMaker Pro/Pro Advanced, FileMaker Server and FileMaker WebDirect.

As part of this update we’re also including a number of features that have been requested by our users, including support for Shopify Webhooks. Webhooks allow you to trigger an action when a specified event happens on your Shopify store. Our first webhook will be an ‘Order Creation’ webhook which will send the Order details automatically to your fmEcommerce Link file and create the Order automatically without you having to manually download the Order.

You could setup a FileMaker Server schedule that ran every x minutes that checked for new orders since a specified timestamp, but it’s much more efficient to leverage Webhooks if they are available and receive notifications when new orders are created on your store.

We’ll be releasing a free update to fmEcommerce Link (Shopify Edition) later this week which will include support for Webhooks when a new Order is created. You will need to setup a Webhook and install the supplied PHP file on your FileMaker Server (you will need to enable Custom Web Publishing/PHP in your FileMaker Server Admin Console), and once this in place anytime a new Order is received in Shopify it will automatically be pushed to the fmEcommerce Link file, typically within a few seconds. N.B. your webhook address must use HTTPS – HTTP addresses are not supported by Shopify.

You can get more information about Shopify Webhooks at the following links:

https://help.shopify.com/en/api/getting-started/webhooks

https://help.shopify.com/en/api/getting-started/webhooks#through-store-admin

Here’s a short video demonstrating this in action (you can also watch this on YouTube here). If you have any other Webhooks you would like us to support please let us know.

WordCamp Brisbane 2018 Recap

Last month I attended WordCamp Brisbane 2018, my second WordCamp for 2018 after attending WordCamp Sydney earlier this year. WordCamps are informal, community-organised events which are heavily subsidised (think $50 tickets for 2 days of sessions and meals, including the after party!) thanks to the conference sponsors, making them very accessible for attendees.

I was fortunate to be selected to speak at WordCamp Brisbane 2018 and gave a presentation on WooCommerce REST API Integration, which included some details on version 3 of the WooCommerce REST API that was released the week of the conference. You can get a copy of my slides here and the videos from the conference are already available on YouTube and will shortly be available on WordPress.tv.

Once my presentation was over I was able to relax a bit more and enjoy attending the sessions. I tried to cover a wide range of WordPress related topics including podcasting, security and copywriting, as well as the sessions covering the upcoming WordPress v5.0 and the new Gutenberg editor.

Like WordCamp Sydney I learnt a lot and made lots of new friends in the WordPress community – a big thanks to all the organisers, sponsors, volunteers and speakers for making it happen and producing such a well run conference.