![\"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 ODBC enables seamless data access between your accounting system and any ODBC-compatible application, including Excel, Power BI, Tableau, custom applications, and databases. ZappySys Tripletex ODBC Driver simplifies this integration by providing a native ODBC interface that handles Tripletex authentication, API communication, and data querying without requiring custom code.<\/p>\n
This tutorial walks you through the complete process of installing the ODBC driver, configuring a data source, and querying Tripletex data from any ODBC-compatible application.<\/p>\n
Prerequisites<\/h2>\n\n- Windows or macOS operating system with admin access for driver installation.<\/li>\n
- Tripletex account with API access enabled.<\/li>\n
- An ODBC-compatible application (Excel, Power BI, Tableau, database tool, etc.).<\/li>\n
- Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n
Step-by-Step Guide<\/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
Creating a new ODBC DSN using ZappySys JSON Driver<\/h3>\n\n- Search for ODBC<\/strong> in the Windows Start menu and open the ODBC Data Source Administrator<\/strong>.
\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png\")
<\/a><\/li>\n- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n
- In the ODBC Data Source Setup<\/strong> window, select the ZappySys JSON Driver<\/strong> and click Continue<\/strong>.
\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png\")
<\/a><\/li>\n<\/ol>\n\u00a0Configure the Connection and API Settings<\/h3>\n\n- In the Base URL<\/strong> field, from the API documentation<\/a>, enter the URL:\n
https:\/\/api-test.tripletex.tech\/v2\/currency<\/pre>\n<\/li>\n
- Select HTTP <\/strong>as the connection type, then\u00a0click it to configure it.<\/li>\n
- Select Dynamic Token<\/strong>\u00a0as the Authentication Type<\/strong>.<\/li>\n
- In the Header Name<\/strong>, enter Authorization<\/strong>.<\/li>\n
- In the OAuth Scheme<\/strong>, use Basic.<\/strong><\/li>\n
- Go to the Dynamic Token<\/strong> tab.<\/li>\n
- Enter the following URL with the consumer and employee token:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={ConsumerToken}&employeeToken={EmployeeToken}&expirationDate=2026-04-28<\/pre>\n<\/li>\n - Set up the HTTP<\/strong> Request Method to PUT.
\n<\/strong><\/strong><\/p>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-ODBC-dynamic-token.png\")
<\/a>Tripletex – ODBC dynamic token<\/p><\/div><\/li>\n
- Go to the Response Settings<\/strong> tab<\/li>\n
- Select Expression Type<\/strong> as JSON<\/strong> and use this JSONPath to get the Session Token: $.value.token<\/span><\/li>\n
- In Token Function<\/strong>, use the following function. The Authorization header must contain the Company ID( Enter your Tripletex company ID or use 0 if unknown) and Session Token in Base64-encoded format: <<0:[$token$],FUN_BASE64ENC>><\/span><\/li>\n
- Click OK to save the connection configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-ODBC-save-Session-Token.png\")
<\/a>Tripletex – ODBC save Session Token<\/p><\/div><\/li>\n
- In the Request Method,<\/strong> use GET<\/strong><\/li>\n
- You can use the Array filter<\/strong> to get the object you need. We\u00a0will use $.value[*].<\/li>\n
- Test the connection to check everything is working fine\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Tripletex-ODBC-JSON-Driver-configuration.png\")
<\/a>Tripletex – ODBC JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview the data<\/h3>\n\n- Once your ODBC DSN is configured, go to the preview tab.<\/li>\n
- Select the table you want to use.<\/li>\n
- Press the Preview data <\/strong>button to see the result.\n
Step-by-Step Guide<\/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
Creating a new ODBC DSN using ZappySys JSON Driver<\/h3>\n\n- Search for ODBC<\/strong> in the Windows Start menu and open the ODBC Data Source Administrator<\/strong>.
\n<\/a><\/li>\n- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n
- In the ODBC Data Source Setup<\/strong> window, select the ZappySys JSON Driver<\/strong> and click Continue<\/strong>.
\n<\/a><\/li>\n<\/ol>\n\u00a0Configure the Connection and API Settings<\/h3>\n\n- In the Base URL<\/strong> field, from the API documentation<\/a>, enter the URL:\n
https:\/\/api-test.tripletex.tech\/v2\/currency<\/pre>\n<\/li>\n
- Select HTTP <\/strong>as the connection type, then\u00a0click it to configure it.<\/li>\n
- Select Dynamic Token<\/strong>\u00a0as the Authentication Type<\/strong>.<\/li>\n
- In the Header Name<\/strong>, enter Authorization<\/strong>.<\/li>\n
- In the OAuth Scheme<\/strong>, use Basic.<\/strong><\/li>\n
- Go to the Dynamic Token<\/strong> tab.<\/li>\n
- Enter the following URL with the consumer and employee token:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={ConsumerToken}&employeeToken={EmployeeToken}&expirationDate=2026-04-28<\/pre>\n<\/li>\n - Set up the HTTP<\/strong> Request Method to PUT.
\n<\/strong><\/strong><\/p>\n<\/a>Tripletex – ODBC dynamic token<\/p><\/div><\/li>\n
- Go to the Response Settings<\/strong> tab<\/li>\n
- Select Expression Type<\/strong> as JSON<\/strong> and use this JSONPath to get the Session Token: $.value.token<\/span><\/li>\n
- In Token Function<\/strong>, use the following function. The Authorization header must contain the Company ID( Enter your Tripletex company ID or use 0 if unknown) and Session Token in Base64-encoded format: <<0:[$token$],FUN_BASE64ENC>><\/span><\/li>\n
- Click OK to save the connection configuration.\n<\/a>
Tripletex – ODBC save Session Token<\/p><\/div><\/li>\n
- In the Request Method,<\/strong> use GET<\/strong><\/li>\n
- You can use the Array filter<\/strong> to get the object you need. We\u00a0will use $.value[*].<\/li>\n
- Test the connection to check everything is working fine\n<\/a>
Tripletex – ODBC JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview the data<\/h3>\n\n- Once your ODBC DSN is configured, go to the preview tab.<\/li>\n
- Select the table you want to use.<\/li>\n
- Press the Preview data <\/strong>button to see the result.\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
Creating a new ODBC DSN using ZappySys JSON Driver<\/h3>\n
- \n
- Search for ODBC<\/strong> in the Windows Start menu and open the ODBC Data Source Administrator<\/strong>.
\n<\/a><\/li>\n- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n
- In the ODBC Data Source Setup<\/strong> window, select the ZappySys JSON Driver<\/strong> and click Continue<\/strong>.
\n<\/a><\/li>\n<\/ol>\n\u00a0Configure the Connection and API Settings<\/h3>\n
- \n
- In the Base URL<\/strong> field, from the API documentation<\/a>, enter the URL:\n
https:\/\/api-test.tripletex.tech\/v2\/currency<\/pre>\n<\/li>\n
- Select HTTP <\/strong>as the connection type, then\u00a0click it to configure it.<\/li>\n
- Select Dynamic Token<\/strong>\u00a0as the Authentication Type<\/strong>.<\/li>\n
- In the Header Name<\/strong>, enter Authorization<\/strong>.<\/li>\n
- In the OAuth Scheme<\/strong>, use Basic.<\/strong><\/li>\n
- Go to the Dynamic Token<\/strong> tab.<\/li>\n
- Enter the following URL with the consumer and employee token:\n
https:\/\/api-test.tripletex.tech\/v2\/token\/session\/:create?consumerToken={ConsumerToken}&employeeToken={EmployeeToken}&expirationDate=2026-04-28<\/pre>\n<\/li>\n- Set up the HTTP<\/strong> Request Method to PUT.
\n<\/strong><\/strong><\/p>\n<\/a>Tripletex – ODBC dynamic token<\/p><\/div><\/li>\n
- Go to the Response Settings<\/strong> tab<\/li>\n
- Select Expression Type<\/strong> as JSON<\/strong> and use this JSONPath to get the Session Token: $.value.token<\/span><\/li>\n
- In Token Function<\/strong>, use the following function. The Authorization header must contain the Company ID( Enter your Tripletex company ID or use 0 if unknown) and Session Token in Base64-encoded format: <<0:[$token$],FUN_BASE64ENC>><\/span><\/li>\n
- Click OK to save the connection configuration.\n
<\/a>Tripletex – ODBC save Session Token<\/p><\/div><\/li>\n
- In the Request Method,<\/strong> use GET<\/strong><\/li>\n
- You can use the Array filter<\/strong> to get the object you need. We\u00a0will use $.value[*].<\/li>\n
- Test the connection to check everything is working fine\n
<\/a>Tripletex – ODBC JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview the data<\/h3>\n
- \n
- Once your ODBC DSN is configured, go to the preview tab.<\/li>\n
- Select the table you want to use.<\/li>\n
- Press the Preview data <\/strong>button to see the result.\n
- Select HTTP <\/strong>as the connection type, then\u00a0click it to configure it.<\/li>\n
- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n