goodmanjl531 1 Posted June 21, 2019 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¤cies=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. Share this post Link to post Share on other sites
Jos 2,275 Posted June 21, 2019 Sure... Look for InetGet() & Excel UDF's in the helpfile and there are several JSON udf's available in the Examples forum. Jos 1 goodmanjl531 reacted to this SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Share this post Link to post Share on other sites
goodmanjl531 1 Posted June 21, 2019 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. Share this post Link to post Share on other sites