OHDSI Home | Forums | Wiki | Github

Atlas JSON to OHDSql conversion

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.

@Patrick_Ryan many thanks.

Yuriy

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

t