Exact

Cloud business software for SMEs and their accountants

Integrate the Exact API with the nocodb API

Setup the Exact API trigger to run a workflow which integrates with the nocodb API. Pipedream's integration platform allows you to integrate Exact and nocodb remarkably fast. Free for developers.

Delete Record with nocodb API on New Account Created from Exact API
Exact + nocodb
 
Try it
Add Record with nocodb API on New Account Created from Exact API
Exact + nocodb
 
Try it
Add Record with nocodb API on New Contact Created from Exact API
Exact + nocodb
 
Try it
Delete Record with nocodb API on New Contact Created from Exact API
Exact + nocodb
 
Try it
Get Record (from row number) with nocodb API on New Account Created from Exact API
Exact + nocodb
 
Try it
New Account Created from the Exact API

Emit new event each time a new account is created. See the docs

 
Try it
New Contact Created from the Exact API

Emit new event each time a new contact is created. See the docs

 
Try it
New Record in Table from the nocodb API

Emit new event for each new record in table. See the documentation

 
Try it
New Update in Table from the nocodb API

Emit new event for each update in table. See the documentation

 
Try it
Add Record with the nocodb API

This action adds a record in a table. See the documentation

 
Try it
Delete Record with the nocodb API

This action deletes a row in a table. See the documentation

 
Try it
Get Record (from row number) with the nocodb API

This action gets a row by row Id. See the documentation

 
Try it
List Records in Table Matching Criteria with the nocodb API

This action lists all rows in a table. See the documentation

 
Try it
Update Record with the nocodb API

This action updates a record in a table. See the documentation

 
Try it

Overview of Exact

The Exact API provides a suite of endpoints for interacting with Exact's cloud-based financial software, which includes tools for accounting, CRM, and ERP functionalities. By leveraging this API on Pipedream, you can automate data flows across various business functions, sync financial records, manage customer relationships, and streamline operational processes. Pipedream's serverless execution model allows for crafting intricate workflows that respond in real-time to events, schedule operations, and connect with countless other apps to extend the functionality of Exact's ecosystem.

Connect Exact

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    exact: {
      type: "app",
      app: "exact",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://start.exactonline.${this.exact.$auth.region}/api/v1/current/Me?$select=UserID,Email`,
      headers: {
        Authorization: `Bearer ${this.exact.$auth.oauth_access_token}`,
        "Content-Type": `application/json`,
      },
      params: {
        "$select": `UserID,Email`,
      },
    })
  },
})

Overview of nocodb

The NoCodeB (NocoDB) API transforms your databases into a smart Excel sheet, providing a platform for managing your data with the ease of a spreadsheet interface. When combined with Pipedream's capabilities, this API allows you to automate data operations, sync with other databases or apps, and streamline workflows without writing complex code. Using Pipedream, you can trigger events based on changes in your NocoDB, process and manipulate the data, and connect to countless apps to extend functionality, such as sending notifications, updating CRMs, or generating reports.

Connect nocodb

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    nocodb: {
      type: "app",
      app: "nocodb",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.nocodb.$auth.domain}/api/v1/db/meta/nocodb/info`,
      headers: {
        "accept": `application/json`,
        "xc-token": `${this.nocodb.$auth.api_key}`,
      },
    })
  },
})