api calls

Hello; I am cross-posting this question from SO. I'm using an API (for a project management database) that returns a result in the following form (in JSON format): {'Content': { 'Projects': ['project1', 'project2', 'project3', 'project4'], 'InvoiceGroups': ['group1'...

There is an Excel Add-in that makes retrieving Economic Data from the Federal Reserve (simply called FRED Data) easy. However, there are inherent problems it presents. You put the CODE of the data series you want in row 1, and optionally add Data Manipulations (such as retrieving the change from...

I am trying to make an API call to Geotab website in VBA. Geotab provides a DeviceStatusInfo Object that can be used to get the current Latitude and Longitude. (MyGeotab API Reference) I have been trying for a while in VBA but having no success. Hoping someone can help me out here. Used...

This is the code Option Explicit Const BaseURL As String = "http://dev.virtualearth.net/REST/V1/Routes/Driving?wp.0=" Const APIKey As String = "tsNlc2fsKN0BN5fcfXdU~UEPmyF6E7-PVJQzuaM_o5w~Am8-J3IwQG7V_ZGHT02VjmfpEq7jx697-0UlLiqzDrIiMLaK5d3UIR24RpirTGyW" Private Const READYSTATE_COMPLETE As...

So i have some vba code which allows me to import data form a website using an api. This data take up the columns A to K and approx 50000 rows each. The problem is that whenever i run this code to bring in my data it clears all the contents on the worksheet before the data was there. In the L...

Dear Expert, I hope all are doing well. I have a requirement to retrieve the API data and the retrieved data will be displayed in an Excel cell. So, I successfully retrieved data from the API. But, I wasn't able to display the retrieved data in an Excel cell. Can you please help me with this...

Hi, I am trying to get the minimum prices from winesearcher with an API call in power query. Here is the code: Xml.Tables(Web.Contents( "https://api.wine-searcher.com/x?api_key=???????? &winename=[Weingut] [Weinname] &vintage=[Jahrgang] &location=Europe &currencycode=EUR &bottle_size=b...

Hi All, I'd like to get the spotify web api data from the following link thru Excel PowerQuery web connector: Spotify API link I created a web query with the following code: let Bron = Json.Document(Web.Contents(functionGetNamedRange("SourceURL"), [Headers=[Accept="application/json"...

Hello all this is my first ever attempt to fiddle with APIs. I have vehicle registrations in Column-A cells and I want to use the UK, DVLA vehicle enquiry service API to get the "make" and "colour" in make and colour columns in excel. I have already applied for the API and have my own API now...

Dears, I need your help please in my issue," I'm new to DAX and I have tried many ways in this issue and nothing work with me", simply what I'm trying to do is to loop over my API to get the customer details. the API limit is 50 per page I manage to retrieve one page but when I wrote the...

I am running into trouble with a basic authorization API call: I have multiple accounts through the data source. When I run the below code, it will prompt me once for a singular login/password, but not again for the subsequent procedures. And while the initial API call works , it then assumes...

Hi Friends, I have constructed list of Google CSE JSON API urls with keywords to extract Linkedin profiles data into excel. I have VBA script which can extract Google CSE ATOM results. But, unfortunately Google has change ATOM results to JSON API results. So, the script is not useful anymore...

Hello, I have a query that connect to a API to update a set of data. The problem I am having is once the date first loads any further updates do not update. It is like the connections has been cache or something. Is there a way I can clear the cache so it will update every time it is run. A...

hi Need help with the following; it is clearly beyond me ! I have an API for openweather.org I can Paste the API info into a Browser and get a response back that looks like this; Webinfo...

Hi there I'm using userform for my Daily Routine with minimize button with following code Private Declare Function FindWindowA Lib "user32" _ (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function GetWindowLongA Lib "user32" _ (ByVal hWnd As Long, ByVal...

I’m trying to get all work items related to a Visual Studio Team Services board. I’m surprised there is no “Get all work items” query in the API that Microsoft has published here: https://www.visualstudio.com/en-us/docs/integrate/api/wit/work-items So therefore I made a custom query in VSTS...

Hi All, I am trying to open another application and it has a hot key (CTRL+ALT+C)to open regardless of which window is currently active. I want to activate that application which then puts the cursor in the first entry box and then send it keystrokes. I am able to manually use the hot key and...

The function GetOpenFileName does not work in Excel 2010 (32 bit) in Windows 7, but does work in Excel 2007 (32bit) in Windows. The window does not open and returns "false" to Output. To test the code, you need to run the sub startit. The problem happens in thCommonFileOpenSave, Line containing...

Hi Guys, Urgently need help. I want to know if something is possible or not and if anyone has tried it? I want to find out the high and low of two contract prices by pulling data from bloomberg. Lets say, i want to pull out 30 days of Apple and RIMM stock prices through the vba code, check...

I want to be able to query data from Google Analytics API into excel using VBA. I have tried Googling the web and this forum but all I can find is partial codes or Excel add-ins like "Automate analytics" which do not work for me because I want to query the data and then further write the macro...