Jump to content
Sign in to follow this  

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..

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.


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...