Update History 2022/10/21 : v2.3.9 Add Added function to return registered location for invoice system Added function to return registered trade name for invoice system Change Changed the function to return the registered name of the invoice system to be equivalent to getting the corporate name of a legal entity. Changed the Replace String function so that it can be executed even if the Replace Target field is blank. 2022/10/18 : v2.3.8 Add Added option to hyphenate streets in address unification. 2022/10/08 : v2.3.7 Change Changed where to get prices of XRP/USD and XEM/USD from coinbase since they were delisted from coinbase. Modified Fixed a bug that the server crashes when access frequency is increased after the daily access limit for one user is reached. Fixed to clarify the error contents when the URL cannot be accessed when converting WebAPI in JSON format to Excel format. 2022/10/01 : v2.3.6 Changed Improved performance of zip code retrieval Fixed Fixed a bug in retrieving a corporation number that could not return results if the name of the corporation included parentheses and the search was performed using single-byte parentheses. Fixed a bug in the retrieval of corporation numbers that in rare cases, different corporation numbers were returned if requests were received at the same time. Fixed a bug in obtaining zip codes that a search for Asahikawa City, Hokkaido returned a wide range of zip codes. Fixed a bug in the zip code retrieval process that could return the number of another street when the zip code is assigned to a street, such as Chuo-ku, Sapporo, Hokkaido. Fixed a bug in the zip code retrieval process that could return the zip code of a wide area for addresses newly established after 2019. 2022/09/24 : v2.3.5 Changes Changed to use official WebAPI for the following functions related to invoice systemGet company name of legal entity Get the location of the legal entity Obtains whether or not the invoice system is registered. Get the registered name of the invoice system 2022/09/18 : v2.3.4 Add Added the ability to create a small graph in a cell. 2022/09/18 : v2.3.3 Add Added hash value generation. 2022/09/13 : v2.3.2 Fixed Changed the behavior to ignore the forced stop when frequent errors occur. 2022/09/10 : v2.3.1 Added Added specification to return sole proprietorship number (see below) when obtaining a corporation number. Added specification to return the sole proprietor's name/name when retrieving the corporation's company name. Added specification to return the sole proprietor's address when acquiring the corporation's location. Change Changed to delete the function of getting the registered name of invoice system. 2022/09/10 : v2.3.0 modified Fixed a server error when retrieving a corporate ID number with a specific corporate name in v2.2.9 or later. 2022/09/05 : v2.2.9 Change Changed database update frequency for invoice system to daily Changed bug report from Google Form to our own system Fix Addressed the problem that IMAGE function cannot display if the string is a response. Return with image. Fixed rare JSON cache corruption issue Fixed issue with v2.2.8 or later not returning an error if the prefecture code cannot be obtained. 2022/09/04 : v2.2.8 Added Added ability to convert formulas to images. 2022/09/03 : v2.2.7 Fixes Server performance improvement Change Created a page for site operators Added a privacy policy stating that access logs are treated as personal information Changed all API use cases to HTTPS 2022/09/03 : v2.2.6 Added Added QR code generation. 2022/09/02 : v2.2.5 added Added function to retrieve registered/unregistered invoice system (qualified invoice storage method) Added function to retrieve registered/non-registered invoice system (qualified invoice storage method) Correction Enhancement of DB performance for obtaining corporate names Fixed a timeout problem when trying to retrieve a zip code with a name similar to a street name in Kyoto Fixed a timeout problem when specifying an incorrect address when retrieving prefecture codes in v2.2.4 or later. Fixed a timeout problem that occurs in rare cases when there is a large number of accesses. 2022/08/30 : v2.2.4 Added Added option to output addresses in numerical digits in "Address Unification". Added option to output streets in numerical digits for address division. Correction Fixed a problem that caused a communication breakdown of about 1 second under overload. Fixed a problem in which certain words in the Wikipedia summary do not return a response. Some other minor internal fixes 2022/08/28 : v2.2.3 Fixed Removed simultaneous access restrictions on Wikipedia article summaries due to Wikipedia partnership Fixed a problem that SDGs URLs are prioritized in URLs of corporations. 2022/08/27 : v2.2.2 Added Added exact match search option to corporation number search Added address option to legal entity number search Change Removed specification to search for reading of legal entity in legal entity number search modified Fixed to return an explicit error when there are no results for a legal entity number search. Fixed problem with corporation number search failing if the corporation name contains multiple space characters. Fixed an issue where the corporation name is not checked when there is only one corporation that matches the reading of the corporation. 2022/08/25 : v2.2.1 Added Added ability to get prefecture code from address Added ability to get city code from address. 2022/08/23 : v2.2.0 added Added Terms of Use and Privacy Policy. 2022/08/20 : v2.1.9 Fixed Added support for Kyoto street names in the zip code return function. 2022/08/20 : v2.1.8 added Supported international holidays. Added international support for holiday list. 2022/08/20 : v2.1.7 added Added Hiragana to Kanji conversion function Added the ability to convert Kanji to Hiragana Fixed Added support for searching corporate names using model dependent characters 2022/08/17 : v2.1.6 Added Added a function to retrieve holiday names in string format (e.g. 2022/08/11).
Added the ability to get holiday names in string format (e.g., 2022/08/11). Correction Fixed an error when retrieving financial information for some companies Fixed broken links to official sites. 2022/08/14 : v2.1.5 Added Added line option to regex-match Changed Added single function of executing regular expression by dividing it into three parts Renewed logo Changed the subtitle of the site 2022/08/11 : v2.1.4 changed Changed the version of getting article summary due to wikipedia specification change. /summary2. 2022/08/07 : v2.1.3 added Added an option to retrieve foreign holidays in the function to retrieve the names of holidays. 2022/08/06 : v2.1.2 Add Released a feature to split first name and last name Added the ability to split a text by a specified character. 2022/08/06 : v2.1.1 Add Released address splitting. 2022/08/06 : v2.1.0 add Released a function to unify addresses. 2022/07/28 : v2.0.9 Add 2022/07/27 : v2.0.8 Add Added number functionalityConvert Chinese numerals to arithmetic numbers Determines if a number is prime or not Measure the number of prime numbers 2022/07/26 : v2.0.7 Fixes Quality improvement of function to get zip code from addressSupported address notations such as county, line, island, jyo, oaza, za, etc. 2022/07/09 : v2.0.6 Added Significantly increased the number of supported currencies for getting prices of virtual currencies Change Change URL for getting prices of virtual currencies (old URL is maintained). 2022/07/09 : v2.0.5 Fixed Converted WebAPI in JSON format to Excel formatFixed a bug in v2.0.1 or later that the target cannot be acquired if it is specified in two or more steps. Specify an error when timeout is not a number Specify the error when target is specified in a special environment. 2022/07/08 : v2.0.4 added Add function to return valid/deactivated phone numbers Fixes Fixed a problem in v2.0.3 that the function to get a zip code from an address is not working. 2022/06/25 : v2.0.3 Added Added Japanese-English translation Added English-Japanese translation Added Japanese-Chinese translation Chinese-Japanese translation added Japanese-Korean Translation added Add Korean-Japanese translation 2022/06/21 : v2.0.2 Changes Site speedup by file compression Improved anti-distortion of corporate names Fixed Fixed a minor documentation error. 2022/06/15 : v2.0.1 Added Added support for searching large business locations by zip code Added ability to use cache in "Convert JSON WebAPI to Excel format Change Changed default behavior of "Convert JSON WebAPI to Excel format" to use cache Changed URL of free English-Japanese dictionary (old URL will be maintained for a while) Changed URL of wikipedia overview (keep old URL for a while) 2022/06/10 : v2.0.0 changed Renewed site design 2022/03/11 : v1.17 Change Changed the specification to display an error message when there are multiple candidates in the function to obtain a corporate ID number. Corresponded to minor distortions in the corporate number search filter Changed the maximum number of accesses per user per day. 2022/03/11 : v1.16 Added Added the ability to retrieve a list of holidays. 2022/03/10 : v1.15 add Added ability to respond with 1 or 0 if there is a holiday ## 2022/03/11 : v1.16 ## 2022/03/11 : v1.15 Added ability to reverse lookup zip code from address Fixes Fixed a bug in the function to retrieve corporate information that was not returning an error when there were no parameters. Security Update. 2021/10/15 : v1.14 Fixed Fixed a bug in v1.13 that zip codes starting with 0 could not be retrieved properly. 2021/07/01 : v1.13 Added Added a function to retrieve corporate information.Corporate name -> Corporate number Corporate name Legal name Address Zip code Location Capital stock Number of employees Official website URL Net Sales Ordinary Income Net income Net Assets Total assets Correction Fix zip code generation logic. 2021/04/19 : v1.12 Added Added contact information on the site Changed Added language specification for wikipedia summary. Changed to shorten sentences by default when retrieving wikipedia summary. 2021/04/03 : v1.11 Added Added the ability to execute regular expressions. 2021/04/02 : v1.10 add Added function to convert WebAPI in JSON format to Excel format. 2021/03/31 : v1.09 added Added a function to get the summary of Wikipedia articles. 2021/03/31 : v1.08 added Added English-Japanese dictionary. 2021/03/30 : v1.07 added Convert to local phone number Convert to international phone number Get country code from international phone number Extract phone number from text 2021/03/28 : v1.06 Add Added ability to convert hiragana to katakana Added ability to convert katakana to hiragana Added ability to convert full-width katakana to half-width katakana Added ability to convert half-width katakana to full-width katakana 2021/03/27 : v1.05 added Added ability to unify special date types Fixed Corrected error handling of search function for addresses by zip code Fixed sitemap generation logic 2021/03/27 : v1.04 Added Added the ability to convert addresses that contain Chinese characters into numerals. 2021/03/25 : v1.03 Add Added the ability to get currency rates. 2021/03/20 : v1.02 Change Major changes to the site design. 2021/03/16 : v1.01 Fixes Applied "Olympic Special Measures Law" rule to the name of national holidays. 2021/02/24 : v1.00 New Release Public release All old functions are closed Released a function to import national holidays into Excel Released Function to import with/without leap year into Excel. 2018/02/22 : v0.05 Support for getting stock prices. 2017/12/28 : v0.04 Implemented a function to retrieve land prices of real estate. 2017/12/27 : v0.03 Google route search implemented. 2017/12/18 : v0.02 2017/10/17 : v0.01 Started production for personal use Currency retrieval function implemented