Quick question for understanding: The BLOB is a compressed Pega specific format of representing the data (in clipboard). It is essentially a byte stream that only Pega platform can make sense of. Please clarify why you would need that stream in Excel?
Note that UDF queries are extremely slow and can only work with scalar references. So if your BLOB contains a nested structure, then it would not be possible to get all entries. Example - page list property where the list may have different number of entries in each row.
Is there any pega libraries available or any other means to extract the BLOB into a readable format (could be XML) without using pega application. External teams have access to database so need to know how can they access BLOB content?
This comment has been branched out as a new node and the new thread can be followed here