The SmartSimple Data Extraction API provides a RESTful interface for programmatic access to SmartSimple data. Built for bulk data extraction and BI and data warehouse pipelines, the API allows system administrators to target specific records and retrieve only the data that changed within a given period, reducing data transfer volume and processing overhead.
Who: Global administrators
When to Use the Data Extraction API
Use the Data Extraction API when:
- Manual data exports are consuming staff time or creating bottlenecks in reporting workflows.
- BI dashboards or reports need to reflect current SmartSimple data without full dataset re-exports (for example, syncing grant application records nightly to a data warehouse).
- Data pipelines require filtered, field-level access rather than bulk record downloads (for example, retrieving only updated organization records from the past 30 days).
- Your organization requires auditable, secure API access with Bearer token authentication and full audit logging.
Enable SmartSearch
To setup the data extraction API, enable SmartSearch:
- Click the System Administration gear in the upper navigation bar, and then select Global Settings.
-
Click the System tab.
-
Locate the System Performance Options section, and toggle Enable SmartSearch for List Views on.
Click Reindex.
- Allow SmartSearch to complete its initial index before proceeding.
Create an API User
The Data Extraction API requires a dedicated user account configured for API access. To create an API user:
- Create a new user in SmartSimple.
- Set the Access Type to API Access.
- Save the user record.
Generate an API User Token
To generate a Data Extraction token for the API user:
- Click the System Administration gear in the upper navigation bar, select Global Settings, and click the Integrations tab.
- Click API Users.
- Locate and click the edit pencil icon next to the API user you created.
- Click Generate User Access Token.
- Enter a note for reference.
- Set the Token Type to Data Extraction.
- Select the entities the user should have access to.
- Click Generate User Access Token.
- Copy the generated token and store it securely. The token is required in the next section and will not be displayed again.
Access and Test the API
The Data Extraction API includes an interactive Swagger UI for exploring endpoints and running test requests. To access and test the API:
- Navigate to your instance URL with the Swagger path appended. Replace youralias.smartsimple.com with your actual instance URL:
https://youralias.smartsimple.com/swagger/extapi-swagger-ui.html - Click Authorize.
- Paste the token copied in the previous section.
- Expand the Health or Data sections to view available endpoints.
- Select the desired endpoint and click Try it out.
- Add any required fields and click Execute to run the request.