Skip to main content

CAD Connector - Spillman

Alex Montgomery avatar
Written by Alex Montgomery
Updated over a month ago

Overview

The Data Agent will read from the Spillman FLEX DEX API. To do this we need a user to connect.

User Permissions: The User needs permissions to the following tables:

CADMasterCallTable (cdcall & tab_cdcall)

CADCallHistoryTable (cdhist & tab_cdhist)

NatureOfCallTable (tbnatur & tab_tbnatur)

GeobaseAddressIDMaintenance (gbaddr & tab_gbaddr)

OfficerNameCodeTable (apnames & tab_apnames)

MasterPersonnelTable (pemain & tab_pemain)

MainNamesTable (nmmain & tab_nmmain)

CADCallCommentsTable (cdccomnt & tab_cdccomnt)

LoginLog (aplilog & tab_aplilog)

rlmain & tab_rlmain

rlofficr & tab_rlofficr

xmlquery

MAKE SURE

  • Login with this user once

  • Make sure the user can login from the machine the service is running on

To prepare for this connection, we need the following details.

Configuration

* required

Explanation

Host*

Host of the Spillman FLEX DEX API. Full URL with protocol and port (e.g. https://cad.example.net:4444/DataExchange/REST)

User*

Spillman API user username

Password*

Spillman API user password

Agency*

Filter to a specific agency.

Time Reported Hours

How far back we should pull data in each query. Default is 48 hours.

Use pemain

Setting on where we should pull data about users. Depends on Spillman licensed modules

Use main radio log

Setting on where we should pull data about users. Depends on Spillman licensed modules

Use complainant information

Setting on will override caller name and caller phone with the complainant information from MainNamesTable

Did this answer your question?