json

Hi all, I would welcome some help with the following macro: Sub getPrices() Dim strURL As String, strJSON As String, strTicker As String, strCurrency As String, strLength As String Dim i As Integer Dim i2 As Integer Dim http As Object Dim JSON As Object, Item As Object Dim LastColumn As Long...

below script runs fine and i also get output in message box. But i keep getting error 424 (Object required) I have used ONLY Microsoft Scripting Library. Sub Test() Set Myrequest = CreateObject("WinHttp.WinHttpRequest.5.1") Myrequest.Open "GET"...

Hello, i have json files (a few) like here: { "Test" : "VB_variable", "Test2" : true, "Test3": "http://google.com", "attributes":[ { "cell":"VB_answer", "property": "highAvailability" } ] } All what i want to get list all values starting from VB*. I am trying to build...

I'm trying to create a file that pulls in real-time golf scores -- the PGA tour site appears to provide data JSON format (which I've never worked with) here: https://statdata.pgatour.com/r/014/leaderboard-v2mini.json I don't quite know how to parse that wall of text for use in Excel 2007. Later...

I been using the same excel dynamic web query for over 10 years, it becane the basis for almost everything I know ab out Excel VBA Soon, all my work will be useless as far as web query is concerned, when the web page in question is progressivly "shut down" The web page is still there, in JSON...

Hi all I've been trying to do this for quite a while. I've used VBA to hit their API to get data, which comes back in JSON format. I'm looking to convert JSON data to something more useful in excel, but so far have been struggling. The JSON file is in this format: <tbody>...

Hi everyone, I'm trying to import and parse the JSON data from the following link into excel using VBA: https://www.alphavantage.co/query?function=SMA&interval=daily&time_period=90&series_type=close&apikey=ES1RXJ7VF1C1L9N5&symbol=MSFT Unfortunately, i'm not able to complete it as it keeps...

Hi, I'm looking for a way to parse a REST API in JSON format without any external modules (like from GitHub). Similar to libraries "Microsoft WinHTTP Services, version 5.1" or "Microsoft XML, v6.0" to parse an XML response, what library contains methods to parse JSON format? And what would be a...

I am my wits' end about this issue. The following code steps through the Output Sheet and writes 24 columns of data into 24 separate files. The file names are in a 3x8 grid on the Temp sheet. The data is being output into .json files for upload into ArcGIS. The code works beautifully for me with...

Hi, I have a spreadsheet that has a list of URLs on Sheet2. The macro pulls the JSON data from each URL and then pastes them in a certain order on another sheet. Since the data pull is huge, it keeps freezing when i try to do all 196 URLs at once. But if i do them 50 at a time, it works just...

I made a scraper in an excel sheet with many importJASON functions that fetch numerical datas from various APIs. The problem is that the format isn't uniform and messes up my VBA calculations. It throws a lot of #REF ! #ERRORS ! etc The reason is that some datas come with decimal separators...

Hi, I have this code for getting JSON data from a specifc URLs that are listed in Sheet2, column A. However, i keep getting an error on the "If" statement. Anyone know how to resolve this? Public Sub NEWURL() Dim https As Object, Json As Object, i As Integer, j As Integer Dim Item...

Hi, I'm thinking that the error is because the url is an HTTPS? I'm getting mismatch type error. I'm trying to getting the JSON data from this URL: https://min-api.cryptocompare.com/data/price?fsym=ETH&tsyms=USD This is the code i'm using: Public Sub exceljson() Dim http As Object, JSON...

It seems I can't find a straight answer anywhere, so I hope someone here is able to answer my question, or at least guide me in the right direction. I'd like to know if there's a way to import specific data from an online source, such as a json or xml file, have it automatically populate the...

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...

Hello, I'm trying to add the key classificationLevels with a value of ["Sectors"] (yes, I need the quotes) to a dictionary When I try Body.Add "classificationLevels", "[""Sectors""]" I actually add the following with the extra ""s. ["Sectors"] I also tried Body.Add "classifiactionLevels"...

Dear all, I have an excel-file with in cells B1, C1, ... , LastColumn1 the name of certain stocks. <tbody> Details BTC ETH NEO LTC ... "LastColum" USD 50 </tbody> Next, I want to send a JSON request to get the Open, High, Low and Close price of these assets. An example can...

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...

Hi I'm using Excel 2016 the import from json is missing on the menu bar Data > New Query > From File (only shows from workbook, csv, xml, text or from folder) need 'from json' I have checked all the other menus undr new query. Also checked in Excel options > add ins etc and cannot spot...

So I'm trying to scrape historic score data from masseyratings.com, and then parse it using a JSON VBA parser. I'm running into issues defining the JSON fields to pull out, I get a runtime error 13 type mismatch on the underlined line of code below. The JSON data for this query looks like this...