WQL Query Data Stream – InvalidPathException: Could not find path in stream: $.data

[vmanojkumar]

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?

[Tanushree Maiti]

Hi @vmanojkumar ,

At backend , check the Workday flow context. 

Ensure exactly where error is throwing. 

Ensure end point does not showing '//' in the path.

As you are using OOB Flow, For the troubleshooting , you can raise a hi-ticket to your ServiceNow Vendor as well.