api

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, I am taking a shot at a real-time dashboard, I'd get a kick out of the chance to utilize the powerbi Rest API. My inquiry how does the refreshing of columns function. I have 1300 records to stack once and after that refresh 2 sections for each column at regular intervals. The main rest...

My file uses an API to pull in 500+ streaming stock-quotes -- once the connection has been established and they're being pulled in, they update rather quickly BUT the initial API call to the stock data provider's service often takes over a minute...I suspect it's because I've got a bunch of...

I have a keen interest now in analyzing stocks and other forms of securities. I would like to be able to have Excel grab the information automatically and keep it up to date, but have been unsuccessful thus far. I understand this used to be possible from Yahoo Finance, but apparently they no...

Hello All, I am trying to connect my Marketo data to Excel. I have a custom service, client secret, and client ID. I set an anonymous credential setting because I did not know what else to select. Other options (Windows, Basic, Web API, Org Account) but those all asked for things out side of...

I'm pulling data every minute from the web via api however occasionally a window pops up with an error message "DataSource.Error: Web.Contents failed to get contents" and everything stops. Once I hit the OK button on that window everything works fine again. I realize that occasionally I will...

Hello, I'm using a Web API to retrieve tables of JSON data successfully into my spreadsheet. In the Query Editor window, there's an "applied steps" sequential list, featuring the first step, "source". Source is the actual web URL of the API itself. The dialog box for source allows entry of the...

Has anyone used Alpha Advantage APIs with excel for importing live stock prices? Yahpoo seem to have dumped their API with no notice and saw this mentioned in a thread as an alternative.

I use the yahoo financial api to download mutual fund prices each day. It has worked fine for months. Today I got run time error 1004 application defined or object defined error the apparent cause of the error is highlighted in bold below. { code Set DataSheet = ActiveSheet...

Is there a way for excel to extract data from Summit FT system through some API or some VBA code?

Hi, I am trying to build a formula that uses some data pulled in from a webservice api. This is the forumual =WEBSERVICE("https://api.coinmarketcap.com/v1/ticker/ethereum/") What i want to do is populate a cell with the current price in USD which is displayed as "price_usd";"343.114" I have...

Dear All, I got a question on the Excel VBA with other software running in my PC. I created a excel file and used DDE to connect the data from the trading software (SPTrader) is fine. Now I want to retrieve the traded record back to the excel file for other purpose. Then I used WinAPI...

I am struggling to extract the data from my JSON source (see below) [{"id":"TEST1","created_at":"2017-02-22 11:55:15 +0000","updated_at":"2017-02-22 12:09:56 +0000","created_by":"chris.k@b.com","fields":[{"id<wbr style="color: rgb(0, 0, 0); font-family: Consolas, "Courier New", monospace...

<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;"> I don't know much about API, in fact, almost nothing. I...

Good afternoon, Can anyone provide me with the code required to find the screen co-ordinates of any window, searchable by its window name as it would appear in appActivate() for example? I know nothing about using APIs to find windows, nor handles etc., and the numerous threads I have read...

Hello all, I'm currently working on a system to print down specific pages from a PDF file loaded into a webbrowser control on a userform into the XPS document writer. I've managed to cahnge the default printer, reference the pdf, run the printpages function and (sometimes) automate the...

Hello all, I have been using the site BrickLink for the past year and would like to use their API to get information from their catalog, etc. I have some basic VBA knowledge, but I am stumped when it comes to using it for this task. I think I have a good grasp of how to use the various methods...

Greetings, I am looking for some excel help with connecting, filtering and using a website API. I have an example of what I am doing by hand and I am looking to automate the process as much as I can. Right now I have a row with airport codes along the top, I then have a row going down...

Hi All, I have made a Sub that I would like to turn into a function, but am having issues getting it to work. here is the Sub I got to work and the function I am trying to get to work Public Sub Runapi() Dim W As Worksheet: Set W = ActiveSheet Dim URL As String: URL =...

I've been searching the boards, but still can't seem to find an answer to why this doesn't work. The authentication works, but when I then try to query the part number I get - "<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN"><HTML> <HEAD> <TITLE>Error 500--Internal Server Error</TITLE>...