POST Agents/ErpSync/GetAllConnections

• 4 minutes to read
 • 4 minutes to read 
POST /api/v1/Agents/ErpSync/GetAllConnections

Returns all ERP Sync connections without config field data.

Uses the ErpConnection archive. NsApiSlow threshold: 5000 ms.

Online Restricted: ## The ErpSync agent is not available in Online by default. Access must be requested specifically when app is registered. Intended for ERP integration apps.

Query String Parameters

Parameter Name Type Description
$select string Optional comma separated list of properties to include in the result. Other fields are then nulled out to reduce payload size: "Name,department,category". Default = show all fields. 
POST /api/v1/Agents/ErpSync/GetAllConnections?$select=name,department,category/id

Request Headers

Parameter Name Description
Authorization Supports 'Basic', 'SoTicket' and 'Bearer' schemes, depending on installation type.
X-XSRF-TOKEN If not using Authorization header, you must provide XSRF value from cookie or hidden input field
Content-Type Content-type of the request body: application/json, text/json, application/xml, text/xml, application/x-www-form-urlencoded, application/json-patch+json, application/merge-patch+json
Accept Content-type(s) you would like the response in: application/json, text/json, application/xml, text/xml, application/json-patch+json, application/merge-patch+json
Accept-Language Convert string references and multi-language values into a specified language (iso2) code.
SO-Language Convert string references and multi-language values into a specified language (iso2) code. Overrides Accept-Language value.
SO-Culture Number, date formatting in a specified culture (iso2 language) code. Partially overrides SO-Language/Accept-Language value. Ignored if no Language set.
SO-TimeZone Specify the timezone code that you would like date/time responses converted to.
SO-AppToken The application token that identifies the partner app. Used when calling Online WebAPI from a server.

Request Body: request

IncludeDeleted

Property Name Type Description
IncludeDeleted Boolean

Response:array

OK

Response Description
200 OK

Response body: array

Property Name Type Description
ErpConnectionId int32 Primary key
ErpConnectorId int32 The connector that this connection should call
DisplayName string Connection name shown to user; multi-language support
DisplayDescription string Tooltip/description shown to user; multi-language support
Active bool Is this connection currently active
ConnectionId string The GUID that uniquely identifies this connection; passed to the Connector in every call
MostRecentTimestamp string Datetime, transaction number or other identification of the point in time of the most-recently seen actor in the ERP system
ConfigFields object The config fields needed to establish a connection to the connector
Deleted bool If true, the connection has been deleted and should not be shown to the users.
AllAccess bool Is this connection accessible to everyone? If not, then the ErpConnectionAccess table tells us who can access it
UserGroupAccessIds array Array of ids containing usergroups that will have access to this connection.
AssociateAccessIds array Array of ids containing associates that will have access to this connection.
TableRight TableRight The carrier's table right
FieldProperties object Field property dictionary mapping field names to field access rights.

Sample request

POST /api/v1/Agents/ErpSync/GetAllConnections
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: en
Content-Type: application/json; charset=utf-8

{
  "IncludeDeleted": true
}

Sample response

HTTP/1.1 200 OK
Content-Type: application/json; charset=utf-8

[
  {
    "ErpConnectionId": 100,
    "ErpConnectorId": 621,
    "DisplayName": "Microsoft Dynamics 365 Sales",
    "DisplayDescription": "Integration with Dynamics 365 for customer and sales data synchronization",
    "Active": true,
    "ConnectionId": "D365-SALES-PROD",
    "MostRecentTimestamp": "2024-11-27T09:15:00Z",
    "ConfigFields": {
      "TenantId": "a1b2c3d4-e5f6-g7h8-i9j0-k1l2m3n4o5p6",
      "Environment": "crm.dynamics.com"
    },
    "Deleted": false,
    "AllAccess": false,
    "UserGroupAccessIds": [
      726,
      623
    ],
    "AssociateAccessIds": [
      163,
      74
    ],
    "TableRight": null,
    "FieldProperties": {
      "fieldName": {
        "FieldRight": null,
        "FieldType": "System.Int32",
        "FieldLength": 638
      }
    }
  }
]