How to parse this in Jira Automation (CIPP Alert)

[Sal]

Hi there

We have set up CIPP-Alerting (MSP's will know) which sends us data through a webhook. I can't parse the data in automation. I've tried

• {{webhookData.TaskInfo.Tenant}}
• {{webhookData.Results}}
• etc...

But the variables are always empty. Do you have any idea on how to access these fields?

The data looks as follows:

{TaskInfo={AdditionalProperties={}, TaskState=Planned, Timestamp=2024-09-17T09:35:41.6335522+00:00, ScheduledTime=1726566297, PartitionKey=ScheduledTask, RowKey=xxx, Results=Planned, Recurrence=7d, Hidden=true, Tenant=AllTenants, Name=Alert on unused licenses for AllTenants, PostExecution=Webhook, Command=Get-CIPPAlertUnusedLicenses, ETag=W/"datetime'2024-09-17T09%3A35%3A41.6335522Z'", Parameters={}}, Results=[O365_BUSINESS_ESSENTIALS has unused licenses. Using 9 of 11., RIGHTSMANAGEMENT_ADHOC has unused licenses. Using 0 of 50000.], Tenant=xxx}

or after beautifying

{ "TaskInfo="{

   "AdditionalProperties="{ },

   "TaskState=Planned",

   "Timestamp=2024-09-17T09":"35":"41.6335522+00":00,

   ScheduledTime=1726566297,

   "PartitionKey=ScheduledTask",

   RowKey=XXX,

   "Results=Planned",

   Recurrence=7d,

   "Hidden=true",

   "Tenant=AllTenants",

   "Name=Alert on unused licenses for AllTenants",

   "PostExecution=Webhook",

   "Command=Get-CIPPAlertUnusedLicenses",

   "ETag=W/""datetime'2024-09-17T09%3A35%3A41.6335522Z'",

   "Parameters="{ }

},

"Results="[

   O365_BUSINESS_ESSENTIALS has unused licenses. Using 9 of 11.,

   RIGHTSMANAGEMENT_ADHOC has unused licenses. Using 0 of 50000.

],

   Tenant=XXX }

Cheers!

[Sal · Accepted solution]

Layer 8 issue... I used a lookup table and forgot to reference to the table...