Nanonets

Nanonets External Integrations API

List external integrations connected to a Nanonets account (Postgres, MySQL, MSSQL, MongoDB, and other databases) and execute generic SQL queries against them in the context of a Nanonets workflow. Used by Database Matching Conditions and database lookup actions inside the no-code workflow builder.

Nanonets External Integrations API is one of 4 APIs that Nanonets publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 1 machine-runnable capability that can be deployed as REST, MCP, or Agent Skill surfaces via Naftiko.

Tagged areas include Integrations, Database, and Lookups. The published artifact set on APIs.io includes API documentation, an OpenAPI specification, and 1 Naftiko capability spec.

GitHub OpenAPI

Documentation

📖
Documentation
https://docs.nanonets.com/reference/getexternalintegrations
📖
Documentation
https://docs.nanonets.com/reference/executequery-1

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/nanonets/refs/heads/main/openapi/nanonets-external-integrations-api-openapi.yml

Other Resources

🔗
NaftikoCapability
https://raw.githubusercontent.com/api-evangelist/nanonets/refs/heads/main/capabilities/external-integrations.yaml

OpenAPI Specification

nanonets-external-integrations-api-openapi.yml Raw ↑ 
openapi: 3.0.3
info:
  title: Nanonets External Integrations API
  description: |
    Manage external database integrations linked to a Nanonets account and
    execute generic SQL-style queries against them inside a Nanonets workflow.
    Used by the Database Matching Conditions and database lookup workflow blocks.
  version: 1.0.0
  contact:
    name: Nanonets
    url: https://nanonets.com
    email: [email protected]
servers:
  - url: https://app.nanonets.com
security:
  - BasicAuth: []
tags:
  - name: External Integrations
    description: List and query external database integrations.
paths:
  /api/v2/externalIntegrations:
    get:
      tags: [External Integrations]
      summary: Get External Integrations
      description: List external integrations connected to the account.
      operationId: getExternalIntegrations
      responses:
        '200':
          description: List of external integrations.
          content:
            application/json:
              schema:
                type: array
                items: { $ref: '#/components/schemas/ExternalIntegration' }
  /api/v2/externalIntegrations/{external_integration_id}/executequery:
    post:
      tags: [External Integrations]
      summary: Execute Query
      description: Execute a generic SQL-style query against a connected external integration.
      operationId: executeQuery
      parameters:
        - name: external_integration_id
          in: path
          required: true
          schema: { type: string }
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required: [query]
              properties:
                query:
                  type: string
                  example: "select * from passports where dob='file_url'"
      responses:
        '200':
          description: Query result rows.
          content:
            application/json:
              schema:
                type: object
                properties:
                  rows:
                    type: array
                    items: { type: object, additionalProperties: true }
components:
  securitySchemes:
    BasicAuth:
      type: http
      scheme: basic
  schemas:
    ExternalIntegration:
      type: object
      properties:
        id: { type: string, example: 4013d779-c2f9-11eb-ba65-122daa108bc5 }
        email: { type: string, format: email }
        name: { type: string }
        type:
          type: string
          example: postgresql
          enum: [postgresql, mysql, mssql, mongodb]
        info:
          type: object
          additionalProperties: true