{"id":14545,"date":"2022-03-29T18:00:01","date_gmt":"2022-03-29T09:00:01","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=14545"},"modified":"2022-03-29T18:46:41","modified_gmt":"2022-03-29T09:46:41","slug":"appsheet%e3%81%a8power-automate%e3%81%a8%e3%81%ae%e9%80%a3%e6%90%ba%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=14545","title":{"rendered":"AppSheet\u3068Power Automate\u3068\u306e\u9023\u643a\u306b\u3064\u3044\u3066"},"content":{"rendered":"<p>AppSheet Automation\u3067\u306f\u3001Webhook\u306b\u3088\u3063\u3066\u4ed6\u30b5\u30fc\u30d3\u30b9\u3068\u306e\u9023\u643a\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/help.appsheet.com\/en\/articles\/5333209-calling-a-webhook-from-a-bot\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=help.appsheet.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">help.appsheet.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/pz-linkcard\/cache\/6142e9dcda3858ca671d159260cb5569e3379e2b47eaca13f5acc5517d4a4cb1.jpeg\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">Calling a webhook from a bot<\/div><div class=\"lkc-url\" title=\"https:\/\/help.appsheet.com\/en\/articles\/5333209-calling-a-webhook-from-a-bot\">https:\/\/help.appsheet.com\/en\/articles\/5333209-calling-a-webhook-from-a-bot<\/div><div class=\"lkc-excerpt\">Call a webhook from a bot.<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<p>\u3068\u3044\u3046\u3053\u3068\u306fPower Automate\u3068\u3082\u9023\u643a\u3067\u304d\u308b\u306f\u305a\u306a\u306e\u3067\u3001\u3055\u3063\u305d\u304f\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<h4 class=\"style4a\">Power Automate\u5074\u306e\u30d5\u30ed\u30fc<\/h4>\n<p>\u4f7f\u7528\u3059\u308b\u306e\u306f\u300c<span style=\"color: #ff0000; font-weight: bold;\">HTTP \u8981\u6c42\u306e\u53d7\u4fe1\u6642<\/span>\u300d\u30c8\u30ea\u30ac\u30fc\u3067\u3001\u4eca\u56de\u306f\u30c6\u30b9\u30c8\u76ee\u7684\u306a\u306e\u3067\u300c\u8981\u6c42\u672c\u6587\u306e JSON \u30b9\u30ad\u30fc\u30de\u300d\u3092\u4e0b\u8a18\u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">{\r\n    &quot;type&quot;: &quot;object&quot;,\r\n    &quot;properties&quot;: {\r\n        &quot;message&quot;: {\r\n            &quot;type&quot;: &quot;string&quot;\r\n        }\r\n    }\r\n}<\/pre>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_01.jpg\" alt=\"\" width=\"629\" height=\"563\" class=\"alignnone size-full wp-image-14546\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_01.jpg 629w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_01-300x269.jpg 300w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/a><\/p>\n<p>\u30d5\u30ed\u30fc\u3092\u4fdd\u5b58\u3057\u305f\u3089\u300cHTTP POST \u306e URL\u300d\u3092\u30b3\u30d4\u30fc\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<h4 class=\"style4a\">AppSheet\u30a2\u30d7\u30ea\u306e\u8a2d\u5b9a<\/h4>\n<p>Power Automate\u5074\u306e\u6e96\u5099\u304c\u3067\u304d\u305f\u3089\u4eca\u5ea6\u306fAppSheet\u306e\u300cAutomation\u300d\u304b\u3089\u4e0b\u8a18\u306e\u3088\u3046\u306b\u30bf\u30b9\u30af\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<ul>\n<li>Event Type\uff1aData Change(Adds and updates)<\/li>\n<li>Task\uff1aCall a webhook<\/li>\n<li>Preset\uff1aCustom<\/li>\n<li>Url\uff1aPower Automate\u30d5\u30ed\u30fc\u306e\u300cHTTP POST \u306e URL\u300d<\/li>\n<li>HTTP Verb\uff1aPOST<\/li>\n<li>HTTP Content Type\uff1aJSON<\/li>\n<li>Body\uff1a\u4e0b\u8a18JSON<\/li>\n<\/ul>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">{\r\n  &quot;message&quot;: &quot;&lt;&lt;&#x5B;app_name]&gt;&gt;&quot;\r\n}<\/pre>\n<p>\u4e0a\u8a18JSON\u306e\u300c&lt;&lt;[app_name]&gt;&gt;\u300d\u90e8\u5206\u306fAppSheet\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u5909\u6570\u3067\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">&lt;&lt;[\u5217\u540d]&gt;&gt;<\/span>\u300d\u3068\u3059\u308b\u3053\u3068\u3067\u6307\u5b9a\u3057\u305f\u5217\u306e\u5024(\u4eca\u56de\u306e\u5834\u5408\u306f\u300capp_name\u300d\u5217)\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u305d\u306e\u4ed6\u7d44\u8fbc\u307f\u5909\u6570\u3082\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u8a73\u7d30\u306f\u4e0b\u8a18\u306e\u30d8\u30eb\u30d7\u30da\u30fc\u30b8\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/help.appsheet.com\/en\/articles\/969715-template-variables\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=help.appsheet.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">help.appsheet.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/pz-linkcard\/cache\/6142e9dcda3858ca671d159260cb5569e3379e2b47eaca13f5acc5517d4a4cb1.jpeg\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">Template Variables<\/div><div class=\"lkc-url\" title=\"https:\/\/help.appsheet.com\/en\/articles\/969715-template-variables\">https:\/\/help.appsheet.com\/en\/articles\/969715-template-variables<\/div><div class=\"lkc-excerpt\">Using variables in your workflow templates.<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_02.jpg\" alt=\"\" width=\"933\" height=\"2122\" class=\"alignnone size-full wp-image-14547\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_02.jpg 933w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_02-132x300.jpg 132w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_02-450x1024.jpg 450w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_02-768x1747.jpg 768w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_02-675x1536.jpg 675w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_02-900x2048.jpg 900w\" sizes=\"auto, (max-width: 933px) 100vw, 933px\" \/><\/a><\/p>\n<p>\u30a2\u30d7\u30ea\u3092\u4fdd\u5b58\u3057\u305f\u3089AppSheet\u5074\u306e\u6e96\u5099\u3082\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<h4 class=\"style4a\">\u52d5\u4f5c\u78ba\u8a8d<\/h4>\n<p>Power Automate\u3068AppSheet\u3001\u4e21\u65b9\u306e\u6e96\u5099\u304c\u3067\u304d\u305f\u306e\u3067\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3057\u3066\u52d5\u4f5c\u78ba\u8a8d\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_03.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/AppSheet_PowerAutomate_03.gif\" alt=\"\" width=\"1090\" height=\"540\" class=\"alignnone size-full wp-image-14548\" \/><\/a><\/p>\n<p>\u7d50\u679c\u306f\u4e0a\u56f3\u306e\u901a\u308a\u3067\u3001AppSheet\u30a2\u30d7\u30ea\u304b\u3089Power Automate\u30d5\u30ed\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u6e21\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n<div id=\"single_banner_area2\" class=\"clearfix one_banner\">\n<div class=\"single_banner single_banner_left\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- \u8a18\u4e8b\u4e2d(\u30c7\u30a3\u30b9\u30d7\u30ec\u30a4\u5e83\u544a\u30e6\u30cb\u30c3\u30c8) -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-7306936664602087\"\r\n     data-ad-slot=\"5429724765\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<div class=\"single_banner single_banner_right\">\n<a href=\"\" target=\"_blank\"><img decoding=\"async\" src=\"\" alt=\"\" title=\"\" \/><\/a>\n<\/div>\n<\/div>\n\n<p>\u4eca\u56de\u4f7f\u7528\u3057\u305f\u300cHTTP \u8981\u6c42\u306e\u53d7\u4fe1\u6642\u300d\u30c8\u30ea\u30ac\u30fc(\u8981\u6c42\u30b3\u30cd\u30af\u30bf)\u306f\u30d7\u30ec\u30df\u30a2\u30e0\u306a\u306e\u3067\u6709\u511f\u30e9\u30a4\u30bb\u30f3\u30b9\u304c\u5fc5\u8981\u3068\u306a\u308a\u307e\u3059\u304c\u3001Power Automate\u3067\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u81a8\u5927\u306a\u30a2\u30af\u30b7\u30e7\u30f3\u3092\u6d3b\u7528\u3067\u304d\u308b\u306e\u3067\u3001\u51e6\u7406\u306e\u5e45\u306f\u5927\u304d\u304f\u5e83\u304c\u308a\u307e\u3059\u3002<\/p>\n<p>\u3082\u3061\u308d\u3093IFTTT\u7b49Webhook\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u308b\u30b5\u30fc\u30d3\u30b9\u306f\u4ed6\u306b\u3082\u3042\u308b\u306e\u3067\u3001\u5fc5\u305a\u3057\u3082Power Automate\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u306f\u7121\u3044\u306e\u3067\u3059\u304c\u3001\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u30d5\u30ed\u30fc(Power Automate for desktop)\u306b\u3088\u3063\u3066\u3001API\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u30ed\u30fc\u30ab\u30eb\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u3082\u30ce\u30fc\u30b3\u30fc\u30c9(\u30ed\u30fc\u30b3\u30fc\u30c9)\u3067\u9023\u643a\u53ef\u80fd\u306aPower Automate\u3092\u5229\u7528\u3059\u308b\u30e1\u30ea\u30c3\u30c8\u306f\u3001\u975e\u5e38\u306b\u5927\u304d\u3044\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>Google Workspace \u00d7 AppSheet \u00d7 Power Automate\u3001\u30b3\u30b9\u30c8\u306e\u554f\u984c\u306f\u3042\u308a\u307e\u3059\u304c\u3001\u4e2d\u3005\u826f\u3044\u7d44\u307f\u5408\u308f\u305b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"AppSheet Automation\u3067\u306f\u3001Webhook\u306b\u3088\u3063\u3066\u4ed6\u30b5\u30fc\u30d3\u30b9\u3068\u306e\u9023\u643a\u304c\u3067\u304d\u307e\u3059\u3002 \u3068\u3044\u3046\u3053\u3068\u306fPower Automate\u3068\u3082\u9023\u643a\u3067\u304d\u308b\u306f\u305a\u306a\u306e\u3067\u3001\u3055\u3063\u305d\u304f\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002 Power Automate\u5074 [&hellip;]","protected":false},"author":1,"featured_media":12424,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[AppSheet\u3068Power Automate\u3068\u306e\u9023\u643a\u306b\u3064\u3044\u3066]","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}},"categories":[168,171],"tags":[],"class_list":["post-14545","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerautomate","category-appsheet"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-PowerAutomate.jpg","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-3MB","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/14545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14545"}],"version-history":[{"count":3,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/14545\/revisions"}],"predecessor-version":[{"id":14552,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/14545\/revisions\/14552"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/12424"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}