Let’s say you need to extract a bunch of request payloads for a given composites.
Maybe you need to replay them for a Load Test or you need to analyze these payloads.
You’re in luck.
I came across such a requirement where I was tasked to extract as many payload as possible for a given composite in the Dev environment so that we could run a Load Test.
Back in the day, you could do this using the BPEL API, but most of it has been decommissioned and/or is no longer exposed to an outside client.
Not to worry, about some research and some very interesting finds along the way, I find the solution:
The payloads are stored in the AUDIT_DETAIL table in the soa-infra table.
They are split into blocked and compressed while stored in that table. So a given incoming payload is compressed and then the compressed payload is split into multiple rows in the AUDIT_DETAIL table.
You can use the following program to extract them at your heart’s content.