How to get JSON ResponseText back from a custom API
-
Hi Ranjith...
I'am an amateur... VBA coder who uses Record Macros to learn :-/
Wondering if you could help me.... I'm developing an app for getting info about documents....from a custom provider...
on a command line (max OSX) using HTTPie... i can run:http POST https://spec-core-api.herokuapp.com/milimot/rvs ApiKey:spec_toKKDgJi0Mox5ktFAQyWpw passage="developed and markets. a SaaS model software platform focused on. the Emergency Medical Services industry"
I get:
HTTP/1.1 201 Created
Cache-Control: max-age=0, private, must-revalidate
Connection: keep-alive
Content-Type: application/json; charset=utf-8
Date: Mon, 02 Jul 2018 01:02:38 GMT
Etag: W/"7e1d4ff5f77e5e215e62869a4c665438"
Server: Cowboy
Transfer-Encoding: chunked
Via: 1.1 vegur
X-Request-Id: 02c41d61-6d30-437f-b089-1e46f519fc15
X-Runtime: 0.100207{
"processes": {
"ack": 0.03451151658988683,
"app": 0.025408199787289233,
"att": 0.054187316786017035,
"bel": 0.03989399211855288,
"con": 0.11569835364612698,
"drv": 0.08517988123891014,
"idn": 0.12009714306707053,
"val": 0.08841837468901542
},
"structures": {
"avr": 0.07455057115544982,
"bnd": 0.17451269646691783,
"crt": 0.12848040003403838,
"det": 0.07688097343759938,
"ign": 0.16440481070024046,
"iso": 0.056601602188535036,
"rej": 0.22330819969295787,
"sep": 0.10126074632426132
},
"success": true
}I've tried to modify your Public Sub getWeather().at (https://codingislove.com/weather-app-in-excel-vba/) .. by sticking in my URL and my key.. and substituting Char(34) for quotes ... to no avail....
I tried the JSON example at (https://codingislove.com/excel-json/) and modified that... but that does not seem set up for key's ... yet ... I can't get the JSON result I get on the command prompt...
any suggestions?