Archive for October, 2020

Let us help you harness the power of APIs with Claris FileMaker Pro

While our primary development efforts at NRG revolve around shipping and carrier APIs, we often assist other Claris developers with projects related to other APIs. With our knowledge of XML and JSON creation and parsing, we can often provide assistance to jumpstart integrations and save considerable time and effort. Contact our sales department for more information on our development services.

ShipStation APIs

We recently did a projet where a customer was implementing NRGship for Endicial Label Server to replace label generation thru ShipStation. The customer wanted to maintain their existing multi-channel order downloads in ShipStation for the time being, but wanted more finite control over label generation from FileMaker. Their workflow consisted of downloading orders (TXT) from ShipStation and importing into their FileMaker ERP. While we were able to quickly add the label generation functionality to their solution, the ShipStation order download only provided limited data. In order to update track info in ShipStation, we needed the order’s internal ID which was not provided in the download. By implementing ShipStation APIs to search for orders, we were able to get the internal ID, and afterwards utilize that ID to update the order and add the appropriate tracking information.

Acuity Scheduling

We responded to a post on FaceBook where a member of the FileMaker community was looking to access their appointment data from the web based Accuity Scheduling system from their FileMaker database. We created a simple database using Insert from URL that would query appointment data and then add or update records in the FileMaker table based on the query result. In addition, another function was created to download client data from Accuity so that it could be used as a Source of Truth for customer information.

Veryfi Invoice Data

We helped another developer who was looking to utlilize the Veryfi API to extract data from PDF invoices. We built scripts which would encode and upload a PDF document from a container field, and then parse out the invoice and line item data from the JSON into FileMaker records.

No Comments


%d bloggers like this: