How to format this data to table json

hello again! I have a question on how do i format this as a json?

this is a table from gmail.
image how do i format this as json format??

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

@reve , it appears that a new line character (\n) represents a row in the table. However, it is not clear what servers as a delimiter of columns. Could you copy/paste the JSON output in between pair of triple backticks in this thread, please? Screenshot does not provide that information. If the delimiter is consistent and different from a regular character, for example, a tab, then it should be possible to convert your string into JSON. Otherwise, it might not be possible.

1 Like

do you mean this? Group Nr.* Casino Screen Name Player ID Enrolled Nr. Of Sessions Currency\nTurnover Win/Loss Date when played Comment/Description\n214 T_M MRQE tuongchuu3 0_10709555 28.01.2024 1 VN2 665.50 144.72\n28.01.2024 Signs\nof Opposite betting in 1 game type\n214 T_M MRQE chutuongg1 455_10709562 28.01.2024 1 VN2 663.00 -163.00\n28.01.2024 Signs of Opposite betting in 1 game type\n215 T_M MRQE thihoaii33 0_10710277 28.01.2024 2 VN2 705.50 272.00\n28.01.2024 Signs\nof Opposite betting in 1 game type\n215 T_M MRQE hoaithiii4 455_10710281 28.01.2024 1 VN2 638.00 -338.00\n28.01.2024 Signs of Opposite betting in 1 game type\n216 T_M MRQE Mjde84 0_10710930 28.01.2024 1 INR 7,800.00 -1,280.00\n28.01.2024 Signs of Opposite betting in 1 game type with another user\nwithin Evolution network\n669 T_M MRQE tranthuong2222 0_10711228 28.01.2024 2 VN2 841.75 -598.00\n28.01.2024 Signs of Opposite betting in 1 game type with another user\nwithin Evolution network

Not quite. There are two important steps Iā€™m after

  1. Copy JSON from the node output
  2. Paste the copied value in between the pair of triple backticks, ```, each pair on its own line

Copy JSON from the node output

Paste the copied value

Paste the copied value preceded with and followed by ``` ensuring those triple ticks are on their own line. If you are not aware yet, the same technique is to be used when you want to share your n8n workflow (as apposed to screenshot).

image

1 Like
[
  {
    "id": "18e3c021b891d92b",
    "threadId": "18e3b0abdaaedd44",
    "labelIds.0": "IMPORTANT",
    "labelIds.1": "CATEGORY_PERSONAL",
    "labelIds.2": "INBOX",
    "sizeEstimate": 23522,
    "headers.delivered-to": "Delivered-To: [email protected]",
    "headers.received": "(Google Transport Security); Thu, 14 Mar 2024 01:09:14 -0700 (PDT)\" id=\"sjs-H2\">Received: from mail-sor-f41.google.com (mail-sor-f41.google.com. [209.85.220.41])&#x000d;\nby mx.google.com with SMTPS id l2-20020a67fdc2000000b0046d245e8f81sor323193vsq.2.2024.03.14.01.09.14&#x000d;\nfor <[email protected]>&#x000d;\n(Google Transport Security);&#x000d;\nThu, 14 Mar 2024 01:09:14 -0700 (PDT)",
    "headers.x-received": "X-Received: by 2002:a67:f541:0:b0:472:58d6:af54 with SMTP id&#x000d;\nz1-20020a67f541000000b0047258d6af54mr1131339vsn.12.1710403753813; Thu, 14 Mar&#x000d;\n2024 01:09:13 -0700 (PDT)",
    "headers.arc-seal": "ARC-Seal: i=1; a=rsa-sha256; t=1710403754; cv=none;&#x000d;\nd=google.com; s=arc-20160816;&#x000d;\nb=uMhlraeCA91Y6hBKPUxac8vT5lw3YGdUTnRkpZU5BestjEQmaxWs7MiRqQt7Lj/bU5&#x000d;\nUnHJ9+lA5yeIRAOFlDedtEqvY0TMRW/bywz1xFIawLMLz0H9Jbm0kLgvcRaZVikN7G7r&#x000d;\nkTQGKjhnz2Lo9KmushAjv4VXhKFv157W1nDkDsg7r3rEgWecbMzMN1SSt3pPaK3zWpmy&#x000d;\naqjkP7xtz9tbXVI6w8Tr673QPANcs1cuw5fdgV/FjHXt7oraA882HhXdLc/M9gXc5c+W&#x000d;\nwA4VGhqHOIJFahowUQwlM6TNlMBm0+yAsaGQANxm/4DlNgH7EvnqqJnp3Ajmdte0kQdv&#x000d;\nPvzg==",
    "headers.arc-message-signature": "ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816;&#x000d;\nh=to:subject:message-id:date:from:in-reply-to:references:mime-version&#x000d;\n:dkim-signature;&#x000d;\nbh=SyuC7BXrCTbaOjYJ8Wkk1Z4AjAsAUkOkV3htMs5dFsk=;&#x000d;\nfh=WZeuQp74YrhpEuyHX79rmKH02kZP82o4bL3AZwkfhjg=;&#x000d;\nb=h5sSItoDQUExDx6++g5fQs53b++rfU3kE8H756nwXmVhLGuBadMbYhbhfL5hGu5MiH&#x000d;\nwExOwiJzxXZP6crWknI2EmaRAWd6saPCLWYZdI7yMCqwSe7cXQyocKyRqDS8RiOiv+QN&#x000d;\nNAhI6r1YWTUlSyy+pEA2fNmgjYwag9hl+txSsZuwDuLJWoqm3mdjiwt/PIBF/lCE0z5M&#x000d;\nGujUIhFs1wdMeJzjsr8oZXWGM38cGlbDyZT23VTD1z2ncp90kduzWoyOf2RjyDsznu7x&#x000d;\njun4nGOUcScEFlYKKV3Df8a79wPG3yi17Tl48VxlNXyDzDf/BCYwwvE2OUY5koxMEaX/&#x000d;\nVkBg==;&#x000d;\ndara=google.com",
    "headers.arc-authentication-results": "ARC-Authentication-Results: i=1; mx.google.com;&#x000d;\ndkim=pass [email protected] header.s=20230601 header.b=emUHkJNX;&#x000d;\nspf=pass (google.com: domain of [email protected] designates 209.85.220.41 as permitted sender) [email protected];&#x000d;\ndmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com",
    "headers.return-path": "\" id=\"sjs-M2\">Return-Path: <[email protected]>",
    "headers.received-spf": "Received-SPF: pass (google.com: domain of [email protected] designates 209.85.220.41 as permitted sender) client-ip=209.85.220.41;",
    "headers.authentication-results": "Authentication-Results: mx.google.com;&#x000d;\ndkim=pass [email protected] header.s=20230601 header.b=emUHkJNX;&#x000d;\nspf=pass (google.com: domain of [email protected] designates 209.85.220.41 as permitted sender) [email protected];&#x000d;\ndmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com",
    "headers.dkim-signature": "DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;&#x000d;\nd=gmail.com; s=20230601; t=1710403754; x=1711008554; darn=mnltechnology.com;&#x000d;\nh=to:subject:message-id:date:from:in-reply-to:references:mime-version&#x000d;\n:from:to:cc:subject:date:message-id:reply-to;&#x000d;\nbh=SyuC7BXrCTbaOjYJ8Wkk1Z4AjAsAUkOkV3htMs5dFsk=;&#x000d;\nb=emUHkJNX9/9Y4hJik+6uOcaFS69vKhDe82rZo0Zk+Qo4bpB7ZPtdTHAAYV05Me28oc&#x000d;\niJ6Cd8Ek5LFszk9E08633LqGxenmtpixA8Wp1u0FW+xP/jQsBWJs27STXE/A0v9MicJ2&#x000d;\nSLIjytLUilog+qrlSvp91cbhlEDNbiXZLCiRw9Jd1orb2MwQPDkeV+56wvwl0DSR7omJ&#x000d;\nUosv38Qb+YKR4xaTXBg/ntR1FdTnfL9hTtjl4ZMo7w6wL8ofLIwMgFpNiPYfjRfDw+tn&#x000d;\n3aU7QhDgCzi1/ToTXgijx+5aUsivyNv8yncB7er4b+0IYAYbBMcAkxPUVh5DFqYK+wHk&#x000d;\nkHhA==",
    "headers.x-google-dkim-signature": "X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;&#x000d;\nd=1e100.net; s=20230601; t=1710403754; x=1711008554;&#x000d;\nh=to:subject:message-id:date:from:in-reply-to:references:mime-version&#x000d;\n:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;&#x000d;\nbh=SyuC7BXrCTbaOjYJ8Wkk1Z4AjAsAUkOkV3htMs5dFsk=;&#x000d;\nb=En5oiDCSd2GUWJw5+jxOk1jnT+H4ltQk35+ZlA7lXauzSywYqNcoZM3nvaaqCfVPh4&#x000d;\niloM/9SI/YoYOZgnUpdG92t3aKvuxb8td3mBOyxE4cxuODDo5dAtFpaP/SRvJXf2efNl&#x000d;\nLxyaXG7dXvRtA90spoHiO3IJGqEi4jk1TBGCLzK2IbVAwef9xryAXrda0rdrEAkpiTGw&#x000d;\nzRiNBiaZe778fHlvQ5rhuSayH5fm0PbKFrmvD5woRVMK5PHmtkixW/nLfgHUvIDEBFWo&#x000d;\nfnXLLtHra7O7uClzUiEG3/4ecDiMn8Lq0cEYfn8SKh51aXU3UvhYl0uE8k84yyy1a/Zs&#x000d;\nSofw==",
    "headers.x-gm-message-state": "X-Gm-Message-State: AOJu0Yzo9YIdHtGL9Y5TLoBZ0nHMTVRn1iEBuAPju+gdckQHTLyka/Nd&#x000d;\n&#x0009;AOWGrrsD3KDgszdfx09T/76FBg4Qus6aX32ahuhW2m+/64/I/aMcBJPWxa+XfRacX7jAiUoCPB1&#x000d;\n&#x0009;P2ztZPNB+xJtvRrlgp4XaH2ow4NSCWWHkKpKFAfdV",
    "headers.x-google-smtp-source": "X-Google-Smtp-Source: AGHT+IEFdPavdp19uEdTFcXixRvLHtv4ZIj/GPr93+QKRibjD7hSYEtXjJ9TIPtpncIl72BTXY+aUKaEaYLVKWrLRKQ=",
    "headers.mime-version": "MIME-Version: 1.0",
    "headers.references": "\" id=\"sjs-U2\">References: <[email protected]> <[email protected]>&#x000d;\n<[email protected]>",
    "headers.in-reply-to": "\" id=\"sjs-V2\">In-Reply-To: <[email protected]>",
    "headers.from": "\" id=\"sjs-W2\">From: Harry P <[email protected]>",
    "headers.date": "Date: Thu, 14 Mar 2024 16:09:00 +0800",
    "headers.message-id": "\" id=\"sjs-Y2\">Message-ID: <CAMQZ9J9Rny_5aF05uoRHe0mHkaQaAEDXPWRxbQ7KEr6as7cXfQ@mail.gmail.com>",
    "headers.subject": "Subject: Fwd: Fw: [Service Desk] Request commented # SD-3439052:Opposite&#x000d;\nBetting Update",
    "headers.to": "To: [email protected]",
    "headers.content-type": "Content-Type: multipart/alternative; boundary=\"0000000000002b2d7c06139a68a2\"",
    "html": "---------- Forwarded message ---------\nFrom:Christian Ramirez<[email protected]>\nDate: Thu, Mar 14, 2024 at 11:14 AM\nSubject: Fw: [Service Desk] Request commented # SD-3439052:Opposite Betting Update\nTo: Harry P <[email protected]>\n\n\n\n\n\nFrom:Evolution Service Desk <[email protected]>\nSent:Tuesday, January 30, 2024 4:46 AM\nSubject:[Service Desk] Request commented # SD-3439052:Opposite Betting UpdateRisk Analysts Team - 29/Jan/24 20:44Dear Casino Team,\nPlease see below newly detected accounts exhibiting signs of opposite betting:"
  },
  {
    "id": "Group Nr.*",
    "threadId": "Casino",
    "labelIds.0": "Screen Name",
    "labelIds.1": "Player ID",
    "labelIds.2": "Enrolled",
    "sizeEstimate": "Nr. Of Sessions",
    "headers.delivered-to": "Currency",
    "headers.received": "Turnover",
    "headers.x-received": "Win/Loss",
    "headers.arc-seal": "Date when played",
    "headers.arc-message-signature": "Comment/Description"
  },
  {
    "id": 214,
    "threadId": "T_M MRQE",
    "labelIds.0": "tuongchuu3",
    "labelIds.1": "0_10709555",
    "labelIds.2": "28.01.2024",
    "sizeEstimate": 1,
    "headers.delivered-to": "VN2",
    "headers.received": 665.5,
    "headers.x-received": 144.72,
    "headers.arc-seal": "28.01.2024",
    "headers.arc-message-signature": "Signs of Opposite betting in 1 game type"
  },
  {
    "id": 214,
    "threadId": "T_M MRQE",
    "labelIds.0": "chutuongg1",
    "labelIds.1": "455_10709562",
    "labelIds.2": "28.01.2024",
    "sizeEstimate": 1,
    "headers.delivered-to": "VN2",
    "headers.received": 663,
    "headers.x-received": -163,
    "headers.arc-seal": "28.01.2024",
    "headers.arc-message-signature": "Signs of Opposite betting in 1 game type"
  },
  {
    "id": 215,
    "threadId": "T_M MRQE",
    "labelIds.0": "thihoaii33",
    "labelIds.1": "0_10710277",
    "labelIds.2": "28.01.2024",
    "sizeEstimate": 2,
    "headers.delivered-to": "VN2",
    "headers.received": 705.5,
    "headers.x-received": 272,
    "headers.arc-seal": "28.01.2024",
    "headers.arc-message-signature": "Signs of Opposite betting in 1 game type"
  },
  {
    "id": 215,
    "threadId": "T_M MRQE",
    "labelIds.0": "hoaithiii4",
    "labelIds.1": "455_10710281",
    "labelIds.2": "28.01.2024",
    "sizeEstimate": 1,
    "headers.delivered-to": "VN2",
    "headers.received": 638,
    "headers.x-received": -338,
    "headers.arc-seal": "28.01.2024",
    "headers.arc-message-signature": "Signs of Opposite betting in 1 game type"
  },
  {
    "id": 216,
    "threadId": "T_M MRQE",
    "labelIds.0": "Mjde84",
    "labelIds.1": "0_10710930",
    "labelIds.2": "28.01.2024",
    "sizeEstimate": 1,
    "headers.delivered-to": "INR",
    "headers.received": 7800,
    "headers.x-received": -1280,
    "headers.arc-seal": "28.01.2024",
    "headers.arc-message-signature": "Signs of Opposite betting in 1 game type with another user within Evolution network"
  },
  {
    "id": 669,
    "threadId": "T_M MRQE",
    "labelIds.0": "tranthuong2222",
    "labelIds.1": "0_10711228",
    "labelIds.2": "28.01.2024",
    "sizeEstimate": 2,
    "headers.delivered-to": "VN2",
    "headers.received": 841.75,
    "headers.x-received": -598,
    "headers.arc-seal": "28.01.2024",
    "headers.arc-message-signature": "Signs of Opposite betting in 1 game type with another user within Evolution network"
  }
]

i now just want to remove the first bracket data, how can i do that?

1 Like

thank you, i appreciate it. i also did the same yesterday!