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 web service integrations and save you considerable time and effort. Contact our sales department for more information on our development services.
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 which we were able to quickly add to their solution. Their existing workflow consisted of manually downloading orders (TXT) from ShipStation and importing into their FileMaker ERP each day. The ShipStation order download only provided limited data. In order to update tracking information 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. We later added code to download orders directly from ShipStation to remove the manual process.
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.