Can we get results via API at column level where filter is applied in MP.

Hi ​@Hanish N ,

thank you for your question. We have this specific usecase covered in our documentation, please see here:

https://docs.ataccama.com/one/16.1.0/one-apis/one-api.html#dq-results section Filter

When obtaining the DQ results via API, you can add the filter part (example):

filter: [
          {
              attributeId: "d3c8da98-0dea-4523-903c-cbc4a3f28e8b"
              values: ["Fire", "Water", "Grass"]
          }
    {
              attributeId: "00e71092-a53b-47f4-ae50-792b777609e7"
              values: ["Blastoise", "Bulbasaur", "Charizard"]}
]

Down below is an example for the whole API call including the filter: https://docs.ataccama.com/one/16.1.0/one-apis/one-api.html#dq-results:~:text=GraphQL%20query%20for%20retrieving%20basic%20monitoring%20results

Let me know if this is what you were looking for.

Kind regards,

Anna

Instead of passing value, can’t we get stats of all values of that column?
 for ex:

country  passed count  failed count   total

US          140                 60                 200

IND        180                120                300

CHI        70                  50                  120

We can’t give all the values in filter right as the values are dynamic. Do we have any query for that?

Hi ​@Hanish N ,

checking the documentation, I believe it should be possible to use #ALL# as a value and that should give all of them:

https://docs.ataccama.com/one/latest/one-apis/one-api.html#filter-values

There is also the API call that will give you all possible values for the filters on an attribute:

query ProcessingFilterValues {

    monitoringProjectProcessing(gid: "da0be1f4-c8c2-430e-85ee-747861e357e6"){
        publishedVersion {
            dqFilterValues(catalogItemId: "6f589e83-ebd4-4486-8b79-f7d0498e6c6e"){
                                name
                values
                attributeId
                order
            }
        }
    }
}

One of them is the #ALL# so I would try with that.

Kind regards,

Anna