Can I use webservices to pull in data from external services (HTTP GET)

One of my vendors has a series of web services that I can make use of. However, the format is in XML. What would be the best method to use to pull in this data?

2 Likes

Hi there, Panoply currently doesn’t accept XML data on input so you’ll need to convert it to a supported format first. One such format is JSON. There are some libraries that do this programmatically: https://pypi.python.org/pypi/xmljson, https://github.com/stleary/JSON-java and https://www.npmjs.com/package/xml-js (python, Java and node.js).

Once the data is in a supported format, you can push it panoply using one our SDKs (https://github.com/panoplyio/panoply-python-sdk) or by writing it an S3 bucket and setting up normal Panoply S3 imports.