{"id":211,"date":"2021-11-02T20:37:32","date_gmt":"2021-11-02T20:37:32","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=211"},"modified":"2023-11-22T05:40:44","modified_gmt":"2023-11-22T04:40:44","slug":"buienradar-in-excel-met-json","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2021\/11\/02\/buienradar-in-excel-with-json\/","title":{"rendered":"Rainfall radar in Excel with JSON"},"content":{"rendered":"<p>The possibilities in Excel are virtually unlimited. You can even make your own rainfall radar and process the data in a sheet. We will do this using <a href=\"https:\/\/nl.wikipedia.org\/wiki\/JSON\" target=\"_blank\" rel=\"noreferrer noopener\">JSON<\/a> (JavaScript Object Notation). To retrieve the weather data we use the free API of <a href=\"https:\/\/www.weatherapi.com\" target=\"_blank\" rel=\"noreferrer noopener\">Weatherapi.com<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-stap-1-account-aanmaken\">Step 1 \u2013 create an account<\/h2>\n\n\n\n<p>Create a free account on <a href=\"https:\/\/www.weatherapi.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Weatherapi.com<\/a> for a personal API key. With the free account you can make 1,000,000 API calls per month and receive forecasts up to three days in advance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2 \u2013 Install VBA-JSON<\/h2>\n\n\n\n<p>Download and install <a href=\"https:\/\/github.com\/VBA-tools\/VBA-JSON\" target=\"_blank\" rel=\"noreferrer noopener\">VBA-JSON<\/a> from Tim Hall via GitHub. Tim Halll&#039;s GitHub page has a step-by-step installation guide on how to install it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 3 \u2013 what data can you retrieve<\/h2>\n\n\n\n<p>The following items can be retrieved through the free API of <a href=\"https:\/\/www.weatherapi.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Weatherapi.com<\/a>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Current weather conditions;<\/li>\n\n\n\n<li>three-day forecast;<\/li>\n\n\n\n<li>Astronomical data.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Step 4 \u2013 Create Weather Dashboard<\/h2>\n\n\n\n<p>We start by creating the dashboard. This visually displays the data collected by us in a neat manner. Weatherapi.com&#039;s documentation page clearly states which parameters can be retrieved. In our example we limit ourselves to the following data:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Date;<\/li>\n\n\n\n<li>Maximum expected temperature in degrees Celsius;<\/li>\n\n\n\n<li>Minimum expected temperature in degrees Celsius;<\/li>\n\n\n\n<li>Total expected precipitation in millimeters;<\/li>\n\n\n\n<li>Chance of rain in percentages;<\/li>\n\n\n\n<li>The weather icon.<\/li>\n<\/ul>\n\n\n\n<p>The retrieved data is displayed as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"275\" height=\"223\" src=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg\" alt=\"Excel rain radar dashboard\" class=\"wp-image-360\" srcset=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg 275w, https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar-15x12.jpg 15w\" sizes=\"(max-width: 275px) 100vw, 275px\" \/><figcaption class=\"wp-element-caption\">Excel rain radar dashboard <\/figcaption><\/figure>\n\n\n\n<p>You can format the display of the dashboard to your own taste, but this dashboard is formatted as follows:<\/p>\n\n\n\n<div class=\"wp-block-wpdatatables-wpdatatables-gutenberg-block\"><div class=\"wpdt-c\">\n    <div class=\"alert alert-danger m-10\" role=\"alert\">\n        <span class=\"wdt-alert-title f-600\">Error<br><\/span>\n        <span class=\"wdt-alert-subtitle\">File &quot;\/home\/u622304142\/domains\/bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Weatherapi-Realtime-API.xlsx&quot; does not exist.<\/span>\n    <\/div>\n<\/div><\/div>\n\n\n\n<p>Nothing needs to be entered for the weather icon. This will be displayed in the correct cell via a VBA script.<br>Furthermore, a button has to be added on the sheet with which we can easily call the macro.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-stap-5-het-ophalen-van-json-data-via-vba\">Step 5 \u2013 retrieving JSON data via VBA<\/h2>\n\n\n\n<p>The code for retrieving the data is quite simple. We start by declaring our variables. Then the subroutine <code>DeleteAllIcons<\/code> addressed. This removes all weather icons on our dashboard. If we wouldn&#039;t do this, every time weather data is retrieved, a new icon is placed over the previous icon.<\/p>\n\n\n\n<p>In the string variable <code>API_key<\/code> enter your own API key which you received on Weatherapi.com.<\/p>\n\n\n\n<p>To the variable <code>strURL<\/code> we then assign the value of the url to retrieve the desired parameters. <code>READYSTATE_COMPLETE<\/code> is set to 4. The XMLHttpRequest.readyState property returns the state in which an XMLHttpRequest client is located. A value of 4 indicates that the operation has been completed.<\/p>\n\n\n\n<p>As soon as we have created an http object, a GET request is sent. When the http operation is completed, the variable <code>MyResponse<\/code> filled with the response text (JSON data) from the http object.<\/p>\n\n\n\n<p>Then the JSON parser is called to parse the JSON data. We do this by using the function <code>ParseJson(MyResponse)<\/code> to invoke.<\/p>\n\n\n\n<p>After the JSON data has been parsed, we can extract our data from it.<\/p>\n\n\n\n<p>The full response body of the JSON is quite long and therefore not displayed. The response body is via the <a href=\"#downloads\">download link<\/a> download at the bottom of this page.<\/p>\n\n\n\n<p>The JSON is structured as follows. The root of the JSON contains the following objects\/arrays:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>location;<\/li>\n\n\n\n<li>current;<\/li>\n\n\n\n<li>forecast;\n<ul class=\"wp-block-list\">\n<li>forecastday(array);<\/li>\n\n\n\n<li>date;<\/li>\n\n\n\n<li>date_epoch;<\/li>\n\n\n\n<li>day\n<ul class=\"wp-block-list\">\n<li>maxtemp_c;<\/li>\n\n\n\n<li>maxtemp_f;<\/li>\n\n\n\n<li>mintemp_c;<\/li>\n\n\n\n<li>&#8230;<\/li>\n\n\n\n<li>daily_chance_of_snow.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>As you can see, you can think of JSON as a folder structure in Windows explorer. Here is <code>forecast day<\/code> an array (set) of data contained in the object <code>forecast<\/code>. In the collection <code>forecast day<\/code> There are again different objects with names and corresponding values.<\/p>\n\n\n\n<p>To remove all dates from the array <code>forecast day<\/code> we use a For Each Loop. As long as we meet the condition, all requested values are retrieved and placed in the correct cells.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\"><pre class=\"brush: vb; title: ; notranslate\" title=\"\">\nOption Explicit Sub getForecast() Dim Item As Object Dim READYSTATE_COMPLETE As Integer Dim API_key As String Dim http As Object, JSON As Object, i As Integer Dim MyResponse As String Dim strUrl As String Dim strIconUrl As String Call DeleteAllIcons API_keyxxxxxxxxxxxxxxx = &quot;http:\/\/api.weatherapi.com\/v1\/forecast.json?key=&quot; &amp; API_key &amp; &quot;&amp;q=Amsterdam&amp;days=3&amp;aqi=no&amp;alerts=no&quot; READYSTATE_COMPLETE = 4 Set http = CreateObject(&quot;MSXML2.XMLHTTP&quot;) http .Open &quot;GET&quot;, strUrl http.SetRequestHeader &quot;Accept&quot;, &quot;application\/json&quot; http.Send Do Until http.ReadyState = READYSTATE_COMPLETE DoEvents Loop MyResponse = http.ResponseText Set JSON = ParseJson(MyResponse) For Each Item In JSON(&quot; forecast&quot;)(&quot;forecastday&quot;) Sheet1.Cells(2, i + 1).Value = Item(&quot;date&quot;) Sheet1.Cells(4, i + 1).Value = Item(&quot;day&quot;)(&quot;maxtemp_c&quot; ) Sheet1.Cells(5, i + 1).Value = Item(&quot;day&quot;)(&quot;mintemp_c&quot;) Sheet1.Cells(6, i + 1).Value = Item(&quot;day&quot;)(&quot;totalprecip_mm&quot;) Sheet1 .Cells(7, i + 1).Value = (Item(&quot;day&quot;)(&quot;daily_chance_of_ra in&quot;) \/ 100) strIconUrl = &quot;http:&quot; &amp; Item(&quot;day&quot;)(&quot;condition&quot;)(&quot;icon&quot;) With Blad1.Pictures.Insert(&quot;http:&quot; &amp; Item(&quot;day&quot;)(&quot;condition &quot;)(&quot;icon&quot;)) With .ShapeRange .LockAspectRatio = msoTrue End With .Left = ActiveSheet.Cells(3, i + 1).Left .Top = ActiveSheet.Cells(3, i + 1).Top .Placement = 1 .PrintObject = True End With i = i + 1 Next Item End Sub Sub DeleteAllIcons() Dim shape As Excel.shape For Each shape In ActiveSheet.Shapes If shape.Name &lt;&gt; &quot;CommandButton1&quot; Then shape.Delete End If\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"downloads\"> <i class=\"fas fa-download\"><\/i> Downloads <\/h2>\n\n\n\n<p>If you can&#039;t figure it out with the above guide alone, download the sample file or ask a question by leaving a message.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-134726f8-f875-4e84-843e-6802520969e4\" href=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/buienradar-api.zip\">rain radar apic<\/a><a href=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/buienradar-api.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-134726f8-f875-4e84-843e-6802520969e4\"><i class=\"fas fa-file-download\"><\/i> Download<\/a><\/div>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>The possibilities in Excel are virtually unlimited. You can even create your own rainfall radar and process the data in a\u2026 <a class=\"read-more\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2021\/11\/02\/buienradar-in-excel-with-json\/\">Continue reading<\/a><\/p>","protected":false},"author":1,"featured_media":360,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[46,45],"tags":[182,17,47,22,183,181],"class_list":["post-211","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-json","category-vba","tag-api","tag-excel","tag-json","tag-vba","tag-weatherapi-com","tag-weerdata"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.11 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Buienradar in Excel met JSON - Bj\u00f6rn Meijer<\/title>\n<meta name=\"description\" content=\"Maak een dashboard met live weer data in Excel. Op een eenvoudige manier leer je via een API een simpel dahsboard te maken met weerdata.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2021\/11\/02\/buienradar-in-excel-with-json\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Buienradar in Excel met JSON\" \/>\n<meta property=\"og:description\" content=\"De mogelijkheden in Excel zijn nagenoeg onbeperkt. Je kunt zelfs je eigen buienradar maken en de gegevens verwerken in een sheet. Dit gaan we doen met\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bjorn-meijer.nl\/en\/2021\/11\/02\/buienradar-in-excel-with-json\/\" \/>\n<meta property=\"og:site_name\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-02T20:37:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-22T04:40:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"275\" \/>\n\t<meta property=\"og:image:height\" content=\"223\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/\"},\"author\":{\"name\":\"Bj\u00f6rn Meijer\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"headline\":\"Buienradar in Excel met JSON\",\"datePublished\":\"2021-11-02T20:37:32+00:00\",\"dateModified\":\"2023-11-22T04:40:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/\"},\"wordCount\":646,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg\",\"keywords\":[\"API\",\"excel\",\"json\",\"vba\",\"Weatherapi.com\",\"weerdata\"],\"articleSection\":[\"JSON\",\"VBA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/\",\"name\":\"Buienradar in Excel met JSON - Bj\u00f6rn Meijer\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg\",\"datePublished\":\"2021-11-02T20:37:32+00:00\",\"dateModified\":\"2023-11-22T04:40:44+00:00\",\"description\":\"Maak een dashboard met live weer data in Excel. Op een eenvoudige manier leer je via een API een simpel dahsboard te maken met weerdata.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#primaryimage\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg\",\"contentUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg\",\"width\":275,\"height\":223},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bjorn-meijer.nl\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Buienradar in Excel met JSON\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/de\/\",\"name\":\"Bj\u00f6rn Meijer\",\"description\":\"At My Playground\",\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"width\":165,\"height\":165,\"caption\":\"Bj\u00f6rn Meijer\"},\"logo\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.bjorn-meijer.nl\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Buienradar in Excel met JSON - Bj\u00f6rn Meijer","description":"Maak een dashboard met live weer data in Excel. Op een eenvoudige manier leer je via een API een simpel dahsboard te maken met weerdata.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bjorn-meijer.nl\/en\/2021\/11\/02\/buienradar-in-excel-with-json\/","og_locale":"en_US","og_type":"article","og_title":"Buienradar in Excel met JSON","og_description":"De mogelijkheden in Excel zijn nagenoeg onbeperkt. Je kunt zelfs je eigen buienradar maken en de gegevens verwerken in een sheet. Dit gaan we doen met","og_url":"https:\/\/www.bjorn-meijer.nl\/en\/2021\/11\/02\/buienradar-in-excel-with-json\/","og_site_name":"Bj\u00f6rn Meijer","article_published_time":"2021-11-02T20:37:32+00:00","article_modified_time":"2023-11-22T04:40:44+00:00","og_image":[{"width":275,"height":223,"url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg","type":"image\/jpeg"}],"author":"Bj\u00f6rn Meijer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bj\u00f6rn Meijer","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#article","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/"},"author":{"name":"Bj\u00f6rn Meijer","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"headline":"Buienradar in Excel met JSON","datePublished":"2021-11-02T20:37:32+00:00","dateModified":"2023-11-22T04:40:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/"},"wordCount":646,"commentCount":0,"publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg","keywords":["API","excel","json","vba","Weatherapi.com","weerdata"],"articleSection":["JSON","VBA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/","url":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/","name":"Buienradar in Excel met JSON - Bj\u00f6rn Meijer","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#primaryimage"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg","datePublished":"2021-11-02T20:37:32+00:00","dateModified":"2023-11-22T04:40:44+00:00","description":"Maak een dashboard met live weer data in Excel. Op een eenvoudige manier leer je via een API een simpel dahsboard te maken met weerdata.","breadcrumb":{"@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#primaryimage","url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg","contentUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg","width":275,"height":223},{"@type":"BreadcrumbList","@id":"https:\/\/www.bjorn-meijer.nl\/2021\/11\/02\/buienradar-in-excel-met-json\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bjorn-meijer.nl\/de\/"},{"@type":"ListItem","position":2,"name":"Buienradar in Excel met JSON"}]},{"@type":"WebSite","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website","url":"https:\/\/www.bjorn-meijer.nl\/de\/","name":"Bj\u00f6rn Meijer","description":"At My Playground","publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","width":165,"height":165,"caption":"Bj\u00f6rn Meijer"},"logo":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.bjorn-meijer.nl"]}]}},"jetpack_featured_media_url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/Excel-dashboard-buienradar.jpg","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":12,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":2654,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/211\/revisions\/2654"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media\/360"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}