Does someone know on which table the datum is ?
I did a quick scan through all the tables but did not find a field based on the cardano-db-sync database.
What i found was a field “DataHash” and “AddressHasScript” on the TxOut.
https://mainnet.cutymals.com/odata/TransactionsOut?includeTxSender=false&includeTxReceiver=true&unspentOnly=false&X-API-KEY=ILoveCutyMals&%24filter=DataHash%20ne%20null&%24orderby=id%20desc
→ The query orders the txouts descending and filters for all entries where “DataHash ne null” which means all fields were a value for DataHash exists.
value": [
{
"Id": 49341120,
"TxId": 21314789,
"Index": 0,
"Address": "addr1z8n7s4g2ux528ch6ty3sq3nz65706chdvfykun0hf9kyvtq92vl27xmdcqhdvcu632a585gfsgx9h29atl8uhqph2rdsgkfpn3",
"AddressRaw": "EefoVQrhqKPi+lkjAEZi1Tz9Yu1iSW5N90lsRiwFUz6vG23ALtZjmoq7Q9EJggxbqL1fz8uAN1Db",
"AddressRawInHex": "11e7e8550ae1a8a3e2fa5923004662d53cfd62ed62496e4df7496c462c05533eaf1b6dc02ed6639a8abb43d109820c5ba8bd5fcfcb803750db",
"PaymentCred": "5+hVCuGoo+L6WSMARmLVPP1i7WJJbk33SWxGLA==",
"PaymentCredInHex": "e7e8550ae1a8a3e2fa5923004662d53cfd62ed62496e4df7496c462c",
"StakeAddressId": 3305663,
"Value": 1814813,
"AddressHasScript": true,
"DataHash": "HIoCR9WBEwG7+fsdy77FXJ2uEXWAe22N/N81VosF3mo="
},
{
"Id": 49328174,
"TxId": 21311616,
"Index": 0,
"Address": "addr1w999n67e86jn6xal07pzxtrmqynspgx0fwmcmpua4wc6yzsxpljz3",
"AddressRaw": "cUpZ69k+pT0bv3+CIyx7AScAoM9Lt42Hnauxogo=",
"AddressRawInHex": "714a59ebd93ea53d1bbf7f82232c7b012700a0cf4bb78d879dabb1a20a",
"PaymentCred": "Slnr2T6lPRu/f4IjLHsBJwCgz0u3jYedq7GiCg==",
"PaymentCredInHex": "4a59ebd93ea53d1bbf7f82232c7b012700a0cf4bb78d879dabb1a20a",
"StakeAddressId": null,
"Value": 1851850,
"AddressHasScript": true,
"DataHash": "LaqIOqsrk6zYvEEia0IPJb+a8Yyk8dbTYnHW2tbvazs="
},
The database returns it as “Base64” encoded at the moment, but if thats what you need we can translate that, so you would be able to retrieve it via the API.