Hi all,
may be someone knows if there are any tools to convert Atlas JSON to OHDSql?
Best regards,
Yuriy
Here you go: https://github.com/OHDSI/OhdsiRTools
The function insertCirceDefinitionInPackage will let you pull out a cohort
from an ATLAS instance, and save the JSON and OHDSql.
It seems that there are some issues with insertCirceDefinitionInPackage.
I have try to convert one of the Altas cohort definitions to SQL but script fails. Here is the code and error message
library(OhdsiRTools)
insertCirceDefinitionInPackage(25247, name = NULL, baseUrl = “http://www.ohdsi.org/web/atlas/#”)
Error in file(con, “r”) : cannot open the connection
The error comes from the third-party package. I have tried all the solution proposed on Stackoverflow and other forums, but failed to fix the problem.
Did anyone have a similar experience?
Best Regards,
Yuriy
That URL that you are using should point to a WebAPI endpoint, but it looks like you are pointing it to an atlas url:
insertCirceDefinitionInPackage(25247, name = NULL, baseUrl = "http://www.ohdsi.org/web/atlas/#")
If you want to use the public ohdsi-hosed webapi, you should call it like this:
insertCirceDefinitionInPackage(25247, name = NULL, baseUrl = "http://54.242.168.196/WebAPI")
Just to test that the URL to the WebAPI works, you can access the cohort definition JSON via this URL:
http://54.242.168.196/WebAPI/cohortdefinition/25247
-Chris