Hopefully this is what you're looking for. That's some horrible JSON you have 🙂
Below is the full flow. I'll go into each of the actions.
JSON is a Compose that contains your JSON data. I'm not sure where your data is coming from.
Compose uses the following expression to strip out parts of your data so we can prepare it into a proper JSON format for your CSV.
//You would replace outputs('JSON') with whatever contains your JSON
split(slice(string(outputs('JSON')), 1, lastIndexOf(string(outputs('JSON')), '}')), '}')
Filter array takes the output from the Compose and filters out any empty rows (the last row) using the following expression.
trim(item())
Select uses the output from the Filter array and appies the following expression to complete the transformation of the data so we get an array of objects that we can use to create the CSV.
json(concat(slice(item(), indexOf(item(), '{')), '}'))
This will provide the following JSON output.
[
{
"id": 1,
"pressure": 0,
"temperature": 282.15,
"atmospheric": 123,
"refdate": "Sun, 12 Feb 2023 19:40:27 GMT",
"tyreid": null,
"vehicleid": null,
"position": null,
"tyresettingid": null,
"ptarget": null,
"palarm": 0,
"talarm": 0,
"strangerptarget": null,
"strangerpalarm": 0,
"strangertalarm": 0,
"triggered": 1,
"fastmode": 0,
"error": 0,
"": 0,
"tagtimeout": true,
"alarmtimeout": true
},
{
"id": 2,
"pressure": 0,
"temperature": 123,
"atmospheric": 123,
"refdate": "Sun, 12 Feb 2023 20:40:45 GMT",
"tyreid": null,
"vehicleid": null,
"position": null,
"tyresettingid": null,
"ptarget": 123,
"palarm": 0,
"talarm": 0,
"strangerptarget": null,
"strangerpalarm": 0,
"strangertalarm": 0,
"triggered": 1,
"fastmode": 0,
"error": 0,
"": 0,
"tagtimeout": true,
"alarmtimeout": true
}
]
Create CSV table takes in the output from Select. Or you could specify just the fields you want. The empty property will just create a column in your CSV that doesn't have anything in the Header column.
Send an email then attaches the CSV table.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
