Hello Forum,
I'm trying to decode the message_attachments from the xdr_xge_att_data table. If you query, you get a result which looks like JSON but it seems is not. I tried with JSON queries like this:
CAST ("message_attachments" as JSON), json_extract(CAST ("message_attachments" as JSON) but the result ends every time like this
[{"name":"invoive.pdf","checksum":"41ce6fa5e0a3656efca22b909d76ccc077ff3dc3d7b2273491bf02119e3ce222","size":35193},{"name":"invoive.pdf","checksum":"c727a008e1e052765e6b1fc957fddb804702c3d5c508549bffb0b8179e591b07","size":1041}]
What I try to extract is only the filename. For exapmle the invoive.pdf
If anyone could give me a hint?
Thanks!
Sevensix
