Gnosis Pay NFTS transfer Ingest

MarcoVGnosis Pay NFTS transfer Ingest

Updated 2023-08-09

with base as (select * from gnosis.core.fact_decoded_event_logs

where --tx_hash=lower('0x6d0b0f7841348e7f8d6fcfda47155a69077ac40d777cbbcb7a093eaa4eaa0615')

--and

contract_address in('0x417e1d9998aaadd1064365671f9256621fc5def3','0x0d0ce23ddb2eac9439d2ba79f802016a60325b09')

and decoded_log:from <>'0x0000000000000000000000000000000000000000')

SELECT

BLOCK_TIMESTAMP,

BLOCK_NUMBER,

TX_HASH,

'Mint NFT' AS ACTION,

contract_address AS CONTRACT_ADDRESS,

TO_JSON(OBJECT_CONSTRUCT(

'user', decoded_log:to,

'tokenid', decoded_log:tokenid

)) AS EXTRA_DATA

FROM base

Run a query to Download Data

flipside