finleap connect Integration

JustOn integrates with finleap connect to retrieve banking transactions, which are to be stored as payment entries.

figo
Retrieving banking transactions and creating payment entries

Integration Concepts

If enabled accordingly, you can retrieve banking transactions for a specified account and a specified period from the bank server, which creates the corresponding payment entries. The field Payment Provider of the produced payment entries is set to figo.

JustOn checks existing balance records for the specified payment provider and transaction no. If Payment Provider is set to figo and the value of Transaction No. matches the value of Transaction No. of the retrieved payment entry, the balance record is considered a "finleap connect balance" and therefore subject to the following procedure:

If there is already an existing balance record that matches the retrieved payment entry, JustOn sets the payment entry to the status Converted but does not create a new balance record. This prevents duplicate payment matching.
If the Is Deleted checkbox on the payment entry is selected and a balance object that matches the payment entry exists, JustOn deletes the balance record and sets the payment entry to the status Converted.

To filter the transactions to be retrieved, you specify finleap connect filters.

finleap connect Transaction Filters control which types of banking transactions are to be transferred.
finleap connect Transaction Content Filters filter the retrieved transactions by their content like name, reference, etc. This filter is an exclude filter, that is, retrieved transactions that match the filter conditions are not written to the database.

finleap connect Data Conversion

finleap connect stores banking transactions in the figo Connect Transaction object. Upon data transfer, JustOn automatically maps the retrieved transaction JSON data to the Payment Entry object.

The following table shows which data is written to the payment entry.

Payment Entry Field	Value	Description
ExternalTransactionId__c	`FIGO` + `<transaction_id>`	External ID that is used to uniquely match a finleap connect transaction
TransactionNo__c	`<transaction_id>`	Internal finleap connect transaction ID
PaymentProvider__c	`figo`	Name of the payment provider
Status__c	`New`	Status for newly created objects
Debit__c	`<amount>` if the value is positive	The debit amount
Credit__c	`<amount>` if the value is negative	The credit amount
Reference__c	`<purpose>`	Purpose text, can be empty if the transaction has no purpose
CustomerName__c	`<name>`	Name of originator or recipient
BankAccountId__c	`<account_id>`	Internal finleap connect account ID
BookingDate__c	`<booking_date>`	Booking date
ProviderSpecificData__c	complete transaction JSON data	The retrieved finleap connect transaction JSON data for this object

The JSON data of the figo Connect Transaction object contains a number of additional fields. JustOn can write additional data values to custom fields of the payment entry. Each JSON value is processed in the following way:

(1) The JSON field name is converted to a Salesforce field name, where

underscores are removed,
if the JSON value belongs to a child object, the field name is prefixed with the field name of the parent object, connected by an underscore,
the string FIGO_ is prepended,
the string __c is appended.

(2) If there is a matching field on the Payment Entry object, the field value is written to this field.

(3) The type of the Payment Entry field must match the type of the JSON field value, like Text (255) for bank_name, Currency for amount or Date for value_date. JustOn automatically converts the JSON value to the type of the Payment Entry field.

Example field conversions

JSON Field	Salesforce Field Name	Type
account_number	FIGO_AccountNumber__c	Text (255)
value_date	FIGO_ValueDate__c	Date
end_to_end_reference	FIGO_EndToEndReference__c	Text (255)
additional_info.gross_amount	FIGO_AdditionalInfo_GrossAmount__c	Currency (13,5)

When retrieving finleap connect transactions from the banking server, the response may contain a list of deleted transactions. For these transactions, JustOn also creates payment entries with the following data:

Payment Entry Field	Value	Description
ExternalTransactionId__c	`FIGO` + `<transaction_id>`	External ID that is used to uniquely match a finleap connect transaction
TransactionNo__c	`<transaction_id>`	Internal finleap connect transaction ID
PaymentProvider__c	`figo`	Name of the Payment Provider
Status__c	`New`	Status for newly created objects
IsDeleted__c	`true`	Indicates that the corresponding transaction is deleted