{"id":101459,"date":"2021-02-09T11:57:49","date_gmt":"2021-02-09T02:57:49","guid":{"rendered":"https:\/\/support.questetra.com\/?p=101459"},"modified":"2021-10-05T17:06:36","modified_gmt":"2021-10-05T08:06:36","slug":"json-string-extract-value-using-json-path","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/json-string-extract-value-using-json-path\/","title":{"rendered":"JSON String, Extract Value using JSON-Path"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">JSON String, Extract Value using JSON-Path<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Extracts value from JSON using JSON Path. It is used when extracting necessary data from JSON received by the Incoming Webhook function. It is also possible to set the path to get multiple values.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> A: Set JSON Text<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B: Set JSON Path to Extract Value (e.g. &#8220;$.id&#8221;)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> C: Select STRING or NUMERIC that stores Extracted Value (update)<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/*\nNotes:\n- JSONPath is a query language for JSON, similar to XPath for XML.\n    - A JSONPath expression specifies a path to an element (or a set of elements) in a JSON.\n    - Paths can use the dot notation: &quot;$.store.book[0].title&quot; or &quot;$[&#39;store&#39;][&#39;book&#39;][0][&#39;title&#39;]&quot;\n- JSON is an abbreviation for &quot;JavaScript Object Notation&quot; and a widely used data exchange format.\n- Assuming an element set, specify a multiline string type to store extracted value.\n- In getting as a number data, numeric parsing depends on JavaScript parseFloat().\n    - https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseFloat\n- If the path to the object or array is configured, the value cannot be obtained.\n    - Output Sample: &quot;[object Object],[object Object]&quot;\n- JSON PATH Online Evaluator\n    - http:\/\/jsonpath.com\/\n- Example1\n    - { &quot;id&quot;: &quot;8PT59XXXXX68743YYYYYCATA&quot;, &quot;resource&quot;: { &quot;id&quot;: &quot;2DC87XXXXX52041YY&quot; } }\n    - Config PATH: &quot;$.resource.id&quot;\n    - Return Value: &quot;2DC87XXXXX52041YY&quot;\n- Example2\n      {\n        &quot;etag&quot;: &quot;abcdefgh&quot;,\n        &quot;members&quot;: [{\n          &quot;etag&quot;: &quot;ijklmnop&quot;,\n          &quot;email&quot;: &quot;example1@example.com&quot;\n        },\n        {\n          &quot;etag&quot;: &quot;qrstuvwx&quot;,\n          &quot;email&quot;: &quot;example2@example.com&quot;\n        }]\n      }\n    - Config PATH: &quot;$.members[*].email&quot;\n    - Return Value (required Multiline String pocket):\n      example1@example.com\n      example2@example.com\n\nNotes(ja):\n- JSONPath \u3068\u306f XPath \u306b\u4f3c\u305f JSON \u30c7\u30fc\u30bf\u7528\u306e\u30af\u30a8\u30ea\u8a00\u8a9e\u3067\u3059\u3002\n    - JSONPath \u5f0f\u306f\u3001JSON \u30c7\u30fc\u30bf\u5185\u306e\u8981\u7d20\uff08\u307e\u305f\u306f\u8981\u7d20\u30bb\u30c3\u30c8\uff09\u3078\u306e\u30d1\u30b9\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\n    - \u30c9\u30c3\u30c8\u8868\u8a18\u7b49\u3067\u8a2d\u5b9a\u3055\u308c\u307e\u3059: &quot;$.store.book[0].title&quot; or &quot;$[&#39;store&#39;][&#39;book&#39;][0][&#39;title&#39;]&quot;\n- JSON \u3068\u306f &quot;JavaScript Object Notation&quot; \u306e\u7565\u3067\u3059\u3002\u5e83\u304f\u666e\u53ca\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u4ea4\u63db\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u3059\u3002\n- \u8981\u7d20\u30bb\u30c3\u30c8\u304c\u60f3\u5b9a\u3055\u308c\u308b\u5834\u5408\u3001\u683c\u7d0d\u5148\u306b\u306f\u8907\u6570\u884c\u6587\u5b57\u5217\u578b\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u6307\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n- \u6570\u5024\u3068\u3057\u3066\u53d6\u5f97\u3057\u305f\u3044\uff08\u6570\u5024\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u6307\u5b9a\u3057\u305f\uff09\u5834\u5408\u3001JavaScript parseFloat() \u3067\u89e3\u91c8\u3055\u308c\u307e\u3059\u3002\n    - https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseFloat\n- \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3084\u914d\u5217\u3078\u306e\u30d1\u30b9\u304c\u8a2d\u5b9a\u3055\u308c\u305f\u5834\u5408\u3001\u5024\uff08Value\uff09\u306f\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002\n    - \u53d6\u5f97\u4f8b\uff1a &quot;[object Object],[object Object]&quot;\n*\/\n\n\n\/*\nAPPENDIX\n- https:\/\/goessner.net\/articles\/JsonPath\/index.html#e2\n    - $\n    - the root object\/element\n    - @\n    - the current object\/element\n    - . or []\n    - child operator\n    - ..\n    - recursive descent. JSONPath borrows this syntax from E4X.\n    - *\n    - wildcard. All objects\/elements regardless their names.\n    - []\n    - subscript operator.\n    - XPath uses it to iterate over element collections and for predicates.\n    - In Javascript and JSON it is the native array operator.\n    - [,]\n    - Union operator in XPath results in a combination of node sets.\n    - JSONPath allows alternate names or array indices as a set.\n    - [start:end:step]\n    - array slice operator borrowed from ES4.\n    - ?()\n    - applies a filter (script) expression.\n    - ()\n    - script expression, using the underlying script engine.\n*\/\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strJsonText      = configs.get( &quot;StrConfA&quot; ); \/\/ required\n  if( strJsonText    === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A JsonText} is empty \\n&quot; );\n  }\nconst strJsonPath      = configs.get( &quot;StrConfB&quot; ); \/\/ required\n  if( strJsonPath    === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {B JsonPath} is empty \\n&quot; );\n  }\nconst multiPocketJsonValue = configs.getObject( &quot;SelectConfC&quot; ); \/\/ required\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nconst objJsonText   = JSON.parse( strJsonText );\nconst arrJsonValues = jsonPath( objJsonText, strJsonPath );\nengine.log( &quot; AutomatedTask: # of JsonValues: &quot; + arrJsonValues.length );\n\nlet strJsonValues  = &quot;&quot;;\nfor( let i = 0; i &lt; arrJsonValues.length; i++ ){\n  strJsonValues   += arrJsonValues[i].toString();\n  if( i !== arrJsonValues.length - 1 ){\n    strJsonValues += &quot;\\n&quot;;\n  }\n}\nlet numJsonValue   = parseFloat( strJsonValues );\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( multiPocketJsonValue.matchDataType( &quot;STRING&quot; ) ){\n  engine.log( &quot; AutomatedTask: Pocket for JsonValue is STRING type&quot; );\n  engine.setData( multiPocketJsonValue, strJsonValues );\n}else{\n  engine.log( &quot; AutomatedTask: Pocket for JsonValue is NUMERIC type&quot; );\n  engine.setData( multiPocketJsonValue, new java.math.BigDecimal( numJsonValue ) );\n}\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\n\/\/\/\/\/\/\/\/\/\/ (source) https:\/\/code.google.com\/archive\/p\/jsonpath\/downloads\n\/* JSONPath 0.8.0 - XPath for JSON\n *\n * Copyright (c) 2007 Stefan Goessner (goessner.net)\n * Licensed under the MIT (MIT-LICENSE.txt) licence.\n *\/\nfunction jsonPath(obj, expr, arg) {\n  var P = {\n    resultType: arg && arg.resultType || &quot;VALUE&quot;,\n    result: [],\n    normalize: function(expr) {\n      var subx = [];\n      return expr.replace(\/[\\[&#39;](\\??\\(.*?\\))[\\]&#39;]\/g, \n                          function($0,$1){return &quot;[#&quot;+(subx.push($1)-1)+&quot;]&quot;;})\n                 .replace(\/&#39;?\\.&#39;?|\\[&#39;?\/g, &quot;;&quot;)\n                 .replace(\/;;;|;;\/g, &quot;;..;&quot;)\n                 .replace(\/;$|&#39;?\\]|&#39;$\/g, &quot;&quot;)\n                 .replace(\/#([0-9]+)\/g, function($0,$1){return subx[$1];});\n    },\n    asPath: function(path) {\n      var x = path.split(&quot;;&quot;), p = &quot;$&quot;;\n      for (var i=1,n=x.length; i&lt;n; i++)\n         p += \/^[0-9*]+$\/.test(x[i]) ? (&quot;[&quot;+x[i]+&quot;]&quot;) : (&quot;[&#39;&quot;+x[i]+&quot;&#39;]&quot;);\n      return p;\n    },\n    store: function(p, v) {\n      if (p) P.result[P.result.length] = P.resultType == &quot;PATH&quot; ? P.asPath(p) : v;\n      return !!p;\n    },\n    trace: function(expr, val, path) {\n      if (expr) {\n        var x = expr.split(&quot;;&quot;), loc = x.shift();\n        x = x.join(&quot;;&quot;);\n        if (val && val.hasOwnProperty(loc))\n          P.trace(x, val[loc], path + &quot;;&quot; + loc);\n        else if (loc === &quot;*&quot;)\n          P.walk(loc, x, val, path, function(m,l,x,v,p) { P.trace(m+&quot;;&quot;+x,v,p); });\n        else if (loc === &quot;..&quot;) {\n          P.trace(x, val, path);\n          P.walk(loc, x, val, path,\n                 function(m,l,x,v,p) {\n                   typeof v[m] === &quot;object&quot; && P.trace(&quot;..;&quot;+x,v[m],p+&quot;;&quot;+m);\n                 }\n          );\n        }\n        else if (\/,\/.test(loc)) { \/\/ [name1,name2,...]\n          for (var s=loc.split(\/&#39;?,&#39;?\/),i=0,n=s.length; i&lt;n; i++)\n            P.trace(s[i]+&quot;;&quot;+x, val, path);\n        }\n        else if (\/^\\(.*?\\)$\/.test(loc)) \/\/ [(expr)]\n          P.trace(P.eval(loc, val, path.substr(path.lastIndexOf(&quot;;&quot;)+1))+&quot;;&quot;+x, val, path);\n        else if (\/^\\?\\(.*?\\)$\/.test(loc)) \/\/ [?(expr)]\n          P.walk(loc, x, val, path, \n             function(m,l,x,v,p) {\n               if (P.eval(l.replace(\/^\\?\\((.*?)\\)$\/,&quot;$1&quot;),v[m],m)) P.trace(m+&quot;;&quot;+x,v,p);\n             }\n          );\n        else if (\/^(-?[0-9]*):(-?[0-9]*):?([0-9]*)$\/.test(loc))\n          \/\/ [start:end:step]  phyton slice syntax\n          P.slice(loc, x, val, path);\n      }\n      else\n        P.store(path, val);\n    },\n    walk: function(loc, expr, val, path, f) {\n      if (val instanceof Array) {\n        for (var i=0,n=val.length; i&lt;n; i++)\n          if (i in val)\n            f(i,loc,expr,val,path);\n      }\n      else if (typeof val === &quot;object&quot;) {\n        for (var m in val)\n          if (val.hasOwnProperty(m))\n            f(m,loc,expr,val,path);\n      }\n    },\n    slice: function(loc, expr, val, path) {\n      if (val instanceof Array) {\n        var len=val.length, start=0, end=len, step=1;\n        loc.replace(\/^(-?[0-9]*):(-?[0-9]*):?(-?[0-9]*)$\/g,\n            function($0,$1,$2,$3){\n              start=parseInt($1||start);end=parseInt($2||end);step=parseInt($3||step);\n            });\n        start = (start &lt; 0) ? Math.max(0,start+len) : Math.min(len,start);\n        end   = (end &lt; 0)   ? Math.max(0,end+len)   : Math.min(len,end);\n        for (var i=start; i&lt;end; i+=step)\n           P.trace(i+&quot;;&quot;+expr, val, path);\n      }\n    },\n    eval: function(x, _v, _vname) {\n      try { return $ && _v && eval(x.replace(\/@\/g, &quot;_v&quot;)); }\n      catch(e) { throw new SyntaxError(&quot;jsonPath: &quot; + e.message + &quot;: &quot; +\n                 x.replace(\/@\/g, &quot;_v&quot;).replace(\/\\^\/g, &quot;_a&quot;)); }\n    }\n  };\n  var $ = obj;\n  if (expr && obj && (P.resultType == &quot;VALUE&quot; || P.resultType == &quot;PATH&quot;)) {\n    P.trace(P.normalize(expr).replace(\/^\\$;\/,&quot;&quot;), obj, &quot;$&quot;);\n    return P.result.length ? P.result : false;\n  }\n} \n\/\/\/ JSONPath end\n\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAECUlEQVRYR8WXbUiVZxjHf4+6KKu5\nXFgsh0GaLDTKIGS0Zg2K9iEoGvQyqzXjnEbZFgOxDyF9iAxxErRz\/HC0dM0gWHS+iWJtFlRgeraS\nrdVIyiWGHns5uWPZE9dz9uB53k6PEZz743Nf1\/\/+X2\/\/+34UkrwU1+fXk47KRhRWobIUhfnArP\/9\nw6jcRaEblQso\/IKHZ26wX0+gkbmMUQF4galuQIH\/AD9TqOYrBhL5JCbgx4tCDTDd5cFmswgq3+PF\n7+TvTKCeH4E9b3iw2c2Hh2\/ssOwJ+PkZhS1v6fAYjEoLXraaMa0EEkQ+852Z7P5oNxvmbyAvI4\/0\ntHQN7+HoQ0LDIZpvNXPu7rlEvC2ZMBKI1dxnh1CxpIIDhQfImpbleMC4Ok5oKMTBawdpvd9qb6ey\nJ74nJgjEuv22ueEk6sCnAS3qtJQ0V1UJR8Mc7TnKsdAxO\/sIU8jVp2OCQD0\/AN+aPU6VnGJb3jZS\nlVTD1pPnT7g6eJX8jHyyZ2SjYEzmyNgIldcq8ffaDkAdHr4TwJiXiAwMmee8alkVkvqpqcbxj7yI\naGk+fuM4i2YtIrg2yIJ3F1iivff0Hjsv7qTj3w7znujE+yJWMQJ+vkShOd5qYcZCDTj\/vXwL8INn\nD9hxcQdt99u0vZtf3NSImJeKypnbZ9jaYWl+mYpSvPykZyAA7IoHqFxSyaFlhyzRi400W7AvSPnl\ncvYV7KO8oNzWTmz7nvaxuX0zVwavmPk14OFrPQPXUVgab3F+7XnW56x31XSJjEZfjFLVVWVtSJVu\nvBTpGRiOu1g0vK6NXRTNLnLElvT2hntputWkZWDe9Hm2ti\/Vl\/h6fey9vNe8H8ZDpk5ANe861VXs\nBkcHqf2jluqealZ\/sJqmVU2OBMQ+8GeAst\/KrAQ9KJMmIBFdGrikRd\/wVwOiE2+DgKUErZ+3siZ7\njWMJ+iP9bL+wXdtPRCA6HuVI9xEOXz+coAR+LE1YU1zD\/oL9jurnlsBwdBhvp5ez\/5w1EjA1oWUM\n1324jsaSRuZMm2ObBbcEOgc6WRlcaYdhGEOLEInHyZKTlOaVkqKkGABEB+48vkPZr7HGkrsiNyPX\nIsePxh5pcixTYKNSBiGylWJRt5bPWlicudjgr0evS6yQPLHihNaQ+hKSp\/8+rSmmzTJJsVg4XEZS\nCt8nPnJm5BjARWBEC2RJhuRtoF9I8l1kelPbJuTSslmmy0gsHK5j2SrOKqbu4zqWZy23pNkMLsRk\nPCX1Doc7XMeClOBBItuSatH+wsxCg\/ZLxCPREdr726n9vdZO9yd4Oj5IdBOXj1FRQJFfqXXPUI8m\nTC7Wa55kOkJSH6WTzISLqMVkks\/yiUwk8cdEJ5HUX7P4\/Cbt59Rlkd\/U7BWT2KQwuv+VjAAAAABJ\nRU5ErkJggg==\n\" alt=\"\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/1d7ikDyVQflmUFQ8y9yow_SmWWhyp0gVk\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Json-String-Extract-Value-using-Json-Path.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-02-09 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/json-string-extract-value-using-json-path\/\">https:\/\/support.questetra.com\/en\/addons\/json-string-extract-value-using-json-path\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Addon-import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>JSONPath is a query language for JSON, similar to XPath for XML.<ul><li>A JSONPath expression specifies a path to an element (or a set of elements) in a JSON.<\/li><li>Paths can use the dot notation: &#8220;<code>$.store.book[0].title<\/code>&#8221; or &#8220;<code>$['store']['book'][0]['title']<\/code>&#8220;<\/li><\/ul><\/li><li>JSON is an abbreviation for &#8220;JavaScript Object Notation&#8221; and a widely used data exchange format.<\/li><li>Assuming an element set, specify a multiline string type to store extracted value.<\/li><li>In getting as a number data, numeric parsing depends on JavaScript parseFloat().<ul><li><a href=\"https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseFloat\" rel=\"nofollow\">https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/parseFloat<\/a><\/li><\/ul><\/li><li>If the path to the object or array is configured, the value cannot be obtained.<ul><li>Output Sample: &#8220;<code>[object Object],[object Object]<\/code>&#8220;<\/li><\/ul><\/li><li>JSON PATH Online Evaluator<ul><li><a href=\"http:\/\/jsonpath.com\/\" rel=\"nofollow\">http:\/\/jsonpath.com\/<\/a><\/li><\/ul><\/li><li>Example1<br><code>{ \"id\": \"8PT59XXXXX68743YYYYYCATA\", \"resource\": { \"id\": \"2DC87XXXXX52041YY\" } }<\/code><ul><li>Config PATH: &#8220;<code>$.resource.id<\/code>&#8220;<\/li><li>Return Value: &#8220;<code>2DC87XXXXX52041YY<\/code>&#8220;<\/li><\/ul><\/li><li>Example2 <br><code>{ \"etag\": \"abcdefgh\", \"members\": [{ \"etag\": \"ijklmnop\", \"email\": \"example1@example.com\" }, { \"etag\": \"qrstuvwx\", \"email\": \"example2@example.com\" }] }<\/code><ul><li>Config PATH: &#8220;<code>$.members[*].email<\/code>&#8220;<\/li><li>Return Value (required Multiline String pocket):<br><code>example1@example.com<br>example2@example.com<\/code><\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Json-String-Extract-Value-using-Json-Path-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"101463\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/json-string-extract-value-using-json-path\/attachment\/json-string-extract-value-using-json-path-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Json-String-Extract-Value-using-Json-Path-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Json-String-Extract-Value-using-Json-Path-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Json-String-Extract-Value-using-Json-Path-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Json-String-Extract-Value-using-Json-Path-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Extracts value from JSON using JSON Path. It is used when extracting necessary data from JSON received by the Incoming Webhook function. It is also possible to set the path to get multiple values.\" class=\"wp-image-101463\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Json-String-Extract-Value-using-Json-Path-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Json-String-Extract-Value-using-Json-Path-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Json-String-Extract-Value-using-Json-Path-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/Json-String-Extract-Value-using-Json-Path-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/goessner.net\/articles\/JsonPath\/index.html#e2\" rel=\"nofollow\">https:\/\/goessner.net\/articles\/JsonPath\/index.html#e2<\/a><\/li><li><strong><code>$<\/code><\/strong><ul><li>the root object\/element<\/li><\/ul><\/li><li><strong><code>@<\/code><\/strong><ul><li>the current object\/element<\/li><\/ul><\/li><li><strong><code>.<\/code><\/strong> or <strong><code>[]<\/code><\/strong><ul><li>child operator<\/li><\/ul><\/li><li><strong><code>..<\/code><\/strong><ul><li>recursive descent. JSONPath borrows this syntax from E4X.<\/li><\/ul><\/li><li><strong><code>*<\/code><\/strong><ul><li>wildcard. All objects\/elements regardless their names.<\/li><\/ul><\/li><li><strong><code>[]<\/code><\/strong><ul><li>subscript operator.<\/li><li>XPath uses it to iterate over element collections and for predicates.<\/li><li>In Javascript and JSON it is the native array operator.<\/li><\/ul><\/li><li><strong><code>[,]<\/code><\/strong><ul><li>Union operator in XPath results in a combination of node sets.<\/li><li>JSONPath allows alternate names or array indices as a set.<\/li><\/ul><\/li><li><strong><code>[start:end:step]<\/code><\/strong><ul><li>array slice operator borrowed from ES4.<\/li><\/ul><\/li><li><strong><code>?()<\/code><\/strong><ul><li>applies a filter (script) expression.<\/li><\/ul><\/li><li><strong><code>()<\/code><\/strong><ul><li>script expression, using the underlying script engine.<\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"esjWdVu9ZW\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-addon-xml-file-extract-configs\/\">Questetra-Addon-XML file, Extract Configs<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cQuestetra-Addon-XML file, Extract Configs\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/questetra-addon-xml-file-extract-configs\/embed\/#?secret=fgxyvxfrDt#?secret=esjWdVu9ZW\" data-secret=\"esjWdVu9ZW\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Extracts value from JSON using JSON Path. It is used when extracting necessary data from JSON received by the Incoming Webhook function. It is also possible to set the path to get multiple values.<\/p>\n","protected":false},"author":2,"featured_media":101460,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Extracts value from JSON using JSON Path. It is used when extracting necessary data from JSON received by the Incoming Webhook function. It is also possible to set the path to get multiple values.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[378],"faq_section":[],"class_list":["post-101459","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-json-parse"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":1,"uagb_excerpt":"Extracts value from JSON using JSON Path. It is used when extracting necessary data from JSON received by the Incoming Webhook function. It is also possible to set the path to get multiple values.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-qor","jetpack-related-posts":[{"id":70070,"url":"https:\/\/support.questetra.com\/en\/addons\/jsonvalue-extractor\/","url_meta":{"origin":101459,"position":0},"title":"Single Value from a JSON object using JSONPath","author":"Hirotaka NISHI","date":"2018-07-17","format":false,"excerpt":"Download JsonValue-Extractor.xmlSince Rhino (deprecated) is specified as the script engine, a setting error will occur even if you install this in a workflow AppTo use this Add-on, you need to change the script engine and modify the script accordinglyPlease refer to Notice Concerning Deprecation of Rhino for the method for\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/07\/single-value-from-json-object-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/07\/single-value-from-json-object-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/07\/single-value-from-json-object-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/07\/single-value-from-json-object-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/07\/single-value-from-json-object-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":72184,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/box-webhook\/","url_meta":{"origin":101459,"position":1},"title":"Monitoring Uploads to Folders Using Box Webhook","author":"Hirotaka NISHI","date":"2018-11-28","format":false,"excerpt":"Introducing three items concerning Box Webhook. Utilizing those three items, I will create an App sample that monitors uploads to the specified folder.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":71399,"url":"https:\/\/support.questetra.com\/en\/addons\/microsoft-teams-add-on\/","url_meta":{"origin":101459,"position":2},"title":"Posting to Microsoft Teams from Workflow","author":"Tsuyoshi Kusaka","date":"2018-09-06","format":false,"excerpt":"Summarized a linkage between Microsoft Team and Questetra BPM Suite","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/microsoft-teams-questetra-1200-675.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/microsoft-teams-questetra-1200-675.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/microsoft-teams-questetra-1200-675.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/microsoft-teams-questetra-1200-675.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/09\/microsoft-teams-questetra-1200-675.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78739,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/receive-task-webhook\/","url_meta":{"origin":101459,"position":3},"title":"Receive Task (Webhook)","author":"Hirotaka NISHI","date":"2019-10-01","format":false,"excerpt":"Holds the token and awaits a webhook (HTTP request) at a specific URL. Advances the token when a webhook for the specified HTTP method is received. Capable of storing the received request body in a String-type Data Item. Also possible to return an HTTP response with Business Data inserted.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/bpmn-icon-receive-task-webhook-1200x675.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84047,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/download-process-file\/","url_meta":{"origin":101459,"position":4},"title":"Download Case Files Using the Workflow API","author":"Peter Glover","date":"2020-05-22","format":false,"excerpt":"Here is a script that searches for a Case that matches the conditions and downloads the file attached to the Case.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/workflow-api-file-download-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/workflow-api-file-download-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/workflow-api-file-download-featured-image.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/workflow-api-file-download-featured-image.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/workflow-api-file-download-featured-image.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70597,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-salesforce\/","url_meta":{"origin":101459,"position":5},"title":"How to Use Customer Data in Salesforce as Options","author":"HatanakaAkihiro","date":"2018-08-16","format":false,"excerpt":"How to check details of selected customer data on Salesforce.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/101459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=101459"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/101459\/revisions"}],"predecessor-version":[{"id":114763,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/101459\/revisions\/114763"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/101460"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=101459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=101459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=101459"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=101459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}