Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Example SELECT query for retrieving Services and related records:

No Formatcode
languagesql
SELECT * FROM SERVICES_CHARGES;

...

These parameters are added in addition to any fields from the specific data types.

Parameter

Default

Description

limit

20

Number of listings to show. Maximum is 50.

page

1

Page number to show. To view more than 50 listings, make successive API calls while incrementing this field.

Response Data

Name

Datatype

Searchable

Notes

BILLABLE

Yes/No

Yes

To indicate whether the service item is or is not billable

STATUS_DATE

string

Yes

Shows the date when the service was set to its current status

SERVICE_HOST

string

Yes

The Service Host associated with the service

SERVICE_ID

string

Yes

Service Id (phone_number, etc.)

SERVICE_ID_FMT

string

Yes

Formatted Service Id

CATALOG

string

Yes

Service Catalog name

OWNER

string

Yes

Name of the service owner – either a person or org hierarchy

LOCATIONS_PATH

string

Yes

The hierarchical path to the location of the service; use LOCATIONS when searching

SLA_CATALOG_PATH

string

Yes

The hierarchical path to the SLA of the service; use SLA when searching

SERVICES_STATUS

string

Yes

The current status of the service

SERVICES_UDF

list

No

List of all the User Defined Fields and the selected values for this service

SERVICES_CHARGES

list

No

Charges listed for this service

SERVICES_CONTACTS

list

No

Contacts associated with the service

SERVICES_EQUIPMENT

list

No

Pieces of equipment to be used/listed for this service

SERVICES_EXPENSE_GLA

list

No

Expense G/L Accounts to be used for billing of this service

SERVICES_REMARKS

list

No

List of all remarks/comments for this service

Results

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>1331</total_count>
        <services>
            <item>
                <RECID>2488</RECID>
                <MODIFIED_DATE>2014-08-22 12:37:49</MODIFIED_DATE>
                <BILLABLE>Yes</BILLABLE>
                <STATUS_DATE>2014-07-11 15:35:38</STATUS_DATE>
                <CAT_RECID>46</CAT_RECID>
                <SERVICE_HOST/>
                <SERVICE_ID>5555555555</SERVICE_ID>
                <SERVICE_ID_FMT>(555) 555-5555</SERVICE_ID_FMT>
                <CATALOG>Amazing Product</CATALOG>
                <OWNER>Blue Alert</OWNER>
                <MODIFIED_BY>PCR User</MODIFIED_BY>
                <LOCATIONS_PATH/>
                <SLA_CATALOG_PATH/>
                <S_SERVICE_STATUS_VALUE>Active</S_SERVICE_STATUS_VALUE>
                <SERVICE_STATUS>ACTIVE</SERVICE_STATUS>
                <SERVICES_UDF>
                    <item>
                        <LABEL>Label</LABEL>
                        <VALUE>value</VALUE>
                    </item>
                </SERVICES_UDF>
                <SERVICES_CHARGES>
                    <item>
                        <RECID>956</RECID>
                        <TENANTS_RECID>0</TENANTS_RECID>
                        <MODIFIED_DATE>2014-07-21 14:55:11</MODIFIED_DATE>
                        <MODIFIED_BY>PCR User</MODIFIED_BY>
                        <SERVICES_RECID>29</SERVICES_RECID>
                        <CHRG_CATALOG_RECID>57</CHRG_CATALOG_RECID>
                        <DESCRIPTION/>
                        <AMOUNT>50</AMOUNT>
                        <BILL_DATE/>
                        <PRORATE>0</PRORATE>
                        <EXPENSE_GLA_RECID/>
                        <QUANTITY/>
                        <CATALOG_NAME>name</CATALOG_NAME>
                        <CATALOG_DESCRIPTION>description</CATALOG_DESCRIPTION>
                        <CATALOG_AMOUNT>199</CATALOG_AMOUNT>
                    </item>
                </SERVICES_CHARGES>
                <SERVICES_CONTACTS>
                    <item>
                        <RECID>2523</RECID>
                        <TENANTS_RECID>0</TENANTS_RECID>
                        <MODIFIED_DATE>2013-06-05 10:25:56</MODIFIED_DATE>
                        <MODIFIED_BY>PCR User</MODIFIED_BY>
                        <SERVICES_RECID>1767</SERVICES_RECID>
                        <CONTACTS_RECID>34</CONTACTS_RECID>
                        <FIRST_NAME>John</FIRST_NAME>
                        <LAST_NAME>Doe</LAST_NAME>
                    </item>
                </SERVICES_CONTACTS>
                <SERVICES_EQUIPMENT>
                    <item>
                        <RECID>71</RECID>
                        <TENANTS_RECID>0</TENANTS_RECID>
                        <MODIFIED_DATE>2015-03-26 13:38:34</MODIFIED_DATE>
                        <MODIFIED_BY>PCR User</MODIFIED_BY>
                        <SERVICES_RECID>1697</SERVICES_RECID>
                        <EQUIPMENT_RECID>3078</EQUIPMENT_RECID>
                        <SERVICE_ID>0000001234</SERVICE_ID>
                        <SERV_CATALOG_RECID>56</SERV_CATALOG_RECID>
                        <OWNER_CONTACTS_RECID/>
                        <OWNER_DEPT_HIERARCHY_RECID>47</OWNER_DEPT_HIERARCHY_RECID>
                        <BILLABLE>No</BILLABLE>
                        <SERVICE_STATUS_LISTS_RECID>1321</SERVICE_STATUS_LISTS_RECID>
                        <STATUS_DATE>2015-03-10 13:24:27</STATUS_DATE>
                        <SERVICE_HOSTS_RECID>26</SERVICE_HOSTS_RECID>
                        <SLA_CATALOG_RECID/>
                        <LOCATIONS_RECID>66</LOCATIONS_RECID>
                        <REFERENCE/>
                        <ESSENTIAL>0</ESSENTIAL>
                        <BILLING_GROUPS_RECID/>
                        <SERVICE_ID_FMT>(000) 000-1234</SERVICE_ID_FMT>
                        <EQP_STATUS_LISTS_RECID>1175</EQP_STATUS_LISTS_RECID>
                        <EQP_CATALOG_RECID>71</EQP_CATALOG_RECID>
                        <SERIAL_NUM>006A</SERIAL_NUM>
                        <SERIAL_NUM_BARCODE/>
                        <EQUIPMENT_ID>006A</EQUIPMENT_ID>
                        <ASSET_TAG/>
                        <CONSUMED>No</CONSUMED>
                        <PURCHASE_PRICE/>
                        <RECEIVED_DATE/>
                        <BILLED_DATE/>
                        <CARD_NUMBER/>
                        <PARENT_EQUIPMENT_RECID/>
                        <CABLING_EQP_TYPE_LISTS_RECID/>
                        <IP4_GATEWAY/>
                        <IP6_GATEWAY/>
                        <LAN_NAME/>
                        <MAC_ADDRESS/>
                        <IP4_ADDRESS/>
                        <IP6_ADDRESS/>
                        <IP4_SUBNET_MASK/>
                        <IP6_SUBNET_MASK/>
                        <IP4_GATEWAY_ADDRESS/>
                        <IP6_GATEWAY_ADDRESS/>
                        <HOST_NAME/>
                        <EQP_CONDITION_LISTS_RECID/>
                        <ORDERED_DATE/>
                        <UNITS/>
                        <WARRANTY_END_DATE/>
                        <USE_DHCP>0</USE_DHCP>
                        <PRIVATE>0</PRIVATE>
                        <STATUS>Active</STATUS>
                        <PART_NUMBER>ABC123</PART_NUMBER>
                        <PART_NUM_BARCODE/>
                        <DESCRIPTION>ABC123</DESCRIPTION>
                        <MANUFACTURER/>
                        <MANU_PART_NUM/>
                        <CATALOG_DESCRIPTION/>
                        <CATEGORY>No</CATEGORY>
                        <PRORATE>No</PRORATE>
                        <ASSIGNABLE>No</ASSIGNABLE>
                        <CABLING_EQUIPMENT>Yes</CABLING_EQUIPMENT>
                        <ASSET>No</ASSET>
                        <LOCATION_REQUIRED>No</LOCATION_REQUIRED>
                        <ORDERABLE>0</ORDERABLE>
                        <CONSUMABLE>No</CONSUMABLE>
                        <PROVISIONED>0</PROVISIONED>
                        <REVENUE_GLA_RECID>45</REVENUE_GLA_RECID>
                        <REVENUE_OB_CODES_RECID>6</REVENUE_OB_CODES_RECID>
                        <EXPENSE_OB_CODES_RECID>6</EXPENSE_OB_CODES_RECID>
                        <WORKER_INSTALL_TIME>3600</WORKER_INSTALL_TIME>
                        <WORKER_REMOVE_TIME>3600</WORKER_REMOVE_TIME>
                        <MAX_QUANTITY/>
                        <PARENT_EQP_CATALOG_RECID/>
                        <WARRANTY_LENGTH_LISTS_RECID/>
                        <HEIGHT/>
                        <WIDTH/>
                        <SLOTS/>
                        <UNIT_LISTS_RECID>1342</UNIT_LISTS_RECID>
                        <HAS_UNITS>0</HAS_UNITS>
                        <CONTIGUOUS>0</CONTIGUOUS>
                    </item>
                </SERVICES_EQUIPMENT>
                <SERVICES_EXPENSE_GLA>
                    <item>
                        <PERCENT>100</PERCENT>
                        <Type>Default</Type>
                        <GLA_FULL_CODES_0>100 > 200 > 300 > 400</GLA_FULL_CODES_0>
                    </item>
                </SERVICES_EXPENSE_GLA>
                <SERVICES_REMARKS>
                    <item>
                        <RECID>74</RECID>
                        <TENANTS_RECID>0</TENANTS_RECID>
                        <MODIFIED_DATE>2013-07-05 14:04:51</MODIFIED_DATE>
                        <MODIFIED_BY>PCR User</MODIFIED_BY>
                        <SERVICES_RECID>1697</SERVICES_RECID>
                        <REMARKS>These are the remarks</REMARKS>
                    </item>
                </SERVICES_REMARKS>
            </item>
        </services>
    </services>

...

Below is how to make a LIST request:

noformat
Code Block
language
sql
   GET http://DOMAIN/api/API_KEY/services.OUTPUT?LIST=LISTTYPE

...

If a LISTTYPE is designated as searchable in the table below, adding the "SEARCH" param will return values that contain the provided value.

noformat
Code Block
language
sql
   GET http://DOMAIN/api/API_KEY/services.OUTPUT?LIST=LISTTYPE&SEARCH=test

Parameter

Replace With

LISTTYPE

The type of List to be retrieved. Types can be found below.

List Types

Type

Description

Extra Parameters*

 

 



CONTACTS

Retrieve available Contacts

CTYPE - Type of contact. Example: "worker"

yes

Results

DEPTHIER

Retrieve available Departments

 


Coming Soon

Results

EXPENSE_TYPE

Retrieve available Expense Types

 


no

Results

GLAS

Retrieve available GLAs

 


no

Results

LOCATIONS

Retrieve available Locations

 


yes

Results

CHARGE_CATALOG

Retrieve available Charge Catalogs

 


yes

Results

SERVICE_CATALOG

Retrieve available Service Catalogs

 


yes

Results

SERVICE_HOSTS

Retrieve available Service Hosts

 


no

Results

UDFS

Retrieve available User Defined Fields (UDF)

SERV_CATALOG_RECID (required)

no

Results

SLAS

Retrieve available SLAs

 


no

Results

POOLS

Retrieve available Service Pools

 


no

Results

SERVICE_CLASSES

Retrieve available Service Classes

 


no

Results

SERVICE_HOST_PARTITIONS

Retrieve available Service Host Partitions

 


no

Results

AUTH_CODE_TYPE

Retrieve available Auth Code Types

 


no

Results

BANDWIDTH

Retrieve available Bandwidths

 


no

Results

RATING_GROUP

Retrieve available Rating Groups

 


no

Results

SERVICE_STATUS

Retrieve available Service Statuses

 


no

Results

*Extra Parameters can be appended to the URL in standard Query String fashion.

Contacts Results
No Formatcode
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <contacts>
            <item>
                <RECID>809</RECID>
                <SERVICE_REP>Doe, John</SERVICE_REP>
                <STATUS>1</STATUS>
                <CONTACT_TYPE_LISTS_RECID>1147</CONTACT_TYPE_LISTS_RECID>
                <C_TITLE_VALUE/>
                <C_TITLE_CODE/>
                <CTYPE_CONTACT_TYPE_VALUE>User</CTYPE_CONTACT_TYPE_VALUE>
                <CTYPE_CONTACT_TYPE_CODE>USER</CTYPE_CONTACT_TYPE_CODE>
            </item>
        </contacts>
    </services>
Department Hierarchy Results
noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <depthier>
            <item>
                <RECID>24</RECID>
                <DH_NAME>Facilities</DH_NAME>
                <STATUS>1</STATUS>
                <DEFAULT_SLA_DESC/>
                <DEFAULT_INCI_SLA_DESC/>
                <BG_NAME>Admin</BG_NAME>
                <DEPT_HIERARCHY_PATH>FM</DEPT_HIERARCHY_PATH>
                <DEPT_HIERARCHY_PATH_TOOLTIP>FM</DEPT_HIERARCHY_PATH_TOOLTIP>
                <NAME_AND_BG>FM - Admin</NAME_AND_BG>
            </item>
        </depthier>
    </services>
Expense Types Results
Code Blocknoformat
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <expense_type>
            <item>
                <RECID>1182</RECID>
                <VALUE>Default</VALUE>
            </item>
        </expense_type>
    </services>
GLAs Results
noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <glas>
            <item>
                <RECID>1</RECID>
                <NAME>ACCOUNT</NAME>
                <DESCRIPTION>GLA Format for Account Billing Group</DESCRIPTION>
            </item>
        </glas>
    </services>
Locations Results
Code Blocknoformat
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <locations>
            <item>
                <RECID>261</RECID>
                <TENANTS_RECID>0</TENANTS_RECID>
                <MODIFIED_DATE>2015-01-02 16:47:00</MODIFIED_DATE>
                <MODIFIED_BY>hsolo</MODIFIED_BY>
                <STATUS>1</STATUS>
                <WAREHOUSE_FLAG>0</WAREHOUSE_FLAG>
                <REPORT_911>0</REPORT_911>
                <DEFAULT_WH_LOCATIONS_RECID/>
                <PARENT_LOCATIONS_RECID>7</PARENT_LOCATIONS_RECID>
                <LOCATION_TYPE_LISTS_RECID/>
                <NAME>Tatooine</NAME>
                <BUILDING_NUMBER/>
                <BUILDING_ADDRESSES_RECID/>
                <MASTER_DEFAULT_WAREHOUSE>0</MASTER_DEFAULT_WAREHOUSE>
                <LATITUDE/>
                <LONGITUDE/>
                <DEFAULT_RETURN_WAREHOUSE>0</DEFAULT_RETURN_WAREHOUSE>
                <DEFAULT_RWH_LOCATIONS_RECID/>
                <COMMUNITY_NAME/>
                <L_LOCATION_TYPE_VALUE/>
                <L_LOCATION_TYPE_CODE/>
            </item>
        </locations>
    </services>
Charge Catalog Results
noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>64</count>
        <total_count>64</total_count>
        <charge_catalog>
            <item>
                <RECID>167</RECID>
                <NAME>Starship Detailing</NAME>
                <DESCRIPTION>1-time charge for cleaning of starships</DESCRIPTION>
                <AMOUNT>126587</AMOUNT>
                <CHARGE_TYPE_LISTS_RECID>1981</CHARGE_TYPE_LISTS_RECID>
                <EXPENSE_TYPE_LISTS_RECID>1182</EXPENSE_TYPE_LISTS_RECID>
                <PARENT_CHRG_CATALOG_RECID/>
                <REVENUE_GLA_RECID>1</REVENUE_GLA_RECID>
                <USE_QUANTITY>1</USE_QUANTITY>
                <TAXABLE>0</TAXABLE>
                <ALLOW_OVERRIDE>1</ALLOW_OVERRIDE>
                <CC_CHARGE_TYPE_VALUE>1 time</CC_CHARGE_TYPE_VALUE>
                <CC_CHARGE_TYPE_CODE>1_TIME</CC_CHARGE_TYPE_CODE>
                <CC_EXPENSE_TYPE_VALUE>Default</CC_EXPENSE_TYPE_VALUE>
                <CC_EXPENSE_TYPE_CODE>DEFAULT</CC_EXPENSE_TYPE_CODE>
            </item>
        </charge_catalog>
    </services>
Service Catalog Results
noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <service_catalog>
            <item>
                <RECID>1</RECID>
                <TENANTS_RECID>0</TENANTS_RECID>
                <MODIFIED_DATE>2013-08-07 13:13:06</MODIFIED_DATE>
                <MODIFIED_BY>lorgana</MODIFIED_BY>
                <STATUS>1</STATUS>
                <SERVICE_NAME>Force Training</SERVICE_NAME>
                <SERVICE_TYPE_LISTS_RECID>1329</SERVICE_TYPE_LISTS_RECID>
                <PARENT_SERV_CATALOG_RECID/>
                <DESCRIPTION>Learn to use the force</DESCRIPTION>
                <CATALOG_DESCRIPTION></CATALOG_DESCRIPTION>
                <CATEGORY>0</CATEGORY>
                <PRORATE>0</PRORATE>
                <ASSIGNABLE>1</ASSIGNABLE>
                <BILLABLE>1</BILLABLE>
                <LOCATION_REQUIRED>0</LOCATION_REQUIRED>
                <REQUIRES_APPROVAL>0</REQUIRES_APPROVAL>
                <ORDERABLE>1</ORDERABLE>
                <DEFAULT_SERVICE_HOSTS_RECID/>
                <WORKER_INSTALL_TIME>3600</WORKER_INSTALL_TIME>
                <WORKER_REMOVE_TIME>5400</WORKER_REMOVE_TIME>
                <REVENUE_GLA_RECID>4</REVENUE_GLA_RECID>
                <REVENUE_OB_CODES_RECID>1</REVENUE_OB_CODES_RECID>
                <AGING/>
                <REPORT_911>0</REPORT_911>
                <FORMAT/>
                <BILLING_GROUP_RESTRICT/>
                <EQUIPMENT_RESTRICT/>
                <LOCATION_RESTRICT/>
            </item>
        </service_catalog>
    </services>
Service Hosts Results
Code Blocknoformat
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <service_hosts>
            <item>
                <RECID>31</RECID>
                <TENANTS_RECID>0</TENANTS_RECID>
                <MODIFIED_DATE>2013-12-18 14:45:06</MODIFIED_DATE>
                <MODIFIED_BY>dvader</MODIFIED_BY>
                <STATUS>1</STATUS>
                <NAME>GNetwork</NAME>
                <HOST_TYPES_LISTS_RECID>1198</HOST_TYPES_LISTS_RECID>
                <SWITCH_TYPES_LISTS_RECID/>
                <DEFAULT_NPA/>
                <DEFAULT_NXX/>
                <UPDATE_REQUIRED>0</UPDATE_REQUIRED>
                <DIAL_PLAN/>
                <IP_ADDRESS/>
                <NETWORK_PORT/>
                <USERNAME/>
                <PASSWORD/>
                <VERSION/>
                <WSDL_URI/>
                <HOST_ADDRESS/>
                <DATA_ENCODING/>
                <REQUEST_HEADERS/>
            </item>
        </service_hosts>
    </services>
UDFs Results
noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <udfs>
            <item>
                <RECID>3</RECID>
                <PRCODE>General</PRCODE>
            </item>
        </udfs>
    </services>
SLAs Results
Code Blocknoformat
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <slas>
            <item>
                <RECID>3</RECID>
                <VALUE>General</VALUE>
            </item>
        </slas>
    </services>
Service Pools Results
No Formatcode
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <pools>
            <item>
                <RECID>11</RECID>
                <VALUE>IT</VALUE>
            </item>
        </pools>
    </services>
Service Classes Results
noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <service_classes>
            <item>
                <RECID>16</RECID>
                <VALUE>SC Name</VALUE>
            </item>
        </service_classes>
    </services>
Service Host Partitions Results
noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <service_host_partitions>
            <item>
                <RECID>54</RECID>
                <TENANTS_RECID>0</TENANTS_RECID>
                <MODIFIED_DATE>2015-11-06 15:05:04</MODIFIED_DATE>
                <MODIFIED_BY>cbacca</MODIFIED_BY>
                <SERVICE_HOSTS_RECID>46</SERVICE_HOSTS_RECID>
                <PARTITIONS_NAME>Default</PARTITIONS_NAME>
                <PARTITIONS_DESC>Default Partition</PARTITIONS_DESC>
            </item>
        </service_host_partitions>
    </services>
Auth Code Types Results
No Formatcode
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>1</total_count>
        <auth_code_types>
            <item>
                <RECID>3</RECID>
                <VALUE>General</VALUE>
            </item>
        </auth_code_types>
    </services>
Bandwidth Results
Code Blocknoformat
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>1</total_count>
        <bandwidth>
            <item>
                <RECID>3</RECID>
                <VALUE>1 Gbps</VALUE>
            </item>
        </bandwidth>
    </services>
Rating Groups Results
No Formatcode
languagexml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <rating_group>
            <item>
                <RECID>1890</RECID>
                <VALUE>Group_1</VALUE>
            </item>
        </rating_group>
    </services>
Service Statuses Results
noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>20</count>
        <total_count>20</total_count>
        <service_status>
            <item>
                <RECID>3</RECID>
                <VALUE>Active</VALUE>
            </item>
        </service_status>
    </services>

...

This version of the API is available starting in 2.1.0.0

Available Fields

Field

Required

Data Type

Options

Default

Notes

RECID

only when updating

Integer

 

 



Identifier of the record to be updated

status

yes

Integer

Lists

 


The status of the service.

serv_catalog

yes

Integer

Lists

 


Recid of the Service Catalog item.

service_id

yes

String

 

 



Service ID of this service

service_id_fmt

no

String

 

 



Formatted version of the Service ID

owner

no*

Integer

Lists

 


Record ID of either the Contact or the Department owner.

owner_type

no*

String

"contact" or "department"

 


Type of owner

location

no

Integer

Lists

 


Recid of location for service.

service_host

no

Integer

Lists

 


Recid of Service Host for service.

sla

no

Integer

Lists

 


Recid of SLA for service.

reference

no

String

 

 



Reference for service

billable

no

Integer

1 = yes; 0 = no

 


Designate if the Service is Billable

billing_group

no

Integer

Lists

 


Recid of billing group for service.

essential

no

Integer

1 = yes; 0 = no

 


Designate if this is an essential Service

status_date

yes

String

 

 



Date status was set for Service

assoc_service

no

Integer

Lists

 


Recid of Associated Service.

equipment

no

String

Lists

 


Recid(s) of equipment to add to Service. If multiple Equipment are to be assigned, separate Recids with commas. Example: 56,875.

contact

no

String

Lists

 


Recid(s) of Contacts to add to Service. If multiple contacts are to be assigned, separate recids with commas. Example: 1234,7894.

remarks

no

String

 

 



Remarks to add to the Service

pool

no

String

Lists

 


Recids of Service pool(s) to add to the Service. If multiple contacts are to be assigned, separate recids with commas. Example: 548,785.

gla

no

Integer

Lists

 


Recid(s) of GLA record(s) to assign to this service. If multiple GLAs are to be assigned, separate recids with commas. Example: 874,32.

gla_percent

no*

String

 


100

Percentage(s) of this Service that should apply to specified GLA(s). *If multiple GLAs are provided, then percent is required and the same count of percentages need to be provided also. Total of all percentages must equal exactly 100.

gla_type

no*

String

Lists

 


List Value(s) of Expense Type(s). *Required if GLA is specified.

service_type

yes

String

"phone", "data", "authcode", "backbone"

 


Type of Service. This value determines specific fields and requirements listed below.

directory

yes

Integer

1 = yes; 0 = no

 


IF service_type = "phone". Designates if this Service is to be listed in the directory.

report_911

yes

Integer

1 = yes; 0 = no

 


IF service_type = "phone". Designates if this Service is to be listed in emergency 911 feed.

multiple_locations

no

Integer

1 = yes; 0 = no

 


IF service_type = "phone". Designates if this Service has multiple locations.

bandwidth

no

Integer

Lists

 


IF service_type = "data" OR "backbone". Recid of bandwidth record.

auth_code_type

no

Integer

Lists

 


IF service_type = "authcode". Recid of authcode type.

service_class

no

Integer

Lists

 


IF service_type = "authcode". Recid of Service Class for authcode.

Results

If the request is successful, the Service RECID will be returns as follows:

Code Blocknoformat
languagexml
    <service>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>0</total_count>
        <service>54875</service>
    </service>

...

Below is the proper format for making a separate request. Note "type=POOLS" to indicate that this is to add a Service to one or more Pools.

POST
No Format
Code Block
languagesql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=POOLS&field1=value1 ...

Available Fields

Field

Required

Data Type

Options

Default

Notes

service_recid

yes

Integer

 

 



Recid of service

pools

yes

String

 

 



One or more Recids of Pools. If multiple, separate with commas. Example: 23,43

Results

If the request is successful, the Recid(s) of the linking records will be returned in same order as provided:

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>0</total_count>
        <services>
            <item>2312</item>
            <item>2313</item>
        </services>
    </services>

...

Below is the proper format for making a separate request. Note "type=REMARK" to indicate that this is to add a remark to a service.

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=REMARK&field1=value1 ...

Available Fields

Field

Required

Data Type

Options

Default

Notes

service_recid

yes

Integer

 

 



Recid of service

remarks

yes

String

 

 



The remark to add to the service

Results

If the request is successful, the Recid of the remark record will be returned as follows:

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>0</total_count>
        <services>456231</services>
    </services>

...

Below is the proper format for making a separate request. Note "type=CHARGES" to indicate that this is to create a Service Charge record.

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=CHARGES&field1=value1 ...

Available Fields

Field

Required

Data Type

Options

Default

Notes

service_recid

yes

Integer

 

 



The RECID of the Service that the charge is for

charge_recid

yes

Integer

 

 



Record ID of the applicable charge catalog. See Lists about how to retrieve available Charge Catalogs.

description

no

String

 

 



The details or description of the charge on the Equipment

amount

no*

Float

 

 



The amount to be charged. *Required if charge does not have an amount on it.

quantity

no

Integer

 


1

Quantity of charge to be used.

prorate

no

Integer

1 or 0

0

Should the charge be prorated when activated

gla

no

Integer

Lists

 


Recid of GLA to assign to Service Charge

location

no

Integer

Lists

 


Location that this Charge applies to for the service

Results

If the request is successful, the RECID of the new Service charge is returned as follows:

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>1</total_count>
        <services>58337</services>
    </services>

...

Below is the proper format for making a separate request. Note "type=GLA" to indicate that this is to add a Service GLA record(s).

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=GLA&field1=value1 ...

If multiple GLAs are to be set, structure your request as follows:

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=GLA&field1=v1.1,v1.2&field2=v2.1,v2.2 ...

When creating your comma separated values, each place in the string corresponds to the same space in other field value strings.

Available Fields

Field

Required

Data Type

Options

Default

Notes

service_recid

yes

Integer

 

 



The RECID of the Service that the GLA is for

gla

yes

String

Lists

 


Record ID(s) of the applicable GLA(s).

gla_percent

yes

String

 

 



Percentages to apply to each GLA. All percentages must equal exactly 100.

gla_type

yes

String

Lists

 


The type(s) of GLA(s).

Results

If the request is successful, the RECID(s) of the new Service GLA records will be returned in the same order as provided:

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>1</total_count>
        <services>
            <item>234</item>
            <item>235</item>
        </services>
    </services>

...

Below is the proper format for making a separate request. Note "type=CONTACTS" to indicate that this is to add contacts to a Service.

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=CONTACTS&field1=value1 ...

Available Fields

Field

Required

Data Type

Options

Default

Notes

service_recid

yes

Integer

 

 



The RECID of the Service that the contact is for

contact

yes

String

Lists

 


Record ID(s) of the contact(s).

Results

If the request is successful, the RECID(s) of the new service contact records will be returned in the same order as provided:

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>1</total_count>
        <services>
            <item>123</item>
            <item>124</item>
        </services>
    </services>

...

Below is the proper format for making a UDF request. Note "type=UDFS" to indicate that this is to add UDFs to a Service.

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=UDFS&field1=value1 ...

Available Fields

Field

Required

Data Type

Options

Default

Notes

service_recid

yes

Integer

 

 



The RECID of the Service that the UDF is for

udf_UDF-RECID

yes

Mixed

 

 



UDF-RECID is the RECID of the UDF to assign the value to. Example: udf_684=value

Results

If the request is successful, the RECID(s) of the new Service UDF records will be returned in the same order as provided:

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>1</total_count>
        <services>
            <item>5434</item>
            <item>5435</item>
        </services>
    </services>

...

Below is the proper format for making a separate request. Note "type=LOCATIONS" to indicate that this is to add locations to a service.

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=LOCATIONS&field1=value1 ...

If multiple locations are to be set, structure your request as follows:

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=LOCATIONS&field1=v1.1,v1.2&field2=v2.1,v2.2 ...

When creating your comma separated values, each place in the string corresponds to the same space in other field value strings.

Available Fields

Field

Required

Data Type

Options

Default

Notes

service_recid

yes

Integer

 

 



Recid of service

location

yes

Integer

Lists

 


Recid(s) of the location(s) to assign to the service.

report_911

yes

Integer

1 = yes; 0 = no

 


Designate if Location should show on emergency 911 feed

location_status

yes

Integer

1 = yes; 0 = no

 


Status of location

Results

If the request is successful, the Recid of the Service Location record(s) will be returned in the same order as provided:

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>0</total_count>
        <services>
            <item>4545</item>
            <item>4546</item>
        </services>
    </services>

...

Below is the proper format for making a separate request. Note "type=EQUIPMENT" to indicate that this is to add Equipment to a Service.

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=EQUIPMENT&field1=value1 ...

If multiple Equipment are to be assigned, structure your request as follows:

noformat
Code Block
language
sql
POST http://DOMAIN/api/API_KEY/services.OUTPUT?type=EQUIPMENT&field1=v1.1,v1.2&field2=v2.1,v2.2 ...

When creating your comma separated values, each place in the string corresponds to the same space in other field value strings.

Available Fields

Field

Required

Data Type

Options

Default

Notes

service_recid

yes

Integer

 

 



Recid of service

equipment

yes

String

Lists

 


Recid(s) of Equipment to assign to the Service

Results

If the request is successful, the Recid of the Service Equipment record(s) will be returned in the order provided:

noformat
Code Block
language
xml
    <services>
        <status>success</status>
        <page>1</page>
        <count>1</count>
        <total_count>0</total_count>
        <services>
            <item>234</item>
            <item>235</item>
        </services>
    </services>

...