Jump to content
Sign in to follow this  
goodmanjl531

API call

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Jos


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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...