Thanks for your help so far Sam!
Unfortunately, I couldnt get the above to work either. I copied and pasted, and got an error as 1.Date wasn’t found anywhere. I replaced that with the raw data, and, as before, nothing happened. This was for both solutions. I tried replacing “Space” with “TimeStamp”, but also no results.
This is from the ParseDate trial:
Input:
[
{
"fields": {
"DOB": "2025-03-07T00:00:00.000Z",
"Country": "Brazil",
"SunSign": "Unknown",
"LastName": "uhjn",
"MoonSign": "Unknown",
"FirstName": "uhj",
"RisingSign": "Unknown",
"ReferredFrom": "Search Engine (Google, Bing, etc.)"
},
"listId": "f3c19de6-d12b-11ef-80b1-2731619ca0c3",
"status": "SUBSCRIBED",
"email_address": "yiun@yuj.co"
}
]
Output:
[
{
"id": "c954f466-04ef-11f0-9923-15af9dd07d0d",
"email_address": "yiun@yuj.co",
"fields": {
"FirstName": "uhj",
"LastName": "uhjn",
"SunSign": "Unknown",
"MoonSign": "Unknown",
"RisingSign": "Unknown",
"ReferredFrom": "Search Engine (Google, Bing, etc.)",
"Country": "Brazil"
},
"status": "SUBSCRIBED",
"created_at": "2025-03-19T18:27:17.000Z"
}
]
Split Trial:
Input
[
{
"fields": {
"DOB": "2025-03-08T00:00:00.000Z",
"Country": "Argentina",
"SunSign": "Aquarius",
"LastName": "uyhn",
"MoonSign": "Unknown",
"FirstName": "ygu",
"RisingSign": "Unknown",
"ReferredFrom": "Social Media"
},
"listId": "f3c19de6-d12b-11ef-80b1-2731619ca0c3",
"status": "SUBSCRIBED",
"email_address": "uyh@uhnj.co"
}
]
Output:
[
{
"id": "8b9e7d1c-04f0-11f0-a66c-9f71043b2a56",
"email_address": "uyh@uhnj.co",
"fields": {
"FirstName": "ygu",
"LastName": "uyhn",
"SunSign": "Aquarius",
"MoonSign": "Unknown",
"RisingSign": "Unknown",
"ReferredFrom": "Social Media",
"Country": "Argentina"
},
"status": "SUBSCRIBED",
"created_at": "2025-03-19T18:32:42.000Z"
}
]
Im sure its something super simple that I’m missing!