Get list of custom pif mappings
Overview
To fetch a list of custom PIFs mapped by the user for the institution.
Resource Access
GET https://<hostname>/institution/v1/institution/<institutionID>/pifMapping
Parameters
The requested criteria can be a combination of one or more of the following fields:
| Keys | Values |
|---|---|
| filter | %7B%7D |
| search | |
| field | <field user wants to search> |
| size | 10 |
| sort | created%3Adesc |
Example Request
GET https://<hostname>/institution/v1/institution/04a29a09-6d54-5074-9346-1dc7cdf71357/pifMapping
Host: <hostname>
Authorization: Bearer <JWT token>
Content-Type: application/json
Example Response
{
"totalRecords": 2,
"totalType": "exact",
"recordCount": 2,
"records": [
{
"acl": [
"pps:cpx-acquiring",
"institution:04a29a09-6d54-5074-9346-1dc7cdf71357",
"network:cebc25a1-186d-509f-bcde-63df16250fbc"
],
"associatedInstitutionId": "04a29a09-6d54-5074-9346-1dc7cdf71357",
"isStandardMapping": true,
"isInstitutionMapping": true,
"mapping": {
"columnOptions": [
{
"id": "0",
"name": "nid",
"ranges": {}
},
{
"id": "1",
"name": "fid",
"ranges": {}
},
{
"id": "2",
"name": "bid",
"ranges": {}
},
{
"id": "3",
"name": "fileDate",
"ranges": {}
},
{
"id": "4",
"name": "transactionId",
"ranges": {}
},
{
"id": "5",
"name": "paymentExpirationDate",
"ranges": {}
},
{
"id": "6",
"name": "accountType",
"ranges": {}
},
{
"id": "7",
"name": "vcnNumber",
"ranges": {}
},
{
"id": "8",
"name": "vcnAccountExpirationDate",
"ranges": {}
},
{
"id": "9",
"name": "bankRoutingNumber",
"ranges": {}
},
{
"id": "10",
"name": "bankAccountNumber",
"ranges": {}
},
{
"id": "11",
"name": "checkNumber",
"ranges": {}
},
{
"id": "12",
"name": "accountId",
"ranges": {}
},
{
"id": "13",
"name": "amount",
"ranges": {}
},
{
"id": "14",
"name": "partialPaymentIndicator",
"ranges": {}
},
{
"id": "15",
"name": "invoiceNumbers",
"ranges": {}
},
{
"id": "16",
"name": "invoiceDates",
"ranges": {}
},
{
"id": "17",
"name": "invoiceAmounts",
"ranges": {}
},
{
"id": "18",
"name": "invoiceTotalDues",
"ranges": {}
},
{
"id": "19",
"name": "invoiceDescription",
"ranges": {}
},
{
"id": "20",
"name": "poNumber",
"ranges": {}
},
{
"id": "21",
"name": "poDate",
"ranges": {}
},
{
"id": "22",
"name": "sid",
"ranges": {}
},
{
"id": "23",
"name": "supplierName",
"ranges": {}
},
{
"id": "24",
"name": "supplierAddressLine1",
"ranges": {}
},
{
"id": "25",
"name": "supplierAddressLine2",
"ranges": {}
},
{
"id": "26",
"name": "supplierCity",
"ranges": {}
},
{
"id": "27",
"name": "supplierState",
"ranges": {}
},
{
"id": "28",
"name": "supplierZip",
"ranges": {}
},
{
"id": "29",
"name": "supplierEmail",
"ranges": {}
},
{
"id": "30",
"name": "reference1",
"ranges": {}
},
{
"id": "31",
"name": "reference2",
"ranges": {}
},
{
"id": "32",
"name": "reference3",
"ranges": {}
},
{
"id": "33",
"name": "reference4",
"ranges": {}
},
{
"id": "34",
"name": "reference5",
"ranges": {}
},
{
"id": "35",
"name": "emailNotes",
"ranges": {}
},
{
"id": "36",
"name": "scheduleDate",
"ranges": {}
},
{
"id": "37",
"name": "udf1",
"ranges": {}
},
{
"id": "38",
"name": "udf2",
"ranges": {}
},
{
"id": "39",
"name": "udf3",
"ranges": {}
},
{
"id": "40",
"name": "udf4",
"ranges": {}
},
{
"id": "41",
"name": "udf5",
"ranges": {}
},
{
"id": "42",
"name": "udf6",
"ranges": {}
},
{
"id": "43",
"name": "udf7",
"ranges": {}
},
{
"id": "44",
"name": "udf8",
"ranges": {}
},
{
"id": "45",
"name": "udf9",
"ranges": {}
},
{
"id": "46",
"name": "udf10",
"ranges": {}
},
{
"id": "47",
"name": "udf11",
"ranges": {}
},
{
"id": "48",
"name": "udf12",
"ranges": {}
},
{
"id": "49",
"name": "udf13",
"ranges": {}
},
{
"id": "50",
"name": "udf14",
"ranges": {}
},
{
"id": "51",
"name": "udf15",
"ranges": {}
},
{
"id": "52",
"name": "udf16",
"ranges": {}
},
{
"id": "53",
"name": "udf17",
"ranges": {}
},
{
"id": "54",
"name": "udf18",
"ranges": {}
},
{
"id": "55",
"name": "udf19",
"ranges": {}
},
{
"id": "56",
"name": "udf20",
"ranges": {}
},
{
"id": "57",
"name": "udf21",
"ranges": {}
},
{
"id": "58",
"name": "udf22",
"ranges": {}
},
{
"id": "59",
"name": "udf23",
"ranges": {}
},
{
"id": "60",
"name": "udf24",
"ranges": {}
},
{
"id": "61",
"name": "udf25",
"ranges": {}
},
{
"id": "62",
"name": "udf26",
"ranges": {}
},
{
"id": "63",
"name": "udf27",
"ranges": {}
},
{
"id": "64",
"name": "udf28",
"ranges": {}
},
{
"id": "65",
"name": "udf29",
"ranges": {}
},
{
"id": "66",
"name": "udf30",
"ranges": {}
},
{
"id": "67",
"name": "udf31",
"ranges": {}
},
{
"id": "68",
"name": "udf32",
"ranges": {}
},
{
"id": "69",
"name": "udf33",
"ranges": {}
},
{
"id": "70",
"name": "udf34",
"ranges": {}
},
{
"id": "71",
"name": "udf35",
"ranges": {}
},
{
"id": "72",
"name": "udf36",
"ranges": {}
},
{
"id": "73",
"name": "udf37",
"ranges": {}
},
{
"id": "74",
"name": "udf38",
"ranges": {}
},
{
"id": "75",
"name": "udf39",
"ranges": {}
},
{
"id": "76",
"name": "udf40",
"ranges": {}
},
{
"id": "77",
"name": "udf41",
"ranges": {}
},
{
"id": "78",
"name": "udf42",
"ranges": {}
},
{
"id": "79",
"name": "udf43",
"ranges": {}
},
{
"id": "80",
"name": "udf44",
"ranges": {}
},
{
"id": "81",
"name": "udf45",
"ranges": {}
},
{
"id": "82",
"name": "udf46",
"ranges": {}
},
{
"id": "83",
"name": "udf47",
"ranges": {}
},
{
"id": "84",
"name": "udf48",
"ranges": {}
},
{
"id": "85",
"name": "udf49",
"ranges": {}
},
{
"id": "86",
"name": "udf50",
"ranges": {}
}
],
"columns": [
[
"0",
"nid"
],
[
"1",
"fid"
],
[
"2",
"bid"
],
[
"3",
"fileDate"
],
[
"4",
"transactionId"
],
[
"5",
"paymentExpirationDate"
],
[
"6",
"accountType"
],
[
"7",
"vcnNumber"
],
[
"8",
"vcnAccountExpirationDate"
],
[
"9",
"bankRoutingNumber"
],
[
"10",
"bankAccountNumber"
],
[
"11",
"checkNumber"
],
[
"12",
"accountId"
],
[
"13",
"amount"
],
[
"14",
"partialPaymentIndicator"
],
[
"15",
"invoiceNumbers"
],
[
"16",
"invoiceDates"
],
[
"17",
"invoiceAmounts"
],
[
"18",
"invoiceTotalDues"
],
[
"19",
"invoiceDescription"
],
[
"20",
"poNumber"
],
[
"21",
"poDate"
],
[
"22",
"sid"
],
[
"23",
"supplierName"
],
[
"24",
"supplierAddressLine1"
],
[
"25",
"supplierAddressLine2"
],
[
"26",
"supplierCity"
],
[
"27",
"supplierState"
],
[
"28",
"supplierZip"
],
[
"29",
"supplierEmail"
],
[
"30",
"reference1"
],
[
"31",
"reference2"
],
[
"32",
"reference3"
],
[
"33",
"reference4"
],
[
"34",
"reference5"
],
[
"35",
"emailNotes"
],
[
"36",
"scheduleDate"
],
[
"37",
"udf1"
],
[
"38",
"udf2"
],
[
"39",
"udf3"
],
[
"40",
"udf4"
],
[
"41",
"udf5"
],
[
"42",
"udf6"
],
[
"43",
"udf7"
],
[
"44",
"udf8"
],
[
"45",
"udf9"
],
[
"46",
"udf10"
],
[
"47",
"udf11"
],
[
"48",
"udf12"
],
[
"49",
"udf13"
],
[
"50",
"udf14"
],
[
"51",
"udf15"
],
[
"52",
"udf16"
],
[
"53",
"udf17"
],
[
"54",
"udf18"
],
[
"55",
"udf19"
],
[
"56",
"udf20"
],
[
"57",
"udf21"
],
[
"58",
"udf22"
],
[
"59",
"udf23"
],
[
"60",
"udf24"
],
[
"61",
"udf25"
],
[
"62",
"udf26"
],
[
"63",
"udf27"
],
[
"64",
"udf28"
],
[
"65",
"udf29"
],
[
"66",
"udf30"
],
[
"67",
"udf31"
],
[
"68",
"udf32"
],
[
"69",
"udf33"
],
[
"70",
"udf34"
],
[
"71",
"udf35"
],
[
"72",
"udf36"
],
[
"73",
"udf37"
],
[
"74",
"udf38"
],
[
"75",
"udf39"
],
[
"76",
"udf40"
],
[
"77",
"udf41"
],
[
"78",
"udf42"
],
[
"79",
"udf43"
],
[
"80",
"udf44"
],
[
"81",
"udf45"
],
[
"82",
"udf46"
],
[
"83",
"udf47"
],
[
"84",
"udf48"
],
[
"85",
"udf49"
],
[
"86",
"udf50"
]
],
"name": "Standard PIF",
"format": "text/csv",
"header": 0,
"footer": 0,
"groupBy": "",
"dateFormat": "MMDDYYYY",
"dateDelimiter": "",
"length": 47
},
"template": {
"preactions": [
{
"action": "openCSVFile",
"id": 1,
"order": 1
}
],
"actions": [
{
"action": "rename",
"column": 0,
"columnName": "nid",
"id": 1,
"order": 1
},
{
"action": "rename",
"column": 1,
"columnName": "fid",
"id": 2,
"order": 2
},
{
"action": "rename",
"column": 2,
"columnName": "bid",
"id": 3,
"order": 3
},
{
"action": "rename",
"column": 3,
"columnName": "fileDate",
"id": 4,
"order": 4
},
{
"action": "rename",
"column": 4,
"columnName": "transactionId",
"id": 5,
"order": 5
},
{
"action": "rename",
"column": 5,
"columnName": "paymentExpirationDate",
"id": 6,
"order": 6
},
{
"action": "rename",
"column": 6,
"columnName": "accountType",
"id": 7,
"order": 7
},
{
"action": "rename",
"column": 7,
"columnName": "vcnNumber",
"id": 8,
"order": 8
},
{
"action": "rename",
"column": 8,
"columnName": "vcnAccountExpirationDate",
"id": 9,
"order": 9
},
{
"action": "rename",
"column": 9,
"columnName": "bankRoutingNumber",
"id": 10,
"order": 10
},
{
"action": "rename",
"column": 10,
"columnName": "bankAccountNumber",
"id": 11,
"order": 11
},
{
"action": "rename",
"column": 11,
"columnName": "checkNumber",
"id": 12,
"order": 12
},
{
"action": "rename",
"column": 12,
"columnName": "accountId",
"id": 13,
"order": 13
},
{
"action": "rename",
"column": 13,
"columnName": "amount",
"id": 14,
"order": 14
},
{
"action": "rename",
"column": 14,
"columnName": "partialPaymentIndicator",
"id": 15,
"order": 15
},
{
"action": "rename",
"column": 15,
"columnName": "invoiceNumbers",
"id": 16,
"order": 16
},
{
"action": "rename",
"column": 16,
"columnName": "invoiceDates",
"id": 17,
"order": 17
},
{
"action": "rename",
"column": 17,
"columnName": "invoiceAmounts",
"id": 18,
"order": 18
},
{
"action": "rename",
"column": 18,
"columnName": "invoiceTotalDues",
"id": 19,
"order": 19
},
{
"action": "rename",
"column": 19,
"columnName": "invoiceDescription",
"id": 20,
"order": 20
},
{
"action": "rename",
"column": 20,
"columnName": "poNumber",
"id": 21,
"order": 21
},
{
"action": "rename",
"column": 21,
"columnName": "poDate",
"id": 22,
"order": 22
},
{
"action": "rename",
"column": 22,
"columnName": "sid",
"id": 23,
"order": 23
},
{
"action": "rename",
"column": 23,
"columnName": "supplierName",
"id": 24,
"order": 24
},
{
"action": "rename",
"column": 24,
"columnName": "supplierAddressLine1",
"id": 25,
"order": 25
},
{
"action": "rename",
"column": 25,
"columnName": "supplierAddressLine2",
"id": 26,
"order": 26
},
{
"action": "rename",
"column": 26,
"columnName": "supplierCity",
"id": 27,
"order": 27
},
{
"action": "rename",
"column": 27,
"columnName": "supplierState",
"id": 28,
"order": 28
},
{
"action": "rename",
"column": 28,
"columnName": "supplierZip",
"id": 29,
"order": 29
},
{
"action": "rename",
"column": 29,
"columnName": "supplierEmail",
"id": 30,
"order": 30
},
{
"action": "rename",
"column": 30,
"columnName": "reference1",
"id": 31,
"order": 31
},
{
"action": "rename",
"column": 31,
"columnName": "reference2",
"id": 32,
"order": 32
},
{
"action": "rename",
"column": 32,
"columnName": "reference3",
"id": 33,
"order": 33
},
{
"action": "rename",
"column": 33,
"columnName": "reference4",
"id": 34,
"order": 34
},
{
"action": "rename",
"column": 34,
"columnName": "reference5",
"id": 35,
"order": 35
},
{
"action": "rename",
"column": 35,
"columnName": "emailNotes",
"id": 36,
"order": 36
},
{
"action": "addOptionalColumn",
"column": 36,
"columnName": "scheduleDate",
"id": 37,
"order": 37
},
{
"action": "addOptionalColumn",
"column": 37,
"columnName": "udf1",
"id": 38,
"order": 38
},
{
"action": "addOptionalColumn",
"column": 38,
"columnName": "udf2",
"id": 39,
"order": 39
},
{
"action": "addOptionalColumn",
"column": 39,
"columnName": "udf3",
"id": 40,
"order": 40
},
{
"action": "addOptionalColumn",
"column": 40,
"columnName": "udf4",
"id": 41,
"order": 41
},
{
"action": "addOptionalColumn",
"column": 41,
"columnName": "udf5",
"id": 42,
"order": 42
},
{
"action": "addOptionalColumn",
"column": 42,
"columnName": "udf6",
"id": 43,
"order": 43
},
{
"action": "addOptionalColumn",
"column": 43,
"columnName": "udf7",
"id": 44,
"order": 44
},
{
"action": "addOptionalColumn",
"column": 44,
"columnName": "udf8",
"id": 45,
"order": 45
},
{
"action": "addOptionalColumn",
"column": 45,
"columnName": "udf9",
"id": 46,
"order": 46
},
{
"action": "addOptionalColumn",
"column": 46,
"columnName": "udf10",
"id": 47,
"order": 47
},
{
"action": "addOptionalColumn",
"column": 47,
"columnName": "udf11",
"id": 48,
"order": 48
},
{
"action": "addOptionalColumn",
"column": 48,
"columnName": "udf12",
"id": 49,
"order": 49
},
{
"action": "addOptionalColumn",
"column": 49,
"columnName": "udf13",
"id": 50,
"order": 50
},
{
"action": "addOptionalColumn",
"column": 50,
"columnName": "udf14",
"id": 51,
"order": 51
},
{
"action": "addOptionalColumn",
"column": 51,
"columnName": "udf15",
"id": 52,
"order": 52
},
{
"action": "addOptionalColumn",
"column": 52,
"columnName": "udf16",
"id": 53,
"order": 53
},
{
"action": "addOptionalColumn",
"column": 53,
"columnName": "udf17",
"id": 54,
"order": 54
},
{
"action": "addOptionalColumn",
"column": 54,
"columnName": "udf18",
"id": 55,
"order": 55
},
{
"action": "addOptionalColumn",
"column": 55,
"columnName": "udf19",
"id": 56,
"order": 56
},
{
"action": "addOptionalColumn",
"column": 56,
"columnName": "udf20",
"id": 57,
"order": 57
},
{
"action": "addOptionalColumn",
"column": 57,
"columnName": "udf21",
"id": 58,
"order": 58
},
{
"action": "addOptionalColumn",
"column": 58,
"columnName": "udf22",
"id": 59,
"order": 59
},
{
"action": "addOptionalColumn",
"column": 59,
"columnName": "udf23",
"id": 60,
"order": 60
},
{
"action": "addOptionalColumn",
"column": 60,
"columnName": "udf24",
"id": 61,
"order": 61
},
{
"action": "addOptionalColumn",
"column": 61,
"columnName": "udf25",
"id": 62,
"order": 62
},
{
"action": "addOptionalColumn",
"column": 62,
"columnName": "udf26",
"id": 63,
"order": 63
},
{
"action": "addOptionalColumn",
"column": 63,
"columnName": "udf27",
"id": 64,
"order": 64
},
{
"action": "addOptionalColumn",
"column": 64,
"columnName": "udf28",
"id": 65,
"order": 65
},
{
"action": "addOptionalColumn",
"column": 65,
"columnName": "udf29",
"id": 66,
"order": 66
},
{
"action": "addOptionalColumn",
"column": 66,
"columnName": "udf30",
"id": 67,
"order": 67
},
{
"action": "addOptionalColumn",
"column": 67,
"columnName": "udf31",
"id": 68,
"order": 68
},
{
"action": "addOptionalColumn",
"column": 68,
"columnName": "udf32",
"id": 69,
"order": 69
},
{
"action": "addOptionalColumn",
"column": 69,
"columnName": "udf33",
"id": 70,
"order": 70
},
{
"action": "addOptionalColumn",
"column": 70,
"columnName": "udf34",
"id": 71,
"order": 71
},
{
"action": "addOptionalColumn",
"column": 71,
"columnName": "udf35",
"id": 72,
"order": 72
},
{
"action": "addOptionalColumn",
"column": 72,
"columnName": "udf36",
"id": 73,
"order": 73
},
{
"action": "addOptionalColumn",
"column": 73,
"columnName": "udf37",
"id": 74,
"order": 74
},
{
"action": "addOptionalColumn",
"column": 74,
"columnName": "udf38",
"id": 75,
"order": 75
},
{
"action": "addOptionalColumn",
"column": 75,
"columnName": "udf39",
"id": 76,
"order": 76
},
{
"action": "addOptionalColumn",
"column": 76,
"columnName": "udf40",
"id": 77,
"order": 77
},
{
"action": "addOptionalColumn",
"column": 77,
"columnName": "udf41",
"id": 78,
"order": 78
},
{
"action": "addOptionalColumn",
"column": 78,
"columnName": "udf42",
"id": 79,
"order": 79
},
{
"action": "addOptionalColumn",
"column": 79,
"columnName": "udf43",
"id": 80,
"order": 80
},
{
"action": "addOptionalColumn",
"column": 80,
"columnName": "udf44",
"id": 81,
"order": 81
},
{
"action": "addOptionalColumn",
"column": 81,
"columnName": "udf45",
"id": 82,
"order": 82
},
{
"action": "addOptionalColumn",
"column": 82,
"columnName": "udf46",
"id": 83,
"order": 83
},
{
"action": "addOptionalColumn",
"column": 83,
"columnName": "udf47",
"id": 84,
"order": 84
},
{
"action": "addOptionalColumn",
"column": 84,
"columnName": "udf48",
"id": 85,
"order": 85
},
{
"action": "addOptionalColumn",
"column": 85,
"columnName": "udf49",
"id": 86,
"order": 86
},
{
"action": "addOptionalColumn",
"column": 86,
"columnName": "udf50",
"id": 87,
"order": 87
},
{
"action": "dateFormat",
"format": "MMDDYYYY",
"id": 88,
"order": 88
},
{
"action": "fixAmount",
"columnName": "amount",
"id": 89,
"order": 89
},
{
"action": "fixAmount",
"columnName": "invoiceAmounts",
"id": 90,
"order": 90
},
{
"action": "fixAmount",
"columnName": "invoiceTotalDues",
"id": 91,
"order": 91
}
]
},
"duplicateRules": [
{
"fields": [
"transactionId"
],
"id": 1,
"order": 1
}
],
"created": "2023-12-15T09:01:58.741Z",
"creator": {
"id": "e24bda88-d9ed-5730-a311-05488b7d65ed",
"username": "john.doe+critical"
},
"modified": "2023-12-15T09:01:58.741Z",
"modifier": {
"id": "e24bda88-d9ed-5730-a311-05488b7d65ed",
"username": "john.doe+critical"
},
"id": "2df83ed0-bee5-5268-b6d0-5b9675ff81d6"
},
}
Updated 3 days ago