JSON Query - Workday =/
I have JSON data from Workday with potentially many Phone_Data sections like below:
"Phone_Data" : [
{
"Formatted_Phone" : "XXXXXXXX",
"Phone_Device_Type_Reference" : {
"...
Forum Discussion
Thanks to a little insider help, I was able to get this working, and figured I would share in case it might be useful to others. Below is the code I ended up using.
jsonPath($Worker_Data.Personal_Data.Contact_Data, "$Phone_Data[?(@.Usage_Data[0].Type_Data[0].Type_Reference.ID.Communication_Usage_Type_ID == 'WORK' && @.Usage_Data[0].Type_Data[0].Primary == '1')].Formatted_Phone")[0]
Ha, worked this out on my own not long ago, wish I had read this first, would have saved me some time!
