How To Call External API Using Google App Script

Checkout how to build Email Marketing Tool on google sheets ? https://youtu.be/gy7ypKE6rbg
Title: How To Call External API Using 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 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:

Learning google apps script- http://amzn.to/2g00LoM
Google apps script for beginners- http://amzn.to/2gVAKvs
========================================================

In this video, you are going to learn how to call external API from google apps script and parse the JSON response to get the desired data.

For learning purpose, I've used fixer.io to get the currency rates with api call.

You have to use URLFetch service to make the API request. That API will return response. You have to parse the response using JSON.parse method.

Some API call will also return response in XML. You have to use XMLservice to parse the same.

? To Hire Me ? https://fwd.cx/WLGgpTiZW5HK

? Kite is a free AI-powered coding assistant that will help you code faster & smarter. It integrates seamlessly with all top editors and IDE. Kite gives you smart completions and documentation while you’re typing. I've been using Kite on VSCode for 6 months and I love it! Check out Kite ? http://bit.ly/get-kite