tschaffter
commented
2 years ago Done by Verena, who shared the JSON files with me over slack.
Closed tschaffter closed 2 years ago
tschaffter
commented
2 years ago Done by Verena, who shared the JSON files with me over slack.
@vpchung shared this Synapse table that powers the Cancer Complexity Knowledge Portal (CCKP).
@jaeddy shared this query in an attempt to keep only tools that may be relevant to CTSA.
https://staging.cancercomplexity.synapse.org/Explore/Tools?QueryWrapper0=%7B%22sql%22%3A%22SELECT%20*%20FROM%20syn26127427%20WHERE%20portalDisplay%20%3D%20true%22%2C%22limit%22%3A25%2C%22offset%22%3A0%2C%22selectedFacets%22%3A%5B%7B%22concreteType%22%3A%22org.sagebionetworks.repo.model.table.FacetColumnValuesRequest%22%2C%22columnName%22%3A%22inputData%22%2C%22facetValues%22%3A%5B%22Clinical%20record%22%2C%22Ontology%20mapping%22%2C%22Terms%22%2C%22Text%22%2C%22Treatment%20agent%22%2C%22Electronic%20health%20records%22%2C%22Patient%20outcome%20data%22%2C%22Phenotype%20name%22%5D%7D%5D%7D
The tool schemas is derived from the bio.tools schema.
Task
Generate a JSON representation of the data stored in the Synapse table. Working with data in JSON format will make things easier when it comes to pushing the data to the Resource Discovery Portal (RDP) Elasticsearch instance created by Dave.