{"id":7667,"date":"2024-12-21T18:13:19","date_gmt":"2024-12-21T18:13:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/su-dung-api-trong-lap-trinh-vba-lay-du-lieu-tu-nhieu-nguon-tren-mang\/"},"modified":"2024-12-21T18:13:19","modified_gmt":"2024-12-21T18:13:19","slug":"su-dung-api-trong-lap-trinh-vba-lay-du-lieu-tu-nhieu-nguon-tren-mang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/su-dung-api-trong-lap-trinh-vba-lay-du-lieu-tu-nhieu-nguon-tren-mang\/","title":{"rendered":"S\u1eed d\u1ee5ng API trong l\u1eadp tr\u00ecnh VBA, l\u1ea5y d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n tr\u00ean m\u1ea1ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>B\u00e0i vi\u1ebft \u0111\u01b0a ra v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c \u00e1p d\u1ee5ng API c\u1ee7a Google Geocoding v\u00e0o vi\u1ec7c t\u00ecm kinh \u0111\u1ed9 v\u00e0 v\u0129 \u0111\u1ed9 c\u1ee7a 1 \u0111\u1ecba ch\u1ec9 cho tr\u01b0\u1edbc, n\u1ed1i ti\u1ebfp v\u1edbi th\u00f4ng tin t\u1eeb kinh \u0111\u1ed9 v\u00e0 v\u0129 \u0111\u1ed9 tr\u1ea3 v\u1ec1 t\u1eeb API c\u1ee7a Google, th\u00f4ng tin n\u00e0y \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u00e0m th\u00f4ng tin \u0111\u1ea7u v\u00e0o cho 1 API v\u1ec1 th\u1eddi ti\u1ebft \u0111\u1ec3 l\u1ea5y v\u1ec1 nhi\u1ec7t \u0111\u1ed9 hi\u1ec7n t\u1ea1i c\u1ee7a v\u1ecb tr\u00ed c\u1ea7n t\u00ecm. B\u00e0i vi\u1ebft c\u00f3 t\u00ednh \u0111\u1ecbnh h\u01b0\u1edbng v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng API trong l\u1eadp tr\u00ecnh Excel \u0111\u1ec3 n\u00e2ng cao kh\u1ea3 n\u0103ng x\u1eed l\u00fd th\u00f4ng tin, truy c\u1eadp th\u00f4ng tin v\u00e0 \u1ee9ng d\u1ee5ng trong c\u00f4ng vi\u1ec7c v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng th\u01b0 vi\u00ean VBA JSON.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6767053e369fc\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-api-trong-lap-trinh-vba-lay-du-lieu-tu-nhieu-nguon-tren-mang.html#API_la_gi\" title=\"API l\u00e0 g\u00ec\">API l\u00e0 g\u00ec<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-api-trong-lap-trinh-vba-lay-du-lieu-tu-nhieu-nguon-tren-mang.html#JSON_la_gi\" title=\"JSON l\u00e0 g\u00ec\">JSON l\u00e0 g\u00ec<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-api-trong-lap-trinh-vba-lay-du-lieu-tu-nhieu-nguon-tren-mang.html#Ban_can_gi_truoc_khi_doc_tiep\" title=\"B\u1ea1n c\u1ea7n g\u00ec tr\u01b0\u1edbc khi \u0111\u1ecdc ti\u1ebfp\">B\u1ea1n c\u1ea7n g\u00ec tr\u01b0\u1edbc khi \u0111\u1ecdc ti\u1ebfp<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-api-trong-lap-trinh-vba-lay-du-lieu-tu-nhieu-nguon-tren-mang.html#Cach_su_dung_JSON_va_lap_trinh_voi_cac_API_trong_VBA\" title=\"C\u00e1ch s\u1eed d\u1ee5ng JSON v\u00e0 l\u1eadp tr\u00ecnh v\u1edbi c\u00e1c API trong VBA\">C\u00e1ch s\u1eed d\u1ee5ng JSON v\u00e0 l\u1eadp tr\u00ecnh v\u1edbi c\u00e1c API trong VBA<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/su-dung-api-trong-lap-trinh-vba-lay-du-lieu-tu-nhieu-nguon-tren-mang.html#Ung_dung_cua_viec_su_dung_API_trong_lap_trinh_VBA\" title=\"\u1ee8ng d\u1ee5ng c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng API trong l\u1eadp tr\u00ecnh VBA\">\u1ee8ng d\u1ee5ng c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng API trong l\u1eadp tr\u00ecnh VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"API_la_gi\"><\/span>API l\u00e0 g\u00ec<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>API vi\u1ebft t\u1eaft c\u1ee7a Application Programming Interface, <a href=\"https:\/\/vi.wikipedia.org\/wiki\/Giao_di%E1%BB%87n_l%E1%BA%ADp_tr%C3%ACnh_%E1%BB%A9ng_d%E1%BB%A5ng\" target=\"_blank\" rel=\"noopener noreferrer\">giao di\u1ec7n l\u1eadp tr\u00ecnh \u1ee9ng d\u1ee5ng<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"JSON_la_gi\"><\/span>JSON l\u00e0 g\u00ec<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>JSON vi\u1ebft t\u1eaft c\u1ee7a JavaScript Object Notation, <a href=\"https:\/\/vi.wikipedia.org\/wiki\/JSON\" target=\"_blank\" rel=\"noopener noreferrer\">\u0111\u1ecdc th\u00eam<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ban_can_gi_truoc_khi_doc_tiep\"><\/span>B\u1ea1n c\u1ea7n g\u00ec tr\u01b0\u1edbc khi \u0111\u1ecdc ti\u1ebfp<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Theo d\u00f5i video sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/5t2QSeDzsu0\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>\u0110\u0103ng k\u00fd Google Geocoding \u1edf \u0111\u1ecba ch\u1ec9 <a href=\"https:\/\/developers.google.com\/maps\/documentation\/geocoding\/get-api-key\" target=\"_blank\" rel=\"noopener noreferrer\">n\u00e0y<\/a><\/p>\n<p>\u0110\u0103ng k\u00fd Darksky API \u1edf \u0111\u1ecba ch\u1ec9 <a href=\"https:\/\/darksky.net\/dev\/\" target=\"_blank\" rel=\"noopener noreferrer\">n\u00e0y<\/a><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-310.gif\" title=\"vba101_92019-nho-310\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-687.gif\" title=\"ex101_92019-nho-687\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_JSON_va_lap_trinh_voi_cac_API_trong_VBA\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng JSON v\u00e0 l\u1eadp tr\u00ecnh v\u1edbi c\u00e1c API trong VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u1ea3 n\u0103ng h\u1ed7 tr\u1ee3 l\u1eadp tr\u00ecnh JSON trong VBA nguy\u00ean b\u1ea3n l\u00e0 kh\u00f4ng c\u00f3, \u0111\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng 1 th\u01b0 vi\u1ec7n \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi 1 l\u1eadp tr\u00ecnh vi\u00ean kh\u00e1c. C\u00e1ch download v\u00e0 c\u00e0i \u0111\u1eb7t th\u01b0 vi\u1ec7n n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn \u1edf trong Video. C\u00f2n \u0111\u00e2y l\u00e0 <strong><a href=\"https:\/\/github.com\/VBA-tools\/VBA-JSON\" target=\"_blank\" rel=\"noopener noreferrer\">link download<\/a>\u00a0<\/strong>v\u00e0<\/p>\n<p>[sociallocker id=3047]<\/p>\n<p><a href=\"https:\/\/www.dropbox.com\/s\/gg4k5dh0aowa45x\/weather-api-vba-json.xlsm?dl=1\" target=\"_blank\" rel=\"noopener noreferrer\">File s\u1eed d\u1ee5ng trong Video<\/a><\/p>\n<p>[\/sociallocker]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ung_dung_cua_viec_su_dung_API_trong_lap_trinh_VBA\"><\/span>\u1ee8ng d\u1ee5ng c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng API trong l\u1eadp tr\u00ecnh VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u1eeb vi\u1ec7c c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng API ngay trong Excel v\u1edbi s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a VBA, ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng (n\u1ebfu bi\u1ebft l\u1eadp tr\u00ecnh VBA) c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c nh\u1eefng \u0111i\u1ec1u sau \u0111\u00e2y, sau \u0111\u00e2y l\u00e0 1 s\u1ed1 g\u1ee3i \u00fd \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 t\u00ecm hi\u1ec3u ti\u1ebfp, v\u00e0 n\u1ebfu mu\u1ed1n l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, \u0111\u1eebng b\u1ecf qua <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">kho\u00e1 h\u1ecdc l\u1eadp tr\u00ecnh VBA<\/a> c\u1ee7a H\u1ecdc Excel Online<\/p>\n<p><a href=\"https:\/\/www.interactivebrokers.com\/en\/software\/api\/api.htm\" target=\"_blank\" rel=\"noopener noreferrer\">L\u1ea5y d\u1eef li\u1ec7u ch\u1ee9ng kho\u00e1n theo th\u1eddi gian th\u1ef1c<\/a><\/p>\n<p><a href=\"https:\/\/www.interactivebrokers.com\/en\/software\/api\/api.htm\" target=\"_blank\" rel=\"noopener noreferrer\">L\u1ea5y d\u1eef li\u1ec7u ch\u1ee9ng kho\u00e1n trong qu\u00e1 kh\u1ee9<\/a><\/p>\n<p><a href=\"http:\/\/stackoverflow.com\/a\/10040996\/4342479\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1c ngu\u1ed3n l\u1ea5y d\u1eef li\u1ec7u ch\u1ee9ng kho\u00e1n mi\u1ec5n ph\u00ed qua API<\/a><\/p>\n<p><a href=\"https:\/\/developers.facebook.com\/docs\/graph-api\" target=\"_blank\" rel=\"noopener noreferrer\">Facebook API d\u00f9ng \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u00e1c post, l\u1ea5y s\u1ed1 l\u01b0\u1ee3ng like, share, follow \u2026<\/a><\/p>\n<p><a href=\"https:\/\/developer.yahoo.com\/yql\/\" target=\"_blank\" rel=\"noopener noreferrer\">Yahoo YQL<\/a>\u00a0s\u1ebd gi\u00fap b\u1ea1n l\u00e0m r\u1ea5t nhi\u1ec1u vi\u1ec7c t\u1eeb scrape web, crawl d\u1eef li\u1ec7u, t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u ngu\u1ed3n, th\u1eadm ch\u00ed c\u1ea3 nh\u1eefng ngu\u1ed3n kh\u00f4ng c\u00f3 API \u2026<\/p>\n<p>\u2026<\/p>\n<p>v\u00e0 r\u1ea5t nhi\u1ec1u API kh\u00e1c h\u1ed7 tr\u1ee3 t\u1eeb nh\u1eadn d\u1ea1ng gi\u1ecdng n\u00f3i, ch\u1eef vi\u1ebft, cho \u0111\u1ebfn x\u1eed l\u00fd d\u1eef li\u1ec7u \u0111ang ch\u1edd c\u00e1c b\u1ea1n kh\u00e1m ph\u00e1.<\/p>\n<blockquote>\n<p>T\u1eb7ng b\u1ea1n: <a href=\"https:\/\/goo.gl\/e5A8Gv\" target=\"_blank\" rel=\"noopener noreferrer\">\u0110\u0103ng k\u00fd nh\u1eadn Ebook gi\u00e1o tr\u00ecnh VBA c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-310.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7668,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7667","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=7667"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7667\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7668"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}