Hi @Hem,
I agree it looks similar to your message, but on my system the body_url is unusable for all messages, old and new. I’m pretty sure it was containing a valid url not long ago though as I retrieved some bodies that way in the past.
Here is the full Json for mailMessages of one Deal, I removed e-mail addresses and changed names, and reformatted using VS Code to make it more readable:
{
"success": true,
"data": [
{
"object": "mailMessage",
"timestamp": "2022-03-29 13:07:50",
"data": {
"id": 62318,
"from": [
{
"id": 1,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "John Smith",
"linked_person_id": 201,
"linked_person_name": "John Smith",
"mail_message_party_id": 37903
}
],
"to": [
{
"id": 583,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "Alice Dickers",
"linked_person_id": 23,
"linked_person_name": "Alice Dickers",
"mail_message_party_id": 37902
}
],
"cc": [],
"bcc": [],
"body_url": "?Expires=0",
"nylas_id": "cbbd702dfba641638a25c04f869bbda6",
"account_id": "cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c",
"user_id": 12640756,
"mail_thread_id": 4872,
"subject": "Samples",
"snippet": "Hello John, hope you are doing well - we would like to give you quotes for your packaging, but need to look your boxes first. Could you please send us samples on address: Address to send samples: Jean Dubois Flexpac Na Dlouh",
"mail_tracking_status": null,
"mail_link_tracking_enabled_flag": 0,
"read_flag": 1,
"draft": null,
"s3_bucket": "pipemailer-message-bodies-live-fr",
"s3_bucket_path": "8892-10083281\/cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c\/AAkALgAAAAAAHYQDEapmEc2byACqAC-EWg0AHg5B-swLXEG3pNxYjxx1wQAFjtS9FgAA\/body",
"draft_flag": 0,
"synced_flag": 1,
"deleted_flag": 0,
"external_deleted_flag": 0,
"has_body_flag": 1,
"sent_flag": 1,
"sent_from_pipedrive_flag": 1,
"smart_bcc_flag": 0,
"message_time": "2022-03-29T13:07:50.000Z",
"add_time": "2022-03-29T13:05:47.000Z",
"update_time": "2022-03-29T13:08:07.000Z",
"has_attachments_flag": 0,
"has_inline_attachments_flag": 0,
"has_real_attachments_flag": 0,
"mua_message_id": "<xxxxxxxxxxxxxxxxxxxxxxxxx@PAXPR04MB8256.eurprd04.prod.outlook.com>",
"template_id": null,
"mail_queue": [],
"item_type": "mailMessage",
"timestamp": "2022-03-29T13:05:47.000Z",
"company_id": 10083281
}
},
{
"object": "mailMessage",
"timestamp": "2022-01-27 10:34:44",
"data": {
"id": 53106,
"from": [
{
"id": 1,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "John Smith",
"linked_person_id": 201,
"linked_person_name": "John Smith",
"mail_message_party_id": 34189
}
],
"to": [
{
"id": 583,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "Alice Dickers",
"linked_person_id": 23,
"linked_person_name": "Alice Dickers",
"mail_message_party_id": 34187
}
],
"cc": [
{
"id": 2,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "Jean Dubois",
"linked_person_id": 4,
"linked_person_name": "Jean Dubois",
"mail_message_party_id": 34188
}
],
"bcc": [],
"body_url": "?Expires=0",
"nylas_id": "1637fb935eb64a188fe0690dd6d5c2fb",
"account_id": "cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c",
"user_id": 12640756,
"mail_thread_id": 3936,
"subject": "RE: Packaging follow up",
"snippet": "Dear John, we have got your technical specification and sizing before, but please send us your rigid boxes samples to our address that we can do correct quote for you, also what kind od volume we should calculate approximatel",
"mail_tracking_status": null,
"mail_link_tracking_enabled_flag": 0,
"read_flag": 1,
"draft": null,
"s3_bucket": "pipemailer-message-bodies-live-fr",
"s3_bucket_path": "8892-10083281\/cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c\/AAkALgAAAAAAHYQDEapmEc2byACqAC-EWg0AHg5B-swLXEG3pNxYjxx1wQAFZmPY3gAA\/body",
"draft_flag": 0,
"synced_flag": 1,
"deleted_flag": 0,
"external_deleted_flag": 0,
"has_body_flag": 1,
"sent_flag": 1,
"sent_from_pipedrive_flag": 1,
"smart_bcc_flag": 0,
"message_time": "2022-01-27T10:34:44.000Z",
"add_time": "2022-01-27T10:30:21.000Z",
"update_time": "2022-01-27T10:34:51.000Z",
"has_attachments_flag": 0,
"has_inline_attachments_flag": 0,
"has_real_attachments_flag": 0,
"mua_message_id": "<xxxxxxxxxxxxxxxxxxxxxxxxx@PAXPR04MB8256.eurprd04.prod.outlook.com>",
"template_id": null,
"mail_queue": [],
"item_type": "mailMessage",
"timestamp": "2022-01-27T10:30:21.000Z",
"company_id": 10083281
}
},
{
"object": "mailMessage",
"timestamp": "2022-01-26 08:39:35",
"data": {
"id": 53041,
"from": [
{
"id": 1,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "John Smith",
"linked_person_id": 201,
"linked_person_name": "John Smith",
"mail_message_party_id": 34134
}
],
"to": [
{
"id": 2,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "Jean Dubois",
"linked_person_id": 4,
"linked_person_name": "Jean Dubois",
"mail_message_party_id": 34135
}
],
"cc": [],
"bcc": [],
"body_url": "?Expires=0",
"nylas_id": "02ee69e77ff05b09e4bf55e0cfeed097",
"account_id": "cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c",
"user_id": 12640756,
"mail_thread_id": 3936,
"subject": "Re: Packaging follow up",
"snippet": "Prijedu do Flexpacu With my best regards John Smith | Business Development Manager Flexpac | Co-packing & Co-manufacturing Solutions",
"mail_tracking_status": null,
"mail_link_tracking_enabled_flag": 0,
"read_flag": 1,
"draft": null,
"s3_bucket": "pipemailer-message-bodies-live-fr",
"s3_bucket_path": "8892-10083281\/cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c\/AAkALgAAAAAAHYQDEapmEc2byACqAC-EWg0AHg5B-swLXEG3pNxYjxx1wQAFZa4umQAA\/body",
"draft_flag": 0,
"synced_flag": 1,
"deleted_flag": 0,
"external_deleted_flag": 0,
"has_body_flag": 1,
"sent_flag": 1,
"sent_from_pipedrive_flag": 0,
"smart_bcc_flag": 0,
"message_time": "2022-01-26T08:39:35.000Z",
"add_time": "2022-01-26T08:39:44.000Z",
"update_time": "2022-01-26T08:39:45.000Z",
"has_attachments_flag": 1,
"has_inline_attachments_flag": 1,
"has_real_attachments_flag": 0,
"mua_message_id": "<xxxxxxxxxxxxxxxxxxxxxxxxx@PAXPR04MB8256.eurprd04.prod.outlook.com>",
"template_id": null,
"mail_queue": [],
"item_type": "mailMessage",
"timestamp": "2022-01-26T08:39:44.000Z",
"company_id": 10083281
}
},
{
"object": "mailMessage",
"timestamp": "2022-01-26 07:35:41",
"data": {
"id": 53025,
"from": [
{
"id": 2,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "Jean Dubois",
"linked_person_id": 4,
"linked_person_name": "Jean Dubois",
"mail_message_party_id": 34132
}
],
"to": [
{
"id": 1,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "John Smith",
"linked_person_id": 201,
"linked_person_name": "John Smith",
"mail_message_party_id": 34133
}
],
"cc": [],
"bcc": [],
"body_url": "?Expires=0",
"nylas_id": "212e3cb914de95d482738eac7e936419",
"account_id": "cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c",
"user_id": 12640756,
"mail_thread_id": 3936,
"subject": "RE: Packaging follow up",
"snippet": "To m\u00e1m radost, probereme to\ud83d\ude0a From: John Smith <xxxxxxxxxxxxxxxxxxxxxxxxx> Sent: Tuesday, January 25, 2022 7:19 PM To: Jean Dubois <xxxxxxxxxxxxxxxxxxxxxxxxx> Subject: RE: Packaging follow up Probereme ve Ct ;-) ---------- ",
"mail_tracking_status": null,
"mail_link_tracking_enabled_flag": 0,
"read_flag": 1,
"draft": null,
"s3_bucket": "pipemailer-message-bodies-live-fr",
"s3_bucket_path": "8892-10083281\/cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c\/AAkALgAAAAAAHYQDEapmEc2byACqAC-EWg0AHg5B-swLXEG3pNxYjxx1wQAFZa4gmwAA\/body",
"draft_flag": 0,
"synced_flag": 1,
"deleted_flag": 0,
"external_deleted_flag": 0,
"has_body_flag": 1,
"sent_flag": 0,
"sent_from_pipedrive_flag": 0,
"smart_bcc_flag": 0,
"message_time": "2022-01-26T07:35:41.000Z",
"add_time": "2022-01-26T07:35:52.000Z",
"update_time": "2022-01-26T08:16:25.000Z",
"has_attachments_flag": 0,
"has_inline_attachments_flag": 0,
"has_real_attachments_flag": 0,
"mua_message_id": "<Vxxxxxxxxxxxxxxxxxxxxxxxxx@VI1PR04MB5872.eurprd04.prod.outlook.com>",
"template_id": null,
"mail_queue": [],
"item_type": "mailMessage",
"timestamp": "2022-01-26T07:35:52.000Z",
"company_id": 10083281
}
},
{
"object": "mailMessage",
"timestamp": "2022-01-25 18:21:48",
"data": {
"id": 53013,
"from": [
{
"id": 1,
"email_address": "John Smith",
"name": "John Smith",
"linked_person_id": 201,
"linked_person_name": "John Smith",
"mail_message_party_id": 34126
}
],
"to": [
{
"id": 3,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "Eric Dupont",
"linked_person_id": 10,
"linked_person_name": "Eric Dupont",
"mail_message_party_id": 34127
}
],
"cc": [],
"bcc": [],
"body_url": "?Expires=0",
"nylas_id": "78e68801753bdb9e313f1aba871a61ac",
"account_id": "cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c",
"user_id": 12640756,
"mail_thread_id": 3936,
"subject": "Fw: Packaging follow up",
"snippet": "Budou kvalitni ponozky ! \ud83d\ude09 ---------- Forwarded message ---------- From: Alice Dickers <xxxxxxxxxxxxxxxxxxxxxxxxx> Date: January 25, 2022 12:23 PM Subject: Re: Packaging follow up To: xxxxxxxxxxxxxxxxxxxxxxxxx Hi Eric, Th",
"mail_tracking_status": null,
"mail_link_tracking_enabled_flag": 0,
"read_flag": 1,
"draft": null,
"s3_bucket": "pipemailer-message-bodies-live-fr",
"s3_bucket_path": "8892-10083281\/cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c\/AAkALgAAAAAAHYQDEapmEc2byACqAC-EWg0AHg5B-swLXEG3pNxYjxx1wQAFZa1jSgAA\/body",
"draft_flag": 0,
"synced_flag": 1,
"deleted_flag": 0,
"external_deleted_flag": 0,
"has_body_flag": 1,
"sent_flag": 1,
"sent_from_pipedrive_flag": 0,
"smart_bcc_flag": 0,
"message_time": "2022-01-25T18:21:48.000Z",
"add_time": "2022-01-25T18:21:52.000Z",
"update_time": "2022-01-25T18:21:52.000Z",
"has_attachments_flag": 0,
"has_inline_attachments_flag": 0,
"has_real_attachments_flag": 0,
"mua_message_id": "<PAXPR04MB82568AD100088F696EAA02A1F15F9@PAXPR04MB8256.eurprd04.prod.outlook.com>",
"template_id": null,
"mail_queue": [],
"item_type": "mailMessage",
"timestamp": "2022-01-25T18:21:52.000Z",
"company_id": 10083281
}
},
{
"object": "mailMessage",
"timestamp": "2022-01-25 18:19:20",
"data": {
"id": 52984,
"from": [
{
"id": 1,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "John Smith",
"linked_person_id": 201,
"linked_person_name": "John Smith",
"mail_message_party_id": 34124
}
],
"to": [
{
"id": 2,
"email_address": "XXXXXXXXXXXXXXxxxx",
"name": "Jean Dubois",
"linked_person_id": 4,
"linked_person_name": "Jean Dubois",
"mail_message_party_id": 34123
}
],
"cc": [],
"bcc": [],
"body_url": "?Expires=0",
"nylas_id": "797e5bd88817494399271953a9e2d8db",
"account_id": "cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c",
"user_id": 12640756,
"mail_thread_id": 3936,
"subject": "RE: Packaging follow up",
"snippet": "Probereme ve Ct ;-) ---------- Forwarded message ---------- From: Alice Dickers <XXXXXXXXXXXXXXXXXXXX> Date: January 25, 2022 12:23 PM Subject: Re: Packaging follow up To: xxxxxxxxxxxxxxxxxxxxxxxxx Hi Eric, Thanks fo",
"mail_tracking_status": null,
"mail_link_tracking_enabled_flag": 0,
"read_flag": 1,
"draft": null,
"s3_bucket": "pipemailer-message-bodies-live-fr",
"s3_bucket_path": "8892-10083281\/cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c\/AAkALgAAAAAAHYQDEapmEc2byACqAC-EWg0AHg5B-swLXEG3pNxYjxx1wQAFZa1TigAA\/body",
"draft_flag": 0,
"synced_flag": 1,
"deleted_flag": 0,
"external_deleted_flag": 0,
"has_body_flag": 1,
"sent_flag": 1,
"sent_from_pipedrive_flag": 1,
"smart_bcc_flag": 0,
"message_time": "2022-01-25T18:19:20.000Z",
"add_time": "2022-01-25T18:18:35.000Z",
"update_time": "2022-01-25T18:20:08.000Z",
"has_attachments_flag": 0,
"has_inline_attachments_flag": 0,
"has_real_attachments_flag": 0,
"mua_message_id": "<xxxxxxxxxxxxxxxxxxxxxxxxx@PAXPR04MB8256.eurprd04.prod.outlook.com>",
"template_id": null,
"mail_queue": [],
"item_type": "mailMessage",
"timestamp": "2022-01-25T18:18:35.000Z",
"company_id": 10083281
}
},
{
"object": "mailMessage",
"timestamp": "2022-01-25 11:23:03",
"data": {
"id": 52954,
"from": [
{
"id": 583,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "Alice Dickers",
"linked_person_id": 23,
"linked_person_name": "Alice Dickers",
"mail_message_party_id": 34105
}
],
"to": [
{
"id": 1,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "John Smith",
"linked_person_id": 201,
"linked_person_name": "John Smith",
"mail_message_party_id": 34106
}
],
"cc": [],
"bcc": [],
"body_url": "?Expires=0",
"nylas_id": "d2565fdd9433579662468e5fa1e789cf",
"account_id": "cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c",
"user_id": 12640756,
"mail_thread_id": 3936,
"subject": "Re: Packaging follow up",
"snippet": "Hi Eric, Thanks for your email - happy 2022 to you too! I'm definitely interested in catching up on plans for this year. I'd be interested to get a quote & understand lead-times on the rigid black boxes we discussed last ye",
"mail_tracking_status": null,
"mail_link_tracking_enabled_flag": 0,
"read_flag": 1,
"draft": null,
"s3_bucket": "pipemailer-message-bodies-live-fr",
"s3_bucket_path": "8892-10083281\/cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c\/AAkALgAAAAAAHYQDEapmEc2byACqAC-EWg0AHg5B-swLXEG3pNxYjxx1wQAFZBU-OAAA\/body",
"draft_flag": 0,
"synced_flag": 1,
"deleted_flag": 0,
"external_deleted_flag": 0,
"has_body_flag": 1,
"sent_flag": 0,
"sent_from_pipedrive_flag": 0,
"smart_bcc_flag": 0,
"message_time": "2022-01-25T11:23:03.000Z",
"add_time": "2022-01-25T11:23:11.000Z",
"update_time": "2022-01-26T08:16:36.000Z",
"has_attachments_flag": 0,
"has_inline_attachments_flag": 0,
"has_real_attachments_flag": 0,
"mua_message_id": "<xxxxxxxxxxxxxxxxxxxxxxxxx@mail.gmail.com>",
"template_id": null,
"mail_queue": [],
"item_type": "mailMessage",
"timestamp": "2022-01-25T11:23:11.000Z",
"company_id": 10083281
}
},
{
"object": "mailMessage",
"timestamp": "2022-01-18 08:39:08",
"data": {
"id": 52250,
"from": [
{
"id": 1,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "John Smith",
"linked_person_id": 201,
"linked_person_name": "John Smith",
"mail_message_party_id": 33625
}
],
"to": [
{
"id": 583,
"email_address": "xxxxxxxxxxxxxxxxxxxxxxxxx",
"name": "Alice Dickers",
"linked_person_id": 23,
"linked_person_name": "Alice Dickers",
"mail_message_party_id": 33624
}
],
"cc": [],
"bcc": [],
"body_url": "?Expires=0",
"nylas_id": "141544d1a66b488c808f648ba4ff3763",
"account_id": "cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c",
"user_id": 12640756,
"mail_thread_id": 3936,
"subject": "Packaging follow up",
"snippet": "Hello John, Happy new year 2022 ! I hope you solved your emergency situation with packaging and business runs as usual now. If you still want to talk about regular cooperation, please give me a short message and we will set a",
"mail_tracking_status": null,
"mail_link_tracking_enabled_flag": 0,
"read_flag": 1,
"draft": null,
"s3_bucket": "pipemailer-message-bodies-live-fr",
"s3_bucket_path": "8892-10083281\/cc2d842d-cf60-4b95-8d4b-8ab6b2716a1c\/AAkALgAAAAAAHYQDEapmEc2byACqAC-EWg0AHg5B-swLXEG3pNxYjxx1wQAFYKLc6QAA\/body",
"draft_flag": 0,
"synced_flag": 1,
"deleted_flag": 0,
"external_deleted_flag": 0,
"has_body_flag": 1,
"sent_flag": 1,
"sent_from_pipedrive_flag": 1,
"smart_bcc_flag": 0,
"message_time": "2022-01-18T08:39:08.000Z",
"add_time": "2022-01-18T08:35:11.000Z",
"update_time": "2022-01-25T18:20:19.000Z",
"has_attachments_flag": 0,
"has_inline_attachments_flag": 0,
"has_real_attachments_flag": 0,
"mua_message_id": "<xxxxxxxxxxxxxxxxxxxxxxxxx@PAXPR04MB8256.eurprd04.prod.outlook.com>",
"template_id": null,
"mail_queue": [],
"item_type": "mailMessage",
"timestamp": "2022-01-18T08:35:11.000Z",
"company_id": 10083281
}
}
],
"additional_data": {
"filesCountByDay": [],
"pagination": {
"start": 0,
"limit": 100,
"more_items_in_collection": false
}
}
}
Thanks,
Olivier.