Download Excel Macro 👉 https: //gum.co/rest-api-excel-vba (Use code RESTAPI and get it for FREE**) JSON Converter 👉 github.com/VBA-tools/VBA-JSON
**To appreciate my subscribers who turned on 🔔, FREE downloads will be applicable only to the first 50 viewers/downloads after that $0.99.Please subscribe and turn on 🔔 to get my future products for FREE.
Use the MSXML2.XMLHTTP.setRequestHeader to pass the API key you need In the case of a Bearer Token you may have received by calling an OAuth endpoint earlier it would look similar to: MSXML2.XMLHTTP.setRequestHeader "Authorization": "Bearer suPerS$CR$TT0ken"
I imported your JsonConverter module but when I compile it states - "Invalid use of New Keyword" this is in the Function = json_ParseObject - The line the error is happening is = Set json_ParseObject = New Dictionary - please advise
Hi, and how do access data inside a subframe current? i can get lat, lon values, but current has it's own items (dt)? {"lat":xx,"lon":xx,"current":{"dt":1671263568}}
Download Excel Macro 👉 https: //gum.co/rest-api-excel-vba (Use code RESTAPI and get it for FREE**)
JSON Converter 👉 github.com/VBA-tools/VBA-JSON
**To appreciate my subscribers who turned on 🔔, FREE downloads will be applicable only to the first 50 viewers/downloads after that $0.99.Please subscribe and turn on 🔔 to get my future products for FREE.
Nice job sticking to the very minimum steps needed. Keep up the good work.
Excellent! Thank you. I’d like to try for a personal project!
Great video to explain REST API call, response handling and JSON parsing. I was able to understand and apply the principles to my VBA code.
Great, I have an issue when dealing with special UTF-8 characters. Is there any way to handle characters like Chinese, Vietnamese, and Japanese?
Great video!
A quick question if I can: Is it possible to parse the contents of the return to a two dimensional array - columns and rows?
Thanks
Caula
Never knew we could call API in vba
Great Video! Thanks for Sharing!
Great! I'd like to know how to capture a respose via XML object.
how to parse complex nested JSON in vba without knowing nodes and items. is there a way to parse key/value pairs?
Nice tutorial. How to write the parsed JSON properties to the an existing Excel with known columns-json properties mapping ?
I love your tutorial, it's very helpful to me.
Sir do you have any idea about the google drive api? How to use it to perhaps add files in the drive using vba code?
Hi, this is a great video. Do you have an example where you have to pass an API key along as well?
I mean I would buy a VBA script like that.
Use the MSXML2.XMLHTTP.setRequestHeader to pass the API key you need
In the case of a Bearer Token you may have received by calling an OAuth endpoint earlier it would look similar to:
MSXML2.XMLHTTP.setRequestHeader "Authorization": "Bearer suPerS$CR$TT0ken"
Sir can I ask somthing. Can vba connect to google sheet API using this method? Thank you.
FAZ UM TOTURIAL PARA ACESSAR A API DA BINANCE PARA ABRIR OPERAÇÕES PELO EXCEL
very helpful
awesome thanks
I imported your JsonConverter module but when I compile it states - "Invalid use of New Keyword" this is in the Function = json_ParseObject - The line the error is happening is = Set json_ParseObject = New Dictionary - please advise
MS Scripting runtime (for dictionary) is not available for MAC... Only for windows... Ding!
any work around that you found?
@@dawud20886 . I think someone wrote a VB class that simulates a dictionary... We can use that
Need to collect jira issues/Bugs with VBA and paste in a excel sheet? can we do it?
There is a Jira/excel plugin
How to set API key and get data?
Hello, it seems the code you typed RESTAPI has expired
Sir will u help me to autofill I'd and password in gst login portal using vba excel...
I m accountant
Will u plz
Set json = JsonConverter.ParseJson(strResponce)
Debug.Print json("viewCount") I am getting error in this section
Ative a legenda para português
Hi, and how do access data inside a subframe current? i can get lat, lon values, but current has it's own items (dt)?
{"lat":xx,"lon":xx,"current":{"dt":1671263568}}
FAZ UM TUTORIAL PARA ACESSAR A API DA BINANCE PARA ABRIR OPERAÇÕES PELO EXCEL