How To Import Data From REST API That Returns JSON

[Hide_Kojima1]

Here is how to import data from Reset API that returns JSON

1. Select File from Data Frame (+) menu

2. Select Remote then JSON

3. Enter the URL for the Rest API

e.g. https://projects.propublica.org/nonprofits/api/v2/search.json?order=revenue&sort_order=desc

4. Preview it and click the Save button

5. Save it as a data frame