API call

[goodmanjl531]

Is there any way i can use Autoit to make an api call then retrieve the data and place it in an excel sheet or word document?

 

My API call is http://www.apilayer.net/api/live?access_key=<APIKEY>&source=USD&currencies=USD,CAD,MXN,EUR,GBP&format=1

the response in a browser will look like this..

{ 
    "success":true,
    "terms":"https:\/\/currencylayer.com\/terms",
    "privacy":"https:\/\/currencylayer.com\/privacy",
    "timestamp":1561127649,
    "source":"USD",
    "quotes":{ 
      "USDUSD":1, 
      "USDCAD":1.321855, 
      "USDMXN":19.04369, 
      "USDEUR":0.883095, 
      "USDGBP":0.789296 
     } 
 }

I need to convert to a word doc or excel spreadsheet to ulitmaley populate a text file to send to my system automatically.

[Jos]

Sure...   Look for InetGet() & Excel UDF's in the helpfile and there are several JSON udf's available in the Examples forum.

Jos

[goodmanjl531]

Jos,

 

thanks got the API call to drop into a simple text file, bnow just need to work on formatting it to make it a bit more usefull.