Hello.
I have the next issue, when I run the next commands:
python prueba.py Prueba.csv
File "prueba.py", line 59
reader = csv.DictReader(open(variables_file, 'rb'))
^
IndentationError: expected an indented block
***************************************************************
This is the code of python, the file "prueba.csv" contains the next:
prueba.CSV
| name |
type |
value |
description |
| test |
Network |
6.6.6.0/24 |
test |
prueba.py
# to run from terminal, type <Python test.py sample.csv>
# use at your own risk
#sample.csv
#name,type,value,description
#test,Host,10.20.19.235,test
import csv
import sys
import json
import requests
import time
server = "https://192.168.90.181"
# Modify the username as required
username = "admin"
if len(sys.argv) > 1:
username = sys.argv[1]
#Modify the password as required
password = "securesoft"
if len(sys.argv) > 2:
password = sys.argv[2]
r = None
headers = {'Content-Type': 'application/json'}
#Create the URL
api_auth_path = "/api/fmc_platform/v1/auth/generatetoken"
auth_url = server + api_auth_path
try:
# Download SSL certificates from your FMC first and provide its path for verification.
r = requests.post(auth_url, headers=headers, auth=requests.auth.HTTPBasicAuth(username,password), verify=False)
auth_headers = r.headers
auth_token = auth_headers.get('X-auth-access-token', default=None)
if auth_token == None:
print("auth_token not found. Exiting...")
print(auth_headers)
sys.exit()
except Exception as err:
print ("Error in generating auth token --> "+str(err))
sys.exit()
headers['X-auth-access-token'] = auth_token
api_path = "/api/fmc_config/v1/domain/e276abec-e0f2-11e3-8169-6d9ed49b625f/object/networks" # param
url = server + api_path
if (url[-1] == '/'):
url = url[:-1]
# POST OPERATION
# Function to convert a csv file to a list of dictionaries. Takes in one variable called "variables_file"
def csv_dict_list(variables_file):
# Open variable-based csv, iterate over the rows and map values to a list of dictionaries containing key/value pairs
#print ("Prueba2 --> ")
#sys.exit()
reader = csv.DictReader(open(variables_file, 'rb'))
dict_list = []
for line in reader:
dict_list.append(line)
return dict_list
#print ("Prueba3 --> ")
#sys.exit()
# Calls the csv_dict_list function, passing the named csv
object_dict = csv_dict_list(sys.argv[1])
#pprint.pprint(object_dict)
for post_data in object_dict:
try:
# REST call with SSL verification turned off:
r = requests.post(url, data=json.dumps(post_data), headers=headers, verify=False)
# REST call with SSL verification turned on:
# r = requests.post(url, data=json.dumps(post_data), headers=headers, verify='/path/to/ssl_certificate')
status_code = r.status_code
resp = r.text
print("Status code is: " + str(status_code))
if status_code == 201 or status_code == 202:
print ("Post was successful...")
json_resp = json.loads(resp)
print(json.dumps(json_resp, sort_keys=True, indent=4, separators=(',', ': ')))
else:
r.raise_for_status()
print ("Error occurred in POST --> " + resp)
except requests.exceptions.HTTPError as err:
print ("Error in connection --> " + str(err))
finally:
if r: r.close()
