topic Importing rulebase into Excel using XML API in Automation/API Discussions

Importing rulebase into Excel using XML API

ssala — Mon, 13 May 2013 05:44:01 GMT

Hi,

i am having an issue with importing the rules base into excel using the XML API.

the query i am using is: https://hostname/esp/restapi.esp?type=config&key=keyvalue&action=show&xpath=devices/entry/vsys/entry[@name='vsys1']/rulebase/security/rules

I used the following to generate the keyvalue: https://hostname/api/?type=keygen&user=username&password=password

i have used the default admin use to create this keyvalue.

i keep getting the error error code 403. User not authorised to perform this operation.

help would be greatly appreciated as to why this user does not have access or if the query i'm using is incorrect.

Re: Importing rulebase into Excel using XML API

hvcomputech — Mon, 13 May 2013 14:41:23 GMT

What version of PaloAlto are you on? Older versions use esp, newer ones use api, so try this:

https://hostname/api?type=config&key=keyvalue&action=show&xpath=devices/entry/vsys/entry[@name='vsys1']/rulebase/security/rules

Re: Importing rulebase into Excel using XML API

ssala — Mon, 13 May 2013 22:58:18 GMT

we are using PANOS 4.1.7

when i try the string with api instead of esp i get the login prompt and then the dashboard same as i would is i logged in via the browser.

Re: Importing rulebase into Excel using XML API

Retired Member — Tue, 14 May 2013 10:40:34 GMT

If you got 403 error, it means something wrong with your key. There is a known bug in 4.1.x that alter your key during the generation. Please try the below operational command and see if it works.

https://hostname/api/?key=keyvalue&type=op&cmd=<show><system><info></info></system></show>

If you still receive 403 error, please regenerate your key and try again. Once you've got the show system info, then try exporting your rule base again.