livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/faacaf42-779b-499c-8fc1-45077e58a868/data/latest'

) :"data" AS data)

SELECT

F.VALUE:EARLIEST_TXN::STRING AS EARLIEST_TXN,

F.VALUE:USER::STRING AS USER

FROM paypal, LATERAL FLATTEN(input => data[]) F