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.

[hreinwald]

@andbeck: I just tried with the newest stx_query() function and it seems to work now as expected.

cas_1 <- c("1073-69-4") # [4-Chlorophenylhydrazine]
dt = stx_query(
  cas_number = cas_1, 
  endpoint_group = NULL, duration_unit = NULL,
)

Returned NULL with the following warning:

Warning messages:
1: In stx_query(cas_number = cas_1, endpoint_group = NULL, duration_unit = NULL,  :
  No query matches found for the provided CAS numbers. Please check the input values.
2: In stx_query(cas_number = cas_1, endpoint_group = NULL, duration_unit = NULL,  :
  No query matches found. Please check the input filter values. 

You might still have to wait till @andschar integrates the NEW stx_query() into the new Package Version or you can source the function from my forked standartox version.

[hreinwald]

@andschar - once you have pulled the changes and updated the package you can close this issue. 👍