namc-utah / NAMCr

NAMC Database and Analysis R API
MIT License
0 stars 0 forks source link

reportMetrics Returning too few rows #28

Open philipbaileynar opened 2 years ago

philipbaileynar commented 2 years ago

The following reportMetrics request returns 1,134 records through the API and SQL directly from the database. However, NAMCr only returns 142 records. Why the dissparity?

NAMCr

result = query(
api_endpoint = "reportMetrics",
args = list(reportId = 2, boxId = 3199)
)

API

{
  reportMetrics(limit: 1000000, offset: 0, reportId:2, boxId: 3199) {
    records {
            sampleId
            metricGroupId
            metricGroupName
            metricId
            metricName
            metricAbbreviation
            metricValue
    }
  }
}

Original Issue