REST API Starter Kit"The World is just a collection of REST API end points." Charles Edge Precursor founder Alex Narvey has been working with REST APIs for many years now and has presented on his work at MacTech Conference L.A. and MacDevOps YVR. At Precursor Systems, we use APIs to enrich our clients' customer support experience by providing them with a secure and searchable online portal where they can examine work orders, look up inventory specs, get a list of Microsoft 365 licensing accounts, get software serial numbers and more. We also use APIs to generate an automated monthly report PDF which encapsulates information from various services like DNSFilter, Hudu, Mosyle, munkireport, Slack, Trello, ZenDesk, and more. And we even use APIs to provide our clients with a DarkWeb Scan report. This page describes the API solutions we have worked on and provides links to starter templates and other resources for those who are interested. Monthly Reporter - DarkWeb Scanner - Archiware P5 - DNSFilter - Hudu - Mosyle - MunkiReport - Slack - Trello - Watchman Monitoring - Zendesk - FAQ Monthly Reporter Precursor Systems Monthly Reporter is a tool created for MacTech Conference L.A. 2019 to demonstrate interacting with several online APIs to generate a nicely formatted executive summary report in FileMaker. 
The PDF report was then emailed and also posted to Slack. 
A video and slides are available at our Seminars page.
Our monthly reporter is now in production and we created a Monthly Report Intro page for our clients that helps them interpret the information.
We built a tool to give each client a DarkWeb scan that provides a summary on the first page and detailed listings for each user after that. 
Each client gets a report annually.
The DarkWeb Scanner was part of our MacTech Conference L.A. 2019 presentation. Slides and video are available from our Seminars page. Look for "Going API with FileMaker".
Precursor Systems Achiware P5 API Query is an tool to interact with Archiware P5 via its API. 
This tool was built on spec for @Matx to quickly view Archive Overviews; We don't currently use it in monthly reporting. The P5 Query FileMaker template is available in our set of sample databases at our Seminars page.
Precursor Systems DNSFilter API Query is an tool to interact with DNSFilter via its API. 
In our monthly report to clients we call out Total Requests and compare it to Blocks. 
The DNSFilter Query FileMaker template is available in our set of sample databases at our Seminars page.
Precursor Systems Hudu API Query is an tool to interact with Hudu via its API. This version can pull out Microsoft 365 licenses (if you have integrated them into your Hudu instance.) 
Our custom client web portal can query FileMaker to give a list of Microsoft licenses. 
The Hudu Query FileMaker template is available in our set of sample databases at our Seminars page.
Precursor Systems Mosyle Query is an tool to interact with the Mosyle MDM via its API. 
In our monthly report to clients we call give a list of Devices in MDM.  
The Mosyle Query FileMaker template is available in our set of sample databases at our Seminars page.
Precursor Systems munkireport Query is an tool to interact with the munkireport database via its API. 
In our monthly report to clients we call show Managed Software and DetectX Stats.  
The MunkiReport Query FileMaker template is available in our set of sample databases at our Seminars page.
Precursor Systems ScoutDNS API Query is an tool to interact with ScoutDNS via its API. 
In our monthly report to clients we call out Total Allowed and compare it to Total Blocked. The ScoutDNS Query FileMaker template is available in our set of sample databases at our Seminars page.
Precursor Systems Slack API Post is an tool to interact with Slack via its API. 
In our MacTech 2019 talk we posted a sample monthly report PDF to Slack.
The Slack Post FileMaker template is available in our set of sample databases at our Seminars page.
Precursor' Auto Triage Board is a tool to link our Zendesk to Trello. 
In our MDOYVR 2020 talk we demonstrated an auto-populating/depopulating Trello board that used Zendesk triggers and Trello Butler Automations to link our trouble tickets in Zendesk to Trello. Trello cards are added when tickets get created in Zendesk and Trello cards are deleted when Zendesk tickets are solved! 
The Recipe is available in as a TextEdit RTF file. Seminars page.
Precursor Systems Watchman API Query is an tool to interact with Watchman Monitoring via its API. 
In our monthly report to clients we call out active warnings. 
At MacDevOps YVR 2019 we showed a FileMaker tool to automate the acquisition and posting of domain name and ssl certificate expiration information to the Watchman Monitoring Expirations area. 
We also use a FileMaker tool to pull inventory reports out of Watchman Monitoring Expirations and make them available on our client's custom web portals. 
The Watchman Query FileMaker template is available in our set of sample databases at our Seminars page.
Precursor Systems Zendesk API Query is an tool to interact with Zendesk via its API. 
In our monthly report to clients we show the number of solved tickets over the last 30 days and the current number of open tickets. 
The Zendesk Query FileMaker template is available in our set of sample databases at our Seminars page.
Frequently Asked Questions Q: Does this solution require Claris FileMaker? A: Yes. You could use the 45 day trial version, but if you are member of the Apple Consultants Network your member benefits include an NFR copy. You also may be able to get an NFR by attending Claris Engage, or by becoming a Claris Partner.
Resources For more help consult:
Monthly Reporter - DarkWeb Scanner - Archiware P5 - DNSFilter - Hudu - Mosyle - MunkiReport - Slack - Trello - Watchman Monitoring - Zendesk - FAQ |
| Mastodon | YouTube | Github | Status |
|
|
|
| Copyright © 2014-24, Precursor.ca, Inc. |