Transaction import UI

This guide walks through the development requirements for a web-based product integrating with transaction import (v1). Before a user can utilise the transaction import funtionality they must have a bank account created in the Banking Service. For creation of a placeholder bank account follow the placeholder bank account guide.

---

Step 1. Obtain an access token

Before integrating with the Banking Service UI, integrate with the Authentication Service.

To work with Banking Service, you need an access token (JWT) from Authentication Service. The JWT is generated using the unique IDs of the organisation (organisationId) and company (companyId). This JWT can be provided as a bearer token for Banking Service requests through the authorisation header: ‘Bearer ‘.

---

Step 2. Create the common UI URL

Create a transaction import (v1) UI launch URL. This is used to launch the common UI in an iFrame inside a full dialogue modal window.

Required parameters

1. {Environment}
   DEV → https://dev-money.sage.com
   QA → https://qa-money.sage.com
   PRE-PROD → https://pp-money.sage.com
   SANDBOX → https://sandbox-money.sage.com
   PROD → https://money.sage.com

2. {route} = the page to launch value is import-bank-transactions.
3. {JWT} = the JWT from Sage Network Platform Authentication Service.
4. {lang} = the language used for display of content translations [for example, en-us, en-uk, fr-fr, fr-ca, es-es].
5. {UXSettings} = UI experience settings. Preset options are: default, wpb-preview, web-iframe, web-popup, sage-desktop, intacct-banking. This field only changes the UI styling and does not affect any core functionality.
6. {bcApiRegion} = region for Banking API call, defaults to US. Available options are EU and US.
7. {countryCode} = the default country code for bank listings. For example USA, GBR.
8. {productname} = the product the import is initiated from.
9. {bankAccountId} = the bank’s account ID, for example, 59d4ca99-9da6-476f-ab11-8989e459239b
10. {bankAccountName} = the bank’s name, for example, Bank of America.
11. {currencyCode} = the possible value for currency code are: “USD”, “CAD”,”GBP”,”AUD”,”ZAR”,”MYR”,”EUR”,”BRL”.
12. {accountRef} = the account reference detail. This is a combination of sort code (UK), routing number (USA), and IBAN.
13. {xFrameDomain} = your product domain URL.
14. {bankId} = the identifier of the bank document that you’re topping up transactions from.

---

Step 3. Load the URL

Create a full screen dialogue modal and open it when the user selects the transaction import button.

full screen dialogue modal code snippet

<!-- The Modal -->
    <div id="dvFileImportV1" class="modal">
        <!-- Modal content -->
        <div class="modal-content">
            <span class="close">×</span>
            <div>
                <iframe id="iframeWPBUIFileImportV1" height="850px" style="width: 100%;" src="" allow="fullscreen"></iframe>
            </div>
        </div>
    </div>

Prepare file import v1 UI URL and load into an iFrame

    const launchURL = 
        `${Environment}/xframe.html?apptokenroute=/${route}/${JWT}/
         ${lang}/{UXSettings}
         &bcApiRegion=${bcRegion}
         &defaultCountry=${countryCode}
         &productname=${productName}
         &bankAccountId=${bankAccountId}
         &bankAccountName=${bankAccountName}
         &accountRef=${bankAccountRef}
         &currencyCode=${currencyCode}
         &xFrameDomain=${xframeDomain}`;
    
    const modal = document.getElementById("dvFileImportV1");
    modal.style.display = "block";
    document.getElementById('iframeWPBUIFileImportV1').src = launchURL;

---

Step 4. User follows the transaction import UI

---

Step 5. Handle message returned from the iFrame

The Banking UI loading in the iFrame will post a message back to the parent window by calling the postMessage() method. To get messages back from the Banking UI, implement the recieveMessage() method as demonstrated:

    function receiveMessage(event) {
        // Add security to ensure you trust the sender of this message
        console.log("MY Data:", event);
    }
    window.addEventListener("message", receiveMessage, false);

The following postback results should be handled:

Import started
This message is sent when the processing of the file in Banking Service has started.

{ "message": "StartFo;e", "data": { "importId": "fileImportId", "bankId": "bankId", "bankAccountId": "bankAccountId", "fileName" : "fileName" }}
```a

__Import confirmed__ <br>
This message is sent to confirm the import was successful. This occurs when the user selects the **finish** button on the choose transaction start date screen. You can store the 'fileImportId' for that specific 'bankAccountId'. This allows you to track the import to a specific account, company and organisation. 

```json
{ "message": "ConfirmFileImport", "data": { "importId": "fileImportId", "bankId": "bankId", "bankAccountId": "bankAccountId"}}

Import cancelled
This is sent when a user chooses to cancel the import at any point during the import journey.

{ "message": "CancelFileImport", "data": {"ImportId": "importId"}}

---

Step 6. Handle the closing of the iFrame

When you’ve received the post message confirming the transaction import, you should handle the closing of the iFrame and direct the user back to their product. You can then call the GET /transactions endpoint to get the newly uploaded transactions.

---

Recap

In this walkthrough we’ve covered how to load the transaction import UI with a bank account or placeholder bank account in an iFrame. We have also covered the steps the user would take when using the common UI to upload transactions and anything your solution would need to action.

---

Was this helpful?

Yes

No

Submit feedback