Customer Contacts
This documentation defines the Customer Contacts (ARCONTCT) schema fields.
Please Note This documentation defines the most relevant fields. Treat the response from the View Table Schema (
XMGETFMT) endpoint as the authoritative field list for any specific site.
Date formats
NTD is a timestamp format used by DICE. NTD dates are used when defining time frames within endpoint calls. See the Date Format documentation for information on converting NTD to UNIX and vice versa if needed.
Field definitions
| # | Name | Description | Length | Padding Type |
|---|---|---|---|---|
| 1 | AR_NUMBER | The unique accounting identifier assigned to the customer. | 10 | Pad with trailing spaces. |
| 2 | LIST_NUMBER | The unique ID assigned to the contact. Users can use the Passcode Lookup or Load Contact endpoints to view contact List Numbers. | 4 | Right justify and pad with leading zeros. |
| 3 | POSITION_CODE | The contact’s position or title. | 6 | Pad with trailing spaces. |
| 4 | TITLE | The contact’s preferred honorific (Mr., Ms., etc.). | 4 | Pad with trailing spaces. |
| 5 | FIRST_NAME | The contact’s first name. | 25 | Pad with trailing spaces. |
| 6 | MIDDLE_INITIAL | The initial of the contact’s middle name. | 2 | Pad with trailing spaces. |
| 7 | LAST_NAME | The contact’s last name. | 30 | Pad with trailing spaces. |
| 8 | STREET_NO | The building number of the contact’s address. | 8 | Pad with trailing spaces. |
| 9 | STREET_NAME1 | The street direction of the contact’s address. | 2 | Pad with trailing spaces. |
| 10 | STREET_NAME2 | The street name of the contact’s address. | 28 | Pad with trailing spaces. |
| 11 | ADDTL_ADDRESS | Additional address information such as P.O. box or apartment number. | 28 | Pad with trailing spaces. |
| 12 | ADDTL_ADDRESS_2 | Additional address information. | 28 | Pad with trailing spaces. |
| 13 | ADDTL_ADDRESS_3 | Additional address information. | 28 | Pad with trailing spaces. |
| 14 | CITY | The city name of the contact’s address. | 18 | Pad with trailing spaces. |
| 15 | STATE | The state or province abbreviation of the contact’s address. | 3 | Pad with trailing spaces. |
| 16 | COUNTRY | The country code of the contact’s address. | 3 | Pad with trailing spaces. |
| 17 | ZIPCODE | The postal code of the contact’s address. | 10 | Pad with trailing spaces. |
| 18 | PHONE_NUMBER | The contact’s primary phone number. | 16 | Pad with trailing spaces. |
| 19 | PHONE_EXTENSION | If applicable, the extension number used to direct dial the contact. | 4 | Pad with trailing spaces. |
| 20 | FAX_NUMBER | If applicable, the number used to reach this contact via fax. | 16 | Pad with trailing spaces. |
| 21 | LAST_OPERATOR | The operator code of the individual who last updated the contact’s profile. | 3 | Pad with trailing spaces. |
| 22 | LAST_ENTRY | The NTD date and time of the last update made to the contact’s profile. | 6 | Pad with trailing spaces. |
| 23 | ACTIVE | Determines if the contact is active within the system. Accepts: Y or N. | 1 | Pad with trailing spaces. |
| 24 | CONTACT_INFO_1 | Contact identifier field 1. | 25 | Pad with trailing spaces. |
| 25 | CONTACT_INFO_2 | Contact identifier field 2. | 25 | Pad with trailing spaces. |
| 26 | BRANCH_ID | The ID of the branch the contact belongs to. | 3 | Pad with trailing spaces. |
| 27 | BEGIN_TIME | The time of day the contact becomes available. | 4 | Pad with trailing spaces. |
| 28 | END_TIME | The time of day the contact is no longer available. | 4 | Pad with trailing spaces. |
| 29 | TIME_ZN | The time zone the contact lives in. | 3 | Pad with trailing spaces. |
| 30 | PHONE_NUMBER_F | Determines the phone number masking applied to the contact’s phone number. For information on the available masking options, see the View Phone Formats endpoint documentation. | 1 | Pad with trailing spaces. |
| 31 | FAX_NUMBER_F | Determines the phone number masking applied to the contact’s fax number. For information on the available masking options, see the View Phone Formats endpoint documentation. | 1 | Pad with trailing spaces. |
| 32 | DEFAULT_SORT_NO | The order the contact will display in. | 5 | Pad with trailing spaces. |
| 33 | SORT_PHONE | The contact’s phone number without any formatting for sorting/searching purposes. | 16 | Pad with trailing spaces. |
| 34 | SMS_NOTIFY | Determines if this contact can be contacted via SMS. Accepts: Y or N. | 1 | Pad with trailing spaces. |
Example request
curl --request GET \
--url 'https://global-rest.ci.matrixmcloud.com/rest/rest.php?dataSource=dice&*view=arcontct&*limit=1&*blanks=all' \
--header 'X-DICE-APPKEY: {{X-DICE-APPKEY}}' \
--header 'X-DICE-USERNAME: {{X-DICE-USERNAME}}' \
--header 'X-DICE-DATE: {{X-DICE-DATE}}' \
--header 'X-DICE-NONCE: {{X-DICE-NONCE}}' \
--header 'X-DICE-DIGEST: {{X-DICE-DIGEST}}' \
--header 'Accept: application/json' \
Example response
{
"ARCONTCT": [
{
"AR_NUMBER": "000000021",
"LIST_NUMBER": "0002",
"POSITION_CODE": "MANAGE",
"TITLE": "MS",
"FIRST_NAME": "TERI",
"MIDDLE_INITIAL": "L",
"LAST_NAME": "WALKER",
"STREET_NO": "991",
"STREET_NAME1": "E",
"STREET_NAME2": "OVILLA ROAD",
"ADDTL_ADDRESS": "SUITE A",
"ADDTL_ADDRESS_2": "",
"ADDTL_ADDRESS_3": "",
"CITY": "RED OAK",
"STATE": "TX",
"COUNTRY": "USA",
"ZIPCODE": "75154",
"PHONE_NUMBER": " (555) 234-2468",
"PHONE_EXTENSION": "301",
"FAX_NUMBER": "(555) 234-6895",
"LAST_OPERATOR": "JS",
"LAST_ENTRY": "733295",
"ACTIVE": "Y",
"CONTACT_INFO_1": "",
"CONTACT_INFO_2": "",
"BRANCH_ID": "",
"BEGIN_TIME": "0800",
"END_TIME": "1700",
"TIME_ZN": "EST",
"PHONE_NUMBER_F": "",
"FAX_NUMBER_F": "",
"DEFAULT_SORT_NO": "00002",
"SORT_PHONE": "5552342468",
"SMS_NOTIFY": ""
}
],
"totalRecords": 1
}