Add a stored procedure with variable using MySQL Connector

[UtiliseIT]

Hi, Im using the Python MySQL Connector to fire a stored procedure with a variable.

Thanks to the awesome help in this forum my working version of an insert is

query = ("SELECT distinctrow UPC, ItemFriendlyNames, ItemName, Brand, Model, Retailer, ItemID FROM my.view where ItemFriendlyNames like "%(pSearch)%" order by UPC, Model, Retailer")
data = (event['pSearch'],)
         
cursor.execute(query,data)
rows = cursor.fetchall()

What I need to do is fire stored procedure sp_showitemswithSearch that recieves an input called pSearchTerm

Ive tried to format based on the select query and also tried callproc but can't quite seem to get either format right.

Thanks in advance

Todd