Hey all,
Can someone help me out with a JSON related question! Many many thanks! 😄
I have a JSON arrays field in this format
results=<200 OK OK, { "tnPortingActivityInProgress" : "N", "availableActions" : [ { "accountAction" : "Restart", "actionAvailable" : "N", "actionNotAvailableReason" : "Account is Active" }, { "accountAction" : "Multi-AP Salable", "actionAvailable" : "Y" }, { "accountAction" : "Seasonal Suspend", "actionAvailable" : "Y" } ], "transactionId" : "1234567" } ,[]>
I would love to parse the json array into this format.
transactionId
aaccountAction
actionAvailable
actionNotAvailableReason
1234567
Restart
N
Account is Active
1234567
Multi-AP Salable
Y
1234567
Seasonal Suspend
Y
I have tried a query like this. As you can see, the data is stacked in the same row right now, which is not working in my case as I have no idea what actionAvailable & actionNotAvailableReason for what accountActions. And also, the search is not working either if we do like this.
... View more