This is the first time Ive tried to use the Open AI connector and I have a paid account for the API key. I have never accessed the API any other way.When I talked with our partner representative they had the same problem
I did a bit more research. Unfortunately the sql collection I mentioned in my reply wont do sum. It only will let you filter out null values.Normally in sql you can do something like this:SELECT SUM(quantity) AS TotalQuantity FROM your_table_name WHE...
What are you doing to query? One problem is that if you have 2500 items and you iterate through each one you are using 2500 tasks. I dont know about you but we get 250,000 tasks/year for a recipe. So you will run through your tasks very quickly.If yo...