Jan Doležal jandolezal
jandolezal
/ getAddress.gs
Created
June 1, 2021 14:39
Google Apps Script custom function for Google Sheets returning address from Czech company id
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * Get basic string address from ARES XML service in format | |
| * 'street street_number, postcode city' based on ičo (company id). | |
| * API description: | |
| * https://wwwinfo.mfcr.cz/ares/ares_xml.html.cz#k3 | |
| * https://wwwinfo.mfcr.cz/ares/ares_xml_standard.html.cz | |
| * Custom function to be used in Google Sheets. | |
| */ | |
| function getAddress(ico) { |