stx_query() with CAS no. that returns no data on Ecotox web search returns large amounts of data.

[andbeck]

It is possible that the stx_query() function is returning information when there should be a null result from the database.

Using a CAS from the help files

# cas from help files
cas_1 <- c("35554-44-0")

# query
l1 <- stx_query(cas = cas_1,
                exposure = 'aquatic',
                taxa = 'Daphnia magna')

# one result
l1$aggregated$cname

Using a CAS that returns nothing on the web database (1073-69-4) [4-Chlorophenylhydrazine]

# DOES NOT WORK
# this cas returns nothing on the database
# but stx_query does

cas_noDB <- c("1073-69-4")
badQuery <- stx_query(casnr = cas_noDB)

# returns a huge amount of stuff.
# 5664 names
badQuery$aggregated$cname
# none of them contain the compound
sum(grepl("Chlorophenylhydrazine", badQuery$aggregated$cname))

[andschar]

Thanks for reporting! Yes, this is indeed strange, it should return an empty data.table. Will work on that.