Advanced JSON parsing difficulty

Questions
1

1
1620×432 18.2 KB

After extended research, I can’t figure out this myself, how to parse “Id” from “ConversationId” but only if the value of “IsDraft” is false, not true. Thanks.

2

paste txt no post pic.and paste all response.

3

make a keycheck block that sends ‘true’ to custom/free instead of success.

4

Namespace

Newtonsoft.Json.Linq

Lolicode

var json = @"{
    ""IsDraft"": false,
    ""ConversationId"": [{
        ""__type"": ""ItemId:#Exchange"",
        ""Id"": ""AQ0kADAwATY32mVAZS9500d1LTF1N2EtMDACLTAwCgAQAGySSO7xPMhOmIMb6MW4IPo=""
    }],
    // ... other properties
}";

var obj = JObject.Parse(json);

string conversationId = null;
if (obj.TryGetValue("IsDraft", out var isDraftToken) && 
    !isDraftToken.Value<bool>() &&
    obj.TryGetValue("ConversationId", out var convIdToken))
{
    var convArray = convIdToken as JArray;
    if (convArray?.Count > 0 && convArray[0]["Id"] != null)
    {
        conversationId = convArray[0]["Id"].Value<string>();
    }
}
5

[
{
“DateTimeReceived”: “2025-04-05T14:39:04-07:00”,
“Size”: 176114,
“IsRead”: true,
“IsSubmitted”: false,
“IsDraft”: false,
“DateTimeSent”: “2025-04-05T14:38:59-07:00”,
“DateTimeCreated”: “2025-04-05T14:39:03-07:00”,
“DisplayTo”: “emailuk”,
“HasAttachments”: false,
“ExtendedProperty”: [
{
“ExtendedFieldURI”: {
“__type”: “ExtendedPropertyUri:#Exchange”,
“PropertyTag”: “0xe1d”,
“PropertyType”: “String”
},
“Value”: “Compra y venta 100% segura con Wallapop Envíos”
}
],
“LastModifiedTime”: “2025-04-05T17:59:48-07:00”,
“ConversationId”: {
“__type”: “ItemId:#Exchange”,
“Id”: “AQQkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKABAAvsmujIOeQUy6IcRonAn2xQ==”
},
“Flag”: {
“FlagStatus”: “NotFlagged”
},
“InstanceKey”: “AQAAAAAAAQwBAAAINhvxmwAAAAA=”,
“Preview”: " \r\n¿Cómo comprar y vender de forma segura en Wallapop?\r\n\r\nCon Wallapop Envíos tus transacciones serán siempre 100% seguras.\r\n\r\n1. Wallapop Envíos está disponible tanto en la web como en la app\r\nNunca te pediremos que salgas de la aplicación para realizar ",
“MessageToMe”: true,
“MessageCcMe”: false,
“ReceivedOrRenewTime”: “2025-04-05T14:39:04-07:00”,
“InferenceClassification”: “Focused”
},
{
“__type”: “Message:#Exchange”,
“Sender”: {
“Mailbox”: {
“Name”: “Wallapop”,
“EmailAddress”: “emailcom”,
“RoutingType”: “SMTP”,
“MailboxType”: “OneOff”
}
},
“ItemId”: {
“__type”: “ItemId:#Exchange”,
“ChangeKey”: “CQAAABYAAAA8XyCA+HRTTZ88BqyH/rRLAAg0sYKB”,
“Id”: “AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAEYAAANMkc3jrLaBTI7xZHe0I6dwBwA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA8XyCA+HRTTZ88BqyH/rRLAAg2G/GSAAAA”
},
“ParentFolderId”: {
“__type”: “FolderId:#Exchange”,
“Id”: “AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAC4AAANMkc3jrLaBTI7xZHe0I6dwAQA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA=”,
“ChangeKey”: “AQAAAA==”
},
“ItemClass”: “IPM.Note”,
“IsReadReceiptRequested”: false,
“Subject”: “Wallapop: ¡Tu nueva cuenta!”,
“Sensitivity”: “Normal”,
“Importance”: “Normal”,
“From”: {
“Mailbox”: {
“Name”: “Wallapop”,
“EmailAddress”: “emailcom”,
“RoutingType”: “SMTP”,
“MailboxType”: “OneOff”
}
},
“DateTimeReceived”: “2025-04-05T13:40:53-07:00”,
“Size”: 172828,
“IsRead”: true,
“IsSubmitted”: false,
“IsDraft”: false,
“DateTimeSent”: “2025-04-05T13:40:50-07:00”,
“DateTimeCreated”: “2025-04-05T13:40:53-07:00”,
“DisplayTo”: “emailuk”,
“HasAttachments”: false,
“ExtendedProperty”: [
{
“ExtendedFieldURI”: {
“__type”: “ExtendedPropertyUri:#Exchange”,
“PropertyTag”: “0xe1d”,
“PropertyType”: “String”
},
“Value”: “Wallapop: ¡Tu nueva cuenta!”
}
],
“LastModifiedTime”: “2025-04-05T13:42:05-07:00”,
“ConversationId”: {
“__type”: “ItemId:#Exchange”,
“Id”: “AQQkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKABAASL/TVdB2mkW5kLMNIoqy5A==”
},
“Flag”: {
“FlagStatus”: “NotFlagged”
},
“InstanceKey”: “AQAAAAAAAQwBAAAINhvxkgAAAAA=”,
“Preview”: “¡Ya eres uno de los nuestros!\r\nTe damos la bienvenida a Wallapop\r\n¡Vende!\r\n\r\nDale una segunda oportunidad a todas esas cosas que ya no usas: súbelas, véndelas y sácate un dinerito\r\n\r\n¡Súbelo!\r\n\r\n¡Compra!\r\n\r\nEncuentra aquello que buscas al mejor prec”,
“MessageToMe”: true,
“MessageCcMe”: false,
“ReceivedOrRenewTime”: “2025-04-05T13:40:53-07:00”,
“InferenceClassification”: “Focused”
},
{
“__type”: “Message:#Exchange”,
“Sender”: {
“Mailbox”: {
“Name”: “account team”,
“EmailAddress”: “emailcom”,
“RoutingType”: “SMTP”,
“MailboxType”: “OneOff”
}
},
“ItemId”: {
“__type”: “ItemId:#Exchange”,
“ChangeKey”: “CQAAABYAAAA8XyCA+HRTTZ88BqyH/rRLAAg0sYJ9”,
“Id”: “AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAEYAAANMkc3jrLaBTI7xZHe0I6dwBwA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA8XyCA+HRTTZ88BqyH/rRLAAg2G/GPAAAA”
}
}
]

6

that would only work if I have one value but I got multiple

7

this look promising but for some reason when I run it, the OB2 gets stuck using CPU and no results.

8 
BLOCK:ConstantString
  value = "[\n{\n\"DateTimeReceived\": \"2025-04-05T14:39:04-07:00\",\n\"Size\": 176114,\n\"IsRead\": true,\n\"IsSubmitted\": false,\n\"IsDraft\": false,\n\"DateTimeSent\": \"2025-04-05T14:38:59-07:00\",\n\"DateTimeCreated\": \"2025-04-05T14:39:03-07:00\",\n\"DisplayTo\": \"emailuk\",\n\"HasAttachments\": false,\n\"ExtendedProperty\": [\n{\n\"ExtendedFieldURI\": {\n\"__type\": \"ExtendedPropertyUri:#Exchange\",\n\"PropertyTag\": \"0xe1d\",\n\"PropertyType\": \"String\"\n},\n\"Value\": \"Compra y venta 100% segura con Wallapop Envíos\"\n}\n],\n\"LastModifiedTime\": \"2025-04-05T17:59:48-07:00\",\n\"ConversationId\": {\n\"__type\": \"ItemId:#Exchange\",\n\"Id\": \"AQQkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKABAAvsmujIOeQUy6IcRonAn2xQ==\"\n},\n\"Flag\": {\n\"FlagStatus\": \"NotFlagged\"\n},\n\"InstanceKey\": \"AQAAAAAAAQwBAAAINhvxmwAAAAA=\",\n\"Preview\": \" \\r\\n¿Cómo comprar y vender de forma segura en Wallapop?\\r\\n\\r\\nCon Wallapop Envíos tus transacciones serán siempre 100% seguras.\\r\\n\\r\\n1. Wallapop Envíos está disponible tanto en la web como en la app\\r\\nNunca te pediremos que salgas de la aplicación para realizar \",\n\"MessageToMe\": true,\n\"MessageCcMe\": false,\n\"ReceivedOrRenewTime\": \"2025-04-05T14:39:04-07:00\",\n\"InferenceClassification\": \"Focused\"\n},\n{\n\"__type\": \"Message:#Exchange\",\n\"Sender\": {\n\"Mailbox\": {\n\"Name\": \"Wallapop\",\n\"EmailAddress\": \"emailcom\",\n\"RoutingType\": \"SMTP\",\n\"MailboxType\": \"OneOff\"\n}\n},\n\"ItemId\": {\n\"__type\": \"ItemId:#Exchange\",\n\"ChangeKey\": \"CQAAABYAAAA8XyCA+HRTTZ88BqyH/rRLAAg0sYKB\",\n\"Id\": \"AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAEYAAANMkc3jrLaBTI7xZHe0I6dwBwA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA8XyCA+HRTTZ88BqyH/rRLAAg2G/GSAAAA\"\n},\n\"ParentFolderId\": {\n\"__type\": \"FolderId:#Exchange\",\n\"Id\": \"AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAC4AAANMkc3jrLaBTI7xZHe0I6dwAQA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA=\",\n\"ChangeKey\": \"AQAAAA==\"\n},\n\"ItemClass\": \"IPM.Note\",\n\"IsReadReceiptRequested\": false,\n\"Subject\": \"Wallapop: ¡Tu nueva cuenta!\",\n\"Sensitivity\": \"Normal\",\n\"Importance\": \"Normal\",\n\"From\": {\n\"Mailbox\": {\n\"Name\": \"Wallapop\",\n\"EmailAddress\": \"emailcom\",\n\"RoutingType\": \"SMTP\",\n\"MailboxType\": \"OneOff\"\n}\n},\n\"DateTimeReceived\": \"2025-04-05T13:40:53-07:00\",\n\"Size\": 172828,\n\"IsRead\": true,\n\"IsSubmitted\": false,\n\"IsDraft\": false,\n\"DateTimeSent\": \"2025-04-05T13:40:50-07:00\",\n\"DateTimeCreated\": \"2025-04-05T13:40:53-07:00\",\n\"DisplayTo\": \"emailuk\",\n\"HasAttachments\": false,\n\"ExtendedProperty\": [\n{\n\"ExtendedFieldURI\": {\n\"__type\": \"ExtendedPropertyUri:#Exchange\",\n\"PropertyTag\": \"0xe1d\",\n\"PropertyType\": \"String\"\n},\n\"Value\": \"Wallapop: ¡Tu nueva cuenta!\"\n}\n],\n\"LastModifiedTime\": \"2025-04-05T13:42:05-07:00\",\n\"ConversationId\": {\n\"__type\": \"ItemId:#Exchange\",\n\"Id\": \"AQQkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKABAASL/TVdB2mkW5kLMNIoqy5A==\"\n},\n\"Flag\": {\n\"FlagStatus\": \"NotFlagged\"\n},\n\"InstanceKey\": \"AQAAAAAAAQwBAAAINhvxkgAAAAA=\",\n\"Preview\": \"¡Ya eres uno de los nuestros!\\r\\nTe damos la bienvenida a Wallapop\\r\\n¡Vende!\\r\\n\\r\\nDale una segunda oportunidad a todas esas cosas que ya no usas: súbelas, véndelas y sácate un dinerito\\r\\n\\r\\n¡Súbelo!\\r\\n\\r\\n¡Compra!\\r\\n\\r\\nEncuentra aquello que buscas al mejor prec\",\n\"MessageToMe\": true,\n\"MessageCcMe\": false,\n\"ReceivedOrRenewTime\": \"2025-04-05T13:40:53-07:00\",\n\"InferenceClassification\": \"Focused\"\n},\n{\n\"__type\": \"Message:#Exchange\",\n\"Sender\": {\n\"Mailbox\": {\n\"Name\": \"account team\",\n\"EmailAddress\": \"emailcom\",\n\"RoutingType\": \"SMTP\",\n\"MailboxType\": \"OneOff\"\n}\n},\n\"ItemId\": {\n\"__type\": \"ItemId:#Exchange\",\n\"ChangeKey\": \"CQAAABYAAAA8XyCA+HRTTZ88BqyH/rRLAAg0sYJ9\",\n\"Id\": \"AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAEYAAANMkc3jrLaBTI7xZHe0I6dwBwA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA8XyCA+HRTTZ88BqyH/rRLAAg2G/GPAAAA\"\n}\n}\n]"
  => VAR @data.SOURCE
ENDBLOCK

BLOCK:Translate
  input = @data.SOURCE
  translations = {("“", "\""), ("”", "\"")}
  => VAR @data.SOURCE
ENDBLOCK

BLOCK:Parse
  input = @data.SOURCE
  jToken = "$[*].ConversationId.Id"
  RECURSIVE
  MODE:Json
  => VAR @Id
ENDBLOCK

you only needs blocks translate and parse.first block is example of source u get.

9

NAMESPACES

Newtonsoft.Json.Linq
System.Linq

LOLICODE

BLOCK:ConstantString
  value = "[ { \"DateTimeReceived\": \"2025-04-05T14:39:04-07:00\", \"Size\": 176114, \"IsRead\": true, \"IsSubmitted\": false, \"IsDraft\": false, \"DateTimeSent\": \"2025-04-05T14:38:59-07:00\", \"DateTimeCreated\": \"2025-04-05T14:39:03-07:00\", \"DisplayTo\": \"emailuk\", \"HasAttachments\": false, \"ExtendedProperty\": [ { \"ExtendedFieldURI\": { \"__type\": \"ExtendedPropertyUri:#Exchange\", \"PropertyTag\": \"0xe1d\", \"PropertyType\": \"String\" }, \"Value\": \"Compra y venta 100% segura con Wallapop Envíos\" } ], \"LastModifiedTime\": \"2025-04-05T17:59:48-07:00\", \"ConversationId\": { \"__type\": \"ItemId:#Exchange\", \"Id\": \"AQQkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKABAAvsmujIOeQUy6IcRonAn2xQ==\" }, \"Flag\": { \"FlagStatus\": \"NotFlagged\" }, \"InstanceKey\": \"AQAAAAAAAQwBAAAINhvxmwAAAAA=\", \"Preview\": \" \\\\r\\\\n¿Cómo comprar y vender de forma segura en Wallapop?\\\\r\\\\n\\\\r\\\\nCon Wallapop Envíos tus transacciones serán siempre 100% seguras.\\\\r\\\\n\\\\r\\\\n1. Wallapop Envíos está disponible tanto en la web como en la app\\\\r\\\\nNunca te pediremos que salgas de la aplicación para realizar \", \"MessageToMe\": true, \"MessageCcMe\": false, \"ReceivedOrRenewTime\": \"2025-04-05T14:39:04-07:00\", \"InferenceClassification\": \"Focused\" }, { \"__type\": \"Message:#Exchange\", \"Sender\": { \"Mailbox\": { \"Name\": \"Wallapop\", \"EmailAddress\": \"emailcom\", \"RoutingType\": \"SMTP\", \"MailboxType\": \"OneOff\" } }, \"ItemId\": { \"__type\": \"ItemId:#Exchange\", \"ChangeKey\": \"CQAAABYAAAA8XyCA+HRTTZ88BqyH/rRLAAg0sYKB\", \"Id\": \"AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAEYAAANMkc3jrLaBTI7xZHe0I6dwBwA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA8XyCA+HRTTZ88BqyH/rRLAAg2G/GSAAAA\" }, \"ParentFolderId\": { \"__type\": \"FolderId:#Exchange\", \"Id\": \"AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAC4AAANMkc3jrLaBTI7xZHe0I6dwAQA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA=\", \"ChangeKey\": \"AQAAAA==\" }, \"ItemClass\": \"IPM.Note\", \"IsReadReceiptRequested\": false, \"Subject\": \"Wallapop: ¡Tu nueva cuenta!\", \"Sensitivity\": \"Normal\", \"Importance\": \"Normal\", \"From\": { \"Mailbox\": { \"Name\": \"Wallapop\", \"EmailAddress\": \"emailcom\", \"RoutingType\": \"SMTP\", \"MailboxType\": \"OneOff\" } }, \"DateTimeReceived\": \"2025-04-05T13:40:53-07:00\", \"Size\": 172828, \"IsRead\": true, \"IsSubmitted\": false, \"IsDraft\": false, \"DateTimeSent\": \"2025-04-05T13:40:50-07:00\", \"DateTimeCreated\": \"2025-04-05T13:40:53-07:00\", \"DisplayTo\": \"emailuk\", \"HasAttachments\": false, \"ExtendedProperty\": [ { \"ExtendedFieldURI\": { \"__type\": \"ExtendedPropertyUri:#Exchange\", \"PropertyTag\": \"0xe1d\", \"PropertyType\": \"String\" }, \"Value\": \"Wallapop: ¡Tu nueva cuenta!\" } ], \"LastModifiedTime\": \"2025-04-05T13:42:05-07:00\", \"ConversationId\": { \"__type\": \"ItemId:#Exchange\", \"Id\": \"AQQkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKABAASL/TVdB2mkW5kLMNIoqy5A==\" }, \"Flag\": { \"FlagStatus\": \"NotFlagged\" }, \"InstanceKey\": \"AQAAAAAAAQwBAAAINhvxkgAAAAA=\", \"Preview\": \"¡Ya eres uno de los nuestros!\\\\r\\\\nTe damos la bienvenida a Wallapop\\\\r\\\\n¡Vende!\\\\r\\\\n\\\\r\\\\nDale una segunda oportunidad a todas esas cosas que ya no usas: súbelas, véndelas y sácate un dinerito\\\\r\\\\n\\\\r\\\\n¡Súbelo!\\\\r\\\\n\\\\r\\\\n¡Compra!\\\\r\\\\n\\\\r\\\\nEncuentra aquello que buscas al mejor prec\", \"MessageToMe\": true, \"MessageCcMe\": false, \"ReceivedOrRenewTime\": \"2025-04-05T13:40:53-07:00\", \"InferenceClassification\": \"Focused\" }, { \"__type\": \"Message:#Exchange\", \"Sender\": { \"Mailbox\": { \"Name\": \"account team\", \"EmailAddress\": \"emailcom\", \"RoutingType\": \"SMTP\", \"MailboxType\": \"OneOff\" } }, \"ItemId\": { \"__type\": \"ItemId:#Exchange\", \"ChangeKey\": \"CQAAABYAAAA8XyCA+HRTTZ88BqyH/rRLAAg0sYJ9\", \"Id\": \"AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAEYAAANMkc3jrLaBTI7xZHe0I6dwBwA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA8XyCA+HRTTZ88BqyH/rRLAAg2G/GPAAAA\" } } ]"
  => VAR @JS
ENDBLOCK
string json = $"{JS}";
JArray items = JArray.Parse(json);

string ConversationId = string.Join("\n", items
    .Where(item => item.Value<bool>("IsDraft") == false)
    .Select(item => item["ConversationId"]?["Id"]?.ToString())
    .Where(id => id != null));

    MARK @ConversationId
10

I get this error

33
331267×299 77.5 KB

11

This works with the data I submitted indeed but not with the raw source data, I think I made a mistake using a JSON data tree trying to make it easier to read, sorry.

here is the raw source

“Subject”:“Compra y venta 100% segura con Wallapop Envíos”,“Sensitivity”:“Normal”,“Importance”:“Normal”,“From”:{“Mailbox”:{“Name”:“Wallapop”,“EmailAddress”:“newnews.wallapopcom”,“RoutingType”:“SMTP”,“MailboxType”:“OneOff”}},“DateTimeReceived”:“2025-04-05T14:39:04-07:00”,“Size”:176114,“IsRead”:true,“IsSubmitted”:false,“IsDraft”:false,“DateTimeSent”:“2025-04-05T14:38:59-07:00”,“DateTimeCreated”:“2025-04-05T14:39:03-07:00”,“DisplayTo”:“jayrahotmailcouk”,“HasAttachments”:false,“ExtendedProperty”:[{“ExtendedFieldURI”:{“__type”:“ExtendedPropertyUri:#Exchange”,“PropertyTag”:“0xe1d”,“PropertyType”:“String”},“Value”:“Compra y venta 100% segura con Wallapop Envíos”}],“LastModifiedTime”:“2025-04-05T17:59:48-07:00”,“ConversationId”:{“__type”:“ItemId:#Exchange”,“Id”:“AQQkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKABAAvsmujIOeQUy6IcRonAn2xQ==”},“Flag”:{“FlagStatus”:“NotFlagged”},“InstanceKey”:“AQAAAAAAAQwBAAAINhvxmwAAAAA=”,“Preview”:" \r\n¿Cómo comprar y vender de forma segura en Wallapop?\r\n\r\nCon Wallapop Envíos tus transacciones serán siempre 100% seguras.\r\n\r\n1. Wallapop Envíos está disponible tanto en la web como en la app\r\nNunca te pediremos que salgas de la aplicación para realizar “,“MessageToMe”:true,“MessageCcMe”:false,“ReceivedOrRenewTime”:“2025-04-05T14:39:04-07:00”,“InferenceClassification”:“Focused”},{”__type":“Message:#Exchange”,“Sender”:{“Mailbox”:{“Name”:“Wallapop”,“EmailAddress”:“newnews.wallapopcom”,“RoutingType”:“SMTP”,“MailboxType”:“OneOff”}},“ItemId”:{“__type”:“ItemId:#Exchange”,“ChangeKey”:“CQAAABYAAAA8XyCA+HRTTZ88BqyH/rRLAAg0sYKB”,“Id”:“AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAEYAAANMkc3jrLaBTI7xZHe0I6dwBwA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA8XyCA+HRTTZ88BqyH/rRLAAg2G/GSAAAA”},“ParentFolderId”:{“__type”:“FolderId:#Exchange”,“Id”:“AQMkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKAC4AAANMkc3jrLaBTI7xZHe0I6dwAQA8XyCA+HRTTZ88BqyH/rRLAAACAQwAAAA=”,“ChangeKey”:“AQAAAA==”},“ItemClass”:“IPM.Note”,“IsReadReceiptRequested”:false,“Subject”:“Wallapop: ¡Tu nueva cuenta!”,“Sensitivity”:“Normal”,“Importance”:“Normal”,“From”:{“Mailbox”:{“Name”:“Wallapop”,“EmailAddress”:“newnews.wallapopcom”,“RoutingType”:“SMTP”,“MailboxType”:“OneOff”}},“DateTimeReceived”:“2025-04-05T13:40:53-07:00”,“Size”:172828,“IsRead”:true,“IsSubmitted”:false,“IsDraft”:false,“DateTimeSent”:“2025-04-05T13:40:50-07:00”,“DateTimeCreated”:“2025-04-05T13:40:53-07:00”,“DisplayTo”:“jayrahotmailcouk”,“HasAttachments”:false,“ExtendedProperty”:[{“ExtendedFieldURI”:{“__type”:“ExtendedPropertyUri:#Exchange”,“PropertyTag”:“0xe1d”,“PropertyType”:“String”},“Value”:“Wallapop: ¡Tu nueva cuenta!”}],“LastModifiedTime”:“2025-04-05T13:42:05-07:00”,“ConversationId”:{“__type”:“ItemId:#Exchange”,“Id”:“AQQkADAwATY0MDABLWQ1NzYtZmE2ZC0wMAItMDAKABAASL/TVdB2mkW5kLMNIoqy5A==”},

12

this not full response to help u , i need full response.this json have error.

14

Full is too big, can’t paste it here;

https://pastebin.com/VEQ8jwa1

15

Error, this is a private paste or is pending moderation.

16

moderation, damn.

https://pastecode.io/s/0jomks3p

this should work

17 
this to know Draft:

$.findMailFolderItem.Body.ResponseMessages.Items[*].RootFolder.Items[*].IsDraft

and this to get Ids:

$.findMailFolderItem.Body.ResponseMessages.Items[*].RootFolder.Items[*].ConversationId.Id

use JSON parse and recursive

18

THanks ! is working !
I zipped two lists into one then parsed again
done. thanks for help