MPO Environment

Import the base connector

  1. Access your MPO environment.
  2. Select Create - From File and add the .json file with the integration.

Create from file

Once the upload is complete, you will see the Oracle NetSuite VX.X (X.X current version) folder in your workspace.

MPO folder

Configure processes

  1. Go to the Connector SETUP folder and open the Common setup process process.

Common setup process

Switch to View mode, and press New task. Fill in all the parameters with required values and press Add task. Wait until the task is processed.   Add task

Alternatively, you can use the following JSON. Modify it and paste into the Code editor tab.

{
    "aws_APIgatewayURL": "",
    "CustomFields_accountDetails": [ ],
    "CustomFields_branchDetails": [ ],
    "CustomFields_clientDetails": [ ],
    "CustomFields_productDetails": [ ],
    "CustomFields_transactionDetails": [ ],
    "Environment_limitSizeBatchNetSuite": 0,
    "Environment_limitSizeBatchSearch": 0,
    "Environment_limitSizeCollectionOfBatches": 0,
    "Mambu_noOfRetries": 0,
    "Mambu_password": "",
    "Mambu_timeZone": "",
    "Mambu_url": "",
    "Mambu_user": "",
    "NetSuite_subsidiary": "",
    "Notification_channel": "",
    "Notification_user": ""
}
ParameterDescription
aws_APIgatewayURLThe AWS API Gateway URL generated previously.
"CustomFields_accountDetails": [ ],
"CustomFields_branchDetails": [ ],
"CustomFields_clientDetails": [ ],
"CustomFields_productDetails": [ ],
"CustomFields_transactionDetails": [ ],
See the Note about custom fields below.
Environment_limitSizeBatchNetSuiteThe minimum number of balanced Journal Lines that can be sent to NetSuite.
Environment_limitSizeBatchSearchThe URL parameter limit that specifies the number of records to return (Journal Lines), used in combination with the offset parameter. These parameters are utilized to retrieve the records in batches, as a paginated set.
Environment_limitSizeCollectionOfBatches.The maximum number of batches processed simultaneously in MPO.
Mambu_noOfRetriesThe number of retries for a Mambu API call in case of errors
Mambu_passwordMambu user (with API access).
Mambu_timeZoneOrganization’s Time Zone.
Mambu_urlOrganization’s Mambu tenant URL address.
Mambu_userMambu user password.
NetSuite_subsidiaryThe subsidiary (organization’s legal entity) id from NetSuite.
Notification_channelNotification channel, for example task - in this case, if an error occurs, a task is created in Mambu.
Notification_userThe encoded key of the assigned Mambu user who will receive notifications in case of errors.

Note about custom fields:
Along with the mandatory data (entryId, glCode, type, amount, description, bookingDate, currency), the integration offers the option to send additional information for a Journal Line, as custom data.
The custom data is limited to fields affiliated with the following entities: Account, Branch, Client, Product and Transaction.
Configuring a custom field set consists of:

  • Identifying the Mambu API source field and its path;
  • Define the NetSuite target field;
  • Add the source-target pair under its corresponding entity (accountDetails, branchDetails, clientDetails, productDetails, transactionDetails)
    The path parameter will have as value the path of the source field name from the JSON response to a GET Mambu API request applied on the specific entity.
    The example below shows how to configure custom field sets, depending on the source field’s path: root, property of an object, element of an array.
"CustomFields_entityDetails": [
    {
        "path": "id", // path of the Mambu source field name (root)
        "target_id": "entityId" // NetSuite target field name
    },
    {
        "path": "object.fieldName", // path of the Mambu source field name (property of an object)
        "target_id": "fieldName" // NetSuite target field name
    },
    {
        "path": "array[i].fieldName", // path of the Mambu source field name (element of an array, with index ‘i’)
        "target_id": "fieldName" // NetSuite target field name
    }
   	 ]

Create webhook URL

Open the Main process and select View details ( i ). Open the Webhook tab and select Copy webhook via JSON.   Webhook URL

Take note of the URL, as it will be used in the next step when configuring your Mambu environment.