Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
Title: How to call an external API with Google App Script
Tutorial Playlists:
Google Apps Script Tutorial for Beginners – https://bit.ly/google-apps-script-tutorial-for-beginners
Automate Internet Explorer with VBA – https://goo.gl/Xmy8Af
Autoit Tutorials for Beginners – https://goo.gl/JHB1E2
Blog: www.amarindaz.com
FB page: http://www.facebook.com/amarindaz
Instagram: https://goo.gl/ma9WUh
What is a Google Apps script?
Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third-party services and build web applications.
====================================================
Recommended books:
Learn Google Apps Script – http://amzn.to/2g00LoM
Google Apps Script for Beginners – http://amzn.to/2gVAKvs
====================================================
In this video, you'll learn how to call external APIs from Google Apps Scripts and parse the JSON response to get the data you want.
For learning purposes, I used fixer.io to get the exchange rates via API call.
You need to use URLFetch service to make the API request. This API returns a response. You need to parse the response using JSON.parse method.
Some API calls also return the response in XML. You need to use XMLservice to parse it.
To register https://fwd.cx/WLGgpTiZW5HK
Check out my app: https://www.myfreshtools.com
Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.