json

Hi everyone! I've been trying to establish a data connection to an online JSON file. This seems to work just fine, but part of the URL is a date, like so: https://www.sampleurl.com/api/file.json?id=25&start=2019-01-01&limit=2500 I'd like to be able to have that date automatically be today's...

Hi All, I am trying to use the NVD database JSON files (available to download from https://nvd.nist.gov/vuln/data-feeds - ) so I can construct a sheet of all the vulnerailities and then I can sort them in Excel. Yes, I realise that NVD does offer a search function so I could limit it to Oracle...

Hi All, I have a macro which worked beautifully on my PC to save a workbook to Dropbox. However, when a colleague tried to use it, it didn't work because Dropbox on their PC is not in the usual place. I have looked into obtaining the Dropbox directory from the json file but I don't know how to...

Hi, I am using VBA-Web to pull in some data in a json format via REST. Which works fine using Public Sub PullStaff()Dim Client As New WebClient Dim Request As New WebRequest Dim RequestResponse As WebResponse WebHelpers.EnableLogging = True Client.BaseUrl =...

Hello, I have a problem with the MSXML2.XMLHTTP object in VBA. I need to send a message in json but the auth token has double quotes in it. So in order for those double quotes to arrive in the message a backslash is used. Now by parsing the xml to Json the xmlhttp object adds an extra...

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, Need to parse a excel sheet containing multiple sheets in it in to a JSON using VBA Macro. And during JSON conversion below should be achieved. 1. The file has multiple sheets. 2. Create a Macro button in a new sheet and call it as Refresh JSON. 3. On click of the above...

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

Hi I have since 1999 downloaded statistics in XML format from a home page and now they have changed to JSON. I can't write code myself and wondering if anyone can help me with VBA code that can pick out details from this file and print the details in a text file. I keep my fingers crossed that...

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've recently got the office 365 package as I have JSON files which I want to use within excel. When I select data > new query > get file > there is no option for JSON yet when I Google it the option should be there. Does anyone know how to fix this as I've checked the ribbon to make sure...

Hey guys! I am having an issue importing JSON into Excel. I am using the VBA-JASON converter from GitHub and I the parse command woks fine. However, I can't get the loop working... I get an error saying 'Object is required' for the loop command, but I can't figure it out.. Don't judge me too...

Hi everyone, May I know if there is a solution to convert my json file to excel format... below data extracts from json... I would like to show 1sr row:add_amount,available_amount,budget_account_code,budget_account_name... 2nd row:0,0,R13006,A123... 3rd row:0,0R13006,A1234...

I can successfully parse the CA Agile Rally API to return information into a worksheet, but the information returned in the description field is full of HTML tags. Is there any way to pull or publish the data in that field without the HTML tags? Sample Code: URL =...

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

Hi, I've a code to import a Json text to excel. There is a way to do a web request to login to the site (probably get cookies too) and parse directly the json url? Sub ConverterJsonEfatura() Dim jsonText As String Dim jsonObject As Object, item As Object Dim i As Long Dim ws As Worksheet Set...

For the last 10 years or so I have wanted to convert JSON data to time series data in Excel. I never found an easy solution. This has irritated me. Coinmarketcap has an API for crypto currencies and JSON data https://api.coinmarketcap.com/v2/ticker/ https://api.coinmarketcap.com/v2/ticker/ {...

How can I convert the following JSON data to an excel table.

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

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