Hi,
I've established a web connection for an API that produces the following output:
{
"totalevents": 28,
"events": [
{
"eventid": 111111,
"clientid": 11111,
"goodafter": "2023-11-14T16:00:00-08:00",
"isactive": true,
"ishybridevent": false
}
]
}
However, when I utilize the JsonToTable function for this connection, it only retrieves the first row, resulting in a table with a single row. In contrast, accessing the raw data allows me to pull the entire dataset. The output is in proper JSON format. Does anyone have a solution for this issue?
