uaspeedsite.blogg.se - Use url data link in excel for mac

#Use url data link in excel for mac code#

country=CA This means the station is in Canada.

fuel_type=ELEC This means the station provides electric fuel.

access=public This means the station is open to the public.

status=E This means the station is open and carries alternative fuel.

location=Toronto+ON This means station is located near Toronto Ontario.

For this, I’ll use the following parameters and values. Just for fun, I’m going to get a bit fancy with some of the parameters available in the API to find 5 electric fuel stations that are currently open to the public and nearest to Toronto, Ontario in Canada. We can easily turn something like this into a more familiar and readable table in just a few clicks, so we won’t need to try and decipher our API’s output on our own. The cool thing is Power Query has JSON parsing functionality built in.

#Use url data link in excel for mac code#

The address contains a street name, number and postal code and the email contains a work and personal email. The address and email objects themselves are also arrays of objects. This object is actually an array of 3 objects (name, address and email). "Work": is a simple example of a JSON data object for a person’s contact information. JSON stands for JavaScript Object Notation and it’s a syntax for storing and exchanging hierarchical data. The output of this API is in a JSON format. The output might not be that readable to you if you’ve never seen JSON before. We’ll try some of these out later.Īfter submitting this request URL it will return a whole bunch of data. All the possible parameters are nicely documented on the government website. In fact, you can pass many other parameters to the API by appending them to the URL in a similar fashion. This means the API will return a list of stations near Denver Colorado. Notice the &location=Denver+CO at the end of the URL.

Copy this URL from the email and paste it into the address bar of any browser (I’m using Chrome) then press enter. Let’s try out our example web request from the email with our API key.