hello everyone
im working on workflow for automating inventory managemnt for a store so basically they have sql db and an endpoint for products
but here’s the issue : the products are organized in way : category > sub-cat>sub-sub-cat>sub-sub-sub-cat> products
so what i did was i careated dedicated http request for :
1- getting all categories in db and select user most relevant to query
2- get all sub categories of this chosed category and formulate a url link to product
3- execute the http url of the product link and return results
but i noticed very weird behavior of the workflow sometimes it says the product doesnt exists although it exists in db and the ai agent tool returend url for it working fine but not executed for example.
i modified agent prompt but still got same issue
any insights??