SSIS tutorial: How export data from Tripletex

Introduction

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

Integrating Tripletex with SQL Server Integration Services (SSIS) lets you synchronize accounting data with databases, reporting systems, and other business applications. ZappySys SSIS PowerPack simplifies this process by providing components that handle HTTP requests, authentication, and data extraction without requiring custom code.

This tutorial walks you through the complete process of creating Tripletex API credentials, generating a session token, and building an SSIS package that extracts data from Tripletex.

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. Install ZappySys SSIS PowerPack.

Steps

Generate 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 a Tripletex session token

Tripletex requires a session token for API authentication. The session token is generated from the Consumer Token and Employee Token obtained in the previous step.

1. In your SSIS package, navigate to the Variables section and create the following variables:
   1. ConsumerToken (String) — Enter the Consumer Token from the previous step.
   2. EmployeeToken (String) — Enter the Employee Token from the previous step.
   3. SessionToken (String) — Stores the generated session token.
   4. CompanyID (String) — Enter your Tripletex company ID, or use 0 if it is 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-12-31

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

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

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

8. Use a future expiration date when you generate the token. If you copy these examples later, replace the sample date before testing.
9. Set the HTTP Request Method to PUT.
10. Test the connection. If successful, you will see the generated session token in the response.
    

    Tripletex – Generate Session Token

Use an HTTP dynamic token connection (recommended)

You can also generate and reuse the session token through an HTTP connection with a dynamic token configuration.

1. Right-click in the Connection Managers pane and select New Connection…
2. Select ZS-HTTP from the SSIS connectors list
   

   Create a new HTTP connection

3. Enter the following URL with the consumer and employee token:
   
   https://api-test.tripletex.tech/v2/token/session/:create?consumerToken={ConsumerToken}&employeeToken={EmployeeToken}&expirationDate=2026-12-31

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

4. In Credentials Type, select Dynamic Token.
5. In the Auth header name, use Authorization.
6. For the Auth Scheme, select Basic.
   

   Tripletex – SSIS HTTP connection

7. Go to the Dynamic Token tab.
8. Enter the previous URL.
9. Set the HTTP Request Method to PUT.
   
   

   Tripletex – ODBC dynamic token

10. Go to the Response Settings tab.
11. Select Expression Type as JSON and use this JSONPath to get the Session Token: $.value.token
12. In Token Function, use the following function. The Authorization header must contain the Company ID (enter your Tripletex company ID, or use 0 if it is unknown) and Session Token in Base64-encoded format: <<0:[$token$],FUN_BASE64ENC>>
13. Click OK to save the connection configuration.
    

    Tripletex – SSIS save 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/currency

   1	https://api-test.tripletex.tech/v2/currency

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}}>>
8. If you want to use the connection option (recommended), select Use credentials and choose the connection you created earlier.
9. In the Array Filter field, specify the JSON path to extract the data array from the Tripletex response: $.value
10. Click Preview Data to test the connection and verify that data is being retrieved correctly from Tripletex.
    

    Tripletex – JSON Source result

11. 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 data extraction is working correctly.
   

   Tripletex – Final Result

Conclusion

You have now 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 the Tripletex API, and loading it into SQL Server or another destination.

This pattern can help automate business processes such as invoice tracking, customer synchronization, project reporting, and financial analysis. By using ZappySys SSIS PowerPack, you can build the workflow with less custom code while keeping the package easier to maintain.

Explore the full capabilities of ZappySys SSIS PowerPack to extend this solution with additional transformations, data validation, error handling, and scheduling through SQL Server Agent.

Frequently Asked Questions

Why does Tripletex require a session token?

Tripletex uses a session token for API authentication. In this workflow, the session token is generated from the Consumer Token and Employee Token before SSIS sends requests to the API.

Should I use the REST API Task or a dynamic token connection?

Both approaches can work. A dynamic token connection is often easier to reuse across multiple components because the token generation logic is stored in the connection instead of being repeated in each task.

What should I check if authentication fails?

Confirm that the Consumer Token and Employee Token are correct, the expiration date is still in the future, and the Authorization header contains the expected Company ID and session token values.

Next step

If you want to build similar API integrations in SSIS, download SSIS PowerPack and use the same pattern for other REST API workflows.

Need Help?

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

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