I've written some code in VBA which is able to send request complying the search criteria and then parse the response which are in json format without the help of any external converter or library. Here is the script I tried with:Sub Xhrpost()Dim http As New XMLHTTP60Dim PostData As String, itm As VariantRange(A1:F1) = [{FirstName,LastName,City,State,Zip,PhoneNumber}]PostData = region=US&latitude=61.7958256&longitude=-148.8045856&location=Sutton-Alpine%2C%20AK&source=US-STANDALONE&radius=25&pageNumber=1&pageSize=10&sortBy=&industryFilter=340&serviceFilter=550,90With http    .Open GET, https://proadvisorservice.intuit.com/v1/search? & PostData, False    .setRequestHeader Content-Type, application/json; charset=utf-8    .setRequestHeader Accept, application/json;version=1.1.0    .send    itm = Split(.responseText, proAdvisorID : )End Withx = UBound(itm)For y = 1 To x    Cells(y + 1, 1) = Split(Split(itm(y), firstName : )(1), )(0)    Cells(y + 1, 2) = Split(Split(itm(y), lastName : )(1), )(0)    Cells(y + 1, 3) = Split(Split(itm(y), city : )(1), )(0)    Cells(y + 1, 4) = Split(Split(itm(y), state : )(1), )(0)    Cells(y + 1, 5) = Split(Split(itm(y), zip : )(1), )(0)    Cells(y + 1, 6) = Split(Split(itm(y), phoneNumber : )(1), )(0)Next yEnd Sub
Parsing json response using GET request in vba
vba;json;web scraping