Translations:Wikidata:Tools/OpenRefine/Editing/Tutorials/Working with APIs/10/en

Extracting information from JSON responses

State of the project after retrieving the JSON responses.

Once the operation is complete, you obtain the JSON responses in a new column. We now need to extract information from this. Each response potentially contains a list of employers, so the first step is to extract the sub-objects for each employer on a separate line, according to OpenRefine's record model. This is unfortunately a slightly inelegant process: