Issues pulling data from object stored in one of the columns in Moralis DB

Technical Issue Reporting
#1

Trying to fetch the data from DB which is storing some record emmited from contract and having problems pulling specific info out of the object stored.

Object is below, the data needed is on a bottom in bold text in args ( {“type”:“BigNumber”,“hex”:“0x24”}

{“to”:“0x365AEb8F89cF4bE292bf33640f2493561eF0a1cB”,“from”:“0x9Beba0d0F2cB869984fDA0549c626223743FE591”,“contractAddress”:null,“transactionIndex”:134,“gasUsed”:{“type”:“BigNumber”,“hex”:“0x06d767”},“logsBloom”:“0x00000000000000000000000000000000000000000000000002000000000000000000000000000000000000000400000200000000000100000000000000000001000000000000000000000008000000000000000000000000000000000440000000000000020800000000000000000800000000000000000000000010000000000000000000000000040000000008000000000010000000000000000000000000000000000002000000000000000000000000000000000000000800000000000008000002000000000000000000000000000000000000000000000000000020000000000010000000000000000000000000081000000000008000000000000000”,“blockHash”:“0x1cc16e373b0eb10356df7852f84f23593c58fbd0bed59cd9e519373e77be63e7”,“transactionHash”:“0xc5e841b3fb3ca0489a909087d3e0eec539bba85a779c0429a5a512866bd43a81”,“logs”:[{“transactionIndex”:134,“blockNumber”:11880970,“transactionHash”:“0xc5e841b3fb3ca0489a909087d3e0eec539bba85a779c0429a5a512866bd43a81”,“address”:“0x71762d2E0380FF102FCF6871d1C08a9728F3f05A”,“topics”:[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000000000000000000000000000000000000000000000”,“0x000000000000000000000000365aeb8f89cf4be292bf33640f2493561ef0a1cb”,“0x0000000000000000000000000000000000000000000000000000000000000024”],“data”:“0x”,“logIndex”:302,“blockHash”:“0x1cc16e373b0eb10356df7852f84f23593c58fbd0bed59cd9e519373e77be63e7”},{“transactionIndex”:134,“blockNumber”:11880970,“transactionHash”:“0xc5e841b3fb3ca0489a909087d3e0eec539bba85a779c0429a5a512866bd43a81”,“address”:“0x365AEb8F89cF4bE292bf33640f2493561eF0a1cB”,“topics”:[“0x75ad75d4cfd4b753727c22404598b3c15808a7d991aef0891afe67187a72ebb2”,“0x0000000000000000000000000000000000000000000000000000000000000024”,“0x00000000000000000000000071762d2e0380ff102fcf6871d1c08a9728f3f05a”,“0x0000000000000000000000000000000000000000000000000000000000000024”],“data”:“0x00000000000000000000000000000000000000000000000000000000000000e00000000000000000000000009beba0d0f2cb869984fda0549c626223743fe591000000000000000000000000365aeb8f89cf4be292bf33640f2493561ef0a1cb000000000000000000000000000000000000000000000000000000000000233100000000000000000000000000000000000000000000000000038d7ea4c68000000000000000000000000000000000000000000000000000000000000000233000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000035697066733a2f2f516d665977503953576168425454524e56386d675a61636f67485042575a5a427a6f7948427051344a59736b41650000000000000000000000”,“logIndex”:303,“blockHash”:“0x1cc16e373b0eb10356df7852f84f23593c58fbd0bed59cd9e519373e77be63e7”}],“blockNumber”:11880970,“confirmations”:2,“cumulativeGasUsed”:{“type”:“BigNumber”,“hex”:“0xd57313”},“status”:1,“type”:0,“byzantium”:true,“events”:[{“transactionIndex”:134,“blockNumber”:11880970,“transactionHash”:“0xc5e841b3fb3ca0489a909087d3e0eec539bba85a779c0429a5a512866bd43a81”,“address”:“0x71762d2E0380FF102FCF6871d1C08a9728F3f05A”,“topics”:[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000000000000000000000000000000000000000000000”,“0x000000000000000000000000365aeb8f89cf4be292bf33640f2493561ef0a1cb”,“0x0000000000000000000000000000000000000000000000000000000000000024”],“data”:“0x”,“logIndex”:302,“blockHash”:“0x1cc16e373b0eb10356df7852f84f23593c58fbd0bed59cd9e519373e77be63e7”},{“transactionIndex”:134,“blockNumber”:11880970,“transactionHash”:“0xc5e841b3fb3ca0489a909087d3e0eec539bba85a779c0429a5a512866bd43a81”,“address”:“0x365AEb8F89cF4bE292bf33640f2493561eF0a1cB”,“topics”:[“0x75ad75d4cfd4b753727c22404598b3c15808a7d991aef0891afe67187a72ebb2”,“0x0000000000000000000000000000000000000000000000000000000000000024”,“0x00000000000000000000000071762d2e0380ff102fcf6871d1c08a9728f3f05a”,“0x0000000000000000000000000000000000000000000000000000000000000024”],“data”:“0x00000000000000000000000000000000000000000000000000000000000000e00000000000000000000000009beba0d0f2cb869984fda0549c626223743fe591000000000000000000000000365aeb8f89cf4be292bf33640f2493561ef0a1cb000000000000000000000000000000000000000000000000000000000000233100000000000000000000000000000000000000000000000000038d7ea4c68000000000000000000000000000000000000000000000000000000000000000233000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000035697066733a2f2f516d665977503953576168425454524e56386d675a61636f67485042575a5a427a6f7948427051344a59736b41650000000000000000000000”,“logIndex”:303,“blockHash”:“0x1cc16e373b0eb10356df7852f84f23593c58fbd0bed59cd9e519373e77be63e7”,“args”:[{“type”:“BigNumber”,“hex”:“0x24”},“0x71762d2E0380FF102FCF6871d1C08a9728F3f05A”,{“type”:“BigNumber”,“hex”:“0x24”},“ipfs://QmfYwP9SWahBTTRNV8mgZacogHPBWZZBzoyHBpQ4JYskAe”,“0x9Beba0d0F2cB869984fDA0549c626223743FE591”,“0x365AEb8F89cF4bE292bf33640f2493561eF0a1cB”,{“type”:“BigNumber”,“hex”:“0x2331”},{“type”:“BigNumber”,“hex”:“0x038d7ea4c68000”},{“type”:“BigNumber”,“hex”:“0x2330”},false],“event”:“MarketItemCreated”,“eventSignature”:“MarketItemCreated(uint256,address,uint256,string,address,address,uint256,uint256,uint256,bool)”}]}

#2

=>

[
    {
        "type": "BigNumber",
        "hex": "0x24"
    },
    "0x71762d2E0380FF102FCF6871d1C08a9728F3f05A",
    {
        "type": "BigNumber",
        "hex": "0x24"
    },
    "ipfs://QmfYwP9SWahBTTRNV8mgZacogHPBWZZBzoyHBpQ4JYskAe",
    "0x9Beba0d0F2cB869984fDA0549c626223743FE591",
    "0x365AEb8F89cF4bE292bf33640f2493561eF0a1cB",
    {
        "type": "BigNumber",
        "hex": "0x2331"
    },
    {
        "type": "BigNumber",
        "hex": "0x038d7ea4c68000"
    },
    {
        "type": "BigNumber",
        "hex": "0x2330"
    },
    false
]

How did you add that data into mongo db initially?
What problems are you having now?

#3

The data is coming from emit and written to DB. We trying to pull ItemId from that record.

    const marketContract = new ethers.Contract(NFT_MARKET_ADDRESS, MarketABI, signer)
    const listingPrice = await marketContract.getListingPrice()
    const transaction = await marketContract.createMarketItem(
      tokenURI,
      price,
      cbtprice,
      data.amount || 0, 
      { value: listingPrice }
    )

    const record = await transaction.wait()
    const moralisData = {
      ...omit(["file", "isAmount", "isAuctionSelected", "isbPrice"], data),
      // jsonFile,
      // assetFile,
      tokenURI,
      assetURI,
      **record: JSON.stringify(record),**
      itemId,
      interval: 0,
      isActive: true,
      createdBy: address,
      seller: address,
      holder: NFT_MARKET_ADDRESS,
      isSold: false,
      contract: NFT_MARKET_ADDRESS,
      expirationDate: dayjs().toISOString() // We need to specify value type for fist item
    }
#4

you can sync that event in Moralis DB using event sync, it looks like you are adding a JSON string on how you are doing it there
assuming that moralisData is what you add to db, you could preprocess it to be in the format that you want

for sync events: https://docs.moralis.io/moralis-server/automatic-transaction-sync/smart-contract-events#sync-and-watch-contract-events