Information
  • Author: Appian Corporation
  • Type: Plug-in (Connected System)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 20.3+
  • First Released:
  • Last Updated:
  • Cost: Free
Share
Home » AppMarket » MongoDB Connected System

MongoDB Connected System

Overview

The benefits of using this plug-in versus MongoDB’s REST API include:

  • Most common MongoDB operations are provided as low-code Integration objects, making it very easy to quickly integrate Appian and MongoDB
  • Uses connection pooling to reduce authentication time per operation
  • Uses the MongoDB Wire Protocol with BSON instead of HTTP/REST with JSON for more efficient communication
  • Automatically handles the conversion of MongoDB BSON Documents to Appian Dictionaries, or alternatively provides MongoDB-created JSON representation
  • Can import from and export to Appian Documents containing JSON
  • Configured using a single Connection String, which is masked and encrypted

Key Features & Functionality

Provides the following Integration Operations:

READ Integration Operations:

  • List Databases
  • List Collections
  • Collection Find
  • Collection Count
  • Collection Aggregate

WRITE Integration Operations:

  • Collection Find to JSON File
  • Collection Aggregate to JSON File
  • Create Collection
  • Create Index in Collection
  • Insert Many in Collection
  • Insert One in Collection
  • Update Many in Collection
  • Update One in Collection
  • Replace One in Collection
  • Delete Many in Collection
  • Delete One in Collection
  • Drop Collection

Provides a set of Expression Functions for easily generating MongoDB Query Expression JSON without creating rules or concatenating strings.

Anonymous
Parents

  • Dear Team,

    While testing this plugin we could see that the filter Collection  type on the field does not work correctly.. here is an example:

    Input

    m_query(
      {
        m_field(
        "status",
        m_eq(
          "Completed"
        )
      )
      }
    )

    Expected : "{ "status": { "$eq": "Completed" } }"

    Actual : "{ "status": { "$eq": "TypedValue[it=3,v=Completed]" } }"

    Any idea why the text "TypedValue[it=3,v=" is getting added to the request while making call to MongoDB ?

Comment

  • Dear Team,

    While testing this plugin we could see that the filter Collection  type on the field does not work correctly.. here is an example:

    Input

    m_query(
      {
        m_field(
        "status",
        m_eq(
          "Completed"
        )
      )
      }
    )

    Expected : "{ "status": { "$eq": "Completed" } }"

    Actual : "{ "status": { "$eq": "TypedValue[it=3,v=Completed]" } }"

    Any idea why the text "TypedValue[it=3,v=" is getting added to the request while making call to MongoDB ?

Children
  • in reply to ankitj0003

    I will take a look at this and submit an update asap.

    For now you can work around it by constructing the JSON via standard expressions. Tip: to use special characters in Dictionary key names, surround the value with single-quotes like so:


    a!toJson({ status: { '$eq': "Completed" } })

© 2024 Appian. All rights reserved.