Read API XML input into MySQL database using Python

Ben_Rudick — Tue, 04 Aug 2020 18:27:31 GMT

For a month now, we've been trying to convert the XML output from an API call to the Panorama for the "devicegroup" information. We can do that just fine but cannot convert it into a table that can be inserted into a MySQL database. The structure of the XML file is nested with several identical tags being uses. Each parent has two children. We are using Python and have successfully converted other XML files into tables. We wondered if anyone has any good code for tabulating XML output from the Panorama "show devicegroups" call. Thanks.

Re: Read API XML input into MySQL database using Python

sovep58165 — Fri, 11 Sep 2020 14:52:27 GMT

Hi buddy, I have one developed by me myself, are you still up for it? If yes we can discuss on this further.

Regards,

Joshua Genin

topic Re: Read API XML input into MySQL database using Python in Automation/API Discussions

Read API XML input into MySQL database using Python

Re: Read API XML input into MySQL database using Python