api

Can you provide some sources from which I can learn about using API functions with VBA?

I have established an API question via Power Query and I am just mimic it through VBA. The JSON document that is returned has multiple drill downs that I need; however, I had to create a new connection each time to change the let statements. I think this is where my query is going really slow...

Hi all, Bit of background, I have a live football scores/fixtures/events spreadsheet with a lot of API queries which generally works well, however, occasionally, when querying the API, there are errors in response which Excel flags up in a message box with an "OK" button. Not sure what the...

Hi: Could you help me solve this please? Column G has values like API0001521 or EE0001625 L2 has formula =IF(G2="API*","",INDEX and Match formula))) Excel is returning #N/A and not "" if G2 has value API... INDEX and Match is returning required value if value in G2 is not API Could you help...

Hi All, I have been working on this for days without success. Even downloaded VBA-WEB and looked at examples there, online and everywhere. I can't seem to get this figured out and I have been working with VBA code for 15 years. I am pretty new at API but Postman makes things pretty...

G'day, I have a url for API call: eg: http://<api ip="" address="">User=<<IPADDRESS>>:123456&Type=XYZ currently i need to manually change values for those variable to see the status of those users. i get the response in XML. i have 1000 users and Type of users are PrIV or PER. for each of...

Hi everyone, Hope you are well. I would like to import daily data from JSON via an API into my Excel Online sheet. It is very important that it is Excel Online because it is for collaboration purpose. If I am right, this is not possible. However, could I, as a first step, import Json into a...

Hi, I was originally using some VBA code and Google's API system to calculate distance between Post Codes, it looked like this: Function G_DISTANCE(Origin As String, Destination As String) As DoubleDim myRequest As XMLHTTP60 Dim myDomDoc As DOMDocument60 Dim distanceNode As IXMLDOMNode...

Hi, I have a sheet that has the street address information Columns 2-5. The rows are dynamic. I am attempting to take the data on Sheet Address Verification and have it connect to USPS site and pull back the correct USPS format on the same sheet; however, I am getting an Object error 91. Here...

Hi, Below is the content from the API documentation ----------------------------------------- Authentication and token exchange: Once the request_token is obtained from the login flow, it should be POSTed to /session/token to complete the token exchange and retrieve the access_token. curl...

Hi, I've been trying to look for a VBA code or spreadsheet template that imports Distance and Time from the Google Maps API. Everything I've seen so far either only have Distance or use ActiveX :( :( Compounded to it is the fact that I use a Mac. I'm not sure if XML works well on Mac's Excel...

Hello all, I would like some help with an issue I am having when I am running my macro. I am using Moody's Excel Add In, and as I pull in DataPoints using their API function it requests the data that I need. Although when I run a marco that has these formulas built with their API functions...

I would greatly appreciate VBA code to submit an API request from excel to the following URL: https://geocoding.geo.census.gov/geocoder/geogaphies/onelineaddress?address=A1+A1+A1+A1+A1=A1&benchmark=4&vintage=4&format=json&layers=8 API Response data placed below A1. Trigger to request API...

Hi, I've had a google of how to do this and have gotten stuck :( I would like to use excel to dl and parse data from www.teamgate.com I have already used the api to connect to klipfolio so I just need to get power query to work ! My (edited for security) details are : GET...

I was wondering if someone could help me retrieve data from an api from http://www.coinapi.io Does this require VBA? If not, will VBA cause data retrieval to be less sluggish? I have tried looking online for the answer, but keeping running across complicated vba explanations.

Hi, I am building a program in Excel/VBA to execute operations in the trading platform CEX.io. I am using their API and it is working perfectly for any public call. However, when I need to use Private calls, I cannot manage to correctly send the parameters requested for the authorization. Every...

Hello, I'm a newbie in Excel VBA. I have a task assigned where I need to read the multiple testcases(inputs) from a excel file,like reading of different test cases and paste the outputs(after formulas and all applied) in different sheet everything through a VBA. I don't have a JSON data or a URL...

Hello I am a non technical user. I am using Excel 2016 Power Query to pull data from a web API. The queries deliver 8 x JSON files and I have set the refresh rate to once per minute. The data is very basic financial market data (open,close, high, low etc) so I'm guessing the files are...

I have a spreadsheet with tracking information on it that I am trying to send through a API to create a tracking event. The issue I have is making sure my body is in JSON format. I have managed to parse my excel cells to JSON but now I need to know how to actually save this as a string instead...

My company uses a spreadsheet to put all their tracking number on and I'm trying to come up with a solution that will automatically update some tracking info and show it on the worksheet. I found a company online that offers tracking services for multiple couriers and they offer an API...