hello,
I have a critical issue about API listpayment.
I figured out this API works if its Virtual Terminal, but if its Point of Sale, the description cannot be retrieved by this API.
This is very critical because we will use this field to do some logics in our ERP system.
Thanks,
Jestin
Are you referring to the note associated to the payment? Do you have an example payment you’re not getting the information you want from the Payments API? 
Yes, I have. How can I upload the attachment to here.
please see this I copied from the API response.
there are two payments I copied, one is for point of sale, another is for VIRTUAL_TERMINAL.
only VIRTUAL_TERMINAL has the note, and point of sales has no note field.
“payments”: [
{
“id”: “L3VeKPohUH3w33oxOTCoIrEyeF7YY”,
“created_at”: “2022-02-28T20:09:53.771Z”,
“updated_at”: “2022-02-28T20:09:58.097Z”,
“amount_money”: {
“amount”: 192327,
“currency”: “CAD”
},
“status”: “COMPLETED”,
“statement_description”: “SQ *HOULE VICTORIA”,
“card_payment_timeline”: {
“authorized_at”: “2022-02-28T20:09:54.133Z”,
“captured_at”: “2022-02-28T20:09:54.341Z”
}
},
“location_id”: “0VQSD7TJ0GJ5W”,
“note”: “1010147-5002-19735 KG”,
“total_money”: {
“amount”: 192327,
“currency”: “CAD”
},
“approved_money”: {
“amount”: 192327,
“currency”: “CAD”
},
“receipt_number”: “L3Ve”,
“delayed_until”: “2022-03-07T20:09:53.771Z”,
“application_details”: {
“square_product”: “VIRTUAL_TERMINAL”,
“application_id”: “sq0idp-4Uw2-7Sy15Umdnct7FTeuQ”
}
},
{
“id”: “rJGO6nReGS0YMsvfvrGuigdrvaB”,
“created_at”: “2022-02-28T18:06:17.049Z”,
“updated_at”: “2022-02-28T18:06:23.336Z”,
“amount_money”: {
“amount”: 51550,
“currency”: “CAD”
},
“status”: “COMPLETED”,
“source_type”: “CARD”,
},
“location_id”: “0VQSD7TJ0GJ5W”,
“order_id”: “3HHgyz31K0FnyptsxMjddaneV”,
“processing_fee”: [
{
“effective_at”: “2022-02-28T20:06:22.000Z”,
“type”: “INITIAL”,
“amount_money”: {
“amount”: 1366,
“currency”: “CAD”
}
}
],
“total_money”: {
“amount”: 51550,
“currency”: “CAD”
},
“approved_money”: {
“amount”: 51550,
“currency”: “CAD”
},
“employee_id”: “TMIdkuVpXVCYcRG1”,
“receipt_number”: “rJGO”,
“application_details”: {
“square_product”: “SQUARE_POS”
},
},please see this I copied from the API response.
there are two payments I copied, one is for point of sale, another is for VIRTUAL_TERMINAL.
only VIRTUAL_TERMINAL has the note, and point of sales has no note field.
“payments”: [
{
“id”: “L3VeKPohUH3w33oxOTCoIrEyeF7YY”,
“created_at”: “2022-02-28T20:09:53.771Z”,
“updated_at”: “2022-02-28T20:09:58.097Z”,
“amount_money”: {
“amount”: 192327,
“currency”: “CAD”
},
“status”: “COMPLETED”,
“statement_description”: “SQ *HOULE VICTORIA”,
“card_payment_timeline”: {
“authorized_at”: “2022-02-28T20:09:54.133Z”,
“captured_at”: “2022-02-28T20:09:54.341Z”
}
},
“location_id”: “0VQSD7TJ0GJ5W”,
“note”: “1010147-5002-19735 KG”,
“total_money”: {
“amount”: 192327,
“currency”: “CAD”
},
“approved_money”: {
“amount”: 192327,
“currency”: “CAD”
},
“receipt_number”: “L3Ve”,
“delayed_until”: “2022-03-07T20:09:53.771Z”,
“application_details”: {
“square_product”: “VIRTUAL_TERMINAL”,
“application_id”: “sq0idp-4Uw2-7Sy15Umdnct7FTeuQ”
}
},
{
“id”: “rJGO6nReGS0YMsvfvrGuigdrvaB”,
“created_at”: “2022-02-28T18:06:17.049Z”,
“updated_at”: “2022-02-28T18:06:23.336Z”,
“amount_money”: {
“amount”: 51550,
“currency”: “CAD”
},
“status”: “COMPLETED”,
“source_type”: “CARD”,
},
“location_id”: “0VQSD7TJ0GJ5W”,
“order_id”: “3HHgyz31K0FnyptsxMjddaneV”,
“processing_fee”: [
{
“effective_at”: “2022-02-28T20:06:22.000Z”,
“type”: “INITIAL”,
“amount_money”: {
“amount”: 1366,
“currency”: “CAD”
}
}
],
“total_money”: {
“amount”: 51550,
“currency”: “CAD”
},
“approved_money”: {
“amount”: 51550,
“currency”: “CAD”
},
“employee_id”: “TMIdkuVpXVCYcRG1”,
“receipt_number”: “rJGO”,
“application_details”: {
“square_product”: “SQUARE_POS”
},
},Are you able to past the body in the in a reply using the
in the above menu.
Hi Bryan,
{
"payments": [
{
"id": "L3VeKPohUH3w33oxOTCoIrEyeF7YY",
"created_at": "2022-02-28T20:09:53.771Z",
"updated_at": "2022-02-28T20:09:58.097Z",
"amount_money": {
"amount": 192327,
"currency": "CAD"
},
"status": "COMPLETED",
"delay_duration": "PT168H",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "VISA",
"last_4": "7828",
"exp_month": 2,
"exp_year": 2023,
"fingerprint": "sq-1-gJGUjvJ9aqWajZe6j27iYO9DHklAhiknzctna8oOIdn3yO0IZVei-fQaWRZ1I-pdcA",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "452088"
},
"entry_method": "KEYED",
"cvv_status": "CVV_ACCEPTED",
"avs_status": "AVS_REJECTED",
"auth_result_code": "08622I",
"statement_description": "SQ *HOULE VICTORIA",
"card_payment_timeline": {
"authorized_at": "2022-02-28T20:09:54.133Z",
"captured_at": "2022-02-28T20:09:54.341Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "UWJqbfYYoBQIKW8GySCWW3GJLVDZY",
"processing_fee": [
{
"effective_at": "2022-02-28T22:09:56.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 6554,
"currency": "CAD"
}
}
],
"note": "1010147-5002-19735 KG",
"total_money": {
"amount": 192327,
"currency": "CAD"
},
"approved_money": {
"amount": 192327,
"currency": "CAD"
},
"employee_id": "M9U0d29c7X-LLFWOyqDM",
"receipt_number": "L3Ve",
"receipt_url": "https://squareup.com/receipt/preview/L3VeKPohUH3w33oxOTCoIrEyeF7YY",
"delay_action": "CANCEL",
"delayed_until": "2022-03-07T20:09:53.771Z",
"team_member_id": "M9U0d29c7X-LLFWOyqDM",
"application_details": {
"square_product": "VIRTUAL_TERMINAL",
"application_id": "sq0idp-4Uw2-7Sy15Umdnct7FTeuQ"
},
"version_token": "vL0EWZ1lntYr8npBn2ui5NR4UEuFYP4wAX8j36IudLV6o"
},
{
"id": "rJGO6nReGS0YMsvfvrGuigdrvaB",
"created_at": "2022-02-28T18:06:17.049Z",
"updated_at": "2022-02-28T18:06:23.336Z",
"amount_money": {
"amount": 51550,
"currency": "CAD"
},
"status": "COMPLETED",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "MASTERCARD",
"last_4": "1973",
"exp_month": 4,
"exp_year": 2024,
"cardholder_name": "GREEN/SHARON ",
"fingerprint": "sq-1-rghVWf2vIp42RksdfFrGfeS18X2aIyNrd5AwsoWVLnr016iQgAjYEFIsEGQNeam_CA",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "516075"
},
"entry_method": "EMV",
"cvv_status": "CVV_NOT_CHECKED",
"avs_status": "AVS_NOT_CHECKED",
"auth_result_code": "08526Z",
"application_identifier": "A0000000041010",
"application_name": "CAPITAL ONE",
"application_cryptogram": "1ad762965b64c3e8",
"verification_method": "PIN",
"verification_results": "SUCCESS",
"statement_description": "SQ *HOULE VICTORIA",
"device_details": {
"device_id": "359118080172734",
"device_name": "",
"device_installation_id": "7c52ba89-0105-4d03-b07f-a407a0e4f3bf"
},
"card_payment_timeline": {
"authorized_at": "2022-02-28T18:06:17.524Z",
"captured_at": "2022-02-28T18:06:22.098Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "3HHgyz31K0FnyptsxMjddaneV",
"processing_fee": [
{
"effective_at": "2022-02-28T20:06:22.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 1366,
"currency": "CAD"
}
}
],
"total_money": {
"amount": 51550,
"currency": "CAD"
},
"approved_money": {
"amount": 51550,
"currency": "CAD"
},
"employee_id": "TMIdkuVpXVCYcRG1",
"receipt_number": "rJGO",
"receipt_url": "https://squareup.com/receipt/preview/rJGO6nReGS0YMsvfvrGuigdrvaB",
"device_details": {
"device_id": "359118080172734",
"device_name": "",
"device_installation_id": "7c52ba89-0105-4d03-b07f-a407a0e4f3bf"
},
"team_member_id": "TMIdkuVpXVCYcRG1",
"application_details": {
"square_product": "SQUARE_POS"
},
"version_token": "M9tcaeExdGkduMJWOUDXCuia1NABFQUQCTrugv3GXkL6o"
},
{
"id": "nXQBx6P3XuwwEDT82whQ24UuuaB",
"created_at": "2022-02-28T17:15:34.926Z",
"updated_at": "2022-02-28T17:15:40.264Z",
"amount_money": {
"amount": 17740,
"currency": "CAD"
},
"status": "COMPLETED",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "VISA",
"last_4": "7142",
"exp_month": 6,
"exp_year": 2022,
"cardholder_name": "LITTLE/TREVOR R ",
"fingerprint": "sq-1-8u_EmAG-ZW_sJtZAb9AEchoRItPh0CWQVg9Fap5oaJLS0NbfWWoFmBbg2hgVEp66Uw",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "478901"
},
"entry_method": "EMV",
"cvv_status": "CVV_NOT_CHECKED",
"avs_status": "AVS_NOT_CHECKED",
"auth_result_code": "06054F",
"application_identifier": "A0000000031010",
"application_name": "VISA CREDIT",
"application_cryptogram": "784cc736432f1805",
"verification_method": "PIN",
"verification_results": "SUCCESS",
"statement_description": "SQ *HOULE VICTORIA",
"device_details": {
"device_id": "354818092483103",
"device_name": "",
"device_installation_id": "574ae8e1-454c-452e-8c2b-bf39dab91a18"
},
"card_payment_timeline": {
"authorized_at": "2022-02-28T17:15:35.121Z",
"captured_at": "2022-02-28T17:15:39.176Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "1wMM6cnt90OQoXITsCi3vateV",
"processing_fee": [
{
"effective_at": "2022-02-28T19:15:39.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 470,
"currency": "CAD"
}
}
],
"total_money": {
"amount": 17740,
"currency": "CAD"
},
"approved_money": {
"amount": 17740,
"currency": "CAD"
},
"employee_id": "ifvyMCBP_ukgiiZ-hOBZ",
"receipt_number": "nXQB",
"receipt_url": "https://squareup.com/receipt/preview/nXQBx6P3XuwwEDT82whQ24UuuaB",
"device_details": {
"device_id": "354818092483103",
"device_name": "",
"device_installation_id": "574ae8e1-454c-452e-8c2b-bf39dab91a18"
},
"team_member_id": "ifvyMCBP_ukgiiZ-hOBZ",
"application_details": {
"square_product": "SQUARE_POS"
},
"version_token": "c7ZFH3BYJcwqTM50c0hlaX1Cnu6EXeUQeD60IhLM4QV6o"
},
{
"id": "fJDBXqoBcSSAOn742VVDveD1uaB",
"created_at": "2022-02-28T16:34:43.305Z",
"updated_at": "2022-02-28T16:34:49.259Z",
"amount_money": {
"amount": 11860,
"currency": "CAD"
},
"status": "COMPLETED",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "MASTERCARD",
"last_4": "2232",
"exp_month": 2,
"exp_year": 2026,
"fingerprint": "sq-1-BgOvI5OZVRvBEnY_TZCaFuekuPmOo1itTW6DzIopLjHnQxtcopL131m3MsBSakvzJg",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "552489"
},
"entry_method": "CONTACTLESS",
"cvv_status": "CVV_NOT_CHECKED",
"avs_status": "AVS_NOT_CHECKED",
"auth_result_code": "03314J",
"application_identifier": "A0000000041010",
"application_name": "Mastercard",
"application_cryptogram": "da7c479e79edfec3",
"verification_method": "NONE",
"verification_results": "SUCCESS",
"statement_description": "SQ *HOULE VICTORIA",
"device_details": {
"device_id": "359118080172734",
"device_name": "",
"device_installation_id": "7c52ba89-0105-4d03-b07f-a407a0e4f3bf"
},
"card_payment_timeline": {
"authorized_at": "2022-02-28T16:34:43.783Z",
"captured_at": "2022-02-28T16:34:47.234Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "rtXHLjgpb075BklL4oftNHueV",
"processing_fee": [
{
"effective_at": "2022-02-28T18:34:47.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 314,
"currency": "CAD"
}
}
],
"total_money": {
"amount": 11860,
"currency": "CAD"
},
"approved_money": {
"amount": 11860,
"currency": "CAD"
},
"employee_id": "TMIdkuVpXVCYcRG1",
"receipt_number": "fJDB",
"receipt_url": "https://squareup.com/receipt/preview/fJDBXqoBcSSAOn742VVDveD1uaB",
"device_details": {
"device_id": "359118080172734",
"device_name": "",
"device_installation_id": "7c52ba89-0105-4d03-b07f-a407a0e4f3bf"
},
"team_member_id": "TMIdkuVpXVCYcRG1",
"application_details": {
"square_product": "SQUARE_POS"
},
"version_token": "biWKWKIt61CAcHciTM48uGz665O4z54zzLJSz9RG2mW6o"
},
{
"id": "RCz5r8bboCybr0tndECglT7TuaB",
"created_at": "2022-02-27T19:04:12.249Z",
"updated_at": "2022-02-27T19:04:17.870Z",
"amount_money": {
"amount": 42730,
"currency": "CAD"
},
"status": "COMPLETED",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "MASTERCARD",
"last_4": "0031",
"exp_month": 8,
"exp_year": 2025,
"fingerprint": "sq-1-ODSi4zLzuQiYA66WHGuYTEE6UijZWkpNFwx-sAhrZMVdnL6RI720S6QWt1HkwOSCnQ",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "519123"
},
"entry_method": "KEYED",
"cvv_status": "CVV_ACCEPTED",
"avs_status": "AVS_NOT_CHECKED",
"auth_result_code": "02382Z",
"statement_description": "SQ *HOULE VICTORIA",
"device_details": {
"device_id": "DEVICE_INSTALLATION_ID:4232e411-bdf2-4c05-a591-72f5b0f1fdf8",
"device_name": "",
"device_installation_id": "4232e411-bdf2-4c05-a591-72f5b0f1fdf8"
},
"card_payment_timeline": {
"authorized_at": "2022-02-27T19:04:12.728Z",
"captured_at": "2022-02-27T19:04:15.109Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "d6Xgy3dswmgSRvOVKtLsYH9eV",
"processing_fee": [
{
"effective_at": "2022-02-27T21:04:15.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 1468,
"currency": "CAD"
}
}
],
"total_money": {
"amount": 42730,
"currency": "CAD"
},
"approved_money": {
"amount": 42730,
"currency": "CAD"
},
"employee_id": "dYYf4eELAkODkRSOH9tj",
"receipt_number": "RCz5",
"receipt_url": "https://squareup.com/receipt/preview/RCz5r8bboCybr0tndECglT7TuaB",
"device_details": {
"device_id": "DEVICE_INSTALLATION_ID:4232e411-bdf2-4c05-a591-72f5b0f1fdf8",
"device_name": "",
"device_installation_id": "4232e411-bdf2-4c05-a591-72f5b0f1fdf8"
},
"team_member_id": "dYYf4eELAkODkRSOH9tj",
"application_details": {
"square_product": "SQUARE_POS"
},
"version_token": "BaiUw5zJl4GIUubOzZNsx97OF24pfXRm5foHee04TQO6o"
},
{
"id": "zx2Bm89EsfiiYCHnHDGdU04ZuaB",
"created_at": "2022-02-25T22:47:13.792Z",
"updated_at": "2022-02-25T22:47:19.471Z",
"amount_money": {
"amount": 22153,
"currency": "CAD"
},
"status": "COMPLETED",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "AMERICAN_EXPRESS",
"last_4": "9012",
"exp_month": 9,
"exp_year": 2023,
"cardholder_name": " ",
"fingerprint": "sq-1-BbbsRWCw3fz3l_BxANuP--fbBuc6Hw3EyB7YM9J5R9vdpvCCH0T3gIm8uCbvX4RvJw",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "379241"
},
"entry_method": "CONTACTLESS",
"cvv_status": "CVV_NOT_CHECKED",
"avs_status": "AVS_NOT_CHECKED",
"auth_result_code": "483166",
"application_identifier": "A000000025010402",
"application_name": "SCOTIABANK AMEX",
"application_cryptogram": "81d52fbc9a7a4ddf",
"verification_method": "NONE",
"verification_results": "SUCCESS",
"statement_description": "HOULE VICTORIA",
"device_details": {
"device_id": "359118080172734",
"device_name": "",
"device_installation_id": "7c52ba89-0105-4d03-b07f-a407a0e4f3bf"
},
"card_payment_timeline": {
"authorized_at": "2022-02-25T22:47:14.199Z",
"captured_at": "2022-02-25T22:47:18.396Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "Hz94DKiKdBW5g5aaZInVgL5eV",
"processing_fee": [
{
"effective_at": "2022-02-26T00:47:18.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 587,
"currency": "CAD"
}
}
],
"total_money": {
"amount": 22153,
"currency": "CAD"
},
"approved_money": {
"amount": 22153,
"currency": "CAD"
},
"employee_id": "TMIdkuVpXVCYcRG1",
"receipt_number": "zx2B",
"receipt_url": "https://squareup.com/receipt/preview/zx2Bm89EsfiiYCHnHDGdU04ZuaB",
"device_details": {
"device_id": "359118080172734",
"device_name": "",
"device_installation_id": "7c52ba89-0105-4d03-b07f-a407a0e4f3bf"
},
"team_member_id": "TMIdkuVpXVCYcRG1",
"application_details": {
"square_product": "SQUARE_POS"
},
"version_token": "s6sERYP7G7kv2Xsm5CNEXdymKUix1h7ZTwVq9jUKXux6o"
},
{
"id": "pOx8zVI841RKDxOleucbg4SjlyKZY",
"created_at": "2022-02-25T21:48:26.133Z",
"updated_at": "2022-02-25T21:48:29.140Z",
"amount_money": {
"amount": 32746,
"currency": "CAD"
},
"status": "COMPLETED",
"delay_duration": "PT168H",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "MASTERCARD",
"last_4": "8882",
"exp_month": 1,
"exp_year": 2026,
"fingerprint": "sq-1-a1ZpiRh4Qag-w6FefsBmtRDnCHr5wEMzhcY6N8kUogQ5Z-rligT9qdM295Wre6SBsQ",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "544614"
},
"entry_method": "KEYED",
"cvv_status": "CVV_ACCEPTED",
"avs_status": "AVS_ACCEPTED",
"auth_result_code": "04800J",
"statement_description": "SQ *HOULE VICTORIA",
"card_payment_timeline": {
"authorized_at": "2022-02-25T21:48:26.641Z",
"captured_at": "2022-02-25T21:48:26.838Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "CVVyXOsVwPVk7IAAD6dFNJgXaE6YY",
"processing_fee": [
{
"effective_at": "2022-02-25T23:48:27.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 1128,
"currency": "CAD"
}
}
],
"note": "Inv#46212#SO#26407#",
"total_money": {
"amount": 32746,
"currency": "CAD"
},
"approved_money": {
"amount": 32746,
"currency": "CAD"
},
"employee_id": "EzZswNIWbXZUQzyeiAWR",
"receipt_number": "pOx8",
"receipt_url": "https://squareup.com/receipt/preview/pOx8zVI841RKDxOleucbg4SjlyKZY",
"delay_action": "CANCEL",
"delayed_until": "2022-03-04T21:48:26.133Z",
"team_member_id": "EzZswNIWbXZUQzyeiAWR",
"application_details": {
"square_product": "VIRTUAL_TERMINAL",
"application_id": "sq0idp-4Uw2-7Sy15Umdnct7FTeuQ"
},
"version_token": "uibmjV77WRYAiMDJBt7SxPnUrYIqQaNYjn0EKH7uIU06o"
},
{
"id": "frsn0UZKPQZwnosQGmdHrX2kuaB",
"created_at": "2022-02-25T21:48:18.487Z",
"updated_at": "2022-02-25T21:48:23.335Z",
"amount_money": {
"amount": 32676,
"currency": "CAD"
},
"status": "COMPLETED",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "VISA",
"last_4": "2980",
"exp_month": 5,
"exp_year": 2024,
"cardholder_name": "JAN/BRIAN ",
"fingerprint": "sq-1-Phf387LaYI5qDwtk_aUsRLsEmh3cusgn56_eYBosrq2ZdZ8frF8kTo5aKFUy_r5GVg",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "452088"
},
"entry_method": "EMV",
"cvv_status": "CVV_NOT_CHECKED",
"avs_status": "AVS_NOT_CHECKED",
"auth_result_code": "04562I",
"application_identifier": "A0000000031010",
"application_name": "VISA CREDIT",
"application_cryptogram": "86ce90dc0f882209",
"verification_method": "PIN",
"verification_results": "SUCCESS",
"statement_description": "SQ *HOULE VICTORIA",
"device_details": {
"device_id": "DEVICE_INSTALLATION_ID:84c36d8b-a22d-4b9b-a111-466ceffdb3a3",
"device_name": "",
"device_installation_id": "84c36d8b-a22d-4b9b-a111-466ceffdb3a3"
},
"card_payment_timeline": {
"authorized_at": "2022-02-25T21:48:18.786Z",
"captured_at": "2022-02-25T21:48:22.059Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "Vcq0Kg0ZPefIqTUmXvrwAopeV",
"processing_fee": [
{
"effective_at": "2022-02-25T23:48:22.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 866,
"currency": "CAD"
}
}
],
"total_money": {
"amount": 32676,
"currency": "CAD"
},
"approved_money": {
"amount": 32676,
"currency": "CAD"
},
"employee_id": "g9O3txuMKxnXDRixCn70",
"receipt_number": "frsn",
"receipt_url": "https://squareup.com/receipt/preview/frsn0UZKPQZwnosQGmdHrX2kuaB",
"device_details": {
"device_id": "DEVICE_INSTALLATION_ID:84c36d8b-a22d-4b9b-a111-466ceffdb3a3",
"device_name": "",
"device_installation_id": "84c36d8b-a22d-4b9b-a111-466ceffdb3a3"
},
"team_member_id": "g9O3txuMKxnXDRixCn70",
"application_details": {
"square_product": "SQUARE_POS"
},
"version_token": "YsXn0w5mZ9OiaylzrsrNZTh5JpOQphZyriyxdJkivfL6o"
},
{
"id": "XFLVVxEisiBglN0zXPvddjNBvaB",
"created_at": "2022-02-25T20:16:38.690Z",
"updated_at": "2022-02-25T20:16:43.753Z",
"amount_money": {
"amount": 35590,
"currency": "CAD"
},
"status": "COMPLETED",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "VISA",
"last_4": "4761",
"exp_month": 10,
"exp_year": 2024,
"cardholder_name": "VOWLES/W ",
"fingerprint": "sq-1-r6Rlv0mH_WCo-tW2ftYgY4Qr--WgQZHfHrsjko3ys-Ia8uMSs7LyfAuNnhWM6MaZcw",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "451401"
},
"entry_method": "EMV",
"cvv_status": "CVV_NOT_CHECKED",
"avs_status": "AVS_NOT_CHECKED",
"auth_result_code": "091665",
"application_identifier": "A0000000031010",
"application_name": "VISA CREDIT",
"application_cryptogram": "748309323c5fc12e",
"verification_method": "PIN",
"verification_results": "SUCCESS",
"statement_description": "SQ *HOULE VICTORIA",
"device_details": {
"device_id": "354818092483103",
"device_name": "",
"device_installation_id": "574ae8e1-454c-452e-8c2b-bf39dab91a18"
},
"card_payment_timeline": {
"authorized_at": "2022-02-25T20:16:38.867Z",
"captured_at": "2022-02-25T20:16:42.856Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "d4GMMX95Y8dzAxwX8zXlUweeV",
"processing_fee": [
{
"effective_at": "2022-02-25T22:16:42.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 943,
"currency": "CAD"
}
}
],
"total_money": {
"amount": 35590,
"currency": "CAD"
},
"approved_money": {
"amount": 35590,
"currency": "CAD"
},
"employee_id": "ifvyMCBP_ukgiiZ-hOBZ",
"receipt_number": "XFLV",
"receipt_url": "https://squareup.com/receipt/preview/XFLVVxEisiBglN0zXPvddjNBvaB",
"device_details": {
"device_id": "354818092483103",
"device_name": "",
"device_installation_id": "574ae8e1-454c-452e-8c2b-bf39dab91a18"
},
"team_member_id": "ifvyMCBP_ukgiiZ-hOBZ",
"application_details": {
"square_product": "SQUARE_POS"
},
"version_token": "PCt0xPLzlVxKlVXpLoz8pQWGznyHN4WUhbcfWEZ5FiE6o"
},
{
"id": "rhqa86wzTrovCBxrKlIvcONxvaB",
"created_at": "2022-02-24T21:03:41.116Z",
"updated_at": "2022-02-24T21:03:47.382Z",
"amount_money": {
"amount": 18666,
"currency": "CAD"
},
"status": "COMPLETED",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "VISA",
"last_4": "9521",
"exp_month": 4,
"exp_year": 2023,
"cardholder_name": " /",
"fingerprint": "sq-1-SU8hVG449iQEbSDte-EH3KHzHbq8tJuFWLxX6kil_R_SClxmVFLtoh7L8AFXeNAk8w",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "450003"
},
"entry_method": "CONTACTLESS",
"cvv_status": "CVV_NOT_CHECKED",
"avs_status": "AVS_NOT_CHECKED",
"auth_result_code": "00239I",
"application_identifier": "A0000000031010",
"application_name": "Visa Credit",
"application_cryptogram": "5809a80890503dd9",
"verification_method": "NONE",
"verification_results": "UNKNOWN",
"statement_description": "SQ *HOULE VICTORIA",
"device_details": {
"device_id": "DEVICE_INSTALLATION_ID:84c36d8b-a22d-4b9b-a111-466ceffdb3a3",
"device_name": "",
"device_installation_id": "84c36d8b-a22d-4b9b-a111-466ceffdb3a3"
},
"card_payment_timeline": {
"authorized_at": "2022-02-24T21:03:41.336Z",
"captured_at": "2022-02-24T21:03:44.940Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "1uXukEehEvIPB02QJumgJI6eV",
"processing_fee": [
{
"effective_at": "2022-02-24T23:03:44.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 495,
"currency": "CAD"
}
}
],
"total_money": {
"amount": 18666,
"currency": "CAD"
},
"approved_money": {
"amount": 18666,
"currency": "CAD"
},
"employee_id": "g9O3txuMKxnXDRixCn70",
"receipt_number": "rhqa",
"receipt_url": "https://squareup.com/receipt/preview/rhqa86wzTrovCBxrKlIvcONxvaB",
"device_details": {
"device_id": "DEVICE_INSTALLATION_ID:84c36d8b-a22d-4b9b-a111-466ceffdb3a3",
"device_name": "",
"device_installation_id": "84c36d8b-a22d-4b9b-a111-466ceffdb3a3"
},
"team_member_id": "g9O3txuMKxnXDRixCn70",
"application_details": {
"square_product": "SQUARE_POS"
},
"version_token": "whhy1XUYA9WaakcjA2N5DhnNwWFI7oQi0NavB0yc8ay6o"
},
{
"id": "tsDgklQ94ni7dsl11mEuUretWWIZY",
"created_at": "2022-02-23T22:39:37.881Z",
"updated_at": "2022-02-23T22:39:40.918Z",
"amount_money": {
"amount": 482475,
"currency": "CAD"
},
"status": "COMPLETED",
"delay_duration": "PT168H",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "VISA",
"last_4": "0445",
"exp_month": 8,
"exp_year": 2023,
"fingerprint": "sq-1--LfWq50OlpwSfupsABjnP2M5OICyX4wFQCdvZJG23xh2cdL4GBh6lsukHLfJrFM7QQ",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "450003"
},
"entry_method": "KEYED",
"cvv_status": "CVV_ACCEPTED",
"avs_status": "AVS_ACCEPTED",
"auth_result_code": "08144I",
"statement_description": "SQ *HOULE VICTORIA",
"card_payment_timeline": {
"authorized_at": "2022-02-23T22:39:38.149Z",
"captured_at": "2022-02-23T22:39:38.549Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "u1iWz4c2GUQIGewVWzgXClGi02JZY",
"processing_fee": [
{
"effective_at": "2022-02-24T00:39:39.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 16419,
"currency": "CAD"
}
}
],
"note": "5002 27687 (RS)",
"total_money": {
"amount": 482475,
"currency": "CAD"
},
"approved_money": {
"amount": 482475,
"currency": "CAD"
},
"employee_id": "DUvbcMN12I67ThdY7ZCP",
"receipt_number": "tsDg",
"receipt_url": "https://squareup.com/receipt/preview/tsDgklQ94ni7dsl11mEuUretWWIZY",
"delay_action": "CANCEL",
"delayed_until": "2022-03-02T22:39:37.881Z",
"team_member_id": "DUvbcMN12I67ThdY7ZCP",
"application_details": {
"square_product": "VIRTUAL_TERMINAL",
"application_id": "sq0idp-4Uw2-7Sy15Umdnct7FTeuQ"
},
"version_token": "2uiXPXxNY773yXY1y4QYIQHIvj8aDvaGJ5mcx8JLZ7Q6o"
},
{
"id": "b3JKwMdoleOE7ovwQwV4znXDmyYZY",
"created_at": "2022-02-23T17:29:24.894Z",
"updated_at": "2022-02-23T17:29:27.472Z",
"amount_money": {
"amount": 12167,
"currency": "CAD"
},
"status": "COMPLETED",
"delay_duration": "PT168H",
"source_type": "CARD",
"card_details": {
"status": "CAPTURED",
"card": {
"card_brand": "VISA",
"last_4": "3811",
"exp_month": 10,
"exp_year": 2022,
"fingerprint": "sq-1-u_6079VifYwK3B-NChj7MfbjL0F8MeTohT4JQduZ6jBg-6tILYBziqaDThSzPsQXtA",
"card_type": "CREDIT",
"prepaid_type": "NOT_PREPAID",
"bin": "452088"
},
"entry_method": "KEYED",
"cvv_status": "CVV_ACCEPTED",
"avs_status": "AVS_ACCEPTED",
"auth_result_code": "07752I",
"statement_description": "SQ *HOULE VICTORIA",
"card_payment_timeline": {
"authorized_at": "2022-02-23T17:29:25.062Z",
"captured_at": "2022-02-23T17:29:25.321Z"
}
},
"location_id": "0VQSD7TJ0GJ5W",
"order_id": "Gt82SOYDtfo25dl9udECkHHcD47YY",
"processing_fee": [
{
"effective_at": "2022-02-23T19:29:26.000Z",
"type": "INITIAL",
"amount_money": {
"amount": 429,
"currency": "CAD"
}
}
],
"note": "Cust ID#1010147 5002-29510 MR",
"total_money": {
"amount": 12167,
"currency": "CAD"
},
"approved_money": {
"amount": 12167,
"currency": "CAD"
},
"employee_id": "EzZswNIWbXZUQzyeiAWR",
"receipt_number": "b3JK",
"receipt_url": "https://squareup.com/receipt/preview/b3JKwMdoleOE7ovwQwV4znXDmyYZY",
"delay_action": "CANCEL",
"delayed_until": "2022-03-02T17:29:24.894Z",
"team_member_id": "EzZswNIWbXZUQzyeiAWR",
"application_details": {
"square_product": "VIRTUAL_TERMINAL",
"application_id": "sq0idp-4Uw2-7Sy15Umdnct7FTeuQ"
},
"version_token": "tLVVvfr1RNnodkYRUMFl4tGOjqM3AzVdag9QNkPMv5x6o"
}
]
}
please see this attachment.
What’s the field that’s missing? Is it the notes? The Payments API doesn’t return a description field so I need to know what field your not seeing in the response.
yes, the “note”.
payments for point of sales have no note field sent out, while payments for Virtual Terminal have this field.
Great, thanks for the clarification. Like you mentioned there is a note on Virtual Terminal and there payment_ids are:
L3VeKPohUH3w33oxOTCoIrEyeF7YY,
pOx8zVI841RKDxOleucbg4SjlyKZY,
tsDgklQ94ni7dsl11mEuUretWWIZY,
b3JKwMdoleOE7ovwQwV4znXDmyYZY
This is because the note that you added to the payment is scoped to the entire payment which is why it’s included in the ListPayment call.
The other payments that you provided have the note but it’s scoped to the item level. Since it’s at the item level you’ll need to use the Orders API and call RetrieveOrder to get the note that’s stored at the item level. Here are the payments with the note at the item level:
zx2Bm89EsfiiYCHnHDGdU04ZuaB,
frsn0UZKPQZwnosQGmdHrX2kuaB,
XFLVVxEisiBglN0zXPvddjNBvaB,
rhqa86wzTrovCBxrKlIvcONxvaB
Lastly, this payment RCz5r8bboCybr0tndECglT7TuaB doesn’t have a note on the payment level nor on the item level.
Hi Bryan,
Thanks, this means we have to call different API twice to download all this information.
Is there any way to call API once to grab all?
Thanks,
Yes, you can use SearchOrders to get all the orders which will have the note for every level they are stored at.
Thanks a lot, Bryan,
its good to us now, I will close this ticket.
how to close this ticket?