CID and SID

[c1au6i0]

I am having troubles querying punchem for entries that have a SSI but not a CID. An example is Angelica oil; 8015-64-3. I clearly cant use get_cid to get info regarding the substance, but also pc_sect is not able to retrieve info, I suppose because it queries by CID (?). I was wondering if you have any tips, and if I am overlooking at something...

[stitam]

Thanks @c1au6i0 for opening this discussion. I tried to retrieve the PubChem SID using get_cid(), I couldn't retrieve it either, and I do not know of any other functions in webchem that can do this. I'll look at the API documentation and try to implement the functionality. Regarding your other question, once you know the PubChem SID, pc_sect() does seem to work:

webchem::pc_sect("480409659", section = "External ID", domain = "substance")
#> # A tibble: 1 × 5
#>   SID       Name         Result    SourceName SourceID
#>   <chr>     <chr>        <chr>     <chr>      <chr>   
#> 1 480409659 Angelica oil 8015-64-3 PubChem    PubChem

^{Created on 2025-06-16 with reprex v2.1.1}

[c1au6i0]

I see. Thank you for your reply and your work @stitam
best

[stitam]

Related to issue #216.