Using the API and other data IO options to extract data from agileBase and/or connect with third party systems

There are a number of ways to extract data from agileBase, whether manually for an individual’s use or programatically for integration with other systems.

There are also multiple ways other than the user interface to enter data into agileBase.

Outgoing Data

Users are able to:

  • Export Data to spreadsheet
  • Generate Docs via a template
  • Access attached files
  • Print screen information

Third parties can access data via an API, either:

  • PULL data
  • PUSH data

There is also dedicated facility for integrating data with a Calendar

  • Calendar Integration

Incoming Data

Users are ablle to add data:

  • Via the User Interface
  • Import CSV files

Third parties can save data in to agilebase

  • Via the POST API

Setting up the Calendar API

A powerful automation feature that can synchronise data with a third party calendar.

Creating a POST API

A powerful automation feature that can allow a third party system to POST data in to agileBase.

Creating a PUSH API

A powerful automation feature that can send data to third party systems.

Creating a PULL API

Control how third party systems read data from agileBase

PUSH API worked example - Zapier

A worked example to send agileBase data to a third party text messaging service using Zapier

PULL API worked example - Power BI

A worked example showing how to send agileBase data to third party business intelligence software

Complete API worked example

A more complex API example showing a real world integration consisting of multiple steps

Exporting to spreadsheet

The data in each view can be exported when the requisite privileges are granted

Slack integration

Allows comments posted in agileBase to be shared as Slack notifications

Importing from spreadsheet

Adding to or updating existing data in a table using a spreadsheet import

Authenticating users via the API

Logging in as a user

Creating user accounts with the API

Creating a user account in a multi-tenanted system with an API request

Last modified June 22, 2021: Tag all docs pages (c49ef8f)