json data extract

Hey all, I'm having some issues with parsing data. One of my coworkers sent me a macro (with one module), when I ran that macro in the workbook he sent all worked well and no errors. But when I copied and pasted the module into my workbook it breaks in the "set parse = .parsejson" I'm unsure how...

Hello all, Please forgive me if my post does not sound very professiona as I am quite proficient in Power Query when I extract data from local sources, but this time I have faced a REST API and got a bit lost. I have connected through a REST API and receive data in JSON format. Surprisingly...

Is there a way to create a collection of JSON Files in a folder based on the content of individual cells in a column in excel? So basically, I have a spreadsheet with a column starting with cell B12 to B26. Each cell contains a JSON script. I want a VBA that would convert each of these cells...

Hey everyone, I'm pretty new to Power Query and am having some trouble when it comes to loading times. When I refresh all data in the workbook (which is just the queries) it takes 7 minutes (I got a little frustrated and actually timed it haha) for everything to load and for me to be able to...

Hey there, I am trying to make excel get automatically get data from a link (however the link changes based on certain inputs like ticker symbol, time intervals, to/from time) instead of manually typing out the inputs into the link, putting it into power query, performing transformations, and...

**Definitely a beginner. Please bear with me. First attempt at web scrapping.** I need the following URL to auto-login and retrieve a table from the website. I have pieced together VBA code from different websites to fill in the login information and hopefully pull a table but I am unable to...

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

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