I’m using a WQL query to retrieve data from Workday in ServiceNow. The response is processed using a For Each loop, where each record is then inserted into a target table.
The Workday report contains around 56,000 records. However, the flow does not process all the records consistently. The number of records processed varies randomly—for example, sometimes around 34,000, 26,000, or 24,000 records are processed before the flow stops.
After processing a random number of records, I receive the following error:
InvalidPathException: Could not find path in stream: $.data
The path $.data is valid and works correctly for the records that are processed before the error occurs. I have also verified the response structure, and I don’t see any obvious issue with the path.
Has anyone experienced this issue when using a Workday WQL data stream with a For Each loop in ServiceNow?
