I have experienced exactly the same issue as @gigisherer1 where the endpoint I was calling returns a response where the root element is an array itself. The path $.[*].property which tests correctly (as you say using https://jsonpath.herokuapp.com/ with Goessner selected). However, when using this path in the response mappings nothing gets returned. With debug logging enabled for the connector I could see errors being generated when the connector tried to parse the jsonPath expression. I will need to replicate the issue again to check what the exact error was.
Like @vkoldenh in the response below I had to implement an after operation rule (which is remarkably similar to his example) to parse the response.