JSONPath Expression Examples – JSON Cheatsheet

What is JSONPath expression

JSONPath expression is an expression language to filter JSON Data. Its similar concept to XPath expression in XML but has limited features compared to XPath. If you are extracting data from REST API Services using JSON Source Connector then you will quickly realize that it’s very important to extract nested data by navigating to a certain level.

Sample data for JSONPath expression

All examples of JSONPath expression in this post will use the following sample JSON for reference.

JSONPath Examples




Posted in SSIS JSON Source (File/REST), SSIS Tips & How-Tos and tagged , , , , .