extract first line of "content" for all documents of a certain type

I would like to see the ISA Control # for every 832 document that I have sent to a certain partner. I can use Trading Networks to search for that document and that vendor, but to get all the data that I want, I have to double click each row, view the “Content” tab and then manually extract the data.

Is there a faster way of doing this?

I have looked at the tables and tried to use SQL queries, but the “Content” in the BizDoc table is encrypted (I think…it just shows up as 0x17183…). What table has the decrypted Content that I see when using TN Console? (I figure I can use SQL to trim the Content to the first X chars and then use Regular expressions to remove everything but the control #)

You can view retreive all envelope (ISA/GS control) information for any particular bizdoc/transaction (edidata) programmatically via this invoking service:

wm.b2b.edi:envelopeProcess (WmEDI)


I’m not sure that would work for me. I’m not trying to extract it at the time of PROCESSING the document. These documents have already been processed. I just want to get the ISA Control # of each one (without re-processing, as that would create problems).

Do you mean there is a way to use this service and go through each document of a certain type (that has already been processed) and get the ISA control #?

I’m more familiar with SQL and would prefer just getting it from the DB myself…but I can’t seem to find it.

In that case you can access it while processing before to TN itself you can access this via envelopeProcess service right after the addICEnvelope step and extract the information you need to:

If you want to search/select from the db then browse the EDI tracking tables reference the bizdoc/InternalId as the correlation?

Thee are few tn:query services also available if want check that also.