4.2.20
OpenRefine January 2020 Review
With the new year, we decided to start a monthly review of what happened in the OpenRefine community. We listed below a summary of what happened in December 2019 and January 2020. Let us know if we missed something.
Do not forget to subscribe to our newsletter on the right to never miss an update.
Do not forget to subscribe to our newsletter on the right to never miss an update.
20.1.20
How to use Columnize by Key/Value
Based on the Wordpress export file in XML format shared by Adam K on the user mailing list the column item - wp:postmeta - wp:meta_key and item - wp:postmeta - wp:meta_value store data in a key:value format. The column meta_key indicates the value type and the column meta_value store the field value.
17.9.18
(Part 2) Update Records in NationBuild API using OpenRefine
This article is part of a series of tutorials to use NationBuilder API. We wrote them in collaboration with Campaign Gears. In the previous article, we explained how to retrieve people information via NationBuilder API. This article explains how to use OpenRefine to bulk update information via NationBuilder API.
Don't hesitate to contact us if you have questions or need help to implement NationBuilder data integration project.
(Part 1) Collecting data from NationalBuilder API with OpenRefine
This article is part of a series of tutorials to use NationBuilder API. We wrote them in collaboration with Campaign Gears. NationalBuilder is an online software that helps organizations to coordinate their community. It supports members management, web pages, finances, and online communications. NationalBuilder has an API that gives access to NationalBuilder's core features.
The NationalBuilder API has extensive documentation and options to explore all available features. Using the API Explorer, you can explore the different API endpoints. These endpoints allow you to review all data available in the NationalBuilder API. You can learn more about the API in the Developer Blog and API Documentation.
The NationalBuilder API documentation provides examples of how to access the API with Ruby, PHP, and Python. In this article, we explain how non-developer can use the API thanks to OpenRefine. We describe two techniques: one using cURL and OpenRefine and one using only OpenRefine.
Don't hesitate to contact us if you have questions or need help to implement NationBuilder data integration project.
Don't hesitate to contact us if you have questions or need help to implement NationBuilder data integration project.
6.6.18
How to call Content Grabber API
In this tutorial, we will describe how to call the Content Grabber API to trigger an agent and pass input parameters. Thanks to Content Grabber API you can embed the scraper in a more complex workflow and configure it on-demand. We will first discuss Content grabber API then I will create a simple example to show step by step how it works
Don't hesitate to contact us if you have questions or need help to implement web scraping projects.
5.12.15
How to check if value within a record are unique in OpenRefine
When working in record mode, it is possible to compare all the value within one record and see if those are unique. To do that we will introduce the function forEach() that let turn the record into an array and count unique value.
Subscribe to:
Posts (Atom)