Importing XML/JSON web API Services into MySQL

is it possible to import an xml or json (obtained via web api services) with a stored procedure in Mysql?
I need to automate the import of data from xml / json web api services in Mysql database.
Thanks

See original post by Paridozzo