Parsley aims to allow you to parse CSV files, JSON Objects, JSON Arrays, XML Documents, and XLSX files into InfoTables as painlessly as possible, without needing a predefined data shape. The Parsley Extension for ThingWorx provides a Parsley Resource with the following services:
- ParseJSON
- ParseCSV
- ParseXML
- ParseXLSX
Note that ParseXLSX is rudimentary and expects a simple grid of data. It also requires the Apache POI libraries, which conflict with some other extensions. A Parsley_No_Poi zip is also included in this directory.
This extension utilizes the Thingworx 6.6.5 SDK.
- From a web browser, launch ThingWorx.
- Log into ThingWorx as an administrator.
- Go to Import/Export > Import.
- Click Choose File and select Parsley_ExtensionPackage.zip
- Click Import.
Note: If an Import Successful message does not display, contact your ThingWorx System Administrator.
- Click Yes to refresh Composer after importing the final extension.
- Confirm that the Extension has been imported properly. Check the Application Log for potential problems.
The Parsley Extension can be used by invoking any one of the following services through the Snippets tab when creating a new Service on any ThingWorx entity: • ParseJSON • ParseCSV
These services can be used to parse a JSON object or CSV file directly into an InfoTable result.
This extension was tested for compatibility with the following ThingWorx Platform version(s) and Operating System(s):
- ThingWorx 6.6.5+