Icon

Exercise 1

Chapter 3 / Exercise 1
Workflow: Chapter3/ Exercise 1 This exercise illustrates how to extract data from Google Sheets and use this data in aGET Request with the REST service provided by the chemical database ChemSpider extract rootresponseInChIKey to MolCreate GET requestdraw structureSheet "InChi" of spreadsheet "InChIkeys" contains a list of keys identifying molecules on a chemical databasekeep onlyInChIKey and MolGiven an API connectionconnetcs to Google SheetsAuthentication toGoogle Services You must click the"Authenticate" button and enter your own Google credentials!XPath GET Request String Manipulation Molecule Type Cast Google SheetsReader Column Filter Google SheetsConnection GoogleAuthentication Workflow: Chapter3/ Exercise 1 This exercise illustrates how to extract data from Google Sheets and use this data in aGET Request with the REST service provided by the chemical database ChemSpider extract rootresponseInChIKey to MolCreate GET requestdraw structureSheet "InChi" of spreadsheet "InChIkeys" contains a list of keys identifying molecules on a chemical databasekeep onlyInChIKey and MolGiven an API connectionconnetcs to Google SheetsAuthentication toGoogle Services You must click the"Authenticate" button and enter your own Google credentials!XPath GET Request String Manipulation Molecule Type Cast Google SheetsReader Column Filter Google SheetsConnection GoogleAuthentication

Nodes

Extensions

Links