Inventree-Python and LibreOffice Calc

[bobb-uk]

Hi all,

Inventree 1.4.2
API 511
Python 3.12.3

I am calling Inventree-Python function PartCategory.list with an empty PARENT parameter, but instead of returning the expected few top level entries, the function is returning all categories.

import uno

from inventree.api import InvenTreeAPI
from inventree.part import PartCategory, Part

def invent_connect():
	#SERVER_ADDRESS = 'http://inventree/'
	SERVER_ADDRESS = 'http://172.17.16.84'
	USER='testuser'
	PASS='testpassword'

	api = InvenTreeAPI(SERVER_ADDRESS, username=USER, password=PASS)
	categories = PartCategory.list(api, parent='')

	doc = XSCRIPTCONTEXT.getDocument()
	sheet = doc.getCurrentController().getActiveSheet()

	row = 0

	cell = sheet.getCellByPosition(0,row)
	cell.setString(str(len(categories))+' top level categories found')
	row+=1

	category_size = len(categories)
	if ((category_size) > 10):
		category_size = 10

	for n in range(0, category_size):
		col = 0

		cell = sheet.getCellByPosition(col,row)
		meta_u = categories[n].metadata_url
		cell.setString(meta_u)
		col+=1

		cell = sheet.getCellByPosition(col,row)
		pk = categories[n].getPkField()
		cell.setString(pk)
		col+=1

		cell = sheet.getCellByPosition(col,row)
		pkv = categories[n].getPkValue()
		cell.setString(pkv)
		col+=1

		cell = sheet.getCellByPosition(col,row)
		mt = categories[n].getModelType()
		cell.setString(mt)
		if (mt == 'partcategory'):
			cell = sheet.getCellByPosition(col,row)
			cell.setString(PartCategory(api, pkv).name)
			col+=1

			cc = categories[n].getChildCategories()
			if (len(cc) >= 1):
				for i in range(0, len(cc)):
					cell = sheet.getCellByPosition(col,row)
					cc_pkv = cc[i].getPkValue()
					cell.setString(PartCategory(api, cc_pkv).name)
					row+=1
		row+=1

	return

These are the output as stored in LO Calc. (no company secret info here)

69 top level categories found
metadata/partcategory/5/	pk	5	Documents	780 Schematic
metadata/partcategory/56/	pk	56	780 Schematic
metadata/partcategory/1/	pk	1	Electrical		115 Cable
											120 Capacitor
											122 Camera
											125 Connector
											126 FFC Sockets
											130 Crystal
											140 Diode
											141 Display Module
											150 IC
											151 IC Socket
											155 Inductor
											156 LED
											158 Motor
											160 Misc Electrical
											165 Oscillator
											172 Power Supply
											175 PCB FPC
											180 Resistor
											185 Switch
											186 Touch Sensor
											195 Transistor
											196 PC Peripheral
metadata/partcategory/7/	pk	7	115 Cable
metadata/partcategory/8/	pk	8	120 Capacitor
metadata/partcategory/9/	pk	9	122 Camera
metadata/partcategory/10/	pk	10	125 Connector
metadata/partcategory/68/	pk	68	126 FFC Sockets
metadata/partcategory/11/	pk	11	130 Crystal
metadata/partcategory/12/	pk	12	140 Diode

I expect to only receive categories such as Documents and Electrical, but I also receive their child categories too.
Documents have a 7xx prefix code and Electrical have a 1xx prefix code.

Am I doing something incorrect ? Is this a bug that needs filing ?

Many thanks,
Bob.

[lMysticl]

Use the dedicated top_level filter:

categories = PartCategory.list(api, top_level=True)

In InvenTree 1.4.2, that filter applies parent=None and returns only root categories.

parent='' is treated as an empty value by the parent filter, so no parent filtering is applied and the endpoint returns every category. This is not related to LibreOffice; the parent='' example in the Python documentation does not match the 1.4.2 server behavior.

See the top_level filter implementation.

[bobb-uk]

Many thanks for explaining that.
I will experiment later when I have time.

Cheers,
Bob.