%use dataframe(enableExperimentalOpenApi=true)

DataFrame.read("api_guru_list.json")

DataFrame.read("api_guru_list.json")
    .gather { all() }
    .into("key", "value")

val _df1 = DataFrame.readJson(
    path = "api_guru_list.json",
    keyValuePaths = listOf(
        JsonPath(),
        JsonPath().appendWildcard().append("versions"),
    ),
)
_df1

val df1 = _df1.value.first()
df1

val ApiGuru = importDataSchema(File("ApiGuruOpenApi.yaml"))

val df2 = ApiGuru.APIs.readJson("api_guru_list.json")

df2

df2.schema()

// For instance: filter the APIs for having recent updates.
df2.filter {
  value.versions.value.any {
    (updated ?: added).year >= 2021
  }
}

val df3 = ApiGuru.Metrics.readJson("apiGuruMetrics.json")
df3