![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-logo.png\"){kind=logo}
<\/a>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.<\/p>\nIntegrating 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.<\/p>\n
This tutorial walks you through the complete process of setting up a Tripletex connection and building your first data integration package.<\/p>\n
Prerequisites<\/h2>\n\n- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).<\/li>\n
- Tripletex account with API access enabled.<\/li>\n
- Finally, do not forget to install\u00a0ZappySys\u00a0SSIS PowerPack.<\/a><\/li>\n<\/ol>\n
Steps<\/h2>\nGenerate your Tripletex API credentials<\/h3>\n\n- Create or log in to your Tripletex account<\/a> using your administrator credentials.<\/li>\n
- Navigate to the Settings section by clicking on your user profile icon in the top-right corner of the screen.<\/li>\n
- Select API Access<\/strong> from the dropdown menu.<\/li>\n
- Click the Generate New Token<\/strong> button to generate a new API token.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-generate-token-1.png\")
<\/a>Tripletex – Generate Token<\/p><\/div><\/li>\n
- Provide a descriptive name for your token.<\/li>\n
- Set the appropriate permissions scope. For this tutorial, select Read and Write<\/strong> access to ensure the integration can both retrieve and push data.<\/li>\n
- Click Generate Token<\/strong>, then immediately copy the Consumer Token<\/strong> and Employee Token<\/strong> values. Store them securely in a password manager or Azure Key Vault, as Tripletex will not display them again.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-getting-tokens.png\")
<\/a>Tripletex – Getting Tokens<\/p><\/div><\/li>\n<\/ol>\n
Generate the Session Token<\/h3>\n
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:<\/p>\n
\n- In your SSIS package, navigate to the Variables section and create the following variables:\n
\n- ConsumerToken<\/strong> (String) \u2014 Enter the Consumer Token from Step 1.<\/li>\n
- EmployeeToken<\/strong> (String) \u2014 Enter the Employee Token from Step 1.<\/li>\n
- SessionToken<\/strong> (String) \u2014 Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) \u2014 Enter your Tripletex company ID (or use 0 if unknown).<\/li>\n<\/ol>\n<\/li>\n
- Drag and drop the REST API Task<\/a> component onto your SSIS package canvas and double-click to open it.\n
![\"Add](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/07\/RestAPITask.jpg\")
<\/a>Add a REST API Task in SSIS<\/p><\/div><\/li>\n
- Navigate to the Response Settings<\/strong> tab and set Response Content Type<\/strong> to JSON<\/strong>.<\/li>\n
- In the JSONPath field, enter:
$.value.Token<\/code> to extract the session token from the API response.<\/li>\n- Enable Save Response Content<\/strong>,<\/strong>\u00a0select the\u00a0Variable<\/strong> option, and\u00a0choose your SessionToken variable.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-save-session-token-in-a-variable.png\")
<\/a>Tripletex – Save Session Token in Variable<\/p><\/div><\/li>\n
- Go back to the Request<\/strong> tab and enter the following URL. For testing, use:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n - Set the HTTP Request Method<\/strong> to PUT<\/strong>.<\/li>\n
- Test the connection. If successful, you will see the generated session token in the response.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-generate-session-token.png\")
<\/a>Tripletex – Generate Session Token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure the JSON Source<\/h3>\n\n- Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.<\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n
![\"SSIS](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\")
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- For testing purposes, enter the following URL:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/>whoAmI<\/pre>\n<\/li>\n
- Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Click the Headers<\/strong> tab and add the required Tripletex authentication headers. The Authorization header must contain the Company ID and Session Token in Base64-encoded format:\n
Accept: application\/json\r\nAuthorization: Basic <<{{User::CompanyID}}:{{User::SessionToken}},FUN_BASE64ENC}}>><\/pre>\n![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-JSON-source-configuration.png\")
<\/a>Tripletex – JSON Source Configuration<\/p><\/div><\/li>\n
- In the Array Filter<\/strong> field, specify the JSON path to extract the data array from the Tripletex response:
$.value<\/code><\/li>\n- Click Preview Data<\/strong> to test the connection and verify that data is being retrieved correctly from Tripletex.\n
![\"Tripletex](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-JSON-source-preview.png\")
<\/a>Tripletex – JSON Source Preview<\/p><\/div><\/li>\n
- Click OK<\/strong> to save the configuration.<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n\n- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialog.<\/li>\n
- Configure the destination to point to your target table or file where Tripletex data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
Steps<\/h2>\nGenerate your Tripletex API credentials<\/h3>\n\n- Create or log in to your Tripletex account<\/a> using your administrator credentials.<\/li>\n
- Navigate to the Settings section by clicking on your user profile icon in the top-right corner of the screen.<\/li>\n
- Select API Access<\/strong> from the dropdown menu.<\/li>\n
- Click the Generate New Token<\/strong> button to generate a new API token.\n<\/a>
Tripletex – Generate Token<\/p><\/div><\/li>\n
- Provide a descriptive name for your token.<\/li>\n
- Set the appropriate permissions scope. For this tutorial, select Read and Write<\/strong> access to ensure the integration can both retrieve and push data.<\/li>\n
- Click Generate Token<\/strong>, then immediately copy the Consumer Token<\/strong> and Employee Token<\/strong> values. Store them securely in a password manager or Azure Key Vault, as Tripletex will not display them again.\n<\/a>
Tripletex – Getting Tokens<\/p><\/div><\/li>\n<\/ol>\n
Generate the Session Token<\/h3>\n
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:<\/p>\n
\n- In your SSIS package, navigate to the Variables section and create the following variables:\n
\n- ConsumerToken<\/strong> (String) \u2014 Enter the Consumer Token from Step 1.<\/li>\n
- EmployeeToken<\/strong> (String) \u2014 Enter the Employee Token from Step 1.<\/li>\n
- SessionToken<\/strong> (String) \u2014 Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) \u2014 Enter your Tripletex company ID (or use 0 if unknown).<\/li>\n<\/ol>\n<\/li>\n
- Drag and drop the REST API Task<\/a> component onto your SSIS package canvas and double-click to open it.\n<\/a>
Add a REST API Task in SSIS<\/p><\/div><\/li>\n
- Navigate to the Response Settings<\/strong> tab and set Response Content Type<\/strong> to JSON<\/strong>.<\/li>\n
- In the JSONPath field, enter:
$.value.Token<\/code> to extract the session token from the API response.<\/li>\n- Enable Save Response Content<\/strong>,<\/strong>\u00a0select the\u00a0Variable<\/strong> option, and\u00a0choose your SessionToken variable.\n<\/a>
Tripletex – Save Session Token in Variable<\/p><\/div><\/li>\n
- Go back to the Request<\/strong> tab and enter the following URL. For testing, use:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n - Set the HTTP Request Method<\/strong> to PUT<\/strong>.<\/li>\n
- Test the connection. If successful, you will see the generated session token in the response.\n<\/a>
Tripletex – Generate Session Token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure the JSON Source<\/h3>\n\n- Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.<\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n<\/a>
SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- For testing purposes, enter the following URL:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/>whoAmI<\/pre>\n<\/li>\n
- Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Click the Headers<\/strong> tab and add the required Tripletex authentication headers. The Authorization header must contain the Company ID and Session Token in Base64-encoded format:\n
Accept: application\/json\r\nAuthorization: Basic <<{{User::CompanyID}}:{{User::SessionToken}},FUN_BASE64ENC}}>><\/pre>\n<\/a>Tripletex – JSON Source Configuration<\/p><\/div><\/li>\n
- In the Array Filter<\/strong> field, specify the JSON path to extract the data array from the Tripletex response:
$.value<\/code><\/li>\n- Click Preview Data<\/strong> to test the connection and verify that data is being retrieved correctly from Tripletex.\n<\/a>
Tripletex – JSON Source Preview<\/p><\/div><\/li>\n
- Click OK<\/strong> to save the configuration.<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n\n- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialog.<\/li>\n
- Configure the destination to point to your target table or file where Tripletex data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- \n
- Create or log in to your Tripletex account<\/a> using your administrator credentials.<\/li>\n
- Navigate to the Settings section by clicking on your user profile icon in the top-right corner of the screen.<\/li>\n
- Select API Access<\/strong> from the dropdown menu.<\/li>\n
- Click the Generate New Token<\/strong> button to generate a new API token.\n
<\/a>Tripletex – Generate Token<\/p><\/div><\/li>\n
- Provide a descriptive name for your token.<\/li>\n
- Set the appropriate permissions scope. For this tutorial, select Read and Write<\/strong> access to ensure the integration can both retrieve and push data.<\/li>\n
- Click Generate Token<\/strong>, then immediately copy the Consumer Token<\/strong> and Employee Token<\/strong> values. Store them securely in a password manager or Azure Key Vault, as Tripletex will not display them again.\n
<\/a>Tripletex – Getting Tokens<\/p><\/div><\/li>\n<\/ol>\n
Generate the Session Token<\/h3>\n
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:<\/p>\n
- \n
- In your SSIS package, navigate to the Variables section and create the following variables:\n
- \n
- ConsumerToken<\/strong> (String) \u2014 Enter the Consumer Token from Step 1.<\/li>\n
- EmployeeToken<\/strong> (String) \u2014 Enter the Employee Token from Step 1.<\/li>\n
- SessionToken<\/strong> (String) \u2014 Stores the generated session token.<\/li>\n
- CompanyID<\/strong> (String) \u2014 Enter your Tripletex company ID (or use 0 if unknown).<\/li>\n<\/ol>\n<\/li>\n
- Drag and drop the REST API Task<\/a> component onto your SSIS package canvas and double-click to open it.\n
<\/a>Add a REST API Task in SSIS<\/p><\/div><\/li>\n
- Navigate to the Response Settings<\/strong> tab and set Response Content Type<\/strong> to JSON<\/strong>.<\/li>\n
- In the JSONPath field, enter:
$.value.Token<\/code> to extract the session token from the API response.<\/li>\n- Enable Save Response Content<\/strong>,<\/strong>\u00a0select the\u00a0Variable<\/strong> option, and\u00a0choose your SessionToken variable.\n
<\/a>Tripletex – Save Session Token in Variable<\/p><\/div><\/li>\n
- Go back to the Request<\/strong> tab and enter the following URL. For testing, use:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n- For production environments, use:\n
https:\/\/tripletex.no\/v2\/token\/session\/:create?consumerToken={{User::ConsumerToken}}&employeeToken={{User::EmployeeToken}}&expirationDate=2026-04-24<\/pre>\n<\/li>\n- Set the HTTP Request Method<\/strong> to PUT<\/strong>.<\/li>\n
- Test the connection. If successful, you will see the generated session token in the response.\n
<\/a>Tripletex – Generate Session Token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure the JSON Source<\/h3>\n
- \n
- Add a new Data Flow Task to your SSIS package. Connect it downstream from the REST API task you created before.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.<\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n<\/a>
SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- For testing purposes, enter the following URL:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/>whoAmI<\/pre>\n<\/li>\n
- Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Click the Headers<\/strong> tab and add the required Tripletex authentication headers. The Authorization header must contain the Company ID and Session Token in Base64-encoded format:\n
Accept: application\/json\r\nAuthorization: Basic <<{{User::CompanyID}}:{{User::SessionToken}},FUN_BASE64ENC}}>><\/pre>\n<\/a>Tripletex – JSON Source Configuration<\/p><\/div><\/li>\n
- In the Array Filter<\/strong> field, specify the JSON path to extract the data array from the Tripletex response:
$.value<\/code><\/li>\n- Click Preview Data<\/strong> to test the connection and verify that data is being retrieved correctly from Tripletex.\n
<\/a>Tripletex – JSON Source Preview<\/p><\/div><\/li>\n
- Click OK<\/strong> to save the configuration.<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n
- \n
- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialog.<\/li>\n
- Configure the destination to point to your target table or file where Tripletex data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- Double-click the ZappySys JSON Source<\/strong><\/a> to open its editor.<\/li>\n
- EmployeeToken<\/strong> (String) \u2014 Enter the Employee Token from Step 1.<\/li>\n
- ConsumerToken<\/strong> (String) \u2014 Enter the Consumer Token from Step 1.<\/li>\n