hreq | User first async http client | Reactive Programming library

I'm trying to use a web API with Excel VBA.

In the API instructions it is written:

Using cURL

Hope somebody might able to help me. I am a real rookie in this field, had a friend of mine write up the following code some time ago. I have VB in Excel that gets data from a yahoo API, URL: "https://query2.finance.yahoo.com/v8/finance/chart/" & ticker & "?interval=1m&range=1d"

The data gets inserted in excel and is auto-refreshed every minute. Everything works smoothly with no issues. Now to the challange, since the data gets auto purged after a day in the excel, I would need to extend the amount of data (rows) from the current 1 day to 7 days. So I tried simply to change the URL from the above mentioned to the following: "https://query2.finance.yahoo.com/v8/finance/chart/" & ticker & "?interval=1m&range=7d"

However the parsing in the code gives me errors which I am to bad at solving.. First warning comes in the code: "Case Else: If token(p + 1) <> ":" Then dic.Add key, token(p)"

And the whole code is as below (feel free to try it in excel if you would like), thanks in advance.

I would like to get data from a JSON-String, which is in a JSON-Array, with VBA to display the data into an Excel-Worksheet. I'm using the library (VBA-JSON v2.3.1 JsonConverter)

I have the following JSON-Object

I would like to get data from a JSON-Object, that I got from a Rest-API, with VBA to display some data into an Excel-Worksheet. I'm using the library (VBA-JSON v2.3.1 JsonConverter).

I have the following JSON-Object:

I have an application that does authentication via oauth.

I am trying to use VBA Excel to access the API provided by the website www.myfxbook.com. The API documentation is here(https://www.myfxbook.com/fr/api). The Steps to get the data are as follows:

1. Login through Login API
2. Get session ID of the session from response of Login API
3. Get data based on this Session ID through various other APIs
4. Logout through the Logout API to generate a new session

The Problem I am facing is that even though the Login and Logout APIs are being used and throwing no error, I am always getting the same Session ID when I am trying to use it through Excel VBA. On the other hand, using the same URLs through Python or even the browser is giving me a different session ID each time. i can only use Excel for this project. Could someone please help me how to get different session ID on successful logout?

I am using the code below to do this. I have hidden (*******) the Email ID and password for security purposes.

I am working with VBA and trying to create a table from a response test using HTTP request. Here is my code:

I connect to the corporate network through Cisco, and then through domain NTLM authorization to the corporate https site.

So I go through the proxy (it’s enough to log in with the password once in IE) and the program goes to all sites except the corporate one, it fails with error 12045 (ERROR_INTERNET_INVALID_CA) or 12057.

How to get a certificate from the store? Naturally, without using a username with a password and certificate name. Help, please, who knows. I tried it also through http.

Here is the function:

I have written a function, which is updating exchange rates depending on date and currency symbol - and it works well. But when I want to change some values (from PLN to, for example, USD) in my worksheet (in defined range), the loop is interputed (in bolded line). Moreover, the range where the exchange rates were saved, change to #ARG!. Below the code of function and loop: