Splitting/Expanding 1 record to multiple records in Openpipelines

yniasreynders96 — Thu, 12 Feb 2026 07:13:48 GMT

This is a followup on the post of Reinhard: https://community.dynatrace.com/t5/Open-Q-A/How-to-properly-parse-BizEvents-JSON-data-with-OpenPipeline/m-p/258898

In this case we are talking about BizEvents but the problem is occuring for every datatype that can be processed through openpipelines. We are capturing BizEvents through Oneagent Bussiness Analytics. These requests are about processing documents/payments. The requests we capture are sometimes processing these documents in bulk, so 1 request may contain multiple documents being processed, example:

{ "documents": [ { "documentid": "xxx-xx", "paymentineuros": "896" }, { "documentid": "yyy-yy", "paymentineuros": "957" }, { "documentid": "zzz-zz", "paymentineuros": "491" } ] }

How do we split this one bizevent into multiple bizevents? We are able to do that in our dashboarding and notebooks through the dql command expand, but that is not a possibility in Openpipelines,

Or is there a possiblity to do this from the OneAgent BussinessAnalytics incomming requests configuration?

topic Splitting/Expanding 1 record to multiple records in Openpipelines in Open Q&A

Splitting/Expanding 1 record to multiple records in Openpipelines