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?


Log in to reply
 

Looks like your connection to Codingislove Forum was lost, please wait while we try to reconnect.