Foxpro / New FreshBooks / 1a. [STRIPE] - Get Publishable Key
Back to Collection Items
LOCAL loHttp
LOCAL lnSuccess
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcId
LOCAL lcAccount_id
LOCAL lnVisa_debit_accepted
LOCAL lnTier_id
LOCAL lcPercent_ach
LOCAL lcPercent_non_amex
LOCAL lcPercent_non_amex_with_card
LOCAL lcPercent_amex
LOCAL lcPercent_amex_with_card
LOCAL lcPercent_virtual_terminal
LOCAL lcAch_tier_1
LOCAL lcAch_tier_2
LOCAL lcAch_tier_3
LOCAL lcPer_transaction_fee
LOCAL lcDefault_pricing_tier_id
LOCAL lcPromo_expiry_date
LOCAL lcMax_ach_fee
LOCAL lnBank_transfer_enabled
LOCAL lnTos_accepted
LOCAL lcState
LOCAL lcV_Email
LOCAL lcTotal_payout
LOCAL lcNext_payout_date
LOCAL lcBank_name
LOCAL lcLast_payment_date
LOCAL lcLast_payment_amount
LOCAL lcWithdrawal_period
LOCAL lcWithdrawal_type
LOCAL lcIncoming_pending_amount
LOCAL lcManage_account_url
LOCAL lcCountry
LOCAL lcStripeId
LOCAL lcGateway_user_id
LOCAL lcUser_state
LOCAL lcStripeEmail
LOCAL lcStripeCountry
LOCAL lcPublishable_key
LOCAL lnStripeBank_transfer_enabled
LOCAL lnStripeMax_ach_fee
LOCAL lcPaypal
LOCAL j
LOCAL lnCount_j
LOCAL lcStrVal
LOCAL i
LOCAL lnCount_i
* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
loHttp = CreateObject('Chilkat_9_5_0.Http')
* Adds the "Authorization: Bearer <access_token>" header.
loHttp.AuthToken = "<access_token>"
loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loHttp.QuickGetSb("https://api.freshbooks.com/payments/account/E86Qp/gateway",loSbResponseBody)
IF (lnSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loSbResponseBody
CANCEL
ENDIF
loJResp = CreateObject('Chilkat_9_5_0.JsonObject')
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = 0
? "Response Body:"
? loJResp.Emit()
lnRespStatusCode = loHttp.LastStatus
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
? "Response Header:"
? loHttp.LastHeader
? "Failed."
RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJResp
CANCEL
ENDIF
* Sample JSON response:
* (Sample code for parsing the JSON response is shown below)
* {
* "gateway_connections": [
* {
* "fbpay": {
* "id": "89dsyfaiosuhlasdjkhcsaldc89879875ih435h",
* "account_id": "45435345345",
* "visa_debit_accepted": true,
* "pricing": {
* "tier_id": 105,
* "percent_ach": "0.00",
* "percent_non_amex": "2.90",
* "percent_non_amex_with_card": "2.70",
* "percent_amex": "3.50",
* "percent_amex_with_card": "3.40",
* "percent_virtual_terminal": "3.50",
* "ach_tier_1": null,
* "ach_tier_2": null,
* "ach_tier_3": null,
* "per_transaction_fee": "0.30",
* "default_pricing_tier_id": null,
* "promo_expiry_date": null,
* "max_ach_fee": null
* },
* "bank_transfer_enabled": false,
* "tos_accepted": true,
* "state": "active",
* "email": "mjohnston@freshbooks.com",
* "bank_info": {
* "total_payout": "0",
* "next_payout_date": null,
* "bank_name": "Gotham Bank XXXXXX2020",
* "last_payment_date": "2020-06-10T22:47:54Z",
* "last_payment_amount": "1240.79",
* "withdrawal_period": "daily",
* "withdrawal_type": "ach",
* "withdrawal_schedule": [
* ],
* "incoming_pending_amount": "0",
* "outgoing_withdrawal_schedule": [
* ]
* },
* "manage_account_url": "https://wepay.com/account/15524535345",
* "currencies": [
* "CAD"
* ],
* "country": "CA",
* "action_reasons": [
* ]
* },
* "stripe": {
* "id": "63kljSDHfglsfjhsf88sdfsd98dsflkjhav",
* "gateway_user_id": "acct_jdhaklsdjnc345",
* "user_state": "registered",
* "email": "mjohnston@freshbooks.com",
* "country": "CA",
* "currencies": [
* "AED",
* "AFN",
* "ALL",
* "AMD",
* "ANG",
* "AOA",
* "ARS",
* "AUD",
* "AWG",
* "AZN",
* "BAM",
* "BBD",
* "BDT",
* "BGN",
* "BIF",
* "BMD",
* "BND",
* "BOB",
* "BRL",
* "BSD",
* "BWP",
* "BZD",
* "CAD",
* "CDF",
* "CHF",
* "CLP",
* "CNY",
* "COP",
* "CRC",
* "CVE",
* "CZK",
* "DJF",
* "DKK",
* "DOP",
* "DZD",
* "EGP",
* "ETB",
* "EUR",
* "FJD",
* "FKP",
* "GBP",
* "GEL",
* "GIP",
* "GMD",
* "GNF",
* "GTQ",
* "GYD",
* "HKD",
* "HNL",
* "HRK",
* "HTG",
* "HUF",
* "IDR",
* "ILS",
* "INR",
* "ISK",
* "JMD",
* "JPY",
* "KES",
* "KGS",
* "KHR",
* "KMF",
* "KRW",
* "KYD",
* "KZT",
* "LAK",
* "LBP",
* "LKR",
* "LRD",
* "LSL",
* "MAD",
* "MDL",
* "MGA",
* "MKD",
* "MMK",
* "MNT",
* "MOP",
* "MRO",
* "MUR",
* "MVR",
* "MWK",
* "MXN",
* "MYR",
* "MZN",
* "NAD",
* "NGN",
* "NIO",
* "NOK",
* "NPR",
* "NZD",
* "PAB",
* "PEN",
* "PGK",
* "PHP",
* "PKR",
* "PLN",
* "PYG",
* "QAR",
* "RON",
* "RSD",
* "RUB",
* "RWF",
* "SAR",
* "SBD",
* "SCR",
* "SEK",
* "SGD",
* "SHP",
* "SLL",
* "SOS",
* "SRD",
* "STD",
* "SZL",
* "THB",
* "TJS",
* "TOP",
* "TRY",
* "TTD",
* "TWD",
* "TZS",
* "UAH",
* "UGX",
* "USD",
* "UYU",
* "UZS",
* "VND",
* "VUV",
* "WST",
* "XAF",
* "XCD",
* "XOF",
* "XPF",
* "YER",
* "ZAR",
* "ZMW"
* ],
* "publishable_key": "pk_live_kha8dfy9oahvoi4h3qpj12qfp0234q9fuqp4938fh34pufh34pf84334f934hfp34uqif43345634oi5y4",
* "bank_transfer_enabled": false,
* "max_ach_fee": 5000
* },
* "paypal": null
* }
* ]
* }
* Sample code for parsing the JSON response...
* Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
i = 0
lnCount_i = loJResp.SizeOfArray("gateway_connections")
DO WHILE i < lnCount_i
loJResp.I = i
lcId = loJResp.StringOf("gateway_connections[i].fbpay.id")
lcAccount_id = loJResp.StringOf("gateway_connections[i].fbpay.account_id")
lnVisa_debit_accepted = loJResp.BoolOf("gateway_connections[i].fbpay.visa_debit_accepted")
lnTier_id = loJResp.IntOf("gateway_connections[i].fbpay.pricing.tier_id")
lcPercent_ach = loJResp.StringOf("gateway_connections[i].fbpay.pricing.percent_ach")
lcPercent_non_amex = loJResp.StringOf("gateway_connections[i].fbpay.pricing.percent_non_amex")
lcPercent_non_amex_with_card = loJResp.StringOf("gateway_connections[i].fbpay.pricing.percent_non_amex_with_card")
lcPercent_amex = loJResp.StringOf("gateway_connections[i].fbpay.pricing.percent_amex")
lcPercent_amex_with_card = loJResp.StringOf("gateway_connections[i].fbpay.pricing.percent_amex_with_card")
lcPercent_virtual_terminal = loJResp.StringOf("gateway_connections[i].fbpay.pricing.percent_virtual_terminal")
lcAch_tier_1 = loJResp.StringOf("gateway_connections[i].fbpay.pricing.ach_tier_1")
lcAch_tier_2 = loJResp.StringOf("gateway_connections[i].fbpay.pricing.ach_tier_2")
lcAch_tier_3 = loJResp.StringOf("gateway_connections[i].fbpay.pricing.ach_tier_3")
lcPer_transaction_fee = loJResp.StringOf("gateway_connections[i].fbpay.pricing.per_transaction_fee")
lcDefault_pricing_tier_id = loJResp.StringOf("gateway_connections[i].fbpay.pricing.default_pricing_tier_id")
lcPromo_expiry_date = loJResp.StringOf("gateway_connections[i].fbpay.pricing.promo_expiry_date")
lcMax_ach_fee = loJResp.StringOf("gateway_connections[i].fbpay.pricing.max_ach_fee")
lnBank_transfer_enabled = loJResp.BoolOf("gateway_connections[i].fbpay.bank_transfer_enabled")
lnTos_accepted = loJResp.BoolOf("gateway_connections[i].fbpay.tos_accepted")
lcState = loJResp.StringOf("gateway_connections[i].fbpay.state")
lcV_Email = loJResp.StringOf("gateway_connections[i].fbpay.email")
lcTotal_payout = loJResp.StringOf("gateway_connections[i].fbpay.bank_info.total_payout")
lcNext_payout_date = loJResp.StringOf("gateway_connections[i].fbpay.bank_info.next_payout_date")
lcBank_name = loJResp.StringOf("gateway_connections[i].fbpay.bank_info.bank_name")
lcLast_payment_date = loJResp.StringOf("gateway_connections[i].fbpay.bank_info.last_payment_date")
lcLast_payment_amount = loJResp.StringOf("gateway_connections[i].fbpay.bank_info.last_payment_amount")
lcWithdrawal_period = loJResp.StringOf("gateway_connections[i].fbpay.bank_info.withdrawal_period")
lcWithdrawal_type = loJResp.StringOf("gateway_connections[i].fbpay.bank_info.withdrawal_type")
lcIncoming_pending_amount = loJResp.StringOf("gateway_connections[i].fbpay.bank_info.incoming_pending_amount")
lcManage_account_url = loJResp.StringOf("gateway_connections[i].fbpay.manage_account_url")
lcCountry = loJResp.StringOf("gateway_connections[i].fbpay.country")
lcStripeId = loJResp.StringOf("gateway_connections[i].stripe.id")
lcGateway_user_id = loJResp.StringOf("gateway_connections[i].stripe.gateway_user_id")
lcUser_state = loJResp.StringOf("gateway_connections[i].stripe.user_state")
lcStripeEmail = loJResp.StringOf("gateway_connections[i].stripe.email")
lcStripeCountry = loJResp.StringOf("gateway_connections[i].stripe.country")
lcPublishable_key = loJResp.StringOf("gateway_connections[i].stripe.publishable_key")
lnStripeBank_transfer_enabled = loJResp.BoolOf("gateway_connections[i].stripe.bank_transfer_enabled")
lnStripeMax_ach_fee = loJResp.IntOf("gateway_connections[i].stripe.max_ach_fee")
lcPaypal = loJResp.StringOf("gateway_connections[i].paypal")
j = 0
lnCount_j = loJResp.SizeOfArray("gateway_connections[i].fbpay.bank_info.withdrawal_schedule")
DO WHILE j < lnCount_j
loJResp.J = j
j = j + 1
ENDDO
j = 0
lnCount_j = loJResp.SizeOfArray("gateway_connections[i].fbpay.bank_info.outgoing_withdrawal_schedule")
DO WHILE j < lnCount_j
loJResp.J = j
j = j + 1
ENDDO
j = 0
lnCount_j = loJResp.SizeOfArray("gateway_connections[i].fbpay.currencies")
DO WHILE j < lnCount_j
loJResp.J = j
lcStrVal = loJResp.StringOf("gateway_connections[i].fbpay.currencies[j]")
j = j + 1
ENDDO
j = 0
lnCount_j = loJResp.SizeOfArray("gateway_connections[i].fbpay.action_reasons")
DO WHILE j < lnCount_j
loJResp.J = j
j = j + 1
ENDDO
j = 0
lnCount_j = loJResp.SizeOfArray("gateway_connections[i].stripe.currencies")
DO WHILE j < lnCount_j
loJResp.J = j
lcStrVal = loJResp.StringOf("gateway_connections[i].stripe.currencies[j]")
j = j + 1
ENDDO
i = i + 1
ENDDO
RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJResp
Curl Command
curl -X GET
-H "Authorization: Bearer <access_token>"
https://api.freshbooks.com/payments/account/E86Qp/gateway
Postman Collection Item JSON
{
"name": "1a. [STRIPE] - Get Publishable Key",
"request": {
"method": "GET",
"header": [
],
"url": {
"raw": "https://api.freshbooks.com/payments/account/E86Qp/gateway",
"protocol": "https",
"host": [
"api",
"freshbooks",
"com"
],
"path": [
"payments",
"account",
"E86Qp",
"gateway"
]
}
},
"response": [
{
"name": "1a. [STRIPE] - Get Publishable Key",
"originalRequest": {
"method": "GET",
"header": [
],
"url": {
"raw": "https://api.freshbooks.com/payments/account/E86Qp/gateway",
"protocol": "https",
"host": [
"api",
"freshbooks",
"com"
],
"path": [
"payments",
"account",
"E86Qp",
"gateway"
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Server",
"value": "nginx"
},
{
"key": "Date",
"value": "Mon, 10 Aug 2020 19:15:46 GMT"
},
{
"key": "Content-Type",
"value": "application/vnd.api+json"
},
{
"key": "Vary",
"value": "Accept-Encoding"
},
{
"key": "X-CardApp-Version",
"value": "2008.16.0"
},
{
"key": "X-NewRelic-App-Data",
"value": "PxQBWV5TCBABV1FUDwYGV1QTGhE1AwE2QgNWEVlbQFtcCxYnRA9QFg1ZWU4FAkpXURQRTEVURAkRQ1VWEUgEA0QHTwNBFkZXQApME1IECQUFQlIWBxpKVkMLFBBUVBVKVB0GHVZfUFYJVwxUDAsGBgpQCFAGTR5TSBRUUAMFCgBSAFMHBFUBAABXFB8EBw8RVT8="
},
{
"key": "X-Frame-Options",
"value": "SAMEORIGIN"
},
{
"key": "X-XSS-Protection",
"value": "1; mode=block"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "Content-Security-Policy",
"value": "default-src 'self'"
},
{
"key": "X-Content-Security-Policy",
"value": "default-src 'self'"
},
{
"key": "Strict-Transport-Security",
"value": "max-age=31556926; includeSubDomains; preload"
},
{
"key": "Referrer-Policy",
"value": "strict-origin-when-cross-origin"
},
{
"key": "X-RateLimit-Limit",
"value": "600"
},
{
"key": "X-RateLimit-Remaining",
"value": "599"
},
{
"key": "X-RateLimit-Reset",
"value": "1597087006"
},
{
"key": "Retry-After",
"value": "59"
},
{
"key": "Access-Control-Allow-Origin",
"value": "*"
},
{
"key": "Content-Encoding",
"value": "gzip"
},
{
"key": "Via",
"value": "1.1 google"
},
{
"key": "Alt-Svc",
"value": "h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
},
{
"key": "Transfer-Encoding",
"value": "chunked"
}
],
"cookie": [
],
"body": "{\n \"gateway_connections\": [\n {\n \"fbpay\": {\n \"id\": \"89dsyfaiosuhlasdjkhcsaldc89879875ih435h\",\n \"account_id\": \"45435345345\",\n \"visa_debit_accepted\": true,\n \"pricing\": {\n \"tier_id\": 105,\n \"percent_ach\": \"0.00\",\n \"percent_non_amex\": \"2.90\",\n \"percent_non_amex_with_card\": \"2.70\",\n \"percent_amex\": \"3.50\",\n \"percent_amex_with_card\": \"3.40\",\n \"percent_virtual_terminal\": \"3.50\",\n \"ach_tier_1\": null,\n \"ach_tier_2\": null,\n \"ach_tier_3\": null,\n \"per_transaction_fee\": \"0.30\",\n \"default_pricing_tier_id\": null,\n \"promo_expiry_date\": null,\n \"max_ach_fee\": null\n },\n \"bank_transfer_enabled\": false,\n \"tos_accepted\": true,\n \"state\": \"active\",\n \"email\": \"mjohnston@freshbooks.com\",\n \"bank_info\": {\n \"total_payout\": \"0\",\n \"next_payout_date\": null,\n \"bank_name\": \"Gotham Bank XXXXXX2020\",\n \"last_payment_date\": \"2020-06-10T22:47:54Z\",\n \"last_payment_amount\": \"1240.79\",\n \"withdrawal_period\": \"daily\",\n \"withdrawal_type\": \"ach\",\n \"withdrawal_schedule\": [],\n \"incoming_pending_amount\": \"0\",\n \"outgoing_withdrawal_schedule\": []\n },\n \"manage_account_url\": \"https://wepay.com/account/15524535345\",\n \"currencies\": [\n \"CAD\"\n ],\n \"country\": \"CA\",\n \"action_reasons\": []\n },\n \"stripe\": {\n \"id\": \"63kljSDHfglsfjhsf88sdfsd98dsflkjhav\",\n \"gateway_user_id\": \"acct_jdhaklsdjnc345\",\n \"user_state\": \"registered\",\n \"email\": \"mjohnston@freshbooks.com\",\n \"country\": \"CA\",\n \"currencies\": [\n \"AED\",\n \"AFN\",\n \"ALL\",\n \"AMD\",\n \"ANG\",\n \"AOA\",\n \"ARS\",\n \"AUD\",\n \"AWG\",\n \"AZN\",\n \"BAM\",\n \"BBD\",\n \"BDT\",\n \"BGN\",\n \"BIF\",\n \"BMD\",\n \"BND\",\n \"BOB\",\n \"BRL\",\n \"BSD\",\n \"BWP\",\n \"BZD\",\n \"CAD\",\n \"CDF\",\n \"CHF\",\n \"CLP\",\n \"CNY\",\n \"COP\",\n \"CRC\",\n \"CVE\",\n \"CZK\",\n \"DJF\",\n \"DKK\",\n \"DOP\",\n \"DZD\",\n \"EGP\",\n \"ETB\",\n \"EUR\",\n \"FJD\",\n \"FKP\",\n \"GBP\",\n \"GEL\",\n \"GIP\",\n \"GMD\",\n \"GNF\",\n \"GTQ\",\n \"GYD\",\n \"HKD\",\n \"HNL\",\n \"HRK\",\n \"HTG\",\n \"HUF\",\n \"IDR\",\n \"ILS\",\n \"INR\",\n \"ISK\",\n \"JMD\",\n \"JPY\",\n \"KES\",\n \"KGS\",\n \"KHR\",\n \"KMF\",\n \"KRW\",\n \"KYD\",\n \"KZT\",\n \"LAK\",\n \"LBP\",\n \"LKR\",\n \"LRD\",\n \"LSL\",\n \"MAD\",\n \"MDL\",\n \"MGA\",\n \"MKD\",\n \"MMK\",\n \"MNT\",\n \"MOP\",\n \"MRO\",\n \"MUR\",\n \"MVR\",\n \"MWK\",\n \"MXN\",\n \"MYR\",\n \"MZN\",\n \"NAD\",\n \"NGN\",\n \"NIO\",\n \"NOK\",\n \"NPR\",\n \"NZD\",\n \"PAB\",\n \"PEN\",\n \"PGK\",\n \"PHP\",\n \"PKR\",\n \"PLN\",\n \"PYG\",\n \"QAR\",\n \"RON\",\n \"RSD\",\n \"RUB\",\n \"RWF\",\n \"SAR\",\n \"SBD\",\n \"SCR\",\n \"SEK\",\n \"SGD\",\n \"SHP\",\n \"SLL\",\n \"SOS\",\n \"SRD\",\n \"STD\",\n \"SZL\",\n \"THB\",\n \"TJS\",\n \"TOP\",\n \"TRY\",\n \"TTD\",\n \"TWD\",\n \"TZS\",\n \"UAH\",\n \"UGX\",\n \"USD\",\n \"UYU\",\n \"UZS\",\n \"VND\",\n \"VUV\",\n \"WST\",\n \"XAF\",\n \"XCD\",\n \"XOF\",\n \"XPF\",\n \"YER\",\n \"ZAR\",\n \"ZMW\"\n ],\n \"publishable_key\": \"pk_live_kha8dfy9oahvoi4h3qpj12qfp0234q9fuqp4938fh34pufh34pf84334f934hfp34uqif43345634oi5y4\",\n \"bank_transfer_enabled\": false,\n \"max_ach_fee\": 5000\n },\n \"paypal\": null\n }\n ]\n}"
}
]
}
