VBA - downloading JSON from API with password

I had this code written for me to extract JSON files. It has been exactly what I need until now.
The data I'm trying to pull is from the API from a site I have a paid subscription to.
I have a username/login and not an API key.
When I access the API link through a browser I am logged into I am able to retrieve all the data, but when I try to use my VBA code some of the data is restricted and is left off the JSON file.
I have been googling to find any info, but my lack of coding skills limits me.
The only thing I could decipher was I may need the login cookie data.

Does anyone know any options I have ?

here is the code:

Please Login or Register  to view this content.

here is the login page:

HTML Code: 

I have also attached my excel file

Difficult to give you an insight as the site requires an authorisation to access it and can't see the underlying data. The data source might have changed or the code which retrieves the JSON might have have bugs.

wanted to add a little more info:

I found the API by inspecting the data in the network tab on my Firefox browser

here is the link to the actual webpage

HTML Code: 

here is the link to the api

HTML Code: 

there is a lot of data available but you need to be logged in to remove the restricted data

It looks like, you are retrieving a text file rather than a JSON as I could not see JSON code. Suggestion: download the text file and see what it looks like.

nope, its defiantly a JSON file.

I am attaching two JSON files (in ZIP)
1 - from my VBA
2 - from my Firefox (logged in)

Okay! But I do not see JSON's parser code

I don't know about the parser code. All I know what kind of file I can download when extracting the data from the API.

Thanks anyways.
Hopefully someone else has a suggestion.

If the data is in JSON format, you need a JSON parser. In other words, once you load the data as one big junk(What you have attached), you need to extract the data using either text parser or JSON. The code appears to use text parser, not JSON.

I don't have any issue viewing the data inside in the file.
The problem I have is not all of the data goes in the file without the login details

Okay! This is just my guess. There is a reason for the API. APIs usually have JSON file, hence for my suspicion that the code is not accessing the right page as the code does not include an API line.

what i think needs to happen is: my login details are in the cookie data, and i need to get these details incorporated into my VBA.

this is from the cookie details

Please Login or Register  to view this content.

Yes, you might be right. The issue is always: you can't disclose the logging credentials and no one could help to read the code with out accessing the site. Effectively, you are on your own, unfortunately.
Sorry!

if someone is willing to help they can pm me and i can create a temporary password for them.

Are you OK if the Json data in the API link provided in your message #3, dumped into Excel sheet?

Haluk - I would like the data to be saved to my hard-drive which then i can later dump into excel

OK... then try this;

Note that, the JSON file file will be saved in the folder where the Excel file is present. So, the Excel file must be saved before running the code.

Please Login or Register  to view this content.

sorry haluk - this doesn't solve my issue with the restricted data.

i need to add the cookie data from post #8 into the request header when i call for the json file

I couldn't see the cookie in response headers....

Please Login or Register  to view this content.

i pulled this info from the postman app
maybe it will help

Please Login or Register  to view this content.

considering I'm looking to create an automated system which will pull multiple files the only consistent i see in the cookie response header is the premium key.