I need a formula that captures all “CONTENT” and “role” from the json file
and at the end transform to
[{“role”:“system”,“content”:“conversations”}, {“role”: “user”, “content”: “conversations”}, {“role”: “assistant”, “content”: “conversations”}, {“role”: “user”, “content”: “conversations”}]
the file is this one
[
{
“messages”: [
{
“id”: “”,
“role”: “user”,
“image”: “ag-asset://f366e23e-dd37-4ca5-afa2-bbc14f5a199e”,
“content”: “conversations”,
“date_time”: “08/04/2023, 16:30:14”
}
],
“filter_time_date”: “04/08/2023, 16:30:14”,
“id”: “6737508d-c3fb-4ebf-b7d5-409cdc313e9a”
},
{
“messages”: [
{
“id”: “”,
“role”: “user”,
“image”: “ag-asset://f366e23e-dd37-4ca5-afa2-bbc14f5a199e”,
“content”: “conversations”,
“date_time”: “08/04/2023, 16:30:54”
}
],
“filter_time_date”: “04/08/2023, 16:30:54”,
“id”: “7604ab5d-f72a-4150-a739-7c8f5d6e0996”
},
{
“messages”: [
{
“id”: “”,
“role”: “user”,
“image”: “ag-asset://f366e23e-dd37-4ca5-afa2-bbc14f5a199e”,
“content”: “conversations”,
“date_time”: “08/04/2023, 16:33:14”
}
],
“filter_time_date”: “04/08/2023, 16:33:14”,
“id”: “30173dbc-5f58-479f-bdb7-ee90fdf82590”
},
{
“messages”: [
{
“id”: “”,
“role”: “user”,
“image”: “ag-asset://f366e23e-dd37-4ca5-afa2-bbc14f5a199e”,
“content”: “conversations”,
“date_time”: “08/04/2023, 16:33:22”
}
],
“filter_time_date”: “04/08/2023, 16:33:22”,
“id”: “ab94d379-eb1e-4a49-bac8-8fbfe119e4d5”
},
{
“messages”: [
{
“id”: “”,
“role”: “user”,
“image”: “ag-asset://f366e23e-dd37-4ca5-afa2-bbc14f5a199e”,
“content”: “conversations”,
“date_time”: “04/08/2023, 16:34:01”
}
],
“filter_time_date”: “04/08/2023, 16:34:01”,
“id”: “95c40c7a-9c66-4297-af60-acd0f901f5be”
}
]