SSIS tutorial: How to connect Tripletex in SSIS

Introduction

Tripletex is a cloud-based accounting and enterprise resource planning (ERP) platform designed for small to medium-sized businesses in Norway and other Scandinavian countries. It provides comprehensive financial management, invoicing, project accounting, and inventory management capabilities through a robust REST API.

Integrating Tripletex with SQL Server Integration Services (SSIS) enables seamless data synchronization between your accounting system and other business applications. ZappySys SSIS PowerPack simplifies this integration by providing pre-built connectors and components that handle Tripletex authentication, API communication, and data transformation without requiring custom code.

This tutorial walks you through the complete process of setting up a Tripletex connection and building your first data integration package.

Prerequisites

1. SQL Server Integration Services (SSIS) is installed.
2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).
3. Tripletex account with API access enabled.
4. Finally, do not forget to install ZappySys SSIS PowerPack.

Steps

Generate your Tripletex API credentials

1. Create or log in to your Tripletex account using your administrator credentials.
2. Navigate to the Settings section by clicking on your user profile icon in the top-right corner of the screen.
3. Select API Access from the dropdown menu.
4. Click the Generate New Token button to generate a new API token.
   

   Tripletex – Generate Token

5. Provide a descriptive name for your token.
6. Set the appropriate permissions scope. For this tutorial, select Read and Write access to ensure the integration can both retrieve and push data.
7. Click Generate Token, then immediately copy the Consumer Token and Employee Token values. Store them securely in a password manager or Azure Key Vault, as Tripletex will not display them again.
   

   Tripletex – Getting Tokens

Generate the Session Token

Tripletex requires a session token for API authentication. This session token is generated from the Consumer Token and Employee Token obtained in Step 1. Follow these steps:

1. In your SSIS package, navigate to the Variables section and create the following variables:
   1. ConsumerToken (String) — Enter the Consumer Token from Step 1.
   2. EmployeeToken (String) — Enter the Employee Token from Step 1.
   3. SessionToken (String) — Stores the generated session token.
   4. CompanyID (String) — Enter your Tripletex company ID (or use 0 if unknown).
2. Drag and drop the REST API Task component onto your SSIS package canvas and double-click to open it.
   

   Add a REST API Task in SSIS

3. Navigate to the Response Settings tab and set Response Content Type to JSON.
4. In the JSONPath field, enter: $.value.Token to extract the session token from the API response.
5. Enable Save Response Content, select the Variable option, and choose your SessionToken variable.
   

   Tripletex – Save Session Token in Variable

6. Go back to the Request tab and enter the following URL. For testing, use:
   
   https://api-test.tripletex.tech/v2/token/session/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24

   1	https://api-test.tripletex.tech/v2/token/session/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24

7. For production environments, use:
   
   https://tripletex.no/v2/token/session/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24

   1	https://tripletex.no/v2/token/session/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24

8. Set the HTTP Request Method to PUT.
9. Test the connection. If successful, you will see the generated session token in the response.
   

   Tripletex – Generate Session Token

Create and Configure the JSON Source

1. Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.
2. Double-click the Data Flow Task to enter the Data Flow design surface.
3. Drag a ZappySys JSON Source component from the toolbox onto the canvas.
   

   SSIS JSON Source – Drag and Drop

4. Double-click the ZappySys JSON Source to open its editor.
5. For testing purposes, enter the following URL:
   
   https://api-test.tripletex.tech/v2/token/session/>whoAmI

   1	https://api-test.tripletex.tech/v2/token/session/>whoAmI

6. Set the HTTP Request Method to GET.
7. Click the Headers tab and add the required Tripletex authentication headers. The Authorization header must contain the Company ID and Session Token in Base64-encoded format:
   
   Accept: application/json Authorization: Basic <<{{User::CompanyID}}:{{User::SessionToken}},FUN_BASE64ENC}}>>

   1 2	Accept: application/json Authorization: Basic <<{{User::CompanyID}}:{{User::SessionToken}},FUN_BASE64ENC}}>>

   

   Tripletex – JSON Source Configuration

8. In the Array Filter field, specify the JSON path to extract the data array from the Tripletex response: $.value
9. Click Preview Data to test the connection and verify that data is being retrieved correctly from Tripletex.
   

   Tripletex – JSON Source Preview

10. Click OK to save the configuration.

Configure the Data Destination

1. Drag and drop a destination component (such as OLE DB Destination, Flat File Destination, or Trash Destination) into the Data Flow.
2. Connect the output arrow from the JSON Source component to the destination component.
3. Double-click the destination component to open its configuration dialog.
4. Configure the destination to point to your target table or file where Tripletex data will be stored.
5. In the Mappings section, map the columns from the JSON response to the corresponding destination columns.
6. Click OK to save the destination configuration.
7. Execute the package and verify that the data extraction is working correctly.
   

   Tripletex – Final Result

Conclusion

You have successfully set up a complete integration between Tripletex and SSIS using ZappySys components. This tutorial covered creating API credentials, configuring session token authentication, retrieving data from Tripletex APIs, and loading it into your SQL Server or other destinations.

This integration enables you to automate critical business processes such as invoice tracking, customer synchronization, project management, and financial reporting. By leveraging ZappySys SSIS PowerPack, you have avoided complex custom coding and achieved a scalable, maintainable solution for your data integration needs.

Explore the full capabilities of the ZappySys SSIS PowerPack to optimize your data integration tasks. By applying this pattern, you can extend your solution to include additional transformations, data validation, error handling, and scheduling through SQL Server Agent.

Need Help?

If you encounter any issues, our support team is here to help:

1. Live Chat — Use the chat widget (bottom-right corner of this page)
2. Email — support@zappysys.com
3. Support Center — Visit the ZappySys Support Portal