Like others, I've also been stumped on how to do this after trying variations of the JSON transformers.
Can someone upload an FME sample snippet or provide detailed instructions on how this can be accomplished?
Thank you in advance!!
I have the following JSON which contains an array within an array.
I'd like to:
- extract the TaskListType from the 1st array (MaintPlanData)
- extract the OperationNum and OperationDesc values from the 2nd array (TaskListItems)
- and put them into a row/column format like the example below.
TaskListType OperationNum OperationDesc
ABC 0010 Execute
ABC 0030 Technician
ABC 0040 Record
EFG 0010 Execute
etc
{
"RemainRecCount": 0,
"MaintPlanData": [
{
"ScheduleIndPlan": 1,
"PlanItems": {
"ItemNum": 1234,
"TaskList": {
"TaskListType": "ABC",
"TaskListItems": [
{
"OperationNum": "0010",
"OperationDesc": "Execute"
},
{
"OperationNum": "0030",
"OperationDesc": "Technician"
}
]
}
},
"PlanCycles": {
"Counter": "00"
}
},
{
"ScheduleIndPlan": 1,
"PlanItems": {
"ItemNum": 1,
"TaskList": {
"TaskListType": "EFG",
"TaskListItems": [
{
"OperationNum": "0010",
"OperationDesc": "Execute"
},
{
"OperationNum": "0030",
"OperationDesc": "Operator"
},
{
"OperationNum": "0040",
"OperationDesc": "Record"
}
]
}
},
"PlanCycles": {
"Counter": "01"
}
}
]
}
