Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
EXEC sp_OASetProperty @http, 'BasicAuth', 1
EXEC sp_OASetProperty @http, 'Login', '{{secretId}}'
EXEC sp_OASetProperty @http, 'Password', '{{secretPassword}}'
-- Use this online tool to generate code from sample JSON: Generate Code to Create JSON
-- The following JSON is sent in the request body.
-- {
-- "date_from": "2020-08-05",
-- "date_to": "2020-10-05",
-- "link": "2ccd5e15-194a-4a19-a45a-e7223c7e6717",
-- "token": "1234ab",
-- "save_data": true,
-- "account": "d4617561-1c01-4b2f-83b6-a594f7b3bc57"
-- }
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'date_from', '2020-08-05'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'date_to', '2020-10-05'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'link', '2ccd5e15-194a-4a19-a45a-e7223c7e6717'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'token', '1234ab'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'save_data', 1
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'account', 'd4617561-1c01-4b2f-83b6-a594f7b3bc57'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', 'application/json'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://domain.com/api/transactions/', 'application/json', @json
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
RETURN
END
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jarrResp int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonArray', @jarrResp OUT
EXEC sp_OAMethod @jarrResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jarrResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jarrResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @resp, 'StatusCode', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @resp, 'Header', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jarrResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- [
-- {
-- "account": {
-- "link": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "institution": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "collected_at": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "category": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "type": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "name": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "number": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "balance": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "currency": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "bank_product_id": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "internal_identification": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "public_identification_name": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "public_identification_value": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "last_accessed_at": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "credit_data": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "loan_data": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "funds_data": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "gig_payment_data": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "collected_at": "<date>",
-- "value_date": "<string>",
-- "accounting_date": "<date>",
-- "amount": "<number>",
-- "balance": "<number>",
-- "currency": "<string>",
-- "description": "<string>",
-- "observations": "<string>",
-- "category": "<string>",
-- "reference": "<string>",
-- "type": "in aliqua exercitation Ut ipsum",
-- "status": "aliqua veniam in",
-- "gig_data": {
-- "pickup_at": "<dateTime>",
-- "dropoff_at": "<dateTime>",
-- "request_at": "<dateTime>",
-- "pickup_address": "<string>",
-- "dropoff_address": "<string>",
-- "pickup_latitude": "<number>",
-- "pickup_longitude": "<number>",
-- "dropoff_latitude": "<number>",
-- "dropoff_longitude": "<number>",
-- "distance": "<number>",
-- "payment_method": "<string>",
-- "vehicle_type": "<string>",
-- "merchant_type": "<string>",
-- "breakdown": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "collected_at": "<dateTime>"
-- },
-- "credit_card_data": {
-- "bill_name": "<string>"
-- }
-- },
-- {
-- "account": {
-- "link": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "institution": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "collected_at": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "category": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "type": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "name": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "number": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "balance": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "currency": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "bank_product_id": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "internal_identification": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "public_identification_name": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "public_identification_value": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "last_accessed_at": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "credit_data": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "loan_data": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "funds_data": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- "gig_payment_data": {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- },
-- "collected_at": "<date>",
-- "value_date": "<string>",
-- "accounting_date": "<date>",
-- "amount": "<number>",
-- "balance": "<number>",
-- "currency": "<string>",
-- "description": "<string>",
-- "observations": "<string>",
-- "category": "<string>",
-- "reference": "<string>",
-- "type": "ad cupidatat nisi",
-- "status": "eiusmod",
-- "gig_data": {
-- "pickup_at": "<dateTime>",
-- "dropoff_at": "<dateTime>",
-- "request_at": "<dateTime>",
-- "pickup_address": "<string>",
-- "dropoff_address": "<string>",
-- "pickup_latitude": "<number>",
-- "pickup_longitude": "<number>",
-- "dropoff_latitude": "<number>",
-- "dropoff_longitude": "<number>",
-- "distance": "<number>",
-- "payment_method": "<string>",
-- "vehicle_type": "<string>",
-- "merchant_type": "<string>",
-- "breakdown": [
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- },
-- {
-- "value": "<Error: Too many levels of nesting to fake this schema>"
-- }
-- ],
-- "collected_at": "<dateTime>"
-- },
-- "credit_card_data": {
-- "bill_name": "<string>"
-- }
-- }
-- ]
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @json int
DECLARE @Value nvarchar(4000)
DECLARE @InstitutionValue nvarchar(4000)
DECLARE @Collected_atValue nvarchar(4000)
DECLARE @CategoryValue nvarchar(4000)
DECLARE @TypeValue nvarchar(4000)
DECLARE @NameValue nvarchar(4000)
DECLARE @NumberValue nvarchar(4000)
DECLARE @BalanceValue nvarchar(4000)
DECLARE @CurrencyValue nvarchar(4000)
DECLARE @Bank_product_idValue nvarchar(4000)
DECLARE @Internal_identificationValue nvarchar(4000)
DECLARE @Public_identification_nameValue nvarchar(4000)
DECLARE @Public_identification_valueValue nvarchar(4000)
DECLARE @Last_accessed_atValue nvarchar(4000)
DECLARE @Credit_dataValue nvarchar(4000)
DECLARE @Loan_dataValue nvarchar(4000)
DECLARE @Funds_dataValue nvarchar(4000)
DECLARE @Gig_payment_dataValue nvarchar(4000)
DECLARE @collected_at nvarchar(4000)
DECLARE @value_date nvarchar(4000)
DECLARE @accounting_date nvarchar(4000)
DECLARE @amount nvarchar(4000)
DECLARE @balance nvarchar(4000)
DECLARE @v_currency nvarchar(4000)
DECLARE @description nvarchar(4000)
DECLARE @observations nvarchar(4000)
DECLARE @category nvarchar(4000)
DECLARE @reference nvarchar(4000)
DECLARE @v_type nvarchar(4000)
DECLARE @status nvarchar(4000)
DECLARE @Pickup_at nvarchar(4000)
DECLARE @Dropoff_at nvarchar(4000)
DECLARE @Request_at nvarchar(4000)
DECLARE @Pickup_address nvarchar(4000)
DECLARE @Dropoff_address nvarchar(4000)
DECLARE @Pickup_latitude nvarchar(4000)
DECLARE @Pickup_longitude nvarchar(4000)
DECLARE @Dropoff_latitude nvarchar(4000)
DECLARE @Dropoff_longitude nvarchar(4000)
DECLARE @Distance nvarchar(4000)
DECLARE @Payment_method nvarchar(4000)
DECLARE @Vehicle_type nvarchar(4000)
DECLARE @Merchant_type nvarchar(4000)
DECLARE @Collected_at nvarchar(4000)
DECLARE @Bill_name nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @value nvarchar(4000)
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAGetProperty @jarrResp, 'Size', @count_i OUT
WHILE @i < @count_i
BEGIN
EXEC sp_OAMethod @jarrResp, 'ObjectAt', @json OUT, @i
EXEC sp_OAMethod @json, 'StringOf', @Value OUT, 'account.link.value'
EXEC sp_OAMethod @json, 'StringOf', @InstitutionValue OUT, 'account.institution.value'
EXEC sp_OAMethod @json, 'StringOf', @Collected_atValue OUT, 'account.collected_at.value'
EXEC sp_OAMethod @json, 'StringOf', @CategoryValue OUT, 'account.category.value'
EXEC sp_OAMethod @json, 'StringOf', @TypeValue OUT, 'account.type.value'
EXEC sp_OAMethod @json, 'StringOf', @NameValue OUT, 'account.name.value'
EXEC sp_OAMethod @json, 'StringOf', @NumberValue OUT, 'account.number.value'
EXEC sp_OAMethod @json, 'StringOf', @BalanceValue OUT, 'account.balance.value'
EXEC sp_OAMethod @json, 'StringOf', @CurrencyValue OUT, 'account.currency.value'
EXEC sp_OAMethod @json, 'StringOf', @Bank_product_idValue OUT, 'account.bank_product_id.value'
EXEC sp_OAMethod @json, 'StringOf', @Internal_identificationValue OUT, 'account.internal_identification.value'
EXEC sp_OAMethod @json, 'StringOf', @Public_identification_nameValue OUT, 'account.public_identification_name.value'
EXEC sp_OAMethod @json, 'StringOf', @Public_identification_valueValue OUT, 'account.public_identification_value.value'
EXEC sp_OAMethod @json, 'StringOf', @Last_accessed_atValue OUT, 'account.last_accessed_at.value'
EXEC sp_OAMethod @json, 'StringOf', @Credit_dataValue OUT, 'account.credit_data.value'
EXEC sp_OAMethod @json, 'StringOf', @Loan_dataValue OUT, 'account.loan_data.value'
EXEC sp_OAMethod @json, 'StringOf', @Funds_dataValue OUT, 'account.funds_data.value'
EXEC sp_OAMethod @json, 'StringOf', @Gig_payment_dataValue OUT, 'account.gig_payment_data.value'
EXEC sp_OAMethod @json, 'StringOf', @collected_at OUT, 'collected_at'
EXEC sp_OAMethod @json, 'StringOf', @value_date OUT, 'value_date'
EXEC sp_OAMethod @json, 'StringOf', @accounting_date OUT, 'accounting_date'
EXEC sp_OAMethod @json, 'StringOf', @amount OUT, 'amount'
EXEC sp_OAMethod @json, 'StringOf', @balance OUT, 'balance'
EXEC sp_OAMethod @json, 'StringOf', @v_currency OUT, 'currency'
EXEC sp_OAMethod @json, 'StringOf', @description OUT, 'description'
EXEC sp_OAMethod @json, 'StringOf', @observations OUT, 'observations'
EXEC sp_OAMethod @json, 'StringOf', @category OUT, 'category'
EXEC sp_OAMethod @json, 'StringOf', @reference OUT, 'reference'
EXEC sp_OAMethod @json, 'StringOf', @v_type OUT, 'type'
EXEC sp_OAMethod @json, 'StringOf', @status OUT, 'status'
EXEC sp_OAMethod @json, 'StringOf', @Pickup_at OUT, 'gig_data.pickup_at'
EXEC sp_OAMethod @json, 'StringOf', @Dropoff_at OUT, 'gig_data.dropoff_at'
EXEC sp_OAMethod @json, 'StringOf', @Request_at OUT, 'gig_data.request_at'
EXEC sp_OAMethod @json, 'StringOf', @Pickup_address OUT, 'gig_data.pickup_address'
EXEC sp_OAMethod @json, 'StringOf', @Dropoff_address OUT, 'gig_data.dropoff_address'
EXEC sp_OAMethod @json, 'StringOf', @Pickup_latitude OUT, 'gig_data.pickup_latitude'
EXEC sp_OAMethod @json, 'StringOf', @Pickup_longitude OUT, 'gig_data.pickup_longitude'
EXEC sp_OAMethod @json, 'StringOf', @Dropoff_latitude OUT, 'gig_data.dropoff_latitude'
EXEC sp_OAMethod @json, 'StringOf', @Dropoff_longitude OUT, 'gig_data.dropoff_longitude'
EXEC sp_OAMethod @json, 'StringOf', @Distance OUT, 'gig_data.distance'
EXEC sp_OAMethod @json, 'StringOf', @Payment_method OUT, 'gig_data.payment_method'
EXEC sp_OAMethod @json, 'StringOf', @Vehicle_type OUT, 'gig_data.vehicle_type'
EXEC sp_OAMethod @json, 'StringOf', @Merchant_type OUT, 'gig_data.merchant_type'
EXEC sp_OAMethod @json, 'StringOf', @Collected_at OUT, 'gig_data.collected_at'
EXEC sp_OAMethod @json, 'StringOf', @Bill_name OUT, 'credit_card_data.bill_name'
SELECT @j = 0
EXEC sp_OAMethod @json, 'SizeOfArray', @count_j OUT, 'gig_data.breakdown'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @json, 'J', @j
EXEC sp_OAMethod @json, 'StringOf', @value OUT, 'gig_data.breakdown[j].value'
SELECT @j = @j + 1
END
EXEC @hr = sp_OADestroy @json
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jarrResp
END
GO
Curl Command
curl -X POST
-u '{{secretId}}:{{secretPassword}}'
-H "Content-Type: application/json"
-d '{
"date_from": "2020-08-05",
"date_to": "2020-10-05",
"link": "2ccd5e15-194a-4a19-a45a-e7223c7e6717",
"token": "1234ab",
"save_data": true,
"account": "d4617561-1c01-4b2f-83b6-a594f7b3bc57"
}'
https://domain.com/api/transactions/
Postman Collection Item JSON
{
"name": "Retrieve",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"date_from\": \"2020-08-05\",\n \"date_to\": \"2020-10-05\",\n \"link\": \"2ccd5e15-194a-4a19-a45a-e7223c7e6717\",\n \"token\": \"1234ab\",\n \"save_data\": true,\n \"account\": \"d4617561-1c01-4b2f-83b6-a594f7b3bc57\"\n}"
},
"url": {
"raw": "{{baseUrl}}/api/transactions/",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"transactions",
""
]
},
"description": "Retrieve transactions for one or more accounts from a specific link.\n\nℹ️ When retrieving transactions, it is important to understand that the available transaction data ranges depend on each institution. \nIf you try to access older information than what we can access, we will return all the data we can read within that date range. For example, if you request transactions for the last year and we can only access the last six months, we will return the information corresponding to these six months of data.\n"
},
"response": [
{
"name": "Ok (when save_data=false)",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"date_from\": \"<date>\",\n \"date_to\": \"<date>\",\n \"link\": \"<uuid>\",\n \"encryption_key\": \"<string>\",\n \"token\": \"<string>\",\n \"save_data\": true,\n \"account\": \"<uuid>\"\n}"
},
"url": {
"raw": "{{baseUrl}}/api/transactions",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"transactions"
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n\t{\n\t\t\"account\": {\n\t\t\t\"link\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"institution\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"collected_at\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"category\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"type\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"name\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"number\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"balance\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"currency\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"bank_product_id\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"internal_identification\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"public_identification_name\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"public_identification_value\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"last_accessed_at\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"credit_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"loan_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"funds_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"gig_payment_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t}\n\t\t},\n\t\t\"collected_at\": \"<date>\",\n\t\t\"value_date\": \"<string>\",\n\t\t\"accounting_date\": \"<date>\",\n\t\t\"amount\": \"<number>\",\n\t\t\"balance\": \"<number>\",\n\t\t\"currency\": \"<string>\",\n\t\t\"description\": \"<string>\",\n\t\t\"observations\": \"<string>\",\n\t\t\"category\": \"<string>\",\n\t\t\"reference\": \"<string>\",\n\t\t\"type\": \"in aliqua exercitation Ut ipsum\",\n\t\t\"status\": \"aliqua veniam in\",\n\t\t\"gig_data\": {\n\t\t\t\"pickup_at\": \"<dateTime>\",\n\t\t\t\"dropoff_at\": \"<dateTime>\",\n\t\t\t\"request_at\": \"<dateTime>\",\n\t\t\t\"pickup_address\": \"<string>\",\n\t\t\t\"dropoff_address\": \"<string>\",\n\t\t\t\"pickup_latitude\": \"<number>\",\n\t\t\t\"pickup_longitude\": \"<number>\",\n\t\t\t\"dropoff_latitude\": \"<number>\",\n\t\t\t\"dropoff_longitude\": \"<number>\",\n\t\t\t\"distance\": \"<number>\",\n\t\t\t\"payment_method\": \"<string>\",\n\t\t\t\"vehicle_type\": \"<string>\",\n\t\t\t\"merchant_type\": \"<string>\",\n\t\t\t\"breakdown\": [\n\t\t\t\t{\n\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t}\n\t\t\t],\n\t\t\t\"collected_at\": \"<dateTime>\"\n\t\t},\n\t\t\"credit_card_data\": {\n\t\t\t\"bill_name\": \"<string>\"\n\t\t}\n\t},\n\t{\n\t\t\"account\": {\n\t\t\t\"link\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"institution\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"collected_at\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"category\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"type\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"name\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"number\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"balance\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"currency\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"bank_product_id\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"internal_identification\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"public_identification_name\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"public_identification_value\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"last_accessed_at\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"credit_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"loan_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"funds_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"gig_payment_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t}\n\t\t},\n\t\t\"collected_at\": \"<date>\",\n\t\t\"value_date\": \"<string>\",\n\t\t\"accounting_date\": \"<date>\",\n\t\t\"amount\": \"<number>\",\n\t\t\"balance\": \"<number>\",\n\t\t\"currency\": \"<string>\",\n\t\t\"description\": \"<string>\",\n\t\t\"observations\": \"<string>\",\n\t\t\"category\": \"<string>\",\n\t\t\"reference\": \"<string>\",\n\t\t\"type\": \"ad cupidatat nisi\",\n\t\t\"status\": \"eiusmod\",\n\t\t\"gig_data\": {\n\t\t\t\"pickup_at\": \"<dateTime>\",\n\t\t\t\"dropoff_at\": \"<dateTime>\",\n\t\t\t\"request_at\": \"<dateTime>\",\n\t\t\t\"pickup_address\": \"<string>\",\n\t\t\t\"dropoff_address\": \"<string>\",\n\t\t\t\"pickup_latitude\": \"<number>\",\n\t\t\t\"pickup_longitude\": \"<number>\",\n\t\t\t\"dropoff_latitude\": \"<number>\",\n\t\t\t\"dropoff_longitude\": \"<number>\",\n\t\t\t\"distance\": \"<number>\",\n\t\t\t\"payment_method\": \"<string>\",\n\t\t\t\"vehicle_type\": \"<string>\",\n\t\t\t\"merchant_type\": \"<string>\",\n\t\t\t\"breakdown\": [\n\t\t\t\t{\n\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t}\n\t\t\t],\n\t\t\t\"collected_at\": \"<dateTime>\"\n\t\t},\n\t\t\"credit_card_data\": {\n\t\t\t\"bill_name\": \"<string>\"\n\t\t}\n\t}\n]"
},
{
"name": "Created (when save_data=true)",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"date_from\": \"<date>\",\n \"date_to\": \"<date>\",\n \"link\": \"<uuid>\",\n \"encryption_key\": \"<string>\",\n \"token\": \"<string>\",\n \"save_data\": true,\n \"account\": \"<uuid>\"\n}"
},
"url": {
"raw": "{{baseUrl}}/api/transactions",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"transactions"
]
}
},
"status": "Created",
"code": 201,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n\t{\n\t\t\"id\": \"<uuid>\",\n\t\t\"account\": {\n\t\t\t\"id\": \"<uuid>\",\n\t\t\t\"link\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"institution\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"collected_at\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"category\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"type\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"name\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"number\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"balance\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"currency\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"bank_product_id\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"internal_identification\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"public_identification_name\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"public_identification_value\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"last_accessed_at\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"credit_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"loan_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"funds_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"gig_payment_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t}\n\t\t},\n\t\t\"collected_at\": \"<date>\",\n\t\t\"value_date\": \"<string>\",\n\t\t\"accounting_date\": \"<date>\",\n\t\t\"amount\": \"<number>\",\n\t\t\"balance\": \"<number>\",\n\t\t\"currency\": \"<string>\",\n\t\t\"description\": \"<string>\",\n\t\t\"observations\": \"<string>\",\n\t\t\"category\": \"<string>\",\n\t\t\"reference\": \"<string>\",\n\t\t\"type\": \"deserun\",\n\t\t\"status\": \"elit tempor aliquip\",\n\t\t\"gig_data\": {\n\t\t\t\"pickup_at\": \"<dateTime>\",\n\t\t\t\"dropoff_at\": \"<dateTime>\",\n\t\t\t\"request_at\": \"<dateTime>\",\n\t\t\t\"pickup_address\": \"<string>\",\n\t\t\t\"dropoff_address\": \"<string>\",\n\t\t\t\"pickup_latitude\": \"<number>\",\n\t\t\t\"pickup_longitude\": \"<number>\",\n\t\t\t\"dropoff_latitude\": \"<number>\",\n\t\t\t\"dropoff_longitude\": \"<number>\",\n\t\t\t\"distance\": \"<number>\",\n\t\t\t\"payment_method\": \"<string>\",\n\t\t\t\"vehicle_type\": \"<string>\",\n\t\t\t\"merchant_type\": \"<string>\",\n\t\t\t\"breakdown\": [\n\t\t\t\t{\n\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t}\n\t\t\t],\n\t\t\t\"collected_at\": \"<dateTime>\"\n\t\t},\n\t\t\"credit_card_data\": {\n\t\t\t\"bill_name\": \"<string>\"\n\t\t}\n\t},\n\t{\n\t\t\"id\": \"<uuid>\",\n\t\t\"account\": {\n\t\t\t\"id\": \"<uuid>\",\n\t\t\t\"link\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"institution\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"collected_at\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"category\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"type\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"name\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"number\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"balance\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"currency\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"bank_product_id\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"internal_identification\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"public_identification_name\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"public_identification_value\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"last_accessed_at\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"credit_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"loan_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"funds_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t},\n\t\t\t\"gig_payment_data\": {\n\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t}\n\t\t},\n\t\t\"collected_at\": \"<date>\",\n\t\t\"value_date\": \"<string>\",\n\t\t\"accounting_date\": \"<date>\",\n\t\t\"amount\": \"<number>\",\n\t\t\"balance\": \"<number>\",\n\t\t\"currency\": \"<string>\",\n\t\t\"description\": \"<string>\",\n\t\t\"observations\": \"<string>\",\n\t\t\"category\": \"<string>\",\n\t\t\"reference\": \"<string>\",\n\t\t\"type\": \"amet eiusmod\",\n\t\t\"status\": \"amet exercitation\",\n\t\t\"gig_data\": {\n\t\t\t\"pickup_at\": \"<dateTime>\",\n\t\t\t\"dropoff_at\": \"<dateTime>\",\n\t\t\t\"request_at\": \"<dateTime>\",\n\t\t\t\"pickup_address\": \"<string>\",\n\t\t\t\"dropoff_address\": \"<string>\",\n\t\t\t\"pickup_latitude\": \"<number>\",\n\t\t\t\"pickup_longitude\": \"<number>\",\n\t\t\t\"dropoff_latitude\": \"<number>\",\n\t\t\t\"dropoff_longitude\": \"<number>\",\n\t\t\t\"distance\": \"<number>\",\n\t\t\t\"payment_method\": \"<string>\",\n\t\t\t\"vehicle_type\": \"<string>\",\n\t\t\t\"merchant_type\": \"<string>\",\n\t\t\t\"breakdown\": [\n\t\t\t\t{\n\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"value\": \"<Error: Too many levels of nesting to fake this schema>\"\n\t\t\t\t}\n\t\t\t],\n\t\t\t\"collected_at\": \"<dateTime>\"\n\t\t},\n\t\t\"credit_card_data\": {\n\t\t\t\"bill_name\": \"<string>\"\n\t\t}\n\t}\n]"
},
{
"name": "Bad request error",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"date_from\": \"<date>\",\n \"date_to\": \"<date>\",\n \"link\": \"<uuid>\",\n \"encryption_key\": \"<string>\",\n \"token\": \"<string>\",\n \"save_data\": true,\n \"account\": \"<uuid>\"\n}"
},
"url": {
"raw": "{{baseUrl}}/api/transactions",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"transactions"
]
}
},
"status": "Bad Request",
"code": 400,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t},\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t}\n]"
},
{
"name": "Unauthorized",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"date_from\": \"<date>\",\n \"date_to\": \"<date>\",\n \"link\": \"<uuid>\",\n \"encryption_key\": \"<string>\",\n \"token\": \"<string>\",\n \"save_data\": true,\n \"account\": \"<uuid>\"\n}"
},
"url": {
"raw": "{{baseUrl}}/api/transactions",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"transactions"
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t},\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t}\n]"
},
{
"name": "Request Timeout",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"date_from\": \"<date>\",\n \"date_to\": \"<date>\",\n \"link\": \"<uuid>\",\n \"encryption_key\": \"<string>\",\n \"token\": \"<string>\",\n \"save_data\": true,\n \"account\": \"<uuid>\"\n}"
},
"url": {
"raw": "{{baseUrl}}/api/transactions",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"transactions"
]
}
},
"status": "Request Timeout",
"code": 408,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t},\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t}\n]"
},
{
"name": "MFA Token Required",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"date_from\": \"<date>\",\n \"date_to\": \"<date>\",\n \"link\": \"<uuid>\",\n \"encryption_key\": \"<string>\",\n \"token\": \"<string>\",\n \"save_data\": true,\n \"account\": \"<uuid>\"\n}"
},
"url": {
"raw": "{{baseUrl}}/api/transactions",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"transactions"
]
}
},
"status": "Precondition Required",
"code": 428,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n\t\"code\": \"<string>\",\n\t\"message\": \"<string>\",\n\t\"request_id\": \"<uuid>\",\n\t\"session\": \"<uuid>\",\n\t\"expiry\": \"<integer>\",\n\t\"link\": \"<uuid>\",\n\t\"token_generation_data\": {\n\t\t\"instructions\": \"<string>\",\n\t\t\"type\": \"<string>\",\n\t\t\"value\": \"<string>\"\n\t}\n}"
},
{
"name": "Unexpected Error",
"originalRequest": {
"method": "POST",
"header": [
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"date_from\": \"<date>\",\n \"date_to\": \"<date>\",\n \"link\": \"<uuid>\",\n \"encryption_key\": \"<string>\",\n \"token\": \"<string>\",\n \"save_data\": true,\n \"account\": \"<uuid>\"\n}"
},
"url": {
"raw": "{{baseUrl}}/api/transactions",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"transactions"
]
}
},
"status": "Internal Server Error",
"code": 500,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "[\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t},\n\t{\n\t\t\"code\": \"<string>\",\n\t\t\"message\": \"<string>\",\n\t\t\"request_id\": \"<string>\"\n\t}\n]"
}
]
}
