{"id":75,"date":"2015-10-21T23:17:00","date_gmt":"2015-10-21T23:17:00","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=75"},"modified":"2025-09-23T23:00:11","modified_gmt":"2025-09-23T23:00:11","slug":"jsonpath-examples-expression-cheetsheet","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/","title":{"rendered":"JSONPath Expression Examples – JSON Cheatsheet (SSIS \/ ODBC)"},"content":{"rendered":"

What is JSONPath expression<\/h2>\n

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

<\/h2>\n

<\/h2>\n

 <\/p>\n

Sample data for JSONPath expression<\/h2>\n

All examples of JSONPath expression in this post will use the following sample JSON for reference.<\/p>\n

\n
{\r\n\u00a0 \"store\": {\r\n\u00a0 \u00a0 \"books\": [\r\n\u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"category\": \"reference\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"author\": \"Nigel Rees\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"title\": \"Sayings of the Century\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"price\": 8.95,\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"sections\": [\"s1\", \"s2\", \"s3\"],\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"publicationDay\": \"2023-05-10\"\r\n\u00a0 \u00a0 \u00a0 },\r\n\u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"category\": \"fiction\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"author\": \"Evelyn Waugh\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"title\": \"Sword of Honour\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"price\": 12.99,\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"sections\": [\"s4\", \"s1\", \"s3\"],\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"publicationDay\": \"2022-08-10\"\r\n\u00a0 \u00a0 \u00a0 },\r\n\u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"category\": \"fiction\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"author\": \"Herman Melville\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"title\": \"Moby Dick\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"isbn\": \"0-553-21311-3\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"price\": 8.99,\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"sections\": [\"s1\"],\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"publicationDay\": \"1851-10-11\"\r\n\u00a0 \u00a0 \u00a0 },\r\n\u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"category\": \"fiction\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"author\": \"J. R. R. Tolkien\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"title\": \"The Lord of the Rings\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"isbn\": \"0-395-19395-8\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"price\": 22.99,\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"sections\": [\"s8\", \"s9\"],\r\n\u00a0 \u00a0 \u00a0 \u00a0 \"publicationDay\": \"1954-07-12\"\r\n\u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 ],\r\n\u00a0 \u00a0 \"time\": {\r\n\u00a0 \u00a0 \u00a0 \"starttime\": \"8:00\",\r\n\u00a0 \u00a0 \u00a0 \"endtime\": \"18:00\"\r\n\u00a0 \u00a0 }\r\n\u00a0 }\r\n}<\/pre>\n<\/div>\n
JSONPath Examples<\/h2>\n
\/\/get all books for store\r\n$.store.books[*]\r\n                     \r\n\/\/get all sections from all books\r\n$.store.books[*].sections[*]     \r\n\r\n\/\/get all authors of all books for store\r\n$.store.books[*].author  \r\n             \r\n\/\/get 3rd book record \r\n$.store.books[2]    \r\n\r\n\/\/get first 2 books from the top\r\n$.store.books[:2]   \r\n\r\n\/\/get last 2 books\r\n$.store.books[-2:]\r\n  \r\n\/\/get all books where author attribute equals to 'sam'\r\n$.store.books[?(@author=='Nigel Rees')] \r\n\r\n\/\/get all documents \/ sub documents (any level) where author attribute equals to 'sam'\r\n$..[?(@author=='Nigel Rees')] \r\n\r\n\/\/get books where price is less than 10\r\n$.store.books[?(@.price<10)] \r\n\r\n\/\/filter all books with tag\r\n$.store.books[?(@.tag)]\r\n\r\n\/\/find all books which contains section s1 or s2 (Use of Logical operator OR ( || )\r\n$.store.books[?(@.sections[*]=='s1' || @.sections[*]=='s2' )]\r\n\r\n\/\/find all books where first section is s1 and second section is s2 (Logical operator OR ( && )\r\n$.store.books[?(@.sections[0]=='s1' && @.sections[1]=='s2' )]\r\n\r\n\/\/ Find all books where the publication day is before 2000-01-01\r\n$.store.books[?(@.publicationDay < '2000-01-01')]\r\n\r\n<\/pre>\n
JSON Path – Using Regular Expressions (Regex)<\/h2>\n
The new version of SSIS PowerPack and ODBC PowerPack Supports Regular expressions in the path. Learn more about Regular expressions check this article<\/a><\/p>\n
\/\/Using Regular Expression: get all books where author attribute contains 'Nigel' or 'Waugh'\r\n\/\/Learn more about regular expressions here : https:\/\/zappysys.com\/blog\/using-regular-expressions-in-ssis\/\r\n$.store.books[?(@author=~ \/Nigel|Waugh\/  )] \r\n\r\n\/\/Using Regular Expression: get all books where category is 'reference' OR author attribute contains 'Nigel' or 'Waugh'\r\n$.store.books[?(@category=='reference' || @author=~ \/Nigel|Waugh\/ )] \r\n\r\n\/\/Using Regular Expression: get all books where category is 'reference' AND author attribute contains 'Nigel' or 'Waugh'\r\n$.store.books[?(@category=='reference' && @author=~ \/Nigel|Waugh\/ )] \r\n\r\n\/\/Using Regular Expression: get all books where author name either start with 'Nigel' (see ^ prefix) or ends with 'Waugh' (see $ suffix)\r\n\/\/Learn more about regular expressions here : https:\/\/zappysys.com\/blog\/using-regular-expressions-in-ssis\/\r\n$.store.books[?(@author=~ \/^Nigel|Waugh$\/  )] \r\n\r\n\/\/Using Regular Expression: get all books where author name starts with 'Nigel'\r\n\/\/Learn more about regular expressions here : https:\/\/zappysys.com\/blog\/using-regular-expressions-in-ssis\/\r\n$.store.books[?(@author=~ \/^Nigel\/  )] \r\n\r\n\/\/Using Regular Expression: get all books where author name ends with 'Waugh'\r\n\/\/Learn more about regular expressions here : https:\/\/zappysys.com\/blog\/using-regular-expressions-in-ssis\/\r\n$.store.books[?(@author=~ \/Waugh$\/  )] \r\n<\/pre>\n
JSON Path – Nested Scan for any level (double dots)<\/h2>\n
Now lets look at example of below JSON. Assume that you like to extract information from all nested “children<\/strong>”\u00a0 nodes (basically extract id and name of every child from any level).<\/p>\n
You can use double dots without specifying parent heirarchy like below to scan recusrsivly.<\/p>\n
$..children[*]<\/span><\/p>\n
\n
{\r\n\u00a0 \"children\": [\r\n\u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \"id\": 1,\r\n\u00a0 \u00a0 \u00a0 \"name\": \"c1\",\r\n\u00a0 \u00a0 \u00a0 \"children\": [\r\n\u00a0 \u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"id\": 2,\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"name\": \"c2\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"children\": [\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 {\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"id\": 3,\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"name\": \"c3\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"children\": [\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 { \"id\": 4, \"name\": \"c4\" },\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 { \"id\": 5, \"name\": \"c5\" }\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ]\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ]\r\n\u00a0 \u00a0 \u00a0 \u00a0 }\r\n\u00a0 \u00a0 \u00a0 ]\r\n\u00a0 \u00a0 }\r\n\u00a0 ]\r\n}<\/pre>\n<\/div>\n
For this you can write following JSON Path<\/p>\n
$..children[*]<\/span><\/p>\n
OR (below to find all children where name is c1 or c2 or c3)<\/p>\n
$..children[?(@name=~ \/c1|c2|c3\/ )]<\/span><\/p>\n
Here is an example of a JSON Driver in ODBC. The same expression can be used in SSIS too.<\/p>\n
\"ODBC<\/a>
ODBC JSON Driver – Using Filter with Regular Expressions \/ JSONPath<\/p><\/div>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
<\/h2>\n
JSONPath for Root Objects in Array<\/h2>\n
Now lets look at another pattern of JSON where your documents are on the first level rather than under some array property. Root filter only works if you have a version released after Dec-29-2021. Previous version didn’t support filtering on Root Array.<\/p>\n
Example JSON<\/strong><\/p>\n
[\r\n { id:1 , color:'red'},\r\n { id:2 , color:'red'},\r\n { id:3 , color:'blue'},\r\n { id:4 , color:'green'}\r\n]<\/pre>\n
Example JSON Path Filters<\/strong><\/p>\n
$.[0]  \/\/Extract first document\r\n$..[?(@color=='red')]   \/\/Recursive scan (any level) - Extract all documents where color=red use 2 dots after $ for filter\r\n<\/pre>\n
NOTE:<\/strong> using two dots after $ (e.g. $..[zzzz]<\/strong>) invokes nested scan so any level array will return documents, this may not be the acceptable case sometimes but if you want to filter the root array then this is the only way for now in ZappySys.<\/p>\n
If you must not allow recursive scan then you can use the following two properties<\/p>\n
EnableRawOutputModeSingleRow = true;
\nRawOutputDataRowTemplate = “{data: [$1] }”\u00a0 –where [$1] is replaced at runtime with Document Text you like to parse (can be static or URL response)<\/p>\n
OR<\/p>\n
Use functions in\u00a0RawOutputDataRowTemplate if needed<\/p>\n
RawOutputDataRowTemplate = “{data: <<[$1],FUN_BASE64DEC>>}”<\/p>\n
The above will wrap around the actual JSON \/ XML you need to parse so now after this setting you can use JSONPath = $.data[?(@id==1)] to avoid two dots to prevent a recursive scan<\/p>\n","protected":false},"excerpt":{"rendered":"
What is JSONPath expression JSONPath expression is an expression language to filter JSON Data. Its a similar concept to XPath expression in XML but has limited features compared to XPath. If you are extracting data from REST API Services using SSIS JSON \/ XML Source\u00a0or ODBC JSON \/ XML Driver then you will quickly realize […]<\/p>\n","protected":false},"author":1,"featured_media":2223,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,11],"tags":[6,18,279,161,95,3,12,4],"yoast_head":"\r\nJSONPath Expression Examples - JSON Cheatsheet (SSIS \/ ODBC) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"In this post you will see many JSONPath examples. Learn various features of JSONPath expression language to filter JSON data. Download JSONPath cheat sheet.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"JSONPath Expression Examples - JSON Cheatsheet (SSIS \/ ODBC) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"In this post you will see many JSONPath examples. Learn various features of JSONPath expression language to filter JSON data. Download JSONPath cheat sheet.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2015-10-21T23:17:00+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-09-23T23:00:11+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/07\/how-to-180x180.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"150\" \/>\r\n\t<meta property=\"og:image:height\" content=\"150\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/\",\"url\":\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/\",\"name\":\"JSONPath Expression Examples - JSON Cheatsheet (SSIS \/ ODBC) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/07\/how-to-180x180.png\",\"datePublished\":\"2015-10-21T23:17:00+00:00\",\"dateModified\":\"2025-09-23T23:00:11+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"In this post you will see many JSONPath examples. Learn various features of JSONPath expression language to filter JSON data. Download JSONPath cheat sheet.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/07\/how-to-180x180.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/07\/how-to-180x180.png\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JSONPath Expression Examples – JSON Cheatsheet (SSIS \/ ODBC)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"JSONPath Expression Examples - JSON Cheatsheet (SSIS \/ ODBC) | ZappySys Blog","description":"In this post you will see many JSONPath examples. Learn various features of JSONPath expression language to filter JSON data. Download JSONPath cheat sheet.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/","og_locale":"en_US","og_type":"article","og_title":"JSONPath Expression Examples - JSON Cheatsheet (SSIS \/ ODBC) | ZappySys Blog","og_description":"In this post you will see many JSONPath examples. Learn various features of JSONPath expression language to filter JSON data. Download JSONPath cheat sheet.","og_url":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2015-10-21T23:17:00+00:00","article_modified_time":"2025-09-23T23:00:11+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/07\/how-to-180x180.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/","url":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/","name":"JSONPath Expression Examples - JSON Cheatsheet (SSIS \/ ODBC) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/07\/how-to-180x180.png","datePublished":"2015-10-21T23:17:00+00:00","dateModified":"2025-09-23T23:00:11+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"In this post you will see many JSONPath examples. Learn various features of JSONPath expression language to filter JSON data. Download JSONPath cheat sheet.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/07\/how-to-180x180.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/07\/how-to-180x180.png","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/jsonpath-examples-expression-cheetsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"JSONPath Expression Examples – JSON Cheatsheet (SSIS \/ ODBC)"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/75"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":24,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":11484,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions\/11484"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2223"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}