hello again! I have a question on how do i format this as a json?
this is a table from gmail.
how do i format this as json format??
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
- Copy JSON from the node output
- 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).
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])
\nby mx.google.com with SMTPS id l2-20020a67fdc2000000b0046d245e8f81sor323193vsq.2.2024.03.14.01.09.14
\nfor <[email protected]>
\n(Google Transport Security);
\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
\nz1-20020a67f541000000b0047258d6af54mr1131339vsn.12.1710403753813; Thu, 14 Mar
\n2024 01:09:13 -0700 (PDT)",
"headers.arc-seal": "ARC-Seal: i=1; a=rsa-sha256; t=1710403754; cv=none;
\nd=google.com; s=arc-20160816;
\nb=uMhlraeCA91Y6hBKPUxac8vT5lw3YGdUTnRkpZU5BestjEQmaxWs7MiRqQt7Lj/bU5
\nUnHJ9+lA5yeIRAOFlDedtEqvY0TMRW/bywz1xFIawLMLz0H9Jbm0kLgvcRaZVikN7G7r
\nkTQGKjhnz2Lo9KmushAjv4VXhKFv157W1nDkDsg7r3rEgWecbMzMN1SSt3pPaK3zWpmy
\naqjkP7xtz9tbXVI6w8Tr673QPANcs1cuw5fdgV/FjHXt7oraA882HhXdLc/M9gXc5c+W
\nwA4VGhqHOIJFahowUQwlM6TNlMBm0+yAsaGQANxm/4DlNgH7EvnqqJnp3Ajmdte0kQdv
\nPvzg==",
"headers.arc-message-signature": "ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816;
\nh=to:subject:message-id:date:from:in-reply-to:references:mime-version
\n:dkim-signature;
\nbh=SyuC7BXrCTbaOjYJ8Wkk1Z4AjAsAUkOkV3htMs5dFsk=;
\nfh=WZeuQp74YrhpEuyHX79rmKH02kZP82o4bL3AZwkfhjg=;
\nb=h5sSItoDQUExDx6++g5fQs53b++rfU3kE8H756nwXmVhLGuBadMbYhbhfL5hGu5MiH
\nwExOwiJzxXZP6crWknI2EmaRAWd6saPCLWYZdI7yMCqwSe7cXQyocKyRqDS8RiOiv+QN
\nNAhI6r1YWTUlSyy+pEA2fNmgjYwag9hl+txSsZuwDuLJWoqm3mdjiwt/PIBF/lCE0z5M
\nGujUIhFs1wdMeJzjsr8oZXWGM38cGlbDyZT23VTD1z2ncp90kduzWoyOf2RjyDsznu7x
\njun4nGOUcScEFlYKKV3Df8a79wPG3yi17Tl48VxlNXyDzDf/BCYwwvE2OUY5koxMEaX/
\nVkBg==;
\ndara=google.com",
"headers.arc-authentication-results": "ARC-Authentication-Results: i=1; mx.google.com;
\ndkim=pass [email protected] header.s=20230601 header.b=emUHkJNX;
\nspf=pass (google.com: domain of [email protected] designates 209.85.220.41 as permitted sender) [email protected];
\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;
\ndkim=pass [email protected] header.s=20230601 header.b=emUHkJNX;
\nspf=pass (google.com: domain of [email protected] designates 209.85.220.41 as permitted sender) [email protected];
\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;
\nd=gmail.com; s=20230601; t=1710403754; x=1711008554; darn=mnltechnology.com;
\nh=to:subject:message-id:date:from:in-reply-to:references:mime-version
\n:from:to:cc:subject:date:message-id:reply-to;
\nbh=SyuC7BXrCTbaOjYJ8Wkk1Z4AjAsAUkOkV3htMs5dFsk=;
\nb=emUHkJNX9/9Y4hJik+6uOcaFS69vKhDe82rZo0Zk+Qo4bpB7ZPtdTHAAYV05Me28oc
\niJ6Cd8Ek5LFszk9E08633LqGxenmtpixA8Wp1u0FW+xP/jQsBWJs27STXE/A0v9MicJ2
\nSLIjytLUilog+qrlSvp91cbhlEDNbiXZLCiRw9Jd1orb2MwQPDkeV+56wvwl0DSR7omJ
\nUosv38Qb+YKR4xaTXBg/ntR1FdTnfL9hTtjl4ZMo7w6wL8ofLIwMgFpNiPYfjRfDw+tn
\n3aU7QhDgCzi1/ToTXgijx+5aUsivyNv8yncB7er4b+0IYAYbBMcAkxPUVh5DFqYK+wHk
\nkHhA==",
"headers.x-google-dkim-signature": "X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
\nd=1e100.net; s=20230601; t=1710403754; x=1711008554;
\nh=to:subject:message-id:date:from:in-reply-to:references:mime-version
\n:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
\nbh=SyuC7BXrCTbaOjYJ8Wkk1Z4AjAsAUkOkV3htMs5dFsk=;
\nb=En5oiDCSd2GUWJw5+jxOk1jnT+H4ltQk35+ZlA7lXauzSywYqNcoZM3nvaaqCfVPh4
\niloM/9SI/YoYOZgnUpdG92t3aKvuxb8td3mBOyxE4cxuODDo5dAtFpaP/SRvJXf2efNl
\nLxyaXG7dXvRtA90spoHiO3IJGqEi4jk1TBGCLzK2IbVAwef9xryAXrda0rdrEAkpiTGw
\nzRiNBiaZe778fHlvQ5rhuSayH5fm0PbKFrmvD5woRVMK5PHmtkixW/nLfgHUvIDEBFWo
\nfnXLLtHra7O7uClzUiEG3/4ecDiMn8Lq0cEYfn8SKh51aXU3UvhYl0uE8k84yyy1a/Zs
\nSofw==",
"headers.x-gm-message-state": "X-Gm-Message-State: AOJu0Yzo9YIdHtGL9Y5TLoBZ0nHMTVRn1iEBuAPju+gdckQHTLyka/Nd
\n	AOWGrrsD3KDgszdfx09T/76FBg4Qus6aX32ahuhW2m+/64/I/aMcBJPWxa+XfRacX7jAiUoCPB1
\n	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]>
\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
\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!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.