The PAYLOAD_OBJECT BLOB has the JSON data inserted.
Need to create cases using the PAYLOAD_OBJECT JSON in Pega.
1)We tried to create the external Table as a datatype and expose the Column for Payload. It doesn't support larger requests due to varchar limitation. We tried updating the data type to BLOB in the DB Column but it doesn't fetch any data.
2) We tried the Connector Metadata setup. But the Blob couldn't be mapped to any Property type and always erroring as "