02-28-2017 07:24 AM
None of these tools are “official” or truly supported. If it breaks, you get to keep the pieces.
Disclaimer aside:
First, re-evaluate why you are writing a JSON Path Expression. Try using a mapper, or several mappers to solve your problem. Understand how to use the Mapping Root in the Mapper. If you must, continue on.
As per the docs, http://jsonpath.com/ is a good place to start. However, it can be a little tricky to use at times, and will occasionally stop live evaluating.
Another site to consider is https://jsonpath.curiousconcept.com/. This one works quite well, but can be a touch opaque at times as to why things are failing.
GitHub - json-path/JsonPath: Java JsonPath implementation is a good place to see examples of JSON Path in action.
http://json.parser.online.fr/ is a great graphical JSON Parser and will show you exactly where you’ve gone wrong.
http://mockbin.org/bin/create lets you create a mock REST Endpoint and define the response. Make sure to set the response content-type
header to application/json
if you want to parse the results into a SnapLogic object. You can use http://mockbin.org/bin/(your random string here)/log to explore the requests that SnapLogic is making to your new “API”.
This is not for the faint of heart, in the cloud, anyway.
The best way that I know of is https://getsandbox.com/. This is doubly true if you have a WSDL already. However, you will have to mess with your WSDL so that the bindings point to your new sandbox. Also please note that the free account on this site is time limited.
If you have to create your own WSDL, the only one I know of is Free online WSDL generator. But, you’ll need to edit it so that it’s recognised by the getsandbox.com WSDL parser.
http://regexr.com is a good place to build patterns that are compatible with SnapLogic’s implementation of Regular Expressions.
Have you got your own useful utility websites? Add them to the comments and I’ll edit them in with credit.