And now we are going to deal with a dictionary. So now go back to the Form and click on Tools and select references. You can see a new module here, so it imported all the scripts which are present on the Bas file. So this is the folder that I extracted go inside this folder and select the JsonConverter.bas And click on Open. The first thing is we need to import the JSON converter that we download from Github. So before writing a script, we need to do some import. So now you can see the visual basic IDE and go to insert, and insert a form and add two button control on it. so go to the developer tool and visual basic. I have already created a blank Excel format. So just click on the download code and it will be downloaded in the zip format.Īnd now go to your Excel sheet. So we are going to use VBA-tools JSON parser which helps us to parse the JSON that we receive after making a get request.Īnd we have to pass this JSON object as a parameter to this VBA JSON or method so that we can easily parse the object and get a value that we are looking for.
How to call rest api from excel vba and parse json response return by rest ApiĪnd this is what we are going to use that in our script. If you make an API call with this get request, you will get on the dummy data user ID, email,first_name,last_name, image, etc.
0 kommentar(er)
