Based on the previous result, the 3rd HTTPRequest would return a blank array []. Does the HTTPRequest node react differently during an active workflow?
From a first glance I think one or more of the values in the URL aren’t filled properly making the HTTPreq making a call to a different url endpoint that does need the $count.
The preview can be misleading some times. When you are testing, do you also use multiple items and the same input? As it seems to go wrong with the 3rd call you have something specific to look for.
Thanks for suggestion, the vendor system always make 2 calls simultaneously, hence it isn’t possible to use 1 workflow for test unless enable as active that the webhook continue to listen to the call.
I’d make the effort, separating the metadata webhook from the response service in order to see what’s going on. And I found the culprit. Apparently the caller system auto wrapped my defined query with “$count=true”