Help with API response - format JSON

Hello Wapplers,

I’m stuck with one of the API response bellow:

{
"header": {
"sessionId": ""
},
"response": {
"2022": {
"9": {
"27": [
"direct"
],
"29": [
"direct"
]
},
"10": {
"1": [
"direct"
],
"2": [
"direct"
],
"4": [
"direct"
],
"6": [
"direct"
],
"8": [
"direct"
],
"9": [
"direct"
],
"11": [
"direct"
],
"13": [
"direct"
],
"15": [
"direct"
],
"16": [
"direct"
],
"18": [
"direct"
],
"20": [
"direct"
],
"22": [
"direct"
],
"23": [
"direct"
],
"25": [
"direct"
],
"27": [
"direct"
],
"29": [
"direct"
],
"31": [
"direct"
]
},
"11": {
"1": [
"direct"
],
"3": [
"direct"
],
"5": [
"direct"
],
"7": [
"direct"
],
"8": [
"direct"
],
"10": [
"direct"
],
"12": [
"direct"
],
"14": [
"direct"
],
"15": [
"direct"
],
"17": [
"direct"
],
"19": [
"direct"
],
"21": [
"direct"
],
"22": [
"direct"
],
"24": [
"direct"
],
"26": [
"direct"
],
"28": [
"direct"
],
"29": [
"direct"
]
},
"12": {
"1": [
"direct"
],
"3": [
"direct"
],
"5": [
"direct"
],
"6": [
"direct"
],
"8": [
"direct"
],
"10": [
"direct"
],
"12": [
"direct"
],
"13": [
"direct"
],
"15": [
"direct"
],
"17": [
"direct"
],
"19": [
"direct"
],
"20": [
"direct"
],
"22": [
"direct"
],
"24": [
"direct"
],
"26": [
"direct"
],
"27": [
"direct"
],
"29": [
"direct"
],
"31": [
"direct"
]
}
},
"2023": {
"1": {
"2": [
"direct"
],
"3": [
"direct"
],
"5": [
"direct"
],
"7": [
"direct"
],
"9": [
"direct"
],
"10": [
"direct"
],
"12": [
"direct"
],
"14": [
"direct"
],
"16": [
"direct"
],
"17": [
"direct"
],
"19": [
"direct"
],
"21": [
"direct"
],
"23": [
"direct"
],
"24": [
"direct"
],
"26": [
"direct"
],
"28": [
"direct"
],
"30": [
"direct"
],
"31": [
"direct"
]
},
"2": {
"2": [
"direct"
],
"4": [
"direct"
],
"6": [
"direct"
],
"7": [
"direct"
],
"9": [
"direct"
],
"11": [
"direct"
],
"13": [
"direct"
],
"14": [
"direct"
],
"16": [
"direct"
],
"18": [
"direct"
],
"20": [
"direct"
],
"21": [
"direct"
],
"23": [
"direct"
],
"25": [
"direct"
],
"27": [
"direct"
],
"28": [
"direct"
]
},
"3": {
"2": [
"direct"
],
"4": [
"direct"
],
"6": [
"direct"
],
"7": [
"direct"
],
"11": [
"direct"
],
"13": [
"direct"
],
"14": [
"direct"
],
"18": [
"direct"
],
"20": [
"direct"
],
"21": [
"direct"
],
"23": [
"direct"
],
"25": [
"direct"
],
"26": [
"direct"
],
"27": [
"direct"
],
"29": [
"direct"
],
"30": [
"direct"
],
"31": [
"direct"
]
},
"4": {
"2": [
"direct"
],
"3": [
"direct"
],
"5": [
"direct"
],
"6": [
"direct"
],
"7": [
"direct"
],
"9": [
"direct"
],
"10": [
"direct"
],
"12": [
"direct"
],
"13": [
"direct"
],
"14": [
"direct"
],
"16": [
"direct"
],
"17": [
"direct"
],
"19": [
"direct"
],
"20": [
"direct"
],
"21": [
"direct"
],
"23": [
"direct"
],
"24": [
"direct"
],
"26": [
"direct"
],
"27": [
"direct"
],
"28": [
"direct"
],
"30": [
"direct"
]
},
"5": {
"1": [
"direct"
],
"3": [
"direct"
],
"4": [
"direct"
],
"5": [
"direct"
],
"7": [
"direct"
],
"8": [
"direct"
],
"10": [
"direct"
],
"11": [
"direct"
],
"12": [
"direct"
],
"14": [
"direct"
],
"15": [
"direct"
],
"17": [
"direct"
],
"18": [
"direct"
],
"19": [
"direct"
],
"21": [
"direct"
],
"22": [
"direct"
],
"24": [
"direct"
],
"25": [
"direct"
],
"26": [
"direct"
],
"28": [
"direct"
],
"29": [
"direct"
],
"31": [
"direct"
]
},
"6": {
"1": [
"direct"
],
"2": [
"direct"
],
"4": [
"direct"
],
"5": [
"direct"
],
"7": [
"direct"
],
"8": [
"direct"
],
"9": [
"direct"
],
"11": [
"direct"
],
"12": [
"direct"
],
"14": [
"direct"
],
"15": [
"direct"
],
"16": [
"direct"
],
"18": [
"direct"
],
"19": [
"direct"
],
"21": [
"direct"
],
"22": [
"direct"
],
"23": [
"direct"
],
"25": [
"direct"
],
"26": [
"direct"
],
"28": [
"direct"
],
"29": [
"direct"
],
"30": [
"direct"
]
},
"7": {
"2": [
"direct"
],
"3": [
"direct"
],
"5": [
"direct"
],
"6": [
"direct"
],
"7": [
"direct"
],
"9": [
"direct"
],
"10": [
"direct"
],
"12": [
"direct"
],
"13": [
"direct"
],
"14": [
"direct"
],
"16": [
"direct"
],
"17": [
"direct"
],
"19": [
"direct"
],
"20": [
"direct"
],
"21": [
"direct"
],
"23": [
"direct"
],
"24": [
"direct"
],
"26": [
"direct"
],
"27": [
"direct"
],
"28": [
"direct"
],
"30": [
"direct"
],
"31": [
"direct"
]
},
"8": {
"2": [
"direct"
],
"3": [
"direct"
],
"4": [
"direct"
],
"6": [
"direct"
],
"7": [
"direct"
],
"9": [
"direct"
],
"10": [
"direct"
],
"11": [
"direct"
],
"13": [
"direct"
],
"14": [
"direct"
],
"16": [
"direct"
],
"17": [
"direct"
],
"18": [
"direct"
],
"20": [
"direct"
],
"21": [
"direct"
],
"23": [
"direct"
],
"24": [
"direct"
],
"25": [
"direct"
],
"27": [
"direct"
],
"28": [
"direct"
],
"30": [
"direct"
],
"31": [
"direct"
]
},
"9": {
"1": [
"direct"
],
"3": [
"direct"
],
"4": [
"direct"
],
"6": [
"direct"
],
"7": [
"direct"
],
"8": [
"direct"
],
"10": [
"direct"
],
"11": [
"direct"
],
"13": [
"direct"
],
"14": [
"direct"
],
"15": [
"direct"
],
"17": [
"direct"
],
"18": [
"direct"
],
"20": [
"direct"
],
"21": [
"direct"
],
"22": [
"direct"
],
"24": [
"direct"
],
"25": [
"direct"
],
"27": [
"direct"
],
"28": [
"direct"
],
"29": [
"direct"
]
},
"10": {
"1": [
"direct"
],
"2": [
"direct"
],
"4": [
"direct"
],
"5": [
"direct"
],
"6": [
"direct"
],
"8": [
"direct"
],
"9": [
"direct"
],
"11": [
"direct"
],
"12": [
"direct"
],
"13": [
"direct"
],
"15": [
"direct"
],
"16": [
"direct"
],
"18": [
"direct"
],
"19": [
"direct"
],
"20": [
"direct"
],
"22": [
"direct"
],
"23": [
"direct"
],
"25": [
"direct"
],
"26": [
"direct"
],
"27": [
"direct"
]
}
}
}
}

It’s very weird output with dates and I need to get from values as - 2022-9-27, 2022-9-29, etc.

What I could achieve is to set repeat for response and get years with this approach:


But I can’t get “keys” in lower level.

Any ideas?

Community Page
Last updated: