Data stream from BMC

[JJ21]

Hi,

Hopefully someone can point out what I'm doing wrong. I'm trying to set up a data stream to pull data from BMC Helix. I'm getting the payload returned from the Rest call and it looks fine to me, however whenever I run the data stream I get an error like so;

record path is not a valid JSON Path: $[0].results

within the splitter step it's defined as JSON with an Item path of;

$[0].results

i've tried a number of other paths with similar results record path is not a valid JSON Path: $[0].results[0]

Co-pilot thinks ;

 since you're still getting the error "record path is not a valid JSON Path: $[0].results" in ServiceNow Data Stream, it suggests that ServiceNow might not support accessing nested arrays inside objects when the root of the JSON is itself an array.

and honestly my head is sore from banging it against this brick wall.  I do have the rest call and payload working via a flow action with a Rest step/JSON Parser/Script step handling the pagination via a data source script.  I would however prefer to get this all into a Data Stream.

a sample of the response body is as below;

[
{
"kind": "HardwareContainer",
"count": 107,
"offset": 0,
"results": [
{
"Name": "changedname",
"SN": "changedsn",
"Key": "changedkey/Nutanix Block",
"Model": "NX-3060-G6",
"Type": "Nutanix Block",
"Vendor": "Nutanix",
"PKey": null,
"SSkey": null,
"LastScan": "2025-06-03 05:07:15"
}
],
"next_offset": 10,
"next": "https://changedurl/api/v1.11/data/search?query=search+HardwareContainer%0Awhere%0A%28type%3D%27Stora...",
"results_id": "SGFyZHdhcmVDb250YWluZXIAbhRRM2gCAFoQAACbhLQ="
}
]