I’m hoping anyone has some good GraphQL examples to share. For us, it is necessary to integrate Ataccama into our standard reporting. To do so I’m trying to get a GraphQL working that returns the scores for each item in a monitoring project. Ideally, listing out all monitoring projects and items with their scores - for the latest processing (although I’ll take all at this point and filter the old ones later). This is all about the statistics (# records passed/failed etc. not the individual results - I am aware I can create post-processing plans to export data, but this is not applicable here).
It’s basically the overview from the report tab in the monitoring project, at item level:
I can get everything I need, including the total row count except the passed or failed figure. I have tried and looked at all GraphQL examples everywhere, including 
ONE API :: Ataccama ONE, and have pieced this together based on the structures visible in the desktop app. Things like DqAggregationResultOverTime don’t really cut it, because it already aggregates across dq dimensions, and I’m interested in the per-item information.
How can I report on passed/failed for each item in a monitoring project, ideally without explicitly listing the catalog item (because we have hundreds)?
The query below is close, all it’s missing is the passed and/or failed count.
query listMonitoringProject {
monitoringProject(gid: "<gid>") {
gid
publishedVersion {
name
processings {
edges {
node {
gid
publishedVersion {
__typename
startedAt
state
result
dqResult {
publishedVersion {
__typename
startedCount
statistics {
publishedVersion {
successCount
}
}
}
}
items {
edges {
node {
publishedVersion {
__typename
catalogItem {
publishedVersion {
name
}
}
result
dqResult {
__typename
gid
publishedVersion {
result
dqResult {
storedVersion {
__typename
ruleCount
recordCount
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
