Importing XML/JSON web API Services into MySQL

Discussion in 'MySQL' started by Paridozzo, Aug 30, 2013.

0
  1. #1
    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
     
    Paridozzo, Aug 30, 2013 IP
  2. kutchbhi

    kutchbhi Active Member

    Messages:
    130
    Likes Received:
    4
    Best Answers:
    2
    Trophy Points:
    70
    #2
    You mean insert an xml/json directly into mysql ? I don't think so thats doable. I could be wrong..

    With php though -> piece of cake. - just do a json_decode() and then do a insert into mysql. Let me know if you need help with this.
     
    kutchbhi, Aug 30, 2013 IP