{"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-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;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><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> 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\/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=\"QigoK5ko7e\"><a href=\"http:\/\/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; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Questetra-Addon-XML file, Extract Configs&#8221; &#8212; Questetra Support\" src=\"http:\/\/support.questetra.com\/addons\/questetra-addon-xml-file-extract-configs\/embed\/#?secret=W2qVW3EFRX#?secret=QigoK5ko7e\" data-secret=\"QigoK5ko7e\" 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],"class_list":["post-101459","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-json-parse"],"jetpack_publicize_connections":[],"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","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_likes_enabled":true,"jetpack-related-posts":[{"id":70075,"url":"https:\/\/support.questetra.com\/ja\/addons\/jsonvalue-extractor\/","url_meta":{"origin":101459,"position":0},"title":"JSONPath \u306b\u3088\u308b JSON Value \u306e\u53d6\u5f97","author":"Hirotaka NISHI","date":"2018-07-17","format":false,"excerpt":"2018-07-10 \u00a9 Questetra, Inc. (MIT License)https:\/\/support.questetra.com\/ja\/addons\/jsonvalue-extractor\/ Download JsonValue-Extractor.xml\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30f3\u30b8\u30f3\u3068\u3057\u3066\u300cRhino\uff08\u5ec3\u6b62\u4e88\u5b9a\uff09\u300d\u304c\u6307\u5b9a\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u30a2\u30d7\u30ea\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3082\u8a2d\u5b9a\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u5229\u7528\u3059\u308b\u306b\u306f\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30f3\u30b8\u30f3\u306e\u5909\u66f4\u3001\u304a\u3088\u3073\u305d\u308c\u306b\u4f34\u3046\u30b9\u30af\u30ea\u30d7\u30c8\u4fee\u6b63\u304c\u5fc5\u8981\u3067\u3059\u5bfe\u5fdc\u65b9\u6cd5\u306f\u3001\u300c\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30f3\u30b8\u30f3 Rhino \u5ec3\u6b62\u306e\u304a\u77e5\u3089\u305b\u300d\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u4fee\u6b63\u7248\u306f\u6e96\u5099\u4e2d\u3067\u3059 Capture Notes JSONPath \u304c\u3001\u8907\u6570\u306e\u5024\uff08\u914d\u5217\u5024\uff09\u3092\u6307\u3057\u793a\u3059\u5834\u5408\u3001\u5148\u982d\u306e\u5024\u304c\u30bb\u30c3\u30c8\u3055\u308c\u307e\u3059\u6587\u5b57\u60c5\u5831\u3092\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3068\u3057\u3066\u683c\u7d0d\u3059\u308b\u969b\u306f parseFloat() \u306e\u4ed5\u69d8\u306b\u6e96\u3058\u307e\u3059\uff08\u201c+3.14\u2033: 3.14\u3001\u201d314e-2\u2033: 3.14\u3001\u201d090\u2033: 90\u3001\u201d2016-12-23\u201d: 2016\u3001\u2019\u6587\u5b57\u59cb\u307e\u308a\u2019: 0 \uff09JSONPath Syntax \u306f\u3001\u3042\u3089\u304b\u3058\u3081\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u3067\u30c6\u30b9\u30c8\u3057\u3066\u304a\u304f\u3053\u3068\u304c\u671b\u307e\u308c\u307e\u3059 http:\/\/jsonpath.com\/","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\/07\/json-value-extractor-header-ja.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\/json-value-extractor-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/07\/json-value-extractor-header-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/07\/json-value-extractor-header-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/07\/json-value-extractor-header-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":95511,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/kintone-choice-download\/","url_meta":{"origin":101459,"position":1},"title":"kintone: \u30ec\u30b3\u30fc\u30c9\u691c\u7d22","author":"Shiho Tatsumi","date":"2024-06-25","format":false,"excerpt":"\u3053\u306e\u5de5\u7a0b\u306f\u3001kintone \u30a2\u30d7\u30ea\u304b\u3089\u691c\u7d22\u30af\u30a8\u30ea\u306b\u5408\u81f4\u3059\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;BPMN\u30a2\u30a4\u30b3\u30f3&quot;","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-kintone.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-kintone.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-kintone.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-kintone.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-kintone.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":74005,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/slack-chat-post-webhook\/","url_meta":{"origin":101459,"position":2},"title":"Slack: \u30c1\u30e3\u30c3\u30c8\u6295\u7a3f\uff08Incoming Webhook\uff09","author":"Shiho Tatsumi","date":"2024-06-18","format":false,"excerpt":"\u3053\u306e\u5de5\u7a0b\u306f\u3001Incoming Webhook \u3092\u4f7f\u3063\u3066 Slack \u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u6295\u7a3f\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;BPMN\u30a2\u30a4\u30b3\u30f3&quot;","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-service-task-slack-new.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-service-task-slack-new.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-service-task-slack-new.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-service-task-slack-new.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-service-task-slack-new.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67318,"url":"https:\/\/support.questetra.com\/ja\/addons\/googlesheets-valueupdate\/","url_meta":{"origin":101459,"position":3},"title":"Google Sheets \u30bb\u30eb\u5024\u306e\u66f4\u65b0","author":"Hirotaka NISHI","date":"2018-11-09","format":false,"excerpt":"2017 \u00a9 Questetra, Inc. (the MIT License)https:\/\/support.questetra.com\/ja\/addons\/googlesheets-valueupdate\/ Download GoogleSheets-valueUpdate.xml\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30f3\u30b8\u30f3\u3068\u3057\u3066\u300cRhino\uff08\u5ec3\u6b62\u4e88\u5b9a\uff09\u300d\u304c\u6307\u5b9a\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u30a2\u30d7\u30ea\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3082\u8a2d\u5b9a\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u5229\u7528\u3059\u308b\u306b\u306f\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30f3\u30b8\u30f3\u306e\u5909\u66f4\u3001\u304a\u3088\u3073\u305d\u308c\u306b\u4f34\u3046\u30b9\u30af\u30ea\u30d7\u30c8\u4fee\u6b63\u304c\u5fc5\u8981\u3067\u3059\u5bfe\u5fdc\u65b9\u6cd5\u306f\u3001\u300c\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30f3\u30b8\u30f3 Rhino \u5ec3\u6b62\u306e\u304a\u77e5\u3089\u305b\u300d\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u4fee\u6b63\u7248\u306f\u6e96\u5099\u4e2d\u3067\u3059 Capture Notes \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 ID \u306f URL \u7b49\u3092\u53c2\u7167\u3057\u307e\u3059\u3002* https:\/\/docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0 See also 2017-09-04 (\u9031\u6b21\u58f2\u4e0a\u5831\u544a\u30d7\u30ed\u30bb\u30b9): \u7b2c551\u8a71\uff1a\u9031\u5831\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3078\u306e\u30b3\u30e1\u30f3\u30c8\u30a8\u30e9\u30fc\u5883\u754c\u30a4\u30d9\u30f3\u30c8","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\/11\/GoogleSheets-valueUpdate-fi-ja.png.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\/GoogleSheets-valueUpdate-fi-ja.png.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/GoogleSheets-valueUpdate-fi-ja.png.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/GoogleSheets-valueUpdate-fi-ja.png.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/GoogleSheets-valueUpdate-fi-ja.png.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82141,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":101459,"position":4},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u4e00\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"0,2,3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","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":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.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\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":101468,"url":"https:\/\/support.questetra.com\/ja\/addons\/json-string-extract-value-using-json-path\/","url_meta":{"origin":101459,"position":5},"title":"JSON \u6587\u5b57\u5217, JSON-Path \u306b\u3088\u308b Value \u62bd\u51fa","author":"IMAMURA, Genichi","date":"2021-02-09","format":false,"excerpt":"JSON Path \u8a2d\u5b9a\u3092\u4f7f\u7528\u3057\u3066\u3001JSON\u30c7\u30fc\u30bf\u5185\u306e\u7279\u5b9a\u306e\u5024\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002Webhook \u6a5f\u80fd\u3067\u53d7\u4fe1\u3057\u305f JSON\uff08Incoming Webhook\uff09\u304b\u3089\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b\u969b\u306a\u3069\u306b\u6d3b\u7528\u3057\u307e\u3059\u3002\u8907\u6570\u5024\u3092\u53d6\u5f97\u3059\u308b\u3088\u3046\u306a\u30d1\u30b9\u8a2d\u5b9a\u3082\u53ef\u80fd\u3067\u3059\u3002","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":"JSON \u6587\u5b57\u5217, JSON-Path \u306b\u3088\u308b Value \u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/02\/JSON-String-Extract-Value-using-JSON-Path-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}