| Time | Status | User Agent | |
|---|---|---|---|
Retrieving recent requests… | |||
Get Merchant Varsheet by Terminal ID
Retrieves the complete Value-Added Reseller (VAR) sheet for a specific terminal belonging to a merchant. The VAR sheet contains all parameters required to program a payment terminal, including acquirer BIN, merchant and store numbers, authorization and settlement phone numbers, debit/EBT configuration, and SSL/host-capture fields.
Endpoint
GET /api/export/Varsheet
Authentication
Basic HTTP Authentication required.
Encode username:password in Base64 and pass in the Authorization header:
Authorization: Basic {base64(username:password)}
When to use
Use this endpoint when provisioning or reprogramming a payment terminal. Call GET /api/export/Terminals first to obtain the internalId for the specific terminal, then pass both the merchant id and the terminal internalId to this endpoint. The returned parameters are passed directly to terminal configuration software or a VAR to program the device.
Query Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
id | integer | Yes | The internal merchant profile ID |
internalId | integer | Yes | The internal terminal ID (from GET /api/export/Terminals response) |
Response
200 OK
Envelope fields:
| Field | Type | Description |
|---|---|---|
requestId | integer | Unique identifier for this API request |
success | boolean | Whether the request was successful |
error | string | Error message if success is false |
validationErrors | array | Field-level validation errors |
data | object | VarsheetInformation object |
data.merchantInformation
| Field | Type | Description |
|---|---|---|
name | string | Merchant DBA name |
address | string | Street address |
city | string | City |
state | string | State code |
zip | string | ZIP code |
phone | string | Merchant phone number |
data.vitalParameters
| Field | Type | Description |
|---|---|---|
acquirerBin | string | Acquirer BIN used for network routing |
merchantNumber | string | Merchant account number |
vNumber | string | V-number assigned to the terminal |
storeNumber | string | Store number within the merchant hierarchy |
terminalNumber | string | Terminal number within the store |
merchantLocationNumber | string | Location identifier for multi-site merchants |
merchantCategoryCode | string | MCC (Merchant Category Code) |
agentNumber | string | ISO/agent number |
chainNumber | string | Chain number for multi-location groups |
merchantZipCode | string | Merchant ZIP code (used in AVS) |
dbaName | string | Doing Business As name programmed into the terminal |
merchantCity | string | Merchant city |
merchantState | string | Merchant state |
timeZoneCode | string | Time zone code for transaction timestamping |
timeZoneDifferential | string | Offset from UTC |
data.vitalPhoneNumbers (read-only)
| Field | Type | Description |
|---|---|---|
authorization | string | Authorization phone number |
settlement | string | Settlement phone number |
voiceAuthorization | string | Voice authorization fallback number |
data.debitEbt
| Field | Type | Description |
|---|---|---|
sharingGroup | string | Debit network sharing group code |
merchantAbaNumber | string | ABA number for debit/EBT routing |
settleAgentNumber | string | Settlement agent number (read-only) |
reimbursementAttribute | string | Reimbursement attribute code (read-only) |
industry | string | Industry code for EBT (read-only) |
fcsId | string | FCS identifier for EBT transactions |
data.authentication
| Field | Type | Description |
|---|---|---|
authenticationCode | string | Authentication code for terminal validation |
data.sslFields (read-only)
| Field | Type | Description |
|---|---|---|
portNumber | string | SSL port for host communication |
url | string | SSL host URL |
data.hostCaptureFields
| Field | Type | Description |
|---|---|---|
hcPosID | string | Host-capture POS ID |
{
"requestId": 304812,
"success": true,
"error": null,
"validationErrors": [],
"data": {
"merchantInformation": {
"name": "Acme Retail Store",
"address": "100 Commerce Blvd",
"city": "Miami",
"state": "FL",
"zip": "33101",
"phone": "3055557890"
},
"vitalParameters": {
"acquirerBin": "999001",
"merchantNumber": "918000000001234",
"vNumber": "79416045",
"storeNumber": "0001",
"terminalNumber": "0001",
"merchantLocationNumber": "00000001",
"merchantCategoryCode": "5999",
"agentNumber": "000100",
"chainNumber": "000000",
"merchantZipCode": "33101",
"dbaName": "ACME RETAIL",
"merchantCity": "MIAMI",
"merchantState": "FL",
"timeZoneCode": "705",
"timeZoneDifferential": "-5"
},
"vitalPhoneNumbers": {
"authorization": "8004STRIPE",
"settlement": "8004SETTLE",
"voiceAuthorization": "8004VAUTH0"
},
"debitEbt": {
"sharingGroup": "NYCE",
"merchantAbaNumber": "021000021",
"settleAgentNumber": "000001",
"reimbursementAttribute": "0",
"industry": "R",
"fcsId": "1234567"
},
"authentication": {
"authenticationCode": "A1B2C3D4"
},
"sslFields": {
"portNumber": "443",
"url": "txn.netevia.com"
},
"hostCaptureFields": {
"hcPosID": "00000001"
}
}
}Error Codes
| Code | When it happens |
|---|---|
| 400 | Missing or malformed id or internalId parameter |
| 401 | Invalid or missing Basic Auth credentials |
| 403 | User does not have permission for this operation |
| 404 | No merchant or terminal found for the provided IDs |
| 500 | Internal server error |
Common Mistakes
- Omitting the
internalIdparameter — bothidandinternalIdare required. - Using the public merchant ID string or terminal name instead of the internal integer IDs.
- Requesting the VAR sheet for a terminal with
status: Closed— closed terminals may return empty or stale programming data. - Attempting to write or modify VAR sheet data via this endpoint — it is read-only.
- Not calling
GET /api/export/Terminalsfirst to obtain validinternalIdvalues.
Related Endpoints
GET /api/export/Terminals— list all terminals for a merchant to obtaininternalIdGET /api/export/MerchantProfile— retrieve full merchant data including equipment sectionGET /api/export/GetAvailableStatusesList— decode merchant status codes
Example
curl -X GET "https://hq.staging.netevia.dev/api/export/Varsheet?id=71103&internalId=10045" \
-H "Authorization: Basic $(echo -n 'username:password' | base64)"