Pipelines JSON Fetch Step settings

records/query returns an object, not a bare array. The records live under data, with fields and metadata beside them. If JSON Records Path is blank, JSON Handler treats the whole object as one record — so you see headers/metadata and nothing to loop.

On the Iterate over JSON Records step (after Fetch JSON), set JSON Records Path to:

/data

Also make sure the Fetch JSON request body is a real runQuery payload, for example:

{"from":"YOUR_TABLE_DBID","select":[3,6,7],"where":"{6.EX.'Open'}"}

Swap in your table dbid, field IDs, and where clause. Keep QB-Realm-Hostname and the Quickbase Usertoken auth schema as you have them.

If you need the raw JSON body without the Iterate step, use the HTTP channel Make Request instead — JSON Handler compresses the body and only exposes records through Iterate.

https://help.quickbase.com/docs/json-handler-details 

https://developer.quickbase.com/operation/runQuery 

https://help.quickbase.com/docs/http-channel