Excelã«ã¤ã³ã¿ã¼ããããããã¼ã¿ãåãè¾¼ããµã¤ã
Excelã«ã¤ã³ã¿ã¼ããããããã¼ã¿ãåãè¾¼ããµã¤ã
ã©ããããã®ï¼ ãã®ããã«é¢æ°ã使ã£ã¦ãã¼ã¿ãåãè¾¼ãã¾ãã èæ¯ å ã ã¯ãã¤ã³ã¿ã¼ãããä¸ã®WebAPIã®ãã¼ã¿ãExcelã«åãè¾¼ã¿ãããã¨æã£ãã®ããã£ããã§ãã VBAãã¯ãã使ãã°ç°¡åã§ã¯ããã¾ããããã¯ãã¯ä½¿ããããªãã¨ããæ¹ãå¤ãã®ã§ã¯ãªãã§ãããããããããç§ãå¤åå ãå±äººåãé²ãããã«ãã¯ãã®ä½¿ç¨ãæ¨å¥¨ãã¦ãã¾ããã ããã§ã颿°ã使ç¨ããæ¹æ³ã鏿ãã¾ããã Excelã«ã¯WEBSERVICE 颿°ã¨ããæå®ããURLã®å¿çãã¼ã¿ãåãè¾¼ã颿°ãããã¾ãã ãããããã®é¢æ°ã¯å¤§å¤ä¾¿å©ãªé¢æ°ã§ãããExcelã¯HTMLãJSONã®ãã¼ãµã¼ãç¨æãã¦ãã¾ãããçµå±åãè¾¼ãã HTMLãJSONã®å¦çã«ã¯VBAãã¯ããå¿ è¦ã«ãªãã¾ãã ã¾ããæ¬²ããWebAPIãåå¨ããªãåé¡ãããã¾ããã ããã§ãExcelã§ãã¼ã¿ãç·¨éããã®ã§ã¯ãªããå ã ã®WebAPIãExcelç¨ã«ä½ãã°
ã¨ã³ã¸ãã¢ãè¶ä¼ 2020/08/19 pastak.icon @pastak ãã®çºè¡¨ã®ã´ã¼ã« ç¾ä»£ã®ã¦ã§ããã©ã¦ã¶ã®ç®æãã¦ããæ¹åæ§ã«ã¤ãã¦ç´¹ä»ãã ã¢ãã³ãã©ã¦ã¶ã§ä½¿ããææ°ã®é¢ç½ä¾¿å©APIãç´¹ä»ãã ã¡ããã¨ä»æ§ã«å ¥ããããªãã®(Googleã®åæã§â¦ãå«ã) ï¼ååã®åãã³ãã®è©±ã¯pastak.iconå人ã®è¦è§£ãå«ã¿ã¾ãï¼ æ¬¡ã§ã¯ãªã ããã³ãã¨ã³ããªãã§ãç¸è«å®¤ åæç¥èã®ã³ã¼ãã¼ "WebAPI"ã¨ã¯ä½ãæãã®ããæ¨æºåã«ã¤ã㦠ECMAScript Ecma Internationalã«ã¦ECMA-262ã¨ããè¦æ ¼çªå· ã»ã¼Living Standardã¨ããé°å²æ°ããããã©ãå¹´ã«1åã¿ã°ãä»ã ES2020: ECMAScript® 2020 Language Specification ææ°ã®æ§å: https://tc39.es/ecma262/ ArrayãNu
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? åå: Qiita APIã§è¨äºããYoutubeåç»ãéãã¦ã¿ã ð¬ ãQiita APIã使ã£ã¦ãQiitaè¨äºãåå¾ãã¦Youtubeåç»ã®URLãæ½åºãããã¨ãã§ãã¾ããã ä»åã¯ãç¹å®APIã«é¢é£ããQiitaè¨äºãåå¾ãã¦ãAPIæ¯ã«åé¡ãã¿ã°ãéè¨ãã¦ãã¼ããã°ã©ãåãããã¨ã§APIã®ç¹å¾´ã表ãã¦ã¿ã¾ããã ææ°ã®APIä¸è¦§ã¯ãã¡ã APIä¸è¦§ | DOGAKIITAA! ï½ APIãã¨ã«Qiitaè¨äºãåé¡ ï½ Googleç³» Cloud Vision API https://cloud.google.com/visi
ããã¾ãã¦ããã§ã¨ããããã¾ãï¼ å»å¹´ã«å¼ãç¶ã2019å¹´ãæ´»åã®æ£å¸ãã¨2020å¹´ã®æ¹éãã¾ã¨ãã¦ã¿ããã¨æãã¾ãã kageura.hatenadiary.jp ã¡ãªã¿ã«ãå»å¹´ã¯ã¡ãã£ã¨æè»½ã«Excelã§æ¸ã¾ãã¦ãã¾ã£ãã®ã§ãä»åã¯ãã£ããã¨PowerBIã§ãã£ã¦ã¿ã¾ããã 2019å¹´ã®æ£å¸ã Blogã®ç¶æ³ ä¸å¿ç§ã¯èªåèªèº«ã®Blogã¨ä¼ç¤¾ã®Blogã®ä¸¡æ¹ã§è¨äºãæç¨¿ãã¦ããã®ã§ãããã¨ããããã¡ã¤ã³ã®MorningGirlã®æç¨¿ç¶æ³ãè¦ã¦ã¿ã¾ãã å»å¹´ã¯43ä»¶ã¨ã¡ãã£ã¨å°ãªãã¨ãªã£ãã®ã§ãããä»å¹´ã¯51ä»¶ã¨2015å¹´ã«æ¬¡ãä»¶æ°ã¨ãªããçµæ§ç²¾åçã«Blogæ´»åãã§ãã¾ããããã ãæå¥ã®æç¨¿ä»¶æ°ãè¦ãã¨1æã14ä»¶ã¨å§åçãªã®ã«ããã以éãä¼¸ã³æ©ã¿ã ã«ãã´ãªã¯APIã2018å¹´ã¨å¤ãããªãã§ãããZOZOåæ¾¤ç¤¾é·ã®ãã¤ã¼ãåéãªã©ããããã¨ããJJUGã§ã®ç»å£ãã¾ã¨ããè¨äºãæ¸ããã
ãã®è¨äºã¯Recruit Engineers Advent Calendar 2018 - 8æ¥ç®ã®è¨äºã§ãã æ³¨æç¹ ã¿ã¤ãã«ã¯ç ½ãã§ãããæ°è¦äºæ¥ã«ããããã¼ã¿ã¨ã³ã¸ãã¢ãªã³ã°ã®åæãã®æ¹ãæ£ããããã§ãã ã¯ãªãªãã£ã¨ãããè¨äºã®ä¿¡é ¼åº¦ã¯ãæç¨¿æéãã®ãªã®ãªã«ãªã£ã¦ãã¾ã£ããã¨ããå¯ãã¦ããããã¨ãããããã§ãã æ¬ã¨ã³ããªã¼ã®å 容ã¯å人çãªè¦è§£ã§ãããæå±ããçµç¹ã代表ãããã®ã§ã¯ããã¾ããããã¼ã¿ã®åãæ±ãã¯é常ã«ã»ã³ã·ãã£ããªãããã¯ã§ãããããæ°è»½ã«çºä¿¡ãã¹ãã§ã¯ãªãã¨ãããã¨ã¯éã æ¿ç¥ãã¦ããã¾ãããã誤ããèæ ®ä¸è¶³ã ã¨æããç¹ãããã°ãããã¯å ¨ã¦ç§å人ã®åä¸è¶³ã«ãããã®ã§ãã®ã§ãã©ããç§å人å½ã¦ã«ãææã®ã³ã¡ã³ããããã ããã¨å¹¸ãã§ãã ããã æ³¨æç¹ ããã èæ¯ åæ ä½å¶ ã·ã¹ãã éçºã¹ã³ã¼ã æ©æ¢°å¦ç¿WebAPIã¯åé¢ ãã¼ã¿åºç¤è¨è¨ å ¨ä½ã®è¨è¨ããªã·ã¼ ãã¼ã¿
REST Security Cheat Sheet¶ Introduction¶ REST (or REpresentational State Transfer) is an architectural style first described in Roy Fielding's Ph.D. dissertation on Architectural Styles and the Design of Network-based Software Architectures. It evolved as Fielding wrote the HTTP/1.1 and URI specs and has been proven to be well-suited for developing distributed hypermedia applications. While REST i
from urlparse import urlparse import urllib def toGSBL(str_url, character_code) scheme, netloc, path, params, query, fragments = urlparse(unicode(str_url, character_code, 'ignore')) netloc = netloc.encode('idna') path = urllib.quote_plus(path.encode('utf-8'), '')ãif len(path) > 0 else '/' query = urllib.quote_plus(query.encode('utf-8'), '')ãif len(query) > 0 else '' return scheme + '://' + netloc
Google Safe Browsing APIã¯ç¹å®ã®URLããã¤ããªãå®å ¨ãå¦ãããã§ãã¯ããAPIããã£ã¨èª¿ã¹ãã¨ãã«ä¾¿å©ãªããã«Jupyterãã使ããããã«ãã¦ã¿ãã æ®éã®URLãå ¥ããã¨ä½ãå¤ãåºã¦ããªãã®ã§ãå®å ¨ã§ãªãURLããæ¢ããã®ã¨ããã¢ããã¥ã¡ã³ãã«URLãåãè¾¼ããããã«è¦å´ã®è·¡ãã import pycurl, io, json url = 'http://malware.testing.google.test/testing/malware/' api_key = 'your_api_key' data = ''' {{ "client": {{ "clientId": "your_client_name", "clientVersion": "0.1" }}, "threatInfo": {{ "threatTypes": ["THREAT_TYPE_UNS
Google Safe Browsingã£ã¦ããã¾ãã¦ã APIãããã®ã§Rubyããããã¤ãã®ã«ã¼ã«ã§ä¸æ£ã¨å¤æãã¦ãããã¡ã¤ã³(ã¾ãã¯å®è¡ãã¡ã¤ã«)ããã§ãã¯ãã¦ã¿ããã¨ãã¾ããã äºåæºå rubygems google-api-client ãã¤ã³ã¹ãã¼ã« APIKEYãç°å¢å¤æ°ã«ããã¦ãã Lookupã®ãµã³ãã«ã³ã¼ã google-api-clientã£ã¦ã»ã¨ãã©åççæãªã®ã§ãæ®éã«ä½¿ãæ¹ãã½ã¼ã¹ããè¦ããã¨ããã¨ãµãããªãããã¾ããã åçã«çæãããããããªããã¨ããã³ã¼ãããªãã¸ããªã«ä¸ç·ã«ä¸ãã£ã¦ããã®ã§ããã¡ããããã¥ã¡ã³ã代ããã«ãã§ãã¯ãã¾ãã https://github.com/google/google-api-ruby-client/tree/master/generated/google/apis safebrowsing_v4ã¯ãã®ã¸ãã§ããã Lo
The safebrowsing Go package can be used with the Google Safe Browsing APIs (v4) to access the Google Safe Browsing lists of unsafe web resources. Inside the cmd sub-directory, you can find two programs: sblookup and sbserver. The sbserver program creates a proxy local server to check URLs and a URL redirector to redirect users to a warning page for unsafe URLs. The sblookup program is a command li
ãã®è¨äºã¯Hamee Advent Calendar 2016ã®15æ¥ç®ã®è¨äºã§ãã ä»åã¯ãElixirã®Webãã¬ã¼ã ã¯ã¼ã¯Phoenixã使ã£ã¦ãQiitaã®Advent Calendar 2016ã©ã³ãã³ã°ãJSONã§è¿ãWebAPIãæ§ç¯ãã¦ã¿ã¾ãã 調ã¹ã¦ããã¨DBãå©ç¨ããå ´åã®è¨äºãå¤ããDBãå©ç¨ããªãå ´åã«ä¸æãåä½ããªãã£ãã®ã§ãDBã使ããªãå ´åã®ã®å®è£ æ¹æ³ãã¾ã¨ãã¦ããã¾ãã ããã㨠Phoenixã®ã¤ã³ã¹ãã¼ã« Elixirã«ããWebã¹ã¯ã¬ã¤ãã³ã° JOSNå½¢å¼ã§ã¹ã¯ã¬ã¤ãã³ã°çµæãè¿ã åææ¡ä»¶ Elixirã®ç°å¢æ§ç¯æ¸ã¿ ã¤ã³ã¹ãã¼ã« 詳細ã¯å ¬å¼ã®ã¤ã³ã¹ãã¼ã«ã¬ã¤ãããåç §ãã ããã Phoenixã®ã¤ã³ã¹ãã¼ã« 以ä¸ã®ã³ãã³ãã§Phoenixãã¤ã³ã¹ãã¼ã«ãã¾ãã $ mix archive.install https://github.com/pho
ã¯ããã« ã¤ã³ãã«ã§1é±éæ½°ãã¾ãããè¾ãã£ãããã ã¨ãããã¨ã§ãã¯ãã¼ãªã³ã°ã«ã¤ãã¦ã§ãã Pythonã§ã¯ãã¼ãªã³ã°ããã¨ãªãã¨ãScrapyã¯ããªãããåºã¦ããã¨æãã¾ãã åãåãã¦è§¦ã£ã¦ãããããã2年以ä¸çµã£ã¦ããããã«æãã¾ãã å¼ç¤¾Liaroã§ã使ã£ã¦ã¾ãããä½ã¨è¨ã£ã¦ã3系対å¿ããã®ãå¬ããã§ããã ä½ãæ¸ãã ãã¥ã¼ããªã¢ã«ã¨ãã¯æ£ã è½ã¡ã¦ã¾ãã®ã§ãTwitterãã¯ãã¼ãªã³ã°ããã¨ãã«APIã¨ã©ã飿ºãããããæ¸ãããã¨ãã©ããåèã«ããã¯ããªã®ã§ããå¿ãã¦ãã¾ããããè¦ã¤ã次第ãªã³ã¯è²¼ã£ã¦ããã¾ãã ãã£ã¦ã¿ã æ¹é åºæ¬çã«ã¯ä¸å³ã§è¨ãMiddlewareãTwitterç¨ã«æ¸ãã¦ãsettingsãæ¸ãã¦ããæãã§ãã Pythonãã¼ã¸ã§ã³ã¯3.5.1ã§ãTwitterã©ã¤ãã©ãªã¯python-twitterã使ãã¾ããã Middleware TW_CON
OSINT(Open Source Intellihence)ã¨ããããã§ããããã¤ã®éã«ãããã£ãè¨èãã§ããã®ããç¥ãã¾ããã§ããããã©ããªåéã§ãæç¨ãªWebãµã¼ãã¹ã«ã¯ãä¸è©±ã«ãªããã®ã§ãã ã»ãã¥ãªãã£ã®Webãµã¼ãã¹ã§æåã©ããã¨è¨ãã° VirusTotal ãããã¾ããæ¤ä½ãæç¨¿ããåãã³ãã¼ã®è£½åã§ã¹ãã£ã³ããçµæã表示ãã¦ããã¾ããä»ã«ãWebãµã¤ãã®ã¹ãã£ã³ããã¡ã¤ã«ã®ããã·ã¥å¤ã§ã®ã¹ãã£ã³çµæã®æ¤ç´¢ãIPããã¡ã¤ã³ã®æ å ±ã®æ¤ç´¢ ãªã©ãå©ç¨å¯è½ãªæ å ±ã¯å¤å²ã«ãããã¾ãã VirusTotalã ãã®è©±ã§ã¯ããã¾ããããæç¨¿ãããã¡ã¤ã«ã«æ©å¯ãªæ å ±ãå«ã¾ãã¦ããªããã¯ç¢ºèªãã¦ããã¾ããããããããå¤é¨Webãµã¤ãã¸ã®ãã¡ã¤ã«ã®ã¢ãããã¼ãã¯ä¸è¬å ¬éããã¦ãå°ããªããã®ã®ã¿ã«éå®ãã¹ãã§ãã ãããã£ãå¤é¨æ å ±ãµã¤ãã¯ä»ã«ãããã¾ããWebãµã¤ãã®æ å ±ã«ç¹åãããã®ããã«ã¦ã§
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}