Question : vba post request json
Answered by : s3ns4
'https://github.com/VBA-tools/VBA-Web.
'Using this library, it would look like:
Sub sendPostRequest() Dim Body As New Dictionary Dim Client As New WebClient Dim Response As WebResponse Body.Add "mType", "OPEN_SYSTEM_TRADE" Body.Add "systemOwnerId", 10 'Equal to Body = "{""mType"":""OPEN_SYSTEM_TRADE"",""systemOwnerId"":10}" Set Response = Client.PostJson("somewebsite.com", Body) Worksheets("Sheet1").Range("A1").Value = Response.Content
End Sub
Source : https://stackoverflow.com/questions/21021540/post-json-to-web-in-excel-vba | Last Update : Thu, 02 Dec 21