topic Bulk update of service groups via API in Automation/API Discussions

Bulk update of service groups via API

GLSparks — Thu, 06 Jul 2023 15:15:43 GMT

I have a requirement to do a bulk update of a custom service group in Panorama (11.0.1) via the API. This is reading in a list of services from a CSV file. However it only ever applies the last entry in the CSV. What am i doing wrong? I've tried PUT & POST. Post simply errors with a duplicate entry. A PUT to an existing group only inserts the last entry overwriting everything else.

location = {'location': 'shared', 'name': 'TEST-GRP' }

with open ('groups.csv') as f:
reader = csv.DictReader(f)
for row in reader:
member = row['members']

body = json.dumps(
{
"entry":
{
"@name": "TEST-GRP",
"members": { "member" : [ member ]
}
}
}
)

r = requests.put(api_url, params=location, verify=False, headers=headers, data=body)
print(r.text)

Contents of groups.csv

members
service-https,
service-http,

Re: Bulk update of service groups via API

SimonT — Tue, 11 Jul 2023 07:12:07 GMT

give this a go:

import json
from pandas import *
data = read_csv("groups.csv")
member_list = data['members'].tolist()
member_set = set(member_list)
unique_member_list = list(member_set)
body = json.dumps(
{
"entry":
{
"@name": "TEST-GRP",
"members": { "member" : unique_member_list
}
}
}
)

print(body)

Outputs:

{"entry": {"@name": "TEST-GRP", "members": {"member": ["service-http", "service-https"]}}}

tip: conversion from list to set and back is to remove any duplicates

Re: Bulk update of service groups via API

GLSparks — Thu, 27 Jul 2023 11:02:04 GMT

Just got back to this.

Unfortunately it does not work. I've taken the CSV import out to test also and i still get errors. Tried it with addresses also rather than services:

"code":3,"message":"Invalid Object","details":[{"@type":"CauseInfo","causes":[{"code":12,"module":"panui_mgmt","description":"Invalid Object: TEST-GRP -> members unexpected here."}]}]}
{"entry": {"@name": "TEST-GRP", "members": {"member": ["gav-1", "gav-2"]}}}

Re: Bulk update of service groups via API

GLSparks — Tue, 01 Aug 2023 08:56:27 GMT

Okay finally got this working so i thought i'd share:

import requests
import json
import csv

with open('test.csv', 'r') as read_obj:
csv_reader = csv.reader(read_obj)
MyList = list(csv_reader)

location = {'location': 'shared', 'name': 'TEST-GRP' }

body = json.dumps(
{
"entry": [
{
"@name": "TEST-GRP",
"@location": "Shared",
"static": {
"member": (MyList)
}
}
]
}
)

r = requests.put(api_url, params=location, verify=False, headers=headers, data=body)
print(r.text)
print (body)

Re: Bulk update of service groups via API

GLSparks — Tue, 01 Aug 2023 08:57:54 GMT

Didn't have pandas available to me but got it to work based off of your input. Thanks