Icon

justKnimeit-12

justKnimeit-12
Challenge 12: Obtaining a List of Human Genes via RESTYour task is to use the REST service provided by MyGene.info to obtain a list of human genes related to a list of hormones provided to you by your coworkers.Next, you should parse the JSON response into a table that is easy to read. You should then parse this JSON into a table with columns "_id", "_score","entrezgene", "name", "symbol", and "taxid". If the list provided by your coworkers contains more than one hormone, all the parsed information should beaggregated into a single table. Also, sometimes your request may return a response in XML instead of JSON. How could you include a way to also parse XML responses? Get DataFilter residualsNew RowIDCreate TablePrepare forPivoitingtop -> jsonbottom -> xmlPick the branchNode 31 GET Request JSON to Table Column Filter Transpose RowID Pivoting Column Expressions Select Hormone Visualizations IF Switch Table Rowto Variable VariableExpressions XML To JSON JSON to Table End IF Challenge 12: Obtaining a List of Human Genes via RESTYour task is to use the REST service provided by MyGene.info to obtain a list of human genes related to a list of hormones provided to you by your coworkers.Next, you should parse the JSON response into a table that is easy to read. You should then parse this JSON into a table with columns "_id", "_score","entrezgene", "name", "symbol", and "taxid". If the list provided by your coworkers contains more than one hormone, all the parsed information should beaggregated into a single table. Also, sometimes your request may return a response in XML instead of JSON. How could you include a way to also parse XML responses? Get DataFilter residualsNew RowIDCreate TablePrepare forPivoitingtop -> jsonbottom -> xmlPick the branchNode 31 GET Request JSON to Table Column Filter Transpose RowID Pivoting Column Expressions Select Hormone Visualizations IF Switch Table Rowto Variable VariableExpressions XML To JSON JSON to Table End IF

Nodes

Extensions

Links