Call API Automation

You can now orchestrate with any API by sending HTTP requests with JSON payloads. This opens up the ability for you to automate thousands of third party services into your process.

Overview

You can use the Call API automation to access functionality or retrieve data from the other tools and products you and your team use. For example, your workflow might call a weather API to retrieve current weather data for a specific location, or call your payment service API to process a customer's payment.

Calling an API refers to the process of making a request to a another product in order to retrieve data or perform a specific action. This enables your Onalu workflow to automatically interact with different software systems or applications.

When you call an API, you send a request containing specific parameters or data to the API endpoint. The API endpoint is a specific URL that serves as the entry point for accessing the API. Our API automation supports HTTP request methods GET, POST, PUT, PATCH, and DELETE. Once the API has processed the request, it will send back a response, which contains the requested data or an acknowledgment of the performed action. You can map the response from the API to return a value from this automation which can be referenced elsewhere in your workflow.

Configuring the Call API Automation

Create a field and open automation settings

  1. Add a new field into your Onalu table by clicking the "+" button on the right side of the table
  2. Choose “Automation”
  3. Choose "Call API"
  4. Click “Create Field”
  5. Go to the sidebar and click on the button labeled “Automation Settings”

Configure the API Request

💡Tip: It helps to have the API documentation for the API that you want to call handy as you configure these settings.

Method

The Call API automation supports HTTP request methods (GET, POST, PUT, PATCH, DELETE)

URL

Select the URL of the API endpoint that serves as the entry point for accessing the API.

Headers

Headers are additional pieces of information sent along with the API request. Headers provide metadata about the API request, allowing the client and server to communicate important details and instructions. 

Example header: Authorization

Used to authenticate and authorize the API request. It typically contains authentication credentials, such as an API key, access token, or a bearer token, to validate the user or application making the request.

Payload

The Call API automation supports JSON payloads. Enter the JSON payload you want to send here.

💡 Tip: Use references to insert dynamic data into your API Request

Map the API Response

Mapping the API response is optional. If you do not map a response, the value of the automation will always return an <empty value>, even after the API call was completed.

You can map the API response so that you can use the response from the API in your Onalu table.

Map the API response source using JMESPath

JMESPath is a query language and syntax for searching and extracting data from JSON-like structures. It stands for "JSON Matching Expression Path." JMESPath allows you to specify a query expression to traverse and filter data in JSON documents, making it easier to retrieve specific information from complex data structures.

Create a property type to capture the data in Onalu

For each piece of data you wish to capture:

1. Select the type: Use the dropdown to select the type that best describes the data sent in the response.

2. Set property name: Type in a name for the mapped data property that best describes what the data is in case you need to reference it in another field or formula.