Splitting the array for Azure integration

The way that Particle publishes the data in one array doesn’t work for my application in Power Bi. When my data pushes out to my Azure integration I need it separated so that when I pull it into Power bi it will be separated into it’s own columns. Is there a way to change the custom JSON so that it will do this?
My JSON now:

“event”: “{{{PARTICLE_EVENT_NAME}}}”,
“data”: “{{{PARTICLE_EVENT_VALUE}}}”,
“device_id”: “{{{PARTICLE_DEVICE_ID}}}”,
“published_at”: “{{{PARTICLE_PUBLISHED_AT}}}”

How the data comes into Power Bi:

1 Like